eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_EXP_COPY dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 74: temp_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;

70: temp_status NUMBER DEFAULT NULL;
71: i BINARY_INTEGER DEFAULT 0;
72:
73: -- Starts Added for bug#4618898
74: temp_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
75: temp_acct_rate_date pa_expenditure_items_all.acct_rate_date%TYPE;
76: temp_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%TYPE;
77: temp_projfunc_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%TYPE;
78: temp_projfunc_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%TYPE;

Line 75: temp_acct_rate_date pa_expenditure_items_all.acct_rate_date%TYPE;

71: i BINARY_INTEGER DEFAULT 0;
72:
73: -- Starts Added for bug#4618898
74: temp_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
75: temp_acct_rate_date pa_expenditure_items_all.acct_rate_date%TYPE;
76: temp_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%TYPE;
77: temp_projfunc_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%TYPE;
78: temp_projfunc_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%TYPE;
79: temp_projfunc_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE;

Line 76: temp_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%TYPE;

72:
73: -- Starts Added for bug#4618898
74: temp_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
75: temp_acct_rate_date pa_expenditure_items_all.acct_rate_date%TYPE;
76: temp_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%TYPE;
77: temp_projfunc_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%TYPE;
78: temp_projfunc_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%TYPE;
79: temp_projfunc_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE;
80: temp_project_rate_type pa_expenditure_items_all.project_rate_type%TYPE;

Line 77: temp_projfunc_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%TYPE;

73: -- Starts Added for bug#4618898
74: temp_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
75: temp_acct_rate_date pa_expenditure_items_all.acct_rate_date%TYPE;
76: temp_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%TYPE;
77: temp_projfunc_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%TYPE;
78: temp_projfunc_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%TYPE;
79: temp_projfunc_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE;
80: temp_project_rate_type pa_expenditure_items_all.project_rate_type%TYPE;
81: temp_project_rate_date pa_expenditure_items_all.project_rate_date%TYPE;

Line 78: temp_projfunc_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%TYPE;

74: temp_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
75: temp_acct_rate_date pa_expenditure_items_all.acct_rate_date%TYPE;
76: temp_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%TYPE;
77: temp_projfunc_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%TYPE;
78: temp_projfunc_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%TYPE;
79: temp_projfunc_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE;
80: temp_project_rate_type pa_expenditure_items_all.project_rate_type%TYPE;
81: temp_project_rate_date pa_expenditure_items_all.project_rate_date%TYPE;
82: temp_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%TYPE;

Line 79: temp_projfunc_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE;

75: temp_acct_rate_date pa_expenditure_items_all.acct_rate_date%TYPE;
76: temp_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%TYPE;
77: temp_projfunc_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%TYPE;
78: temp_projfunc_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%TYPE;
79: temp_projfunc_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE;
80: temp_project_rate_type pa_expenditure_items_all.project_rate_type%TYPE;
81: temp_project_rate_date pa_expenditure_items_all.project_rate_date%TYPE;
82: temp_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%TYPE;
83:

Line 80: temp_project_rate_type pa_expenditure_items_all.project_rate_type%TYPE;

76: temp_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%TYPE;
77: temp_projfunc_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%TYPE;
78: temp_projfunc_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%TYPE;
79: temp_projfunc_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE;
80: temp_project_rate_type pa_expenditure_items_all.project_rate_type%TYPE;
81: temp_project_rate_date pa_expenditure_items_all.project_rate_date%TYPE;
82: temp_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%TYPE;
83:
84: l_status VARCHAR2(30);

Line 81: temp_project_rate_date pa_expenditure_items_all.project_rate_date%TYPE;

77: temp_projfunc_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%TYPE;
78: temp_projfunc_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%TYPE;
79: temp_projfunc_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE;
80: temp_project_rate_type pa_expenditure_items_all.project_rate_type%TYPE;
81: temp_project_rate_date pa_expenditure_items_all.project_rate_date%TYPE;
82: temp_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%TYPE;
83:
84: l_status VARCHAR2(30);
85: l_dummy1 NUMBER;

Line 82: temp_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%TYPE;

