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.PJM_TRANSFER_CHARGES_PKG dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 18: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;

14: -- End of comments
15:
16: Function batch_name
17: RETURN VARCHAR2 IS
18: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;
19: l_Batch_ID NUMBER;
20:
21: Begin
22: --

Line 286: l_IPV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

282: -- l_msg_token2 VARCHAR2(30);
283: -- l_msg_token3 VARCHAR2(30);
284: -- l_msg_count NUMBER;
285:
286: l_IPV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
287: l_ERV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
288: l_Freight_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
289: l_Tax_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
290: l_Misc_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

Line 287: l_ERV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

283: -- l_msg_token3 VARCHAR2(30);
284: -- l_msg_count NUMBER;
285:
286: l_IPV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
287: l_ERV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
288: l_Freight_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
289: l_Tax_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
290: l_Misc_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
291: l_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

Line 288: l_Freight_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

284: -- l_msg_count NUMBER;
285:
286: l_IPV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
287: l_ERV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
288: l_Freight_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
289: l_Tax_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
290: l_Misc_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
291: l_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
292: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;

Line 289: l_Tax_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

285:
286: l_IPV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
287: l_ERV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
288: l_Freight_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
289: l_Tax_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
290: l_Misc_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
291: l_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
292: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;
293: l_Receipt_Num RCV_Shipment_Headers.Receipt_Num%TYPE;

Line 290: l_Misc_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

286: l_IPV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
287: l_ERV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
288: l_Freight_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
289: l_Tax_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
290: l_Misc_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
291: l_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
292: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;
293: l_Receipt_Num RCV_Shipment_Headers.Receipt_Num%TYPE;
294: l_User_Conv_Type GL_Daily_Conversion_Types.User_Conversion_Type%TYPE;

Line 291: l_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

287: l_ERV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
288: l_Freight_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
289: l_Tax_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
290: l_Misc_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
291: l_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
292: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;
293: l_Receipt_Num RCV_Shipment_Headers.Receipt_Num%TYPE;
294: l_User_Conv_Type GL_Daily_Conversion_Types.User_Conversion_Type%TYPE;
295: l_Start_Date DATE;

Line 292: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;

288: l_Freight_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
289: l_Tax_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
290: l_Misc_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
291: l_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
292: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;
293: l_Receipt_Num RCV_Shipment_Headers.Receipt_Num%TYPE;
294: l_User_Conv_Type GL_Daily_Conversion_Types.User_Conversion_Type%TYPE;
295: l_Start_Date DATE;
296: l_End_Date DATE;

Line 654: -- PA_Transaction_Interface_All

650: PJM_CONC.new_line(1);
651:
652: ----------------------------------------------------------------------
653: -- Loop for transfering Variances from Invoice_Distribution_All to
654: -- PA_Transaction_Interface_All
655: ----------------------------------------------------------------------
656:
657: fnd_message.set_name('PJM','CONC-APINV Start Loop');
658: PJM_CONC.put_line(fnd_message.get || ' ...');

Line 921: INSERT INTO pa_transaction_interface_all

917: PJM_CONC.put_line('...... Processing IPV, ERV, Tax Variances');
918:
919: -- Insert for all the charges
920:
921: INSERT INTO pa_transaction_interface_all
922: (transaction_source,
923: batch_name,
924: expenditure_ending_date,
925: employee_number,

Line 1289: INSERT INTO pa_transaction_interface_all

1285: PJM_CONC.put_line('...... Processing Special Charge');
1286:
1287: -- Insert for all the charges
1288:
1289: INSERT INTO pa_transaction_interface_all
1290: (transaction_source,
1291: batch_name,
1292: expenditure_ending_date,
1293: employee_number,

Line 1663: INSERT INTO pa_transaction_interface_all

1659:
1660: PJM_CONC.put_line('...... Processing IPV, ERV, Tax Variances');
1661:
1662: -- Insert for Charges
1663: INSERT INTO pa_transaction_interface_all
1664: (transaction_source,
1665: batch_name,
1666: expenditure_ending_date,
1667: employee_number,

Line 2028: INSERT INTO pa_transaction_interface_all

2024:
2025: PJM_CONC.put_line('...... Processing Special Charges');
2026:
2027: -- Insert for Charges
2028: INSERT INTO pa_transaction_interface_all
2029: (transaction_source,
2030: batch_name,
2031: expenditure_ending_date,
2032: employee_number,