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 95: G_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;

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

Line 96: G_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

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

Line 97: G_NRT_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;

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

Line 98: G_NRT_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

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

Line 103: G_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

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

Line 104: G_NRT_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

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

Line 107: G_SYSTEM_LINKAGE pa_transaction_interface.system_linkage%TYPE;

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

Line 109: G_TRANSACTION_STATUS_CODE pa_transaction_interface.transaction_status_code%TYPE;

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

Line 110: G_TRANSACTION_REJECTION_CODE pa_transaction_interface.transaction_rejection_code%TYPE;

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

Line 114: G_DISC_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;

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

Line 115: G_DISC_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

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

Line 116: G_DISC_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

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

Line 127: G_RCV_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

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

Line 128: G_RCVTAX_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

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

Line 131: G_RCV_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;

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

Line 132: G_RCVTAX_TRANSACTION_SOURCE pa_transaction_interface.transaction_source%TYPE;

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

Line 133: G_RCV_USER_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

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

Line 134: G_RCVTAX_USER_TRX_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

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

Line 137: G_RCV_PRC_ADJ_TRX_SRC pa_transaction_interface.transaction_source%TYPE;

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

Line 138: G_RCV_PRC_ADJ_USER_TRX_SRC pa_transaction_interface.user_transaction_source%TYPE;

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

Line 139: G_RCVTAX_PRC_ADJ_TRX_SRC pa_transaction_interface.transaction_source%TYPE;

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

Line 140: G_RCVTAX_PRC_ADJ_USER_TRX_SRC pa_transaction_interface.user_transaction_source%TYPE;

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

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

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

Line 146: G_AP_VAR_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

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

Line 148: G_AP_VAR_USER_TXN_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

144:
145: --AP VARIANCE
146: G_AP_VAR_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
147: G_AP_VAR_INTERFACE_ID NUMBER;
148: G_AP_VAR_USER_TXN_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
149: G_AP_VAR_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
150: G_NUM_AP_VARIANCE_MARKED_W NUMBER;
151: G_NUM_AP_SAT_VARIANCE_MARKED_W NUMBER;--Bug 13602288: Self Assessed Tax Changes
152: G_NUM_AP_VARIANCE_PROCESSED NUMBER;

Line 149: G_AP_VAR_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

145: --AP VARIANCE
146: G_AP_VAR_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
147: G_AP_VAR_INTERFACE_ID NUMBER;
148: G_AP_VAR_USER_TXN_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
149: G_AP_VAR_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
150: G_NUM_AP_VARIANCE_MARKED_W NUMBER;
151: G_NUM_AP_SAT_VARIANCE_MARKED_W NUMBER;--Bug 13602288: Self Assessed Tax Changes
152: G_NUM_AP_VARIANCE_PROCESSED NUMBER;
153:

Line 155: G_AP_ERV_BATCH_NAME pa_transaction_interface.batch_name%TYPE;

151: G_NUM_AP_SAT_VARIANCE_MARKED_W NUMBER;--Bug 13602288: Self Assessed Tax Changes
152: G_NUM_AP_VARIANCE_PROCESSED NUMBER;
153:
154: --AP ERV
155: G_AP_ERV_BATCH_NAME pa_transaction_interface.batch_name%TYPE;
156: G_AP_ERV_INTERFACE_ID NUMBER;
157: G_AP_ERV_USER_TXN_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
158: G_AP_ERV_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;
159:

Line 157: G_AP_ERV_USER_TXN_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

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

Line 158: G_AP_ERV_TRANSACTION_SOURCE pa_transaction_interface.user_transaction_source%TYPE;

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

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

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

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

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

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

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

Line 183: G_EXPENDITURE_ENDING_DATE pa_transaction_interface.expenditure_ending_date%TYPE;

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

Line 184: G_PER_BUS_GRP_ID pa_transaction_interface.person_business_group_id%TYPE;

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

Line 190: l_pay_cc_id pa_transaction_interface.dr_code_combination_id%TYPE;

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

Line 191: l_quantity pa_transaction_interface.quantity%TYPE;

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

Line 192: l_denom_raw_cost pa_transaction_interface.denom_raw_cost%TYPE;

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

Line 193: l_acct_raw_cost pa_transaction_interface.acct_raw_cost%TYPE;

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

Line 194: l_denom_cur_code pa_transaction_interface.denom_currency_code%TYPE;

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

Line 195: l_acct_rate_date pa_transaction_interface.acct_rate_date%TYPE;

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

Line 196: l_acct_rate_type pa_transaction_interface.acct_rate_type%TYPE;

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

Line 197: l_acct_exch_rate pa_transaction_interface.acct_exchange_rate%TYPE;

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

Line 198: l_txn_src pa_transaction_interface.transaction_source%TYPE;

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

Line 199: l_user_txn_src pa_transaction_interface.user_transaction_source%TYPE;

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

Line 200: l_batch_name pa_transaction_interface.batch_name%TYPE;

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

Line 201: l_interface_id pa_transaction_interface.interface_id%TYPE;

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