78: temp_projfunc_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%TYPE;
79: temp_projfunc_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%TYPE;
80: temp_project_rate_type pa_expenditure_items_all.project_rate_type%TYPE;
81: temp_project_rate_date pa_expenditure_items_all.project_rate_date%TYPE;
82: temp_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%TYPE;
83:
84: l_status VARCHAR2(30);
85: l_dummy1 NUMBER;
86: l_dummy2 NUMBER;

Line 90: l_labor_cost_multiplier_name pa_expenditure_items_all.labor_cost_multiplier_name%TYPE;

86: l_dummy2 NUMBER;
87: l_dummy3 NUMBER;
88: -- Ends Added for bug#4618898
89:
90: l_labor_cost_multiplier_name pa_expenditure_items_all.labor_cost_multiplier_name%TYPE;
91:
92: l_denom_burdened_cost pa_expenditure_items_all.denom_burdened_cost%TYPE; /* bug#2794006 */
93:
94: CURSOR getEI IS

Line 92: l_denom_burdened_cost pa_expenditure_items_all.denom_burdened_cost%TYPE; /* bug#2794006 */

88: -- Ends Added for bug#4618898
89:
90: l_labor_cost_multiplier_name pa_expenditure_items_all.labor_cost_multiplier_name%TYPE;
91:
92: l_denom_burdened_cost pa_expenditure_items_all.denom_burdened_cost%TYPE; /* bug#2794006 */
93:
94: CURSOR getEI IS
95: SELECT
96: pa_expenditure_items_s.nextval expenditure_item_id

Line 198: l_Tp_Amt_Type_Code Pa_Expenditure_Items_All.Tp_Amt_Type_Code%TYPE;

194: Function GetTpAmtTypeCode (P_Work_Type_Id IN NUMBER) Return Varchar2
195:
196: Is
197:
198: l_Tp_Amt_Type_Code Pa_Expenditure_Items_All.Tp_Amt_Type_Code%TYPE;
199:
200: Begin
201: IF P_Work_Type_Id is NOT NULL THEN /* IF Added for Bug2220691*/
202: Select Tp_Amt_Type_Code

Line 915: pa_expenditure_items_all ei

911: , ei.task_id
912: , ei.transaction_source -- OTC changes
913: , ei.orig_transaction_reference -- OTC changes
914: from
915: pa_expenditure_items_all ei
916: where
917: expenditure_id = expend_id ;
918:
919: cursor ReverseGroup is

Line 1046: FROM pa_expenditure_items_all

1042: /* Code added for bug 5405636 : Start*/
1043:
1044: SELECT expenditure_item_id
1045: INTO l_BackOutExp_Id
1046: FROM pa_expenditure_items_all
1047: WHERE adjusted_expenditure_item_id = ExpEi.expenditure_item_id;
1048:
1049: pa_costing.CreateReverseCdl(
1050: X_exp_item_id => ExpEi.expenditure_item_id,

Line 1216: Function Check_lcm(P_Lcm_Name IN Pa_Expenditure_Items_All.Labor_Cost_Multiplier_Name%TYPE,

1212: return TRUE ;
1213:
1214: END check_reverse_allowed ;
1215:
1216: Function Check_lcm(P_Lcm_Name IN Pa_Expenditure_Items_All.Labor_Cost_Multiplier_Name%TYPE,
1217: P_Ei_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE) RETURN VARCHAR2
1218:
1219: Is
1220:

Line 1217: P_Ei_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE) RETURN VARCHAR2

1213:
1214: END check_reverse_allowed ;
1215:
1216: Function Check_lcm(P_Lcm_Name IN Pa_Expenditure_Items_All.Labor_Cost_Multiplier_Name%TYPE,
1217: P_Ei_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE) RETURN VARCHAR2
1218:
1219: Is
1220:
1221: l_lcm_Name Pa_Expenditure_Items_All.Labor_Cost_Multiplier_Name%TYPE := NULL;

Line 1221: l_lcm_Name Pa_Expenditure_Items_All.Labor_Cost_Multiplier_Name%TYPE := NULL;

1217: P_Ei_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE) RETURN VARCHAR2
1218:
1219: Is
1220:
1221: l_lcm_Name Pa_Expenditure_Items_All.Labor_Cost_Multiplier_Name%TYPE := NULL;
1222:
1223: Begin
1224:
1225: If P_lcm_name is not null Then