APPS.PJM_TRANSFER_IPV_PKG dependencies on PA_TRANSACTION_INTERFACE

Line 6: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;

2: /* $Header: PJMTIPVB.pls 115.52 2004/08/18 04:30:08 yliou ship $ */
3:
4: Function batch_name
5: RETURN VARCHAR2 IS
6: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;
7: l_Batch_ID NUMBER;
8:
9: Begin
10: --

Line 150: -- INVENTORY. And then push these data to PA_TRANSACTION_INTERFACES.

146: --
147: -- DESCRIPTION
148: -- This procedure will get the expenditure and costing data from Invoice
149: -- Distributions which has IPV amount and the destination type is
150: -- INVENTORY. And then push these data to PA_TRANSACTION_INTERFACES.
151: --
152: -- PARAMETERS
153: -- X_Project_Id IN
154: -- X_Start_Date IN

Line 189: l_IPV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

185: -- l_msg_token2 VARCHAR2(30);
186: -- l_msg_token3 VARCHAR2(30);
187: -- l_msg_count NUMBER;
188:
189: l_IPV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
190: l_ERV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
191: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;
192: l_Receipt_Num RCV_Shipment_Headers.Receipt_Num%TYPE;
193: l_User_Conv_Type GL_Daily_Conversion_Types.User_Conversion_Type%TYPE;

Line 190: l_ERV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;

186: -- l_msg_token3 VARCHAR2(30);
187: -- l_msg_count NUMBER;
188:
189: l_IPV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
190: l_ERV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
191: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;
192: l_Receipt_Num RCV_Shipment_Headers.Receipt_Num%TYPE;
193: l_User_Conv_Type GL_Daily_Conversion_Types.User_Conversion_Type%TYPE;
194: l_Start_Date DATE;

Line 191: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;

187: -- l_msg_count NUMBER;
188:
189: l_IPV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
190: l_ERV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
191: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;
192: l_Receipt_Num RCV_Shipment_Headers.Receipt_Num%TYPE;
193: l_User_Conv_Type GL_Daily_Conversion_Types.User_Conversion_Type%TYPE;
194: l_Start_Date DATE;
195: l_End_Date DATE;

Line 403: -- PA_Transaction_Interfaces

399: */
400:
401: ----------------------------------------------------------------------
402: -- Loop for transfering IPV from Invoice_Distribution to
403: -- PA_Transaction_Interfaces
404: ----------------------------------------------------------------------
405:
406: fnd_message.set_name('PJM','CONC-APINV Start Loop');
407: PJM_CONC.put_line(fnd_message.get || ' ...');

Line 510: -- Insert into PA_TRANSACTION_INTERFACES table

506:
507: end if;
508:
509: ----------------------------------------------------------------------
510: -- Insert into PA_TRANSACTION_INTERFACES table
511: ----------------------------------------------------------------------
512:
513: fnd_message.set_name('PJM','CONC-APINV Insert');
514: PJM_CONC.put_line('... ' || fnd_message.get);

Line 562: INSERT INTO pa_transaction_interface

558:
559: PJM_CONC.put_line('...... Processing IPV');
560:
561: -- Insert for IPV
562: INSERT INTO pa_transaction_interface
563: (transaction_source,
564: batch_name,
565: expenditure_ending_date,
566: employee_number,

Line 671: INSERT INTO pa_transaction_interface

667: l_progress := 120;
668:
669: PJM_CONC.put_line('...... Processing ERV');
670:
671: INSERT INTO pa_transaction_interface
672: (transaction_source,
673: batch_name,
674: expenditure_ending_date,
675: employee_number,