Line 202: l_exp_end_date pa_transaction_interface.EXPENDITURE_ENDING_DATE%TYPE;

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

Line 203: l_txn_status_code pa_transaction_interface.transaction_status_code%TYPE;

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

Line 204: l_txn_rej_code pa_transaction_interface.transaction_rejection_code%TYPE;

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

Line 205: l_bus_grp_id pa_transaction_interface.person_business_group_id%TYPE;

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

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

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

Line 358: RETURN pa_transaction_interface.orig_transaction_reference%TYPE;

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

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

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

Line 371: p_batch_name IN pa_transaction_interface.batch_name%TYPE,

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

Line 372: p_interface_id IN pa_transaction_interface.interface_id%TYPE,

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

Line 473: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,

469: PROCEDURE transfer_inv_to_pa;
470:
471: /*Tieback to AP Phase --------------------------------------------*/
472: PROCEDURE tieback_AP_ER (
473: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
474: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
475: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
476:
477:

Line 474: p_batch_name IN pa_transaction_interface.batch_name%TYPE,

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

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

471: /*Tieback to AP Phase --------------------------------------------*/
472: PROCEDURE tieback_AP_ER (
473: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
474: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
475: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
476:
477:
478: PROCEDURE lock_rcv_txn (p_po_distribution_id IN ap_invoice_distributions.po_distribution_id%TYPE);
479:

Line 719: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,

715:
716: PROCEDURE transfer_receipts_to_pa;
717:
718: PROCEDURE tieback_rcv_Txn (
719: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
720: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
721: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
722:
723: PROCEDURE check_failed_receipts (

Line 720: p_batch_name IN pa_transaction_interface.batch_name%TYPE,

716: PROCEDURE transfer_receipts_to_pa;
717:
718: PROCEDURE tieback_rcv_Txn (
719: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
720: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
721: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
722:
723: PROCEDURE check_failed_receipts (
724: p_batch_name IN pa_transaction_interface.batch_name%TYPE,

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

717:
718: PROCEDURE tieback_rcv_Txn (
719: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
720: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
721: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
722:
723: PROCEDURE check_failed_receipts (
724: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
725: p_interface_id IN pa_transaction_interface.interface_id%TYPE);

Line 724: p_batch_name IN pa_transaction_interface.batch_name%TYPE,

720: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
721: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
722:
723: PROCEDURE check_failed_receipts (
724: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
725: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
726:
727: PROCEDURE lock_ap_invoice (p_po_distribution_id IN ap_invoice_distributions.po_distribution_id%TYPE);
728:

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

721: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
722:
723: PROCEDURE check_failed_receipts (
724: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
725: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
726:
727: PROCEDURE lock_ap_invoice (p_po_distribution_id IN ap_invoice_distributions.po_distribution_id%TYPE);
728:
729: PROCEDURE tieback_locked_invoice;

Line 814: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,

810:
811: PROCEDURE transfer_inv_var_to_pa;
812:
813: PROCEDURE tieback_invoice_variances (
814: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
815: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
816: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
817:
818: /* Added for Bug#3193740 */

Line 815: p_batch_name IN pa_transaction_interface.batch_name%TYPE,

811: PROCEDURE transfer_inv_var_to_pa;
812:
813: PROCEDURE tieback_invoice_variances (
814: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
815: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
816: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
817:
818: /* Added for Bug#3193740 */
819: FUNCTION increment_W_count(W_flag IN VARCHAR2)

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

812:
813: PROCEDURE tieback_invoice_variances (
814: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
815: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
816: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
817:
818: /* Added for Bug#3193740 */
819: FUNCTION increment_W_count(W_flag IN VARCHAR2)
820: RETURN VARCHAR2 ;

Line 1054: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,

1050:
1051: PROCEDURE transfer_pay_to_pa;
1052:
1053: PROCEDURE tieback_payment_AP_ER (
1054: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
1055: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
1056: p_batch_type IN Varchar2,
1057: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
1058:

Line 1055: p_batch_name IN pa_transaction_interface.batch_name%TYPE,

1051: PROCEDURE transfer_pay_to_pa;
1052:
1053: PROCEDURE tieback_payment_AP_ER (
1054: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
1055: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
1056: p_batch_type IN Varchar2,
1057: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
1058:
1059: FUNCTION check_prepay_fully_applied(p_prepay_dist_id in NUMBER,is_self_assessed_tax in VARCHAR2) --Bug 13602288: Self Assessed Tax Changes

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

1053: PROCEDURE tieback_payment_AP_ER (
1054: p_transaction_source IN pa_transaction_interface.transaction_source%TYPE,
1055: p_batch_name IN pa_transaction_interface.batch_name%TYPE,
1056: p_batch_type IN Varchar2,
1057: p_interface_id IN pa_transaction_interface.interface_id%TYPE);
1058:
1059: FUNCTION check_prepay_fully_applied(p_prepay_dist_id in NUMBER,is_self_assessed_tax in VARCHAR2) --Bug 13602288: Self Assessed Tax Changes
1060: RETURN VARCHAR2;
1061: