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.PAAPIMP_PKG dependencies on PA_TRANSACTION_INTERFACE

Line 32: p_system_linkage IN pa_transaction_interface.system_linkage%TYPE,

28: p_invoice_source1 IN ap_invoices.source%TYPE DEFAULT NULL,
29: p_invoice_source2 IN ap_invoices.source%TYPE DEFAULT NULL,
30: p_invoice_source3 IN ap_invoices.source%TYPE DEFAULT NULL,
31: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE,
32: p_system_linkage IN pa_transaction_interface.system_linkage%TYPE,
33: p_process_receipts IN VARCHAR2 DEFAULT 'N');
34:
35: PROCEDURE fetch_pf_var(p_process_receipts IN VARCHAR2 DEFAULT 'N');
36:

Line 38: RETURN pa_transaction_interface.batch_name%TYPE;

34:
35: PROCEDURE fetch_pf_var(p_process_receipts IN VARCHAR2 DEFAULT 'N');
36:
37: FUNCTION create_new_batch_name
38: RETURN pa_transaction_interface.batch_name%TYPE;
39:
40: PROCEDURE write_validate_param_log;
41:
42: PROCEDURE write_log ( p_message_type IN NUMBER,

Line 94: G_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;

90:
91: G_PROFILE_NAME VARCHAR2(128);
92: G_LOCK_NAME VARCHAR2(128);
93: G_LOCKHNDL VARCHAR2(128);
94: G_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
95: G_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
96: G_NRT_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
97: G_NRT_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
98: G_INVOICE_SOURCE1 ap_invoices.source%TYPE;

Line 95: G_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

91: G_PROFILE_NAME VARCHAR2(128);
92: G_LOCK_NAME VARCHAR2(128);
93: G_LOCKHNDL VARCHAR2(128);
94: G_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
95: G_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
96: G_NRT_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
97: G_NRT_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
98: G_INVOICE_SOURCE1 ap_invoices.source%TYPE;
99: G_INVOICE_SOURCE2 ap_invoices.source%TYPE;

Line 96: G_NRT_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;

92: G_LOCK_NAME VARCHAR2(128);
93: G_LOCKHNDL VARCHAR2(128);
94: G_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
95: G_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
96: G_NRT_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
97: G_NRT_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
98: G_INVOICE_SOURCE1 ap_invoices.source%TYPE;
99: G_INVOICE_SOURCE2 ap_invoices.source%TYPE;
100: G_INVOICE_SOURCE3 ap_invoices.source%TYPE;

Line 97: G_NRT_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

93: G_LOCKHNDL VARCHAR2(128);
94: G_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
95: G_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
96: G_NRT_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
97: G_NRT_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
98: G_INVOICE_SOURCE1 ap_invoices.source%TYPE;
99: G_INVOICE_SOURCE2 ap_invoices.source%TYPE;
100: G_INVOICE_SOURCE3 ap_invoices.source%TYPE;
101: G_INVOICE_TYPE ap_invoices.invoice_type_lookup_code%TYPE;

Line 102: G_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

98: G_INVOICE_SOURCE1 ap_invoices.source%TYPE;
99: G_INVOICE_SOURCE2 ap_invoices.source%TYPE;
100: G_INVOICE_SOURCE3 ap_invoices.source%TYPE;
101: G_INVOICE_TYPE ap_invoices.invoice_type_lookup_code%TYPE;
102: G_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
103: G_NRT_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
104: G_INTERFACE_ID NUMBER;
105: G_NRT_INTERFACE_ID NUMBER;
106: G_SYSTEM_LINKAGE pa_transaction_interface.system_linkage%TYPE;

Line 103: G_NRT_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

99: G_INVOICE_SOURCE2 ap_invoices.source%TYPE;
100: G_INVOICE_SOURCE3 ap_invoices.source%TYPE;
101: G_INVOICE_TYPE ap_invoices.invoice_type_lookup_code%TYPE;
102: G_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
103: G_NRT_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
104: G_INTERFACE_ID NUMBER;
105: G_NRT_INTERFACE_ID NUMBER;
106: G_SYSTEM_LINKAGE pa_transaction_interface.system_linkage%TYPE;
107: G_OUTPUT NUMBER; /* Indicate what kind of output procedure to use: dbms_output or PA_DEBUG */

Line 106: G_SYSTEM_LINKAGE pa_transaction_interface.system_linkage%TYPE;

102: G_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
103: G_NRT_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
104: G_INTERFACE_ID NUMBER;
105: G_NRT_INTERFACE_ID NUMBER;
106: G_SYSTEM_LINKAGE pa_transaction_interface.system_linkage%TYPE;
107: G_OUTPUT NUMBER; /* Indicate what kind of output procedure to use: dbms_output or PA_DEBUG */
108: G_TRANSACTION_STATUS_CODE pa_transaction_interface.transaction_status_code%TYPE;
109: G_TRANSACTION_REJECTION_CODE pa_transaction_interface.transaction_rejection_code%TYPE;
110:

Line 108: G_TRANSACTION_STATUS_CODE pa_transaction_interface.transaction_status_code%TYPE;

104: G_INTERFACE_ID NUMBER;
105: G_NRT_INTERFACE_ID NUMBER;
106: G_SYSTEM_LINKAGE pa_transaction_interface.system_linkage%TYPE;
107: G_OUTPUT NUMBER; /* Indicate what kind of output procedure to use: dbms_output or PA_DEBUG */
108: G_TRANSACTION_STATUS_CODE pa_transaction_interface.transaction_status_code%TYPE;
109: G_TRANSACTION_REJECTION_CODE pa_transaction_interface.transaction_rejection_code%TYPE;
110:
111: --AP Discounts
112: G_Discount_Method VARCHAR2(10);

Line 109: G_TRANSACTION_REJECTION_CODE pa_transaction_interface.transaction_rejection_code%TYPE;

105: G_NRT_INTERFACE_ID NUMBER;
106: G_SYSTEM_LINKAGE pa_transaction_interface.system_linkage%TYPE;
107: G_OUTPUT NUMBER; /* Indicate what kind of output procedure to use: dbms_output or PA_DEBUG */
108: G_TRANSACTION_STATUS_CODE pa_transaction_interface.transaction_status_code%TYPE;
109: G_TRANSACTION_REJECTION_CODE pa_transaction_interface.transaction_rejection_code%TYPE;
110:
111: --AP Discounts
112: G_Discount_Method VARCHAR2(10);
113: G_DISC_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;

Line 113: G_DISC_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;

109: G_TRANSACTION_REJECTION_CODE pa_transaction_interface.transaction_rejection_code%TYPE;
110:
111: --AP Discounts
112: G_Discount_Method VARCHAR2(10);
113: G_DISC_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
114: G_DISC_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
115: G_DISC_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
116: G_DISC_INTERFACE_ID NUMBER;
117: G_Profile_Discount_Start_date DATE;

Line 114: G_DISC_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

110:
111: --AP Discounts
112: G_Discount_Method VARCHAR2(10);
113: G_DISC_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
114: G_DISC_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
115: G_DISC_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
116: G_DISC_INTERFACE_ID NUMBER;
117: G_Profile_Discount_Start_date DATE;
118:

Line 115: G_DISC_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

111: --AP Discounts
112: G_Discount_Method VARCHAR2(10);
113: G_DISC_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
114: G_DISC_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
115: G_DISC_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
116: G_DISC_INTERFACE_ID NUMBER;
117: G_Profile_Discount_Start_date DATE;
118:
119: -- Receipt Accruals

Line 126: G_RCV_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

122: G_RCV_TRANSACTIONS_MARKED_NULL NUMBER;
123: G_RCV_TRANSACTIONS_MARKED_G NUMBER;
124: G_NUM_RCV_TXN_PROCESSED NUMBER;
125: G_NUM_RCVTAX_PROCESSED NUMBER;
126: G_RCV_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
127: G_RCVTAX_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
128: G_RCV_INTERFACE_ID NUMBER;
129: G_RCVNRT_INTERFACE_ID NUMBER;
130: G_RCV_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;

Line 127: G_RCVTAX_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

123: G_RCV_TRANSACTIONS_MARKED_G NUMBER;
124: G_NUM_RCV_TXN_PROCESSED NUMBER;
125: G_NUM_RCVTAX_PROCESSED NUMBER;
126: G_RCV_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
127: G_RCVTAX_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
128: G_RCV_INTERFACE_ID NUMBER;
129: G_RCVNRT_INTERFACE_ID NUMBER;
130: G_RCV_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
131: G_RCVTAX_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;

Line 130: G_RCV_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;

126: G_RCV_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
127: G_RCVTAX_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
128: G_RCV_INTERFACE_ID NUMBER;
129: G_RCVNRT_INTERFACE_ID NUMBER;
130: G_RCV_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
131: G_RCVTAX_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
132: G_RCV_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
133: G_RCVTAX_USER_TRX_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
134:

Line 131: G_RCVTAX_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;

127: G_RCVTAX_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
128: G_RCV_INTERFACE_ID NUMBER;
129: G_RCVNRT_INTERFACE_ID NUMBER;
130: G_RCV_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
131: G_RCVTAX_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
132: G_RCV_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
133: G_RCVTAX_USER_TRX_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
134:
135: -- pricing changes

Line 132: G_RCV_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

128: G_RCV_INTERFACE_ID NUMBER;
129: G_RCVNRT_INTERFACE_ID NUMBER;
130: G_RCV_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
131: G_RCVTAX_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
132: G_RCV_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
133: G_RCVTAX_USER_TRX_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
134:
135: -- pricing changes
136: G_RCV_PRC_ADJ_TRX_SRC pa_transaction_interface.transaction_source%TYPE;

Line 133: G_RCVTAX_USER_TRX_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

129: G_RCVNRT_INTERFACE_ID NUMBER;
130: G_RCV_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
131: G_RCVTAX_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;
132: G_RCV_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
133: G_RCVTAX_USER_TRX_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
134:
135: -- pricing changes
136: G_RCV_PRC_ADJ_TRX_SRC pa_transaction_interface.transaction_source%TYPE;
137: G_RCV_PRC_ADJ_USER_TRX_SRC pa_transaction_interface.user_transaction_source%TYPE;

Line 136: G_RCV_PRC_ADJ_TRX_SRC pa_transaction_interface.transaction_source%TYPE;

132: G_RCV_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
133: G_RCVTAX_USER_TRX_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
134:
135: -- pricing changes
136: G_RCV_PRC_ADJ_TRX_SRC pa_transaction_interface.transaction_source%TYPE;
137: G_RCV_PRC_ADJ_USER_TRX_SRC pa_transaction_interface.user_transaction_source%TYPE;
138: G_RCVTAX_PRC_ADJ_TRX_SRC pa_transaction_interface.transaction_source%TYPE;
139: G_RCVTAX_PRC_ADJ_USER_TRX_SRC pa_transaction_interface.user_transaction_source%TYPE;
140:

Line 137: G_RCV_PRC_ADJ_USER_TRX_SRC pa_transaction_interface.user_transaction_source%TYPE;

133: G_RCVTAX_USER_TRX_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
134:
135: -- pricing changes
136: G_RCV_PRC_ADJ_TRX_SRC pa_transaction_interface.transaction_source%TYPE;
137: G_RCV_PRC_ADJ_USER_TRX_SRC pa_transaction_interface.user_transaction_source%TYPE;
138: G_RCVTAX_PRC_ADJ_TRX_SRC pa_transaction_interface.transaction_source%TYPE;
139: G_RCVTAX_PRC_ADJ_USER_TRX_SRC pa_transaction_interface.user_transaction_source%TYPE;
140:
141: G_TRANS_DFF_PO VARCHAR2(10);

Line 138: G_RCVTAX_PRC_ADJ_TRX_SRC pa_transaction_interface.transaction_source%TYPE;

134:
135: -- pricing changes
136: G_RCV_PRC_ADJ_TRX_SRC pa_transaction_interface.transaction_source%TYPE;
137: G_RCV_PRC_ADJ_USER_TRX_SRC pa_transaction_interface.user_transaction_source%TYPE;
138: G_RCVTAX_PRC_ADJ_TRX_SRC pa_transaction_interface.transaction_source%TYPE;
139: G_RCVTAX_PRC_ADJ_USER_TRX_SRC pa_transaction_interface.user_transaction_source%TYPE;
140:
141: G_TRANS_DFF_PO VARCHAR2(10);
142: l_cdl_system_reference4 pa_transaction_interface.cdl_system_reference4%TYPE :=NULL;

Line 139: G_RCVTAX_PRC_ADJ_USER_TRX_SRC pa_transaction_interface.user_transaction_source%TYPE;

135: -- pricing changes
136: G_RCV_PRC_ADJ_TRX_SRC pa_transaction_interface.transaction_source%TYPE;
137: G_RCV_PRC_ADJ_USER_TRX_SRC pa_transaction_interface.user_transaction_source%TYPE;
138: G_RCVTAX_PRC_ADJ_TRX_SRC pa_transaction_interface.transaction_source%TYPE;
139: G_RCVTAX_PRC_ADJ_USER_TRX_SRC pa_transaction_interface.user_transaction_source%TYPE;
140:
141: G_TRANS_DFF_PO VARCHAR2(10);
142: l_cdl_system_reference4 pa_transaction_interface.cdl_system_reference4%TYPE :=NULL;
143:

Line 142: l_cdl_system_reference4 pa_transaction_interface.cdl_system_reference4%TYPE :=NULL;

138: G_RCVTAX_PRC_ADJ_TRX_SRC pa_transaction_interface.transaction_source%TYPE;
139: G_RCVTAX_PRC_ADJ_USER_TRX_SRC pa_transaction_interface.user_transaction_source%TYPE;
140:
141: G_TRANS_DFF_PO VARCHAR2(10);
142: l_cdl_system_reference4 pa_transaction_interface.cdl_system_reference4%TYPE :=NULL;
143:
144: --AP VARIANCE
145: G_AP_VAR_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
146: G_AP_VAR_INTERFACE_ID NUMBER;

Line 145: G_AP_VAR_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

141: G_TRANS_DFF_PO VARCHAR2(10);
142: l_cdl_system_reference4 pa_transaction_interface.cdl_system_reference4%TYPE :=NULL;
143:
144: --AP VARIANCE
145: G_AP_VAR_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
146: G_AP_VAR_INTERFACE_ID NUMBER;
147: G_AP_VAR_USER_TXN_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
148: G_AP_VAR_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
149: G_NUM_AP_VARIANCE_MARKED_W NUMBER;

Line 147: G_AP_VAR_USER_TXN_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

143:
144: --AP VARIANCE
145: G_AP_VAR_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
146: G_AP_VAR_INTERFACE_ID NUMBER;
147: G_AP_VAR_USER_TXN_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
148: G_AP_VAR_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
149: G_NUM_AP_VARIANCE_MARKED_W NUMBER;
150: G_NUM_AP_VARIANCE_PROCESSED NUMBER;
151:

Line 148: G_AP_VAR_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

144: --AP VARIANCE
145: G_AP_VAR_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
146: G_AP_VAR_INTERFACE_ID NUMBER;
147: G_AP_VAR_USER_TXN_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
148: G_AP_VAR_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
149: G_NUM_AP_VARIANCE_MARKED_W NUMBER;
150: G_NUM_AP_VARIANCE_PROCESSED NUMBER;
151:
152: --AP ERV

Line 153: G_AP_ERV_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

149: G_NUM_AP_VARIANCE_MARKED_W NUMBER;
150: G_NUM_AP_VARIANCE_PROCESSED NUMBER;
151:
152: --AP ERV
153: G_AP_ERV_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
154: G_AP_ERV_INTERFACE_ID NUMBER;
155: G_AP_ERV_USER_TXN_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
156: G_AP_ERV_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
157:

Line 155: G_AP_ERV_USER_TXN_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

151:
152: --AP ERV
153: G_AP_ERV_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
154: G_AP_ERV_INTERFACE_ID NUMBER;
155: G_AP_ERV_USER_TXN_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
156: G_AP_ERV_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
157:
158: -- AP Freight and Misc
159: G_AP_FRT_BATCH_NAME pa_transaction_interface.batch_name%TYPE; --NEW

Line 156: G_AP_ERV_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

152: --AP ERV
153: G_AP_ERV_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
154: G_AP_ERV_INTERFACE_ID NUMBER;
155: G_AP_ERV_USER_TXN_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
156: G_AP_ERV_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
157:
158: -- AP Freight and Misc
159: G_AP_FRT_BATCH_NAME pa_transaction_interface.batch_name%TYPE; --NEW
160: G_AP_FRT_INTERFACE_ID NUMBER; --NEW

Line 159: G_AP_FRT_BATCH_NAME pa_transaction_interface.batch_name%TYPE; --NEW

155: G_AP_ERV_USER_TXN_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
156: G_AP_ERV_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
157:
158: -- AP Freight and Misc
159: G_AP_FRT_BATCH_NAME pa_transaction_interface.batch_name%TYPE; --NEW
160: G_AP_FRT_INTERFACE_ID NUMBER; --NEW
161:
162: --Prepayment
163: G_PREPAY_BATCH_NAME pa_transaction_interface.batch_name%TYPE; --NEW

Line 163: G_PREPAY_BATCH_NAME pa_transaction_interface.batch_name%TYPE; --NEW

159: G_AP_FRT_BATCH_NAME pa_transaction_interface.batch_name%TYPE; --NEW
160: G_AP_FRT_INTERFACE_ID NUMBER; --NEW
161:
162: --Prepayment
163: G_PREPAY_BATCH_NAME pa_transaction_interface.batch_name%TYPE; --NEW
164: G_PREPAY_INTERFACE_ID NUMBER; --NEW
165:
166: G_UNIQUE_ID NUMBER;
167: G_err_stack VARCHAR2(630);

Line 178: /* Used during insertion into pa_transaction_interface, this variable is set

174: G_ORG_ID NUMBER;
175: E_DIFFERENT_SOB EXCEPTION;
176: L_pay_code_combination_id ap_invoices.accts_pay_code_combination_id%TYPE := NULL;
177:
178: /* Used during insertion into pa_transaction_interface, this variable is set
179: to the weekending date of the maximum expenditure item date of an invoice */
180:
181: G_EXPENDITURE_ENDING_DATE pa_transaction_interface.expenditure_ending_date%TYPE;
182: G_PER_BUS_GRP_ID pa_transaction_interface.person_business_group_id%TYPE;

Line 181: G_EXPENDITURE_ENDING_DATE pa_transaction_interface.expenditure_ending_date%TYPE;

177:
178: /* Used during insertion into pa_transaction_interface, this variable is set
179: to the weekending date of the maximum expenditure item date of an invoice */
180:
181: G_EXPENDITURE_ENDING_DATE pa_transaction_interface.expenditure_ending_date%TYPE;
182: G_PER_BUS_GRP_ID pa_transaction_interface.person_business_group_id%TYPE;
183:
184: /* Added for performance improvement*/
185: G_Assets_Addition_flag ap_invoice_distributions.Assets_Addition_Flag%TYPE;

Line 182: G_PER_BUS_GRP_ID pa_transaction_interface.person_business_group_id%TYPE;

178: /* Used during insertion into pa_transaction_interface, this variable is set
179: to the weekending date of the maximum expenditure item date of an invoice */
180:
181: G_EXPENDITURE_ENDING_DATE pa_transaction_interface.expenditure_ending_date%TYPE;
182: G_PER_BUS_GRP_ID pa_transaction_interface.person_business_group_id%TYPE;
183:
184: /* Added for performance improvement*/
185: G_Assets_Addition_flag ap_invoice_distributions.Assets_Addition_Flag%TYPE;
186:

Line 188: l_pay_cc_id pa_transaction_interface.dr_code_combination_id%TYPE;

184: /* Added for performance improvement*/
185: G_Assets_Addition_flag ap_invoice_distributions.Assets_Addition_Flag%TYPE;
186:
187: /* Added to create pl/sql table columns in the same cursor*/
188: l_pay_cc_id pa_transaction_interface.dr_code_combination_id%TYPE;
189: l_quantity pa_transaction_interface.quantity%TYPE;
190: l_denom_raw_cost pa_transaction_interface.denom_raw_cost%TYPE;
191: l_acct_raw_cost pa_transaction_interface.acct_raw_cost%TYPE;
192: l_denom_cur_code pa_transaction_interface.denom_currency_code%TYPE;

Line 189: l_quantity pa_transaction_interface.quantity%TYPE;

185: G_Assets_Addition_flag ap_invoice_distributions.Assets_Addition_Flag%TYPE;
186:
187: /* Added to create pl/sql table columns in the same cursor*/
188: l_pay_cc_id pa_transaction_interface.dr_code_combination_id%TYPE;
189: l_quantity pa_transaction_interface.quantity%TYPE;
190: l_denom_raw_cost pa_transaction_interface.denom_raw_cost%TYPE;
191: l_acct_raw_cost pa_transaction_interface.acct_raw_cost%TYPE;
192: l_denom_cur_code pa_transaction_interface.denom_currency_code%TYPE;
193: l_acct_rate_date pa_transaction_interface.acct_rate_date%TYPE;

Line 190: l_denom_raw_cost pa_transaction_interface.denom_raw_cost%TYPE;

186:
187: /* Added to create pl/sql table columns in the same cursor*/
188: l_pay_cc_id pa_transaction_interface.dr_code_combination_id%TYPE;
189: l_quantity pa_transaction_interface.quantity%TYPE;
190: l_denom_raw_cost pa_transaction_interface.denom_raw_cost%TYPE;
191: l_acct_raw_cost pa_transaction_interface.acct_raw_cost%TYPE;
192: l_denom_cur_code pa_transaction_interface.denom_currency_code%TYPE;
193: l_acct_rate_date pa_transaction_interface.acct_rate_date%TYPE;
194: l_acct_rate_type pa_transaction_interface.acct_rate_type%TYPE;

Line 191: l_acct_raw_cost pa_transaction_interface.acct_raw_cost%TYPE;

187: /* Added to create pl/sql table columns in the same cursor*/
188: l_pay_cc_id pa_transaction_interface.dr_code_combination_id%TYPE;
189: l_quantity pa_transaction_interface.quantity%TYPE;
190: l_denom_raw_cost pa_transaction_interface.denom_raw_cost%TYPE;
191: l_acct_raw_cost pa_transaction_interface.acct_raw_cost%TYPE;
192: l_denom_cur_code pa_transaction_interface.denom_currency_code%TYPE;
193: l_acct_rate_date pa_transaction_interface.acct_rate_date%TYPE;
194: l_acct_rate_type pa_transaction_interface.acct_rate_type%TYPE;
195: l_acct_exch_rate pa_transaction_interface.acct_exchange_rate%TYPE;

Line 192: l_denom_cur_code pa_transaction_interface.denom_currency_code%TYPE;

188: l_pay_cc_id pa_transaction_interface.dr_code_combination_id%TYPE;
189: l_quantity pa_transaction_interface.quantity%TYPE;
190: l_denom_raw_cost pa_transaction_interface.denom_raw_cost%TYPE;
191: l_acct_raw_cost pa_transaction_interface.acct_raw_cost%TYPE;
192: l_denom_cur_code pa_transaction_interface.denom_currency_code%TYPE;
193: l_acct_rate_date pa_transaction_interface.acct_rate_date%TYPE;
194: l_acct_rate_type pa_transaction_interface.acct_rate_type%TYPE;
195: l_acct_exch_rate pa_transaction_interface.acct_exchange_rate%TYPE;
196: l_txn_src pa_transaction_interface.transaction_source%TYPE;

Line 193: l_acct_rate_date pa_transaction_interface.acct_rate_date%TYPE;

189: l_quantity pa_transaction_interface.quantity%TYPE;
190: l_denom_raw_cost pa_transaction_interface.denom_raw_cost%TYPE;
191: l_acct_raw_cost pa_transaction_interface.acct_raw_cost%TYPE;
192: l_denom_cur_code pa_transaction_interface.denom_currency_code%TYPE;
193: l_acct_rate_date pa_transaction_interface.acct_rate_date%TYPE;
194: l_acct_rate_type pa_transaction_interface.acct_rate_type%TYPE;
195: l_acct_exch_rate pa_transaction_interface.acct_exchange_rate%TYPE;
196: l_txn_src pa_transaction_interface.transaction_source%TYPE;
197: l_user_txn_src pa_transaction_interface.user_transaction_source%TYPE;

Line 194: l_acct_rate_type pa_transaction_interface.acct_rate_type%TYPE;

190: l_denom_raw_cost pa_transaction_interface.denom_raw_cost%TYPE;
191: l_acct_raw_cost pa_transaction_interface.acct_raw_cost%TYPE;
192: l_denom_cur_code pa_transaction_interface.denom_currency_code%TYPE;
193: l_acct_rate_date pa_transaction_interface.acct_rate_date%TYPE;
194: l_acct_rate_type pa_transaction_interface.acct_rate_type%TYPE;
195: l_acct_exch_rate pa_transaction_interface.acct_exchange_rate%TYPE;
196: l_txn_src pa_transaction_interface.transaction_source%TYPE;
197: l_user_txn_src pa_transaction_interface.user_transaction_source%TYPE;
198: l_batch_name pa_transaction_interface.batch_name%TYPE;

Line 195: l_acct_exch_rate pa_transaction_interface.acct_exchange_rate%TYPE;

191: l_acct_raw_cost pa_transaction_interface.acct_raw_cost%TYPE;
192: l_denom_cur_code pa_transaction_interface.denom_currency_code%TYPE;
193: l_acct_rate_date pa_transaction_interface.acct_rate_date%TYPE;
194: l_acct_rate_type pa_transaction_interface.acct_rate_type%TYPE;
195: l_acct_exch_rate pa_transaction_interface.acct_exchange_rate%TYPE;
196: l_txn_src pa_transaction_interface.transaction_source%TYPE;
197: l_user_txn_src pa_transaction_interface.user_transaction_source%TYPE;
198: l_batch_name pa_transaction_interface.batch_name%TYPE;
199: l_interface_id pa_transaction_interface.interface_id%TYPE;

Line 196: l_txn_src pa_transaction_interface.transaction_source%TYPE;

192: l_denom_cur_code pa_transaction_interface.denom_currency_code%TYPE;
193: l_acct_rate_date pa_transaction_interface.acct_rate_date%TYPE;
194: l_acct_rate_type pa_transaction_interface.acct_rate_type%TYPE;
195: l_acct_exch_rate pa_transaction_interface.acct_exchange_rate%TYPE;
196: l_txn_src pa_transaction_interface.transaction_source%TYPE;
197: l_user_txn_src pa_transaction_interface.user_transaction_source%TYPE;
198: l_batch_name pa_transaction_interface.batch_name%TYPE;
199: l_interface_id pa_transaction_interface.interface_id%TYPE;
200: l_exp_end_date pa_transaction_interface.EXPENDITURE_ENDING_DATE%TYPE;

Line 197: l_user_txn_src pa_transaction_interface.user_transaction_source%TYPE;

193: l_acct_rate_date pa_transaction_interface.acct_rate_date%TYPE;
194: l_acct_rate_type pa_transaction_interface.acct_rate_type%TYPE;
195: l_acct_exch_rate pa_transaction_interface.acct_exchange_rate%TYPE;
196: l_txn_src pa_transaction_interface.transaction_source%TYPE;
197: l_user_txn_src pa_transaction_interface.user_transaction_source%TYPE;
198: l_batch_name pa_transaction_interface.batch_name%TYPE;
199: l_interface_id pa_transaction_interface.interface_id%TYPE;
200: l_exp_end_date pa_transaction_interface.EXPENDITURE_ENDING_DATE%TYPE;
201: l_txn_status_code pa_transaction_interface.transaction_status_code%TYPE;

Line 198: l_batch_name pa_transaction_interface.batch_name%TYPE;

194: l_acct_rate_type pa_transaction_interface.acct_rate_type%TYPE;
195: l_acct_exch_rate pa_transaction_interface.acct_exchange_rate%TYPE;
196: l_txn_src pa_transaction_interface.transaction_source%TYPE;
197: l_user_txn_src pa_transaction_interface.user_transaction_source%TYPE;
198: l_batch_name pa_transaction_interface.batch_name%TYPE;
199: l_interface_id pa_transaction_interface.interface_id%TYPE;
200: l_exp_end_date pa_transaction_interface.EXPENDITURE_ENDING_DATE%TYPE;
201: l_txn_status_code pa_transaction_interface.transaction_status_code%TYPE;
202: l_txn_rej_code pa_transaction_interface.transaction_rejection_code%TYPE;

Line 199: l_interface_id pa_transaction_interface.interface_id%TYPE;

195: l_acct_exch_rate pa_transaction_interface.acct_exchange_rate%TYPE;
196: l_txn_src pa_transaction_interface.transaction_source%TYPE;
197: l_user_txn_src pa_transaction_interface.user_transaction_source%TYPE;
198: l_batch_name pa_transaction_interface.batch_name%TYPE;
199: l_interface_id pa_transaction_interface.interface_id%TYPE;
200: l_exp_end_date pa_transaction_interface.EXPENDITURE_ENDING_DATE%TYPE;
201: l_txn_status_code pa_transaction_interface.transaction_status_code%TYPE;
202: l_txn_rej_code pa_transaction_interface.transaction_rejection_code%TYPE;
203: l_bus_grp_id pa_transaction_interface.person_business_group_id%TYPE;

Line 200: l_exp_end_date pa_transaction_interface.EXPENDITURE_ENDING_DATE%TYPE;

196: l_txn_src pa_transaction_interface.transaction_source%TYPE;
197: l_user_txn_src pa_transaction_interface.user_transaction_source%TYPE;
198: l_batch_name pa_transaction_interface.batch_name%TYPE;
199: l_interface_id pa_transaction_interface.interface_id%TYPE;
200: l_exp_end_date pa_transaction_interface.EXPENDITURE_ENDING_DATE%TYPE;
201: l_txn_status_code pa_transaction_interface.transaction_status_code%TYPE;
202: l_txn_rej_code pa_transaction_interface.transaction_rejection_code%TYPE;
203: l_bus_grp_id pa_transaction_interface.person_business_group_id%TYPE;
204: l_record_type VARCHAR2(20);

Line 201: l_txn_status_code pa_transaction_interface.transaction_status_code%TYPE;

197: l_user_txn_src pa_transaction_interface.user_transaction_source%TYPE;
198: l_batch_name pa_transaction_interface.batch_name%TYPE;
199: l_interface_id pa_transaction_interface.interface_id%TYPE;
200: l_exp_end_date pa_transaction_interface.EXPENDITURE_ENDING_DATE%TYPE;
201: l_txn_status_code pa_transaction_interface.transaction_status_code%TYPE;
202: l_txn_rej_code pa_transaction_interface.transaction_rejection_code%TYPE;
203: l_bus_grp_id pa_transaction_interface.person_business_group_id%TYPE;
204: l_record_type VARCHAR2(20);
205: l_insert_flag VARCHAR2(1);

Line 202: l_txn_rej_code pa_transaction_interface.transaction_rejection_code%TYPE;

198: l_batch_name pa_transaction_interface.batch_name%TYPE;
199: l_interface_id pa_transaction_interface.interface_id%TYPE;
200: l_exp_end_date pa_transaction_interface.EXPENDITURE_ENDING_DATE%TYPE;
201: l_txn_status_code pa_transaction_interface.transaction_status_code%TYPE;
202: l_txn_rej_code pa_transaction_interface.transaction_rejection_code%TYPE;
203: l_bus_grp_id pa_transaction_interface.person_business_group_id%TYPE;
204: l_record_type VARCHAR2(20);
205: l_insert_flag VARCHAR2(1);
206: l_cancel_flag VARCHAR2(1) := 'N';

Line 203: l_bus_grp_id pa_transaction_interface.person_business_group_id%TYPE;

199: l_interface_id pa_transaction_interface.interface_id%TYPE;
200: l_exp_end_date pa_transaction_interface.EXPENDITURE_ENDING_DATE%TYPE;
201: l_txn_status_code pa_transaction_interface.transaction_status_code%TYPE;
202: l_txn_rej_code pa_transaction_interface.transaction_rejection_code%TYPE;
203: l_bus_grp_id pa_transaction_interface.person_business_group_id%TYPE;
204: l_record_type VARCHAR2(20);
205: l_insert_flag VARCHAR2(1);
206: l_cancel_flag VARCHAR2(1) := 'N';
207: l_sc_xfer_code VARCHAR2(1) := 'V';

Line 351: FUNCTION Create_New_Org_Transref ( p_batch_name IN pa_transaction_interface.batch_name%TYPE,

347: /* Mark Distributions Phase --------------------------*/
348: PROCEDURE mark_PAflag_O;
349:
350: /* Populate Transaction Interface Phase --------------------------*/
351: FUNCTION Create_New_Org_Transref ( p_batch_name IN pa_transaction_interface.batch_name%TYPE,
352: p_invoice_id IN ap_invoices.invoice_id%TYPE,
353: p_invoice_distribution_id IN ap_invoice_distributions.invoice_distribution_id %TYPE)
354: RETURN pa_transaction_interface.orig_transaction_reference%TYPE;
355:

Line 354: RETURN pa_transaction_interface.orig_transaction_reference%TYPE;

350: /* Populate Transaction Interface Phase --------------------------*/
351: FUNCTION Create_New_Org_Transref ( p_batch_name IN pa_transaction_interface.batch_name%TYPE,
352: p_invoice_id IN ap_invoices.invoice_id%TYPE,
353: p_invoice_distribution_id IN ap_invoice_distributions.invoice_distribution_id %TYPE)
354: RETURN pa_transaction_interface.orig_transaction_reference%TYPE;
355:
356: PRAGMA RESTRICT_REFERENCES(create_new_org_transref, WNDS);
357:
358: PROCEDURE print_stat_and_submit_report;

Line 366: PROCEDURE Trans_Import ( p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,

362: FUNCTION get_mrc_flag RETURN VARCHAR2;
363:
364: /* Transaction Import Phase ---------------------------------------*/
365:
366: PROCEDURE Trans_Import ( p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
367: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
368: p_interface_id IN pa_transaction_interface.interface_id%TYPE,
369: p_user_id IN NUMBER);
370:

Line 367: p_batch_name IN pa_transaction_interface.batch_name%TYPE,

363:
364: /* Transaction Import Phase ---------------------------------------*/
365:
366: PROCEDURE Trans_Import ( p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
367: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
368: p_interface_id IN pa_transaction_interface.interface_id%TYPE,
369: p_user_id IN NUMBER);
370:
371: /*===================================*/

Line 368: p_interface_id IN pa_transaction_interface.interface_id%TYPE,

364: /* Transaction Import Phase ---------------------------------------*/
365:
366: PROCEDURE Trans_Import ( p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
367: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
368: p_interface_id IN pa_transaction_interface.interface_id%TYPE,
369: p_user_id IN NUMBER);
370:
371: /*===================================*/
372: /*Declarations for invoice processing*/

Line 468: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,

464: PROCEDURE transfer_inv_to_pa;
465:
466: /*Tieback to AP Phase --------------------------------------------*/
467: PROCEDURE tieback_AP_ER (
468: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
469: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
470: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
471:
472:

Line 469: p_batch_name IN pa_transaction_interface.batch_name%TYPE,

465:
466: /*Tieback to AP Phase --------------------------------------------*/
467: PROCEDURE tieback_AP_ER (
468: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
469: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
470: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
471:
472:
473: PROCEDURE lock_rcv_txn (p_po_distribution_id IN ap_invoice_distributions.po_distribution_id%TYPE);

Line 470: p_interface_id IN pa_transaction_interface.interface_id%TYPE);

466: /*Tieback to AP Phase --------------------------------------------*/
467: PROCEDURE tieback_AP_ER (
468: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
469: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
470: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
471:
472:
473: PROCEDURE lock_rcv_txn (p_po_distribution_id IN ap_invoice_distributions.po_distribution_id%TYPE);
474:

Line 712: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,

708:
709: PROCEDURE transfer_receipts_to_pa;
710:
711: PROCEDURE tieback_rcv_Txn (
712: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
713: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
714: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
715:
716: PROCEDURE check_failed_receipts (

Line 713: p_batch_name IN pa_transaction_interface.batch_name%TYPE,

709: PROCEDURE transfer_receipts_to_pa;
710:
711: PROCEDURE tieback_rcv_Txn (
712: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
713: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
714: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
715:
716: PROCEDURE check_failed_receipts (
717: p_batch_name IN pa_transaction_interface.batch_name%TYPE,

Line 714: p_interface_id IN pa_transaction_interface.interface_id%TYPE);

710:
711: PROCEDURE tieback_rcv_Txn (
712: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
713: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
714: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
715:
716: PROCEDURE check_failed_receipts (
717: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
718: p_interface_id IN pa_transaction_interface.interface_id%TYPE);

Line 717: p_batch_name IN pa_transaction_interface.batch_name%TYPE,

713: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
714: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
715:
716: PROCEDURE check_failed_receipts (
717: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
718: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
719:
720: PROCEDURE lock_ap_invoice (p_po_distribution_id IN ap_invoice_distributions.po_distribution_id%TYPE);
721:

Line 718: p_interface_id IN pa_transaction_interface.interface_id%TYPE);

714: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
715:
716: PROCEDURE check_failed_receipts (
717: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
718: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
719:
720: PROCEDURE lock_ap_invoice (p_po_distribution_id IN ap_invoice_distributions.po_distribution_id%TYPE);
721:
722: PROCEDURE tieback_locked_invoice;

Line 807: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,

803:
804: PROCEDURE transfer_inv_var_to_pa;
805:
806: PROCEDURE tieback_invoice_variances (
807: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
808: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
809: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
810:
811: /* Added for Bug#3193740 */

Line 808: p_batch_name IN pa_transaction_interface.batch_name%TYPE,

804: PROCEDURE transfer_inv_var_to_pa;
805:
806: PROCEDURE tieback_invoice_variances (
807: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
808: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
809: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
810:
811: /* Added for Bug#3193740 */
812: FUNCTION increment_W_count(W_flag IN VARCHAR2)

Line 809: p_interface_id IN pa_transaction_interface.interface_id%TYPE);

805:
806: PROCEDURE tieback_invoice_variances (
807: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
808: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
809: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
810:
811: /* Added for Bug#3193740 */
812: FUNCTION increment_W_count(W_flag IN VARCHAR2)
813: RETURN VARCHAR2 ;

Line 1047: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,

1043:
1044: PROCEDURE transfer_pay_to_pa;
1045:
1046: PROCEDURE tieback_payment_AP_ER (
1047: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
1048: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
1049: p_batch_type IN Varchar2,
1050: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
1051:

Line 1048: p_batch_name IN pa_transaction_interface.batch_name%TYPE,

1044: PROCEDURE transfer_pay_to_pa;
1045:
1046: PROCEDURE tieback_payment_AP_ER (
1047: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
1048: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
1049: p_batch_type IN Varchar2,
1050: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
1051:
1052: FUNCTION check_prepay_fully_applied(p_prepay_dist_id in NUMBER)

Line 1050: p_interface_id IN pa_transaction_interface.interface_id%TYPE);

1046: PROCEDURE tieback_payment_AP_ER (
1047: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
1048: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
1049: p_batch_type IN Varchar2,
1050: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
1051:
1052: FUNCTION check_prepay_fully_applied(p_prepay_dist_id in NUMBER)
1053: RETURN VARCHAR2;
1054: