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_PAY_INTERFACE dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 1866: -- pa_expenditure_items_all ei

1862: -- SELECT temp.expenditure_item_id,
1863: -- ei.acct_currency_code,
1864: -- ei.acct_raw_cost
1865: -- FROM PA_PAY_EXP_TEMP temp ,
1866: -- pa_expenditure_items_all ei
1867: -- WHERE (
1868: -- ( /* uncosted ei picked up for stamping cost on that*/
1869: -- temp.payroll_accrual_flag IS NULL
1870: -- AND NVL(temp.cost_distributed_flag,'N') = 'N'

Line 1909: pa_expenditure_items_all ei1,

1905: SELECT temp.expenditure_item_id,
1906: ei1.acct_currency_code,
1907: ei1.acct_raw_cost
1908: FROM PA_PAY_EXP_TEMP temp ,
1909: pa_expenditure_items_all ei1,
1910: pa_expenditure_items_all ei2,
1911: pa_expenditure_items_all ei3
1912: WHERE
1913: temp.expenditure_item_id= ei3.expenditure_item_id

Line 1910: pa_expenditure_items_all ei2,

1906: ei1.acct_currency_code,
1907: ei1.acct_raw_cost
1908: FROM PA_PAY_EXP_TEMP temp ,
1909: pa_expenditure_items_all ei1,
1910: pa_expenditure_items_all ei2,
1911: pa_expenditure_items_all ei3
1912: WHERE
1913: temp.expenditure_item_id= ei3.expenditure_item_id
1914: AND ei3.transaction_source = 'ORACLE TIME AND LABOR'

Line 1911: pa_expenditure_items_all ei3

1907: ei1.acct_raw_cost
1908: FROM PA_PAY_EXP_TEMP temp ,
1909: pa_expenditure_items_all ei1,
1910: pa_expenditure_items_all ei2,
1911: pa_expenditure_items_all ei3
1912: WHERE
1913: temp.expenditure_item_id= ei3.expenditure_item_id
1914: AND ei3.transaction_source = 'ORACLE TIME AND LABOR'
1915: AND ei2.orig_transaction_reference = ei3.orig_transaction_reference

Line 3105: x_exp_id pa_expenditure_items_all.expenditure_id%type;

3101: p_exp_item_date IN DATE)
3102: RETURN VARCHAR2 IS
3103:
3104:
3105: x_exp_id pa_expenditure_items_all.expenditure_id%type;
3106: x_exp_item_date pa_expenditure_items_all.expenditure_item_date%type;
3107:
3108:
3109:

Line 3106: x_exp_item_date pa_expenditure_items_all.expenditure_item_date%type;

3102: RETURN VARCHAR2 IS
3103:
3104:
3105: x_exp_id pa_expenditure_items_all.expenditure_id%type;
3106: x_exp_item_date pa_expenditure_items_all.expenditure_item_date%type;
3107:
3108:
3109:
3110: cursor get_emp_override_rule is

Line 3894: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;

3890:
3891: PROCEDURE process_burden IS
3892: l_exp_group pa_expenditure_groups_all.expenditure_group%type;
3893: l_expenditure_id pa_expenditures_all.expenditure_id%type;
3894: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
3895: i PLS_INTEGER;
3896: l_status VARCHAR2(100);
3897: l_msg_application VARCHAR2(10);
3898: l_msg_type VARCHAR2(1);

Line 3905: l_billable_flag pa_expenditure_items_all.billable_flag%type;

3901: l_msg_token3 VARCHAR2(2000);
3902: l_msg_count NUMBER;
3903: l_burden_exists VARCHAR2(1) := 'N';
3904: EI_PROCESS_FAILED EXCEPTION;
3905: l_billable_flag pa_expenditure_items_all.billable_flag%type;
3906: BEGIN
3907:
3908:
3909: BEGIN

Line 4227: PA_EXPENDITURE_ITEMS_ALL

4223: ); */
4224:
4225: INSERT
4226: INTO
4227: PA_EXPENDITURE_ITEMS_ALL
4228: (
4229: EXPENDITURE_ITEM_ID ,
4230: LAST_UPDATE_DATE ,
4231: LAST_UPDATED_BY ,

Line 4329: /* UPDATE pa_expenditure_items_all

4325:
4326: END LOOP; -- End Y loop .. Exp Items
4327: -- pa_transactions.InsItems(1,0,'BTC','BTC',i, l_status,'N');
4328:
4329: /* UPDATE pa_expenditure_items_all
4330: SET interface_run_id = G_INTERFACE_RUN_ID
4331: ,COSTING_METHOD = 'ACTUAL'
4332: ,PAYROLL_ACCRUAL_FLAG = 'N'
4333: WHERE expenditure_id = l_expenditure_id ; */

Line 4364: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;

4360:
4361: PROCEDURE process_misc IS
4362: l_exp_group pa_expenditure_groups_all.expenditure_group%type;
4363: l_expenditure_id pa_expenditures_all.expenditure_id%type;
4364: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
4365: i PLS_INTEGER;
4366: l_status VARCHAR2(100);
4367: l_msg_application VARCHAR2(10);
4368: l_msg_type VARCHAR2(1);

Line 4375: l_billable_flag pa_expenditure_items_all.billable_flag%TYPE;

4371: l_msg_token3 VARCHAR2(2000);
4372: l_msg_count NUMBER;
4373: l_misc_exists VARCHAR2(1) := 'N';
4374: EI_PROCESS_FAILED EXCEPTION;
4375: l_billable_flag pa_expenditure_items_all.billable_flag%TYPE;
4376:
4377:
4378:
4379: BEGIN

Line 4713: PA_EXPENDITURE_ITEMS_ALL

4709: */
4710:
4711: INSERT
4712: INTO
4713: PA_EXPENDITURE_ITEMS_ALL
4714: (
4715: EXPENDITURE_ITEM_ID ,
4716: LAST_UPDATE_DATE ,
4717: LAST_UPDATED_BY ,

Line 4821: UPDATE pa_expenditure_items_all

4817:
4818: END LOOP; -- End Y loop .. Exp Items
4819: /* -- pa_transactions.InsItems(1,0,'PJ','PJ',i, l_status,'N');
4820:
4821: UPDATE pa_expenditure_items_all
4822: SET interface_run_id = G_INTERFACE_RUN_ID
4823: ,COSTING_METHOD = 'ACTUAL'
4824: ,PAYROLL_ACCRUAL_FLAG = 'N'
4825: WHERE expenditure_id = l_expenditure_id ;

Line 4860: l_denom_raw_cost pa_expenditure_items_all.denom_raw_cost%TYPE;

4856: --paid_ei_for_update Eid_TabType;
4857: l_transfer_id NUMBER(15);
4858: l_reversal_id NUMBER(15);
4859: l_item_comment pa_expenditure_comments.expenditure_comment%TYPE;
4860: l_denom_raw_cost pa_expenditure_items_all.denom_raw_cost%TYPE;
4861: l_denom_orig_amount pa_expenditure_items_all.denom_raw_cost%TYPE;
4862:
4863: EI_PROCESS_FAILED EXCEPTION;
4864:

Line 4861: l_denom_orig_amount pa_expenditure_items_all.denom_raw_cost%TYPE;

4857: l_transfer_id NUMBER(15);
4858: l_reversal_id NUMBER(15);
4859: l_item_comment pa_expenditure_comments.expenditure_comment%TYPE;
4860: l_denom_raw_cost pa_expenditure_items_all.denom_raw_cost%TYPE;
4861: l_denom_orig_amount pa_expenditure_items_all.denom_raw_cost%TYPE;
4862:
4863: EI_PROCESS_FAILED EXCEPTION;
4864:
4865:

Line 4929: PA_EXPENDITURE_ITEMS_ALL EI

4925: write_log(LOG,'l_denom_raw_cost' || l_denom_raw_cost) ;
4926:
4927:
4928: UPDATE
4929: PA_EXPENDITURE_ITEMS_ALL EI
4930: SET DENOM_CURRENCY_CODE = X.DENOM_CURRENCY_CODE
4931: ,DENOM_RAW_COST = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1(l_denom_raw_cost, X.DENOM_CURRENCY_CODE)
4932: ,REQUEST_ID = G_REQUEST_ID
4933: ,INTERFACE_RUN_ID = G_INTERFACE_RUN_ID

Line 5085: PA_EXPENDITURE_ITEMS_ALL

5081:
5082:
5083: INSERT
5084: INTO
5085: PA_EXPENDITURE_ITEMS_ALL
5086: (
5087: EXPENDITURE_ITEM_ID ,
5088: LAST_UPDATE_DATE ,
5089: LAST_UPDATED_BY ,

Line 5497: PA_EXPENDITURE_ITEMS_ALL ei,

5493: /* RATE_SOURCE_CODE , */
5494: 'N',
5495: G_INTERFACE_RUN_ID
5496: FROM
5497: PA_EXPENDITURE_ITEMS_ALL ei,
5498: ( SELECT source_expenditure_item_id seid ,denom_CURRENCY_CODE,Sum(denom_raw_cost) denom_raw_cost, Sum(denom_raw_cost) acct_raw_cost FROM
5499: pa_pay_dist_lines
5500: WHERE
5501: source_expenditure_item_id IS NOT NULL

Line 5568: UPDATE PA_EXPENDITURE_ITEMS_ALL EI2

5564: END LOOP;
5565:
5566: /*
5567:
5568: UPDATE PA_EXPENDITURE_ITEMS_ALL EI2
5569: SET EI2.DENOM_RAW_COST = 0 ,
5570: EI2.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
5571: WHERE EI2.EXPENDITURE_ITEM_ID IN
5572: ( SELECT EI.EXPENDITURE_ITEM_ID

Line 5573: FROM PA_EXPENDITURE_ITEMS_ALL EI ,

5569: SET EI2.DENOM_RAW_COST = 0 ,
5570: EI2.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
5571: WHERE EI2.EXPENDITURE_ITEM_ID IN
5572: ( SELECT EI.EXPENDITURE_ITEM_ID
5573: FROM PA_EXPENDITURE_ITEMS_ALL EI ,
5574: PA_EXPENDITURES_ALL E,
5575: PA_PAY_AUDIT AUD
5576: WHERE E.INCURRED_BY_PERSON_ID = G_PERSON_ID
5577: AND AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID

Line 6034: and mark the CDF on pa_expenditure_items_all

6030:
6031:
6032: /* ========================================================================
6033: PROCEDURE CreateReverseCdl:Creates the reversal cdl for backout items
6034: and mark the CDF on pa_expenditure_items_all
6035: ========================================================================*/
6036:
6037: PROCEDURE CreateReverseCdl ( X_exp_item_id IN NUMBER,
6038: X_backout_id IN NUMBER,

Line 6151: FROM pa_expenditure_items_All ITEMS,

6147: ,l_recvr_org_id
6148: ,l_sys_link_function
6149: ,l_exp_id
6150:
6151: FROM pa_expenditure_items_All ITEMS,
6152: pa_transaction_sources TRN
6153: WHERE ITEMS.transaction_source = TRN.transaction_source (+)
6154: AND ITEMS.expenditure_item_id = X_exp_item_id;
6155: