DBA Data[Home] [Help]

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 287: l_IPV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

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

Line 288: l_ERV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

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

Line 289: l_Freight_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

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

Line 290: l_Tax_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

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

Line 291: l_Misc_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

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

Line 292: l_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

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

Line 293: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;

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

Line 316: Later in this procedure, when inserting into pa_transaction_interface_all

312: l_acct_raw_cost NUMBER;
313: l_acct_burdened_cost NUMBER;
314: /* Bug 8506213, system reference is default to null and will be changed to
315: 'PJM' if transaction source is either Inventory or Work In Process.
316: Later in this procedure, when inserting into pa_transaction_interface_all
317: table, l_system_reference will be used to populate the
318: cdl_system_reference4 column (4 places) */
319: l_system_reference VARCHAR2(30);
320:

Line 670: -- PA_Transaction_Interface_All

666: PJM_CONC.new_line(1);
667:
668: ----------------------------------------------------------------------
669: -- Loop for transfering Variances from Invoice_Distribution_All to
670: -- PA_Transaction_Interface_All
671: ----------------------------------------------------------------------
672:
673: fnd_message.set_name('PJM','CONC-APINV Start Loop');
674: PJM_CONC.put_line(fnd_message.get || ' ...');

Line 998: INSERT INTO pa_transaction_interface_all

994: PJM_CONC.put_line('...... Processing IPV, ERV, Tax Variances');
995:
996: -- Insert for all the charges
997:
998: INSERT INTO pa_transaction_interface_all
999: (transaction_source,
1000: batch_name,
1001: expenditure_ending_date,
1002: employee_number,

Line 1431: INSERT INTO pa_transaction_interface_all

1427: PJM_CONC.put_line('...... Processing Special Charge');
1428:
1429: -- Insert for all the charges
1430:
1431: INSERT INTO pa_transaction_interface_all
1432: (transaction_source,
1433: batch_name,
1434: expenditure_ending_date,
1435: employee_number,

Line 1870: INSERT INTO pa_transaction_interface_all

1866:
1867: PJM_CONC.put_line('...... Processing IPV, ERV, Tax Variances');
1868:
1869: -- Insert for Charges
1870: INSERT INTO pa_transaction_interface_all
1871: (transaction_source,
1872: batch_name,
1873: expenditure_ending_date,
1874: employee_number,

Line 2299: INSERT INTO pa_transaction_interface_all

2295:
2296: PJM_CONC.put_line('...... Processing Special Charges');
2297:
2298: -- Insert for Charges
2299: INSERT INTO pa_transaction_interface_all
2300: (transaction_source,
2301: batch_name,
2302: expenditure_ending_date,
2303: employee_number,