1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Labour cost distribution

Discussion in 'Oracle Projects' started by neelambhumij, May 27, 2014.

  1. neelambhumij

    neelambhumij Active Member

    Messages:
    51
    Likes Received:
    2
    Trophy Points:
    160
    Location:
    JOHANNESBURG
    Hi all

    i have a requirement to add an additional column of project expenditure inquiry.
    a dff is set up n it is linked to attribute1 of pa_expenditures_all.

    I he modified PA_Client_Extn_Costing to make it work.
    the updated part..

    IF c_org1%FOUND THEN

    SELECT pbr.rate
    into l_rate_coe
    FROM PA_STD_BILL_RATE_SCHEDULES_ALL pas,
    PA_BILL_RATES_ALL pbr,
    PER_JOBS JOB
    WHERE pas.BILL_RATE_SCH_ID = pbr.BILL_RATE_SCH_ID
    AND pas.STD_BILL_RATE_SCHEDULE = l_org_name||' TENOVA JOB COST'
    AND pbr.JOB_ID = JOB.JOB_ID
    AND JOB.NAME = l_job_name1
    AND l_expenditure_item_date1 >= pbr.START_DATE_ACTIVE
    AND (l_expenditure_item_date1 <= pbr.END_DATE_ACTIVE OR pbr.END_DATE_ACTIVE IS NULL);

    l_raw_cost := l_hr * l_rate_coe;
    l_attr_cat := 'Tenova Job Costing';

    CLOSE c_org1;

    ELSE
    CLOSE c_org1;


    l_raw_cost := null ;
    l_attr_cat := null ;


    END IF;

    UPDATE pa.pa_expenditure_items_all
    SET ATTRIBUTE1=l_raw_cost
    ---SET ATTRIBUTE1=000
    where EXPENDITURE_ITEM_ID= x_expenditure_item_id;

    UPDATE pa.pa_expenditure_items_all
    SET ATTRIBUTE_CATEGORY =l_attr_cat
    where EXPENDITURE_ITEM_ID= x_expenditure_item_id;

    It is working grt but is failing when the expenditure item is reversed /transfered to new task number.
    It is not giving me the updated attribute1.

    please find the attachment for detail.


    any help is appreciated.
    Thanks...
     

    Attached Files:

  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    Can you elaborate your requirement?

    what is PA_Client_Extn_Costing?