DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 169: ,p_job_id pa_transaction_interface_all.job_id%type default null

165: p_fc_document_type IN varchar2 default NULL
166: -- , p_agreement_id IN OUT NOCOPY NUMBER --FSIO Changes
167: -- , p_agreement_number IN OUT NOCOPY varchar2
168: -- 10253400: Payroll integration enhancement for 12.2.. start
169: ,p_job_id pa_transaction_interface_all.job_id%type default null
170: ,p_job_name pa_transaction_interface_all.job_name%type default null
171: ,p_location_id pa_transaction_interface_all.location_id%type default null
172: ,p_location_code pa_transaction_interface_all.location_code%type default null
173: ,p_pay_element_type_id pa_transaction_interface_all.pay_element_type_id%type default null

Line 170: ,p_job_name pa_transaction_interface_all.job_name%type default null

166: -- , p_agreement_id IN OUT NOCOPY NUMBER --FSIO Changes
167: -- , p_agreement_number IN OUT NOCOPY varchar2
168: -- 10253400: Payroll integration enhancement for 12.2.. start
169: ,p_job_id pa_transaction_interface_all.job_id%type default null
170: ,p_job_name pa_transaction_interface_all.job_name%type default null
171: ,p_location_id pa_transaction_interface_all.location_id%type default null
172: ,p_location_code pa_transaction_interface_all.location_code%type default null
173: ,p_pay_element_type_id pa_transaction_interface_all.pay_element_type_id%type default null
174: -- 10253400: Payroll integration enhancement for 12.2.. end

Line 171: ,p_location_id pa_transaction_interface_all.location_id%type default null

167: -- , p_agreement_number IN OUT NOCOPY varchar2
168: -- 10253400: Payroll integration enhancement for 12.2.. start
169: ,p_job_id pa_transaction_interface_all.job_id%type default null
170: ,p_job_name pa_transaction_interface_all.job_name%type default null
171: ,p_location_id pa_transaction_interface_all.location_id%type default null
172: ,p_location_code pa_transaction_interface_all.location_code%type default null
173: ,p_pay_element_type_id pa_transaction_interface_all.pay_element_type_id%type default null
174: -- 10253400: Payroll integration enhancement for 12.2.. end
175: -- Start: Added for bug 16220146

Line 172: ,p_location_code pa_transaction_interface_all.location_code%type default null

168: -- 10253400: Payroll integration enhancement for 12.2.. start
169: ,p_job_id pa_transaction_interface_all.job_id%type default null
170: ,p_job_name pa_transaction_interface_all.job_name%type default null
171: ,p_location_id pa_transaction_interface_all.location_id%type default null
172: ,p_location_code pa_transaction_interface_all.location_code%type default null
173: ,p_pay_element_type_id pa_transaction_interface_all.pay_element_type_id%type default null
174: -- 10253400: Payroll integration enhancement for 12.2.. end
175: -- Start: Added for bug 16220146
176: ,P_CBS_ELEMENT_ID PA_TRANSACTION_INTERFACE_ALL.CBS_ELEMENT_ID%TYPE DEFAULT NULL

Line 173: ,p_pay_element_type_id pa_transaction_interface_all.pay_element_type_id%type default null

169: ,p_job_id pa_transaction_interface_all.job_id%type default null
170: ,p_job_name pa_transaction_interface_all.job_name%type default null
171: ,p_location_id pa_transaction_interface_all.location_id%type default null
172: ,p_location_code pa_transaction_interface_all.location_code%type default null
173: ,p_pay_element_type_id pa_transaction_interface_all.pay_element_type_id%type default null
174: -- 10253400: Payroll integration enhancement for 12.2.. end
175: -- Start: Added for bug 16220146
176: ,P_CBS_ELEMENT_ID PA_TRANSACTION_INTERFACE_ALL.CBS_ELEMENT_ID%TYPE DEFAULT NULL
177: ,P_CBS_ELEMENT_NAME PA_TRANSACTION_INTERFACE_ALL.CBS_ELEMENT_NAME%TYPE DEFAULT NULL

Line 176: ,P_CBS_ELEMENT_ID PA_TRANSACTION_INTERFACE_ALL.CBS_ELEMENT_ID%TYPE DEFAULT NULL

172: ,p_location_code pa_transaction_interface_all.location_code%type default null
173: ,p_pay_element_type_id pa_transaction_interface_all.pay_element_type_id%type default null
174: -- 10253400: Payroll integration enhancement for 12.2.. end
175: -- Start: Added for bug 16220146
176: ,P_CBS_ELEMENT_ID PA_TRANSACTION_INTERFACE_ALL.CBS_ELEMENT_ID%TYPE DEFAULT NULL
177: ,P_CBS_ELEMENT_NAME PA_TRANSACTION_INTERFACE_ALL.CBS_ELEMENT_NAME%TYPE DEFAULT NULL
178: -- End: Added for bug 16220146
179: );
180:

Line 177: ,P_CBS_ELEMENT_NAME PA_TRANSACTION_INTERFACE_ALL.CBS_ELEMENT_NAME%TYPE DEFAULT NULL

173: ,p_pay_element_type_id pa_transaction_interface_all.pay_element_type_id%type default null
174: -- 10253400: Payroll integration enhancement for 12.2.. end
175: -- Start: Added for bug 16220146
176: ,P_CBS_ELEMENT_ID PA_TRANSACTION_INTERFACE_ALL.CBS_ELEMENT_ID%TYPE DEFAULT NULL
177: ,P_CBS_ELEMENT_NAME PA_TRANSACTION_INTERFACE_ALL.CBS_ELEMENT_NAME%TYPE DEFAULT NULL
178: -- End: Added for bug 16220146
179: );
180:
181: PROCEDURE

Line 200: * Interface Table (PA_TRANSACTION_INTERFACE_ALL). Once data is loaded in the transaction interface table,

196:
197:
198: /*#
199: * Use the Pre-Import Client Extension to load approved self-service time cards from Internet Time into the Oracle Projects Transaction
200: * Interface Table (PA_TRANSACTION_INTERFACE_ALL). Once data is loaded in the transaction interface table,
201: * the Transaction Import Process will load the data into Oracle Projects.
202: * This client extension allows you to automate the process of loading
203: * Oracle Internet Time data to the interface table as part of the import process.
204: * @param P_transaction_source Classification of the transactions loaded into Oracle Projects from an external system.

Line 350: G_unmatched_negative_txn_flag pa_transaction_interface_all.unmatched_negative_txn_flag%TYPE default 'N'; -- bug 14173646

346: G_Po_Line_Amt NUMBER := 0; /*cwk */
347: G_person_type VARCHAR2 (30) := 'EMP';
348:
349: /*Bug 14748295*/
350: G_unmatched_negative_txn_flag pa_transaction_interface_all.unmatched_negative_txn_flag%TYPE default 'N'; -- bug 14173646
351:
352: PoLineTaskTab pa_utils.Char150TabTyp;
353: PoAmtTab pa_utils.AmtTabTyp;
354: