[Home] [Help]
44: | |
45: | SCOPE - PUBLIC |
46: | |
47: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
48: | arp_util.debug |
49: | |
50: | ARGUMENTS : IN: |
51: | p_dist_rec |
52: | OUT: |
68:
69:
70: BEGIN
71:
72: arp_util.debug('arp_ctlgd_pkg.display_dist_rec()+');
73:
74: arp_util.debug('************** Dump of ra_cust_trx_line_gl_dist record '||
75: '**************');
76:
70: BEGIN
71:
72: arp_util.debug('arp_ctlgd_pkg.display_dist_rec()+');
73:
74: arp_util.debug('************** Dump of ra_cust_trx_line_gl_dist record '||
75: '**************');
76:
77: arp_util.debug('cust_trx_line_gl_dist_id: '
78: || p_dist_rec.cust_trx_line_gl_dist_id);
73:
74: arp_util.debug('************** Dump of ra_cust_trx_line_gl_dist record '||
75: '**************');
76:
77: arp_util.debug('cust_trx_line_gl_dist_id: '
78: || p_dist_rec.cust_trx_line_gl_dist_id);
79: arp_util.debug('customer_trx_id: ' || p_dist_rec.customer_trx_id);
80: arp_util.debug('customer_trx_line_id: ' || p_dist_rec.customer_trx_line_id);
81: arp_util.debug('cust_trx_line_salesrep_id: '
75: '**************');
76:
77: arp_util.debug('cust_trx_line_gl_dist_id: '
78: || p_dist_rec.cust_trx_line_gl_dist_id);
79: arp_util.debug('customer_trx_id: ' || p_dist_rec.customer_trx_id);
80: arp_util.debug('customer_trx_line_id: ' || p_dist_rec.customer_trx_line_id);
81: arp_util.debug('cust_trx_line_salesrep_id: '
82: || p_dist_rec.cust_trx_line_salesrep_id);
83: arp_util.debug('account_class: ' || p_dist_rec.account_class);
76:
77: arp_util.debug('cust_trx_line_gl_dist_id: '
78: || p_dist_rec.cust_trx_line_gl_dist_id);
79: arp_util.debug('customer_trx_id: ' || p_dist_rec.customer_trx_id);
80: arp_util.debug('customer_trx_line_id: ' || p_dist_rec.customer_trx_line_id);
81: arp_util.debug('cust_trx_line_salesrep_id: '
82: || p_dist_rec.cust_trx_line_salesrep_id);
83: arp_util.debug('account_class: ' || p_dist_rec.account_class);
84: arp_util.debug('percent: ' || p_dist_rec.percent);
77: arp_util.debug('cust_trx_line_gl_dist_id: '
78: || p_dist_rec.cust_trx_line_gl_dist_id);
79: arp_util.debug('customer_trx_id: ' || p_dist_rec.customer_trx_id);
80: arp_util.debug('customer_trx_line_id: ' || p_dist_rec.customer_trx_line_id);
81: arp_util.debug('cust_trx_line_salesrep_id: '
82: || p_dist_rec.cust_trx_line_salesrep_id);
83: arp_util.debug('account_class: ' || p_dist_rec.account_class);
84: arp_util.debug('percent: ' || p_dist_rec.percent);
85: arp_util.debug('amount: ' || p_dist_rec.amount);
79: arp_util.debug('customer_trx_id: ' || p_dist_rec.customer_trx_id);
80: arp_util.debug('customer_trx_line_id: ' || p_dist_rec.customer_trx_line_id);
81: arp_util.debug('cust_trx_line_salesrep_id: '
82: || p_dist_rec.cust_trx_line_salesrep_id);
83: arp_util.debug('account_class: ' || p_dist_rec.account_class);
84: arp_util.debug('percent: ' || p_dist_rec.percent);
85: arp_util.debug('amount: ' || p_dist_rec.amount);
86: arp_util.debug('acctd_amount: ' || p_dist_rec.acctd_amount);
87: arp_util.debug('gl_date: ' || p_dist_rec.gl_date);
80: arp_util.debug('customer_trx_line_id: ' || p_dist_rec.customer_trx_line_id);
81: arp_util.debug('cust_trx_line_salesrep_id: '
82: || p_dist_rec.cust_trx_line_salesrep_id);
83: arp_util.debug('account_class: ' || p_dist_rec.account_class);
84: arp_util.debug('percent: ' || p_dist_rec.percent);
85: arp_util.debug('amount: ' || p_dist_rec.amount);
86: arp_util.debug('acctd_amount: ' || p_dist_rec.acctd_amount);
87: arp_util.debug('gl_date: ' || p_dist_rec.gl_date);
88: arp_util.debug('original_gl_date: ' || p_dist_rec.original_gl_date);
81: arp_util.debug('cust_trx_line_salesrep_id: '
82: || p_dist_rec.cust_trx_line_salesrep_id);
83: arp_util.debug('account_class: ' || p_dist_rec.account_class);
84: arp_util.debug('percent: ' || p_dist_rec.percent);
85: arp_util.debug('amount: ' || p_dist_rec.amount);
86: arp_util.debug('acctd_amount: ' || p_dist_rec.acctd_amount);
87: arp_util.debug('gl_date: ' || p_dist_rec.gl_date);
88: arp_util.debug('original_gl_date: ' || p_dist_rec.original_gl_date);
89: arp_util.debug('gl_posted_date: ' || p_dist_rec.gl_posted_date);
82: || p_dist_rec.cust_trx_line_salesrep_id);
83: arp_util.debug('account_class: ' || p_dist_rec.account_class);
84: arp_util.debug('percent: ' || p_dist_rec.percent);
85: arp_util.debug('amount: ' || p_dist_rec.amount);
86: arp_util.debug('acctd_amount: ' || p_dist_rec.acctd_amount);
87: arp_util.debug('gl_date: ' || p_dist_rec.gl_date);
88: arp_util.debug('original_gl_date: ' || p_dist_rec.original_gl_date);
89: arp_util.debug('gl_posted_date: ' || p_dist_rec.gl_posted_date);
90: arp_util.debug('code_combination_id: ' || p_dist_rec.code_combination_id);
83: arp_util.debug('account_class: ' || p_dist_rec.account_class);
84: arp_util.debug('percent: ' || p_dist_rec.percent);
85: arp_util.debug('amount: ' || p_dist_rec.amount);
86: arp_util.debug('acctd_amount: ' || p_dist_rec.acctd_amount);
87: arp_util.debug('gl_date: ' || p_dist_rec.gl_date);
88: arp_util.debug('original_gl_date: ' || p_dist_rec.original_gl_date);
89: arp_util.debug('gl_posted_date: ' || p_dist_rec.gl_posted_date);
90: arp_util.debug('code_combination_id: ' || p_dist_rec.code_combination_id);
91: arp_util.debug('concatenated_segments: '
84: arp_util.debug('percent: ' || p_dist_rec.percent);
85: arp_util.debug('amount: ' || p_dist_rec.amount);
86: arp_util.debug('acctd_amount: ' || p_dist_rec.acctd_amount);
87: arp_util.debug('gl_date: ' || p_dist_rec.gl_date);
88: arp_util.debug('original_gl_date: ' || p_dist_rec.original_gl_date);
89: arp_util.debug('gl_posted_date: ' || p_dist_rec.gl_posted_date);
90: arp_util.debug('code_combination_id: ' || p_dist_rec.code_combination_id);
91: arp_util.debug('concatenated_segments: '
92: || p_dist_rec.concatenated_segments);
85: arp_util.debug('amount: ' || p_dist_rec.amount);
86: arp_util.debug('acctd_amount: ' || p_dist_rec.acctd_amount);
87: arp_util.debug('gl_date: ' || p_dist_rec.gl_date);
88: arp_util.debug('original_gl_date: ' || p_dist_rec.original_gl_date);
89: arp_util.debug('gl_posted_date: ' || p_dist_rec.gl_posted_date);
90: arp_util.debug('code_combination_id: ' || p_dist_rec.code_combination_id);
91: arp_util.debug('concatenated_segments: '
92: || p_dist_rec.concatenated_segments);
93: arp_util.debug('collected_tax_ccid: ' || p_dist_rec.collected_tax_ccid);
86: arp_util.debug('acctd_amount: ' || p_dist_rec.acctd_amount);
87: arp_util.debug('gl_date: ' || p_dist_rec.gl_date);
88: arp_util.debug('original_gl_date: ' || p_dist_rec.original_gl_date);
89: arp_util.debug('gl_posted_date: ' || p_dist_rec.gl_posted_date);
90: arp_util.debug('code_combination_id: ' || p_dist_rec.code_combination_id);
91: arp_util.debug('concatenated_segments: '
92: || p_dist_rec.concatenated_segments);
93: arp_util.debug('collected_tax_ccid: ' || p_dist_rec.collected_tax_ccid);
94: arp_util.debug('collected_tax_concat_seg: '
87: arp_util.debug('gl_date: ' || p_dist_rec.gl_date);
88: arp_util.debug('original_gl_date: ' || p_dist_rec.original_gl_date);
89: arp_util.debug('gl_posted_date: ' || p_dist_rec.gl_posted_date);
90: arp_util.debug('code_combination_id: ' || p_dist_rec.code_combination_id);
91: arp_util.debug('concatenated_segments: '
92: || p_dist_rec.concatenated_segments);
93: arp_util.debug('collected_tax_ccid: ' || p_dist_rec.collected_tax_ccid);
94: arp_util.debug('collected_tax_concat_seg: '
95: || p_dist_rec.collected_tax_concat_seg);
89: arp_util.debug('gl_posted_date: ' || p_dist_rec.gl_posted_date);
90: arp_util.debug('code_combination_id: ' || p_dist_rec.code_combination_id);
91: arp_util.debug('concatenated_segments: '
92: || p_dist_rec.concatenated_segments);
93: arp_util.debug('collected_tax_ccid: ' || p_dist_rec.collected_tax_ccid);
94: arp_util.debug('collected_tax_concat_seg: '
95: || p_dist_rec.collected_tax_concat_seg);
96: arp_util.debug('comments: ' || p_dist_rec.comments);
97: arp_util.debug('account_set_flag: ' || p_dist_rec.account_set_flag);
90: arp_util.debug('code_combination_id: ' || p_dist_rec.code_combination_id);
91: arp_util.debug('concatenated_segments: '
92: || p_dist_rec.concatenated_segments);
93: arp_util.debug('collected_tax_ccid: ' || p_dist_rec.collected_tax_ccid);
94: arp_util.debug('collected_tax_concat_seg: '
95: || p_dist_rec.collected_tax_concat_seg);
96: arp_util.debug('comments: ' || p_dist_rec.comments);
97: arp_util.debug('account_set_flag: ' || p_dist_rec.account_set_flag);
98: arp_util.debug('latest_rec_flag: ' || p_dist_rec.latest_rec_flag);
92: || p_dist_rec.concatenated_segments);
93: arp_util.debug('collected_tax_ccid: ' || p_dist_rec.collected_tax_ccid);
94: arp_util.debug('collected_tax_concat_seg: '
95: || p_dist_rec.collected_tax_concat_seg);
96: arp_util.debug('comments: ' || p_dist_rec.comments);
97: arp_util.debug('account_set_flag: ' || p_dist_rec.account_set_flag);
98: arp_util.debug('latest_rec_flag: ' || p_dist_rec.latest_rec_flag);
99: arp_util.debug('rec_offset_flag: ' || p_dist_rec.rec_offset_flag);
100: arp_util.debug('ussgl_transaction_code: '
93: arp_util.debug('collected_tax_ccid: ' || p_dist_rec.collected_tax_ccid);
94: arp_util.debug('collected_tax_concat_seg: '
95: || p_dist_rec.collected_tax_concat_seg);
96: arp_util.debug('comments: ' || p_dist_rec.comments);
97: arp_util.debug('account_set_flag: ' || p_dist_rec.account_set_flag);
98: arp_util.debug('latest_rec_flag: ' || p_dist_rec.latest_rec_flag);
99: arp_util.debug('rec_offset_flag: ' || p_dist_rec.rec_offset_flag);
100: arp_util.debug('ussgl_transaction_code: '
101: || p_dist_rec.ussgl_transaction_code);
94: arp_util.debug('collected_tax_concat_seg: '
95: || p_dist_rec.collected_tax_concat_seg);
96: arp_util.debug('comments: ' || p_dist_rec.comments);
97: arp_util.debug('account_set_flag: ' || p_dist_rec.account_set_flag);
98: arp_util.debug('latest_rec_flag: ' || p_dist_rec.latest_rec_flag);
99: arp_util.debug('rec_offset_flag: ' || p_dist_rec.rec_offset_flag);
100: arp_util.debug('ussgl_transaction_code: '
101: || p_dist_rec.ussgl_transaction_code);
102: arp_util.debug('ussgl_transaction_code_context: '
95: || p_dist_rec.collected_tax_concat_seg);
96: arp_util.debug('comments: ' || p_dist_rec.comments);
97: arp_util.debug('account_set_flag: ' || p_dist_rec.account_set_flag);
98: arp_util.debug('latest_rec_flag: ' || p_dist_rec.latest_rec_flag);
99: arp_util.debug('rec_offset_flag: ' || p_dist_rec.rec_offset_flag);
100: arp_util.debug('ussgl_transaction_code: '
101: || p_dist_rec.ussgl_transaction_code);
102: arp_util.debug('ussgl_transaction_code_context: '
103: || p_dist_rec.ussgl_transaction_code_context);
96: arp_util.debug('comments: ' || p_dist_rec.comments);
97: arp_util.debug('account_set_flag: ' || p_dist_rec.account_set_flag);
98: arp_util.debug('latest_rec_flag: ' || p_dist_rec.latest_rec_flag);
99: arp_util.debug('rec_offset_flag: ' || p_dist_rec.rec_offset_flag);
100: arp_util.debug('ussgl_transaction_code: '
101: || p_dist_rec.ussgl_transaction_code);
102: arp_util.debug('ussgl_transaction_code_context: '
103: || p_dist_rec.ussgl_transaction_code_context);
104: arp_util.debug('attribute_category: ' || p_dist_rec.attribute_category);
98: arp_util.debug('latest_rec_flag: ' || p_dist_rec.latest_rec_flag);
99: arp_util.debug('rec_offset_flag: ' || p_dist_rec.rec_offset_flag);
100: arp_util.debug('ussgl_transaction_code: '
101: || p_dist_rec.ussgl_transaction_code);
102: arp_util.debug('ussgl_transaction_code_context: '
103: || p_dist_rec.ussgl_transaction_code_context);
104: arp_util.debug('attribute_category: ' || p_dist_rec.attribute_category);
105: arp_util.debug('attribute1: ' || p_dist_rec.attribute1);
106: arp_util.debug('attribute2: ' || p_dist_rec.attribute2);
100: arp_util.debug('ussgl_transaction_code: '
101: || p_dist_rec.ussgl_transaction_code);
102: arp_util.debug('ussgl_transaction_code_context: '
103: || p_dist_rec.ussgl_transaction_code_context);
104: arp_util.debug('attribute_category: ' || p_dist_rec.attribute_category);
105: arp_util.debug('attribute1: ' || p_dist_rec.attribute1);
106: arp_util.debug('attribute2: ' || p_dist_rec.attribute2);
107: arp_util.debug('attribute3: ' || p_dist_rec.attribute3);
108: arp_util.debug('attribute4: ' || p_dist_rec.attribute4);
101: || p_dist_rec.ussgl_transaction_code);
102: arp_util.debug('ussgl_transaction_code_context: '
103: || p_dist_rec.ussgl_transaction_code_context);
104: arp_util.debug('attribute_category: ' || p_dist_rec.attribute_category);
105: arp_util.debug('attribute1: ' || p_dist_rec.attribute1);
106: arp_util.debug('attribute2: ' || p_dist_rec.attribute2);
107: arp_util.debug('attribute3: ' || p_dist_rec.attribute3);
108: arp_util.debug('attribute4: ' || p_dist_rec.attribute4);
109: arp_util.debug('attribute5: ' || p_dist_rec.attribute5);
102: arp_util.debug('ussgl_transaction_code_context: '
103: || p_dist_rec.ussgl_transaction_code_context);
104: arp_util.debug('attribute_category: ' || p_dist_rec.attribute_category);
105: arp_util.debug('attribute1: ' || p_dist_rec.attribute1);
106: arp_util.debug('attribute2: ' || p_dist_rec.attribute2);
107: arp_util.debug('attribute3: ' || p_dist_rec.attribute3);
108: arp_util.debug('attribute4: ' || p_dist_rec.attribute4);
109: arp_util.debug('attribute5: ' || p_dist_rec.attribute5);
110: arp_util.debug('attribute6: ' || p_dist_rec.attribute6);
103: || p_dist_rec.ussgl_transaction_code_context);
104: arp_util.debug('attribute_category: ' || p_dist_rec.attribute_category);
105: arp_util.debug('attribute1: ' || p_dist_rec.attribute1);
106: arp_util.debug('attribute2: ' || p_dist_rec.attribute2);
107: arp_util.debug('attribute3: ' || p_dist_rec.attribute3);
108: arp_util.debug('attribute4: ' || p_dist_rec.attribute4);
109: arp_util.debug('attribute5: ' || p_dist_rec.attribute5);
110: arp_util.debug('attribute6: ' || p_dist_rec.attribute6);
111: arp_util.debug('attribute7: ' || p_dist_rec.attribute7);
104: arp_util.debug('attribute_category: ' || p_dist_rec.attribute_category);
105: arp_util.debug('attribute1: ' || p_dist_rec.attribute1);
106: arp_util.debug('attribute2: ' || p_dist_rec.attribute2);
107: arp_util.debug('attribute3: ' || p_dist_rec.attribute3);
108: arp_util.debug('attribute4: ' || p_dist_rec.attribute4);
109: arp_util.debug('attribute5: ' || p_dist_rec.attribute5);
110: arp_util.debug('attribute6: ' || p_dist_rec.attribute6);
111: arp_util.debug('attribute7: ' || p_dist_rec.attribute7);
112: arp_util.debug('attribute8: ' || p_dist_rec.attribute8);
105: arp_util.debug('attribute1: ' || p_dist_rec.attribute1);
106: arp_util.debug('attribute2: ' || p_dist_rec.attribute2);
107: arp_util.debug('attribute3: ' || p_dist_rec.attribute3);
108: arp_util.debug('attribute4: ' || p_dist_rec.attribute4);
109: arp_util.debug('attribute5: ' || p_dist_rec.attribute5);
110: arp_util.debug('attribute6: ' || p_dist_rec.attribute6);
111: arp_util.debug('attribute7: ' || p_dist_rec.attribute7);
112: arp_util.debug('attribute8: ' || p_dist_rec.attribute8);
113: arp_util.debug('attribute9: ' || p_dist_rec.attribute9);
106: arp_util.debug('attribute2: ' || p_dist_rec.attribute2);
107: arp_util.debug('attribute3: ' || p_dist_rec.attribute3);
108: arp_util.debug('attribute4: ' || p_dist_rec.attribute4);
109: arp_util.debug('attribute5: ' || p_dist_rec.attribute5);
110: arp_util.debug('attribute6: ' || p_dist_rec.attribute6);
111: arp_util.debug('attribute7: ' || p_dist_rec.attribute7);
112: arp_util.debug('attribute8: ' || p_dist_rec.attribute8);
113: arp_util.debug('attribute9: ' || p_dist_rec.attribute9);
114: arp_util.debug('attribute10: ' || p_dist_rec.attribute10);
107: arp_util.debug('attribute3: ' || p_dist_rec.attribute3);
108: arp_util.debug('attribute4: ' || p_dist_rec.attribute4);
109: arp_util.debug('attribute5: ' || p_dist_rec.attribute5);
110: arp_util.debug('attribute6: ' || p_dist_rec.attribute6);
111: arp_util.debug('attribute7: ' || p_dist_rec.attribute7);
112: arp_util.debug('attribute8: ' || p_dist_rec.attribute8);
113: arp_util.debug('attribute9: ' || p_dist_rec.attribute9);
114: arp_util.debug('attribute10: ' || p_dist_rec.attribute10);
115: arp_util.debug('attribute11: ' || p_dist_rec.attribute11);
108: arp_util.debug('attribute4: ' || p_dist_rec.attribute4);
109: arp_util.debug('attribute5: ' || p_dist_rec.attribute5);
110: arp_util.debug('attribute6: ' || p_dist_rec.attribute6);
111: arp_util.debug('attribute7: ' || p_dist_rec.attribute7);
112: arp_util.debug('attribute8: ' || p_dist_rec.attribute8);
113: arp_util.debug('attribute9: ' || p_dist_rec.attribute9);
114: arp_util.debug('attribute10: ' || p_dist_rec.attribute10);
115: arp_util.debug('attribute11: ' || p_dist_rec.attribute11);
116: arp_util.debug('attribute12: ' || p_dist_rec.attribute12);
109: arp_util.debug('attribute5: ' || p_dist_rec.attribute5);
110: arp_util.debug('attribute6: ' || p_dist_rec.attribute6);
111: arp_util.debug('attribute7: ' || p_dist_rec.attribute7);
112: arp_util.debug('attribute8: ' || p_dist_rec.attribute8);
113: arp_util.debug('attribute9: ' || p_dist_rec.attribute9);
114: arp_util.debug('attribute10: ' || p_dist_rec.attribute10);
115: arp_util.debug('attribute11: ' || p_dist_rec.attribute11);
116: arp_util.debug('attribute12: ' || p_dist_rec.attribute12);
117: arp_util.debug('attribute13: ' || p_dist_rec.attribute13);
110: arp_util.debug('attribute6: ' || p_dist_rec.attribute6);
111: arp_util.debug('attribute7: ' || p_dist_rec.attribute7);
112: arp_util.debug('attribute8: ' || p_dist_rec.attribute8);
113: arp_util.debug('attribute9: ' || p_dist_rec.attribute9);
114: arp_util.debug('attribute10: ' || p_dist_rec.attribute10);
115: arp_util.debug('attribute11: ' || p_dist_rec.attribute11);
116: arp_util.debug('attribute12: ' || p_dist_rec.attribute12);
117: arp_util.debug('attribute13: ' || p_dist_rec.attribute13);
118: arp_util.debug('attribute14: ' || p_dist_rec.attribute14);
111: arp_util.debug('attribute7: ' || p_dist_rec.attribute7);
112: arp_util.debug('attribute8: ' || p_dist_rec.attribute8);
113: arp_util.debug('attribute9: ' || p_dist_rec.attribute9);
114: arp_util.debug('attribute10: ' || p_dist_rec.attribute10);
115: arp_util.debug('attribute11: ' || p_dist_rec.attribute11);
116: arp_util.debug('attribute12: ' || p_dist_rec.attribute12);
117: arp_util.debug('attribute13: ' || p_dist_rec.attribute13);
118: arp_util.debug('attribute14: ' || p_dist_rec.attribute14);
119: arp_util.debug('attribute15: ' || p_dist_rec.attribute15);
112: arp_util.debug('attribute8: ' || p_dist_rec.attribute8);
113: arp_util.debug('attribute9: ' || p_dist_rec.attribute9);
114: arp_util.debug('attribute10: ' || p_dist_rec.attribute10);
115: arp_util.debug('attribute11: ' || p_dist_rec.attribute11);
116: arp_util.debug('attribute12: ' || p_dist_rec.attribute12);
117: arp_util.debug('attribute13: ' || p_dist_rec.attribute13);
118: arp_util.debug('attribute14: ' || p_dist_rec.attribute14);
119: arp_util.debug('attribute15: ' || p_dist_rec.attribute15);
120: arp_util.debug('set_of_books_id: ' || p_dist_rec.set_of_books_id);
113: arp_util.debug('attribute9: ' || p_dist_rec.attribute9);
114: arp_util.debug('attribute10: ' || p_dist_rec.attribute10);
115: arp_util.debug('attribute11: ' || p_dist_rec.attribute11);
116: arp_util.debug('attribute12: ' || p_dist_rec.attribute12);
117: arp_util.debug('attribute13: ' || p_dist_rec.attribute13);
118: arp_util.debug('attribute14: ' || p_dist_rec.attribute14);
119: arp_util.debug('attribute15: ' || p_dist_rec.attribute15);
120: arp_util.debug('set_of_books_id: ' || p_dist_rec.set_of_books_id);
121: arp_util.debug('posting_control_id: ' || p_dist_rec.posting_control_id);
114: arp_util.debug('attribute10: ' || p_dist_rec.attribute10);
115: arp_util.debug('attribute11: ' || p_dist_rec.attribute11);
116: arp_util.debug('attribute12: ' || p_dist_rec.attribute12);
117: arp_util.debug('attribute13: ' || p_dist_rec.attribute13);
118: arp_util.debug('attribute14: ' || p_dist_rec.attribute14);
119: arp_util.debug('attribute15: ' || p_dist_rec.attribute15);
120: arp_util.debug('set_of_books_id: ' || p_dist_rec.set_of_books_id);
121: arp_util.debug('posting_control_id: ' || p_dist_rec.posting_control_id);
122: arp_util.debug('last_updated_by: ' || p_dist_rec.last_updated_by);
115: arp_util.debug('attribute11: ' || p_dist_rec.attribute11);
116: arp_util.debug('attribute12: ' || p_dist_rec.attribute12);
117: arp_util.debug('attribute13: ' || p_dist_rec.attribute13);
118: arp_util.debug('attribute14: ' || p_dist_rec.attribute14);
119: arp_util.debug('attribute15: ' || p_dist_rec.attribute15);
120: arp_util.debug('set_of_books_id: ' || p_dist_rec.set_of_books_id);
121: arp_util.debug('posting_control_id: ' || p_dist_rec.posting_control_id);
122: arp_util.debug('last_updated_by: ' || p_dist_rec.last_updated_by);
123: arp_util.debug('created_by: ' || p_dist_rec.created_by);
116: arp_util.debug('attribute12: ' || p_dist_rec.attribute12);
117: arp_util.debug('attribute13: ' || p_dist_rec.attribute13);
118: arp_util.debug('attribute14: ' || p_dist_rec.attribute14);
119: arp_util.debug('attribute15: ' || p_dist_rec.attribute15);
120: arp_util.debug('set_of_books_id: ' || p_dist_rec.set_of_books_id);
121: arp_util.debug('posting_control_id: ' || p_dist_rec.posting_control_id);
122: arp_util.debug('last_updated_by: ' || p_dist_rec.last_updated_by);
123: arp_util.debug('created_by: ' || p_dist_rec.created_by);
124: arp_util.debug('last_update_login: ' || p_dist_rec.last_update_login);
117: arp_util.debug('attribute13: ' || p_dist_rec.attribute13);
118: arp_util.debug('attribute14: ' || p_dist_rec.attribute14);
119: arp_util.debug('attribute15: ' || p_dist_rec.attribute15);
120: arp_util.debug('set_of_books_id: ' || p_dist_rec.set_of_books_id);
121: arp_util.debug('posting_control_id: ' || p_dist_rec.posting_control_id);
122: arp_util.debug('last_updated_by: ' || p_dist_rec.last_updated_by);
123: arp_util.debug('created_by: ' || p_dist_rec.created_by);
124: arp_util.debug('last_update_login: ' || p_dist_rec.last_update_login);
125: arp_util.debug('program_application_id: '
118: arp_util.debug('attribute14: ' || p_dist_rec.attribute14);
119: arp_util.debug('attribute15: ' || p_dist_rec.attribute15);
120: arp_util.debug('set_of_books_id: ' || p_dist_rec.set_of_books_id);
121: arp_util.debug('posting_control_id: ' || p_dist_rec.posting_control_id);
122: arp_util.debug('last_updated_by: ' || p_dist_rec.last_updated_by);
123: arp_util.debug('created_by: ' || p_dist_rec.created_by);
124: arp_util.debug('last_update_login: ' || p_dist_rec.last_update_login);
125: arp_util.debug('program_application_id: '
126: || p_dist_rec.program_application_id);
119: arp_util.debug('attribute15: ' || p_dist_rec.attribute15);
120: arp_util.debug('set_of_books_id: ' || p_dist_rec.set_of_books_id);
121: arp_util.debug('posting_control_id: ' || p_dist_rec.posting_control_id);
122: arp_util.debug('last_updated_by: ' || p_dist_rec.last_updated_by);
123: arp_util.debug('created_by: ' || p_dist_rec.created_by);
124: arp_util.debug('last_update_login: ' || p_dist_rec.last_update_login);
125: arp_util.debug('program_application_id: '
126: || p_dist_rec.program_application_id);
127: arp_util.debug('program_id: ' || p_dist_rec.program_id);
120: arp_util.debug('set_of_books_id: ' || p_dist_rec.set_of_books_id);
121: arp_util.debug('posting_control_id: ' || p_dist_rec.posting_control_id);
122: arp_util.debug('last_updated_by: ' || p_dist_rec.last_updated_by);
123: arp_util.debug('created_by: ' || p_dist_rec.created_by);
124: arp_util.debug('last_update_login: ' || p_dist_rec.last_update_login);
125: arp_util.debug('program_application_id: '
126: || p_dist_rec.program_application_id);
127: arp_util.debug('program_id: ' || p_dist_rec.program_id);
128: arp_util.debug('rounding_correction_flag:'|| p_dist_rec.rounding_correction_flag);
121: arp_util.debug('posting_control_id: ' || p_dist_rec.posting_control_id);
122: arp_util.debug('last_updated_by: ' || p_dist_rec.last_updated_by);
123: arp_util.debug('created_by: ' || p_dist_rec.created_by);
124: arp_util.debug('last_update_login: ' || p_dist_rec.last_update_login);
125: arp_util.debug('program_application_id: '
126: || p_dist_rec.program_application_id);
127: arp_util.debug('program_id: ' || p_dist_rec.program_id);
128: arp_util.debug('rounding_correction_flag:'|| p_dist_rec.rounding_correction_flag);
129: arp_util.debug('************** End ra_cust_trx_line_gl_dist record ' ||
123: arp_util.debug('created_by: ' || p_dist_rec.created_by);
124: arp_util.debug('last_update_login: ' || p_dist_rec.last_update_login);
125: arp_util.debug('program_application_id: '
126: || p_dist_rec.program_application_id);
127: arp_util.debug('program_id: ' || p_dist_rec.program_id);
128: arp_util.debug('rounding_correction_flag:'|| p_dist_rec.rounding_correction_flag);
129: arp_util.debug('************** End ra_cust_trx_line_gl_dist record ' ||
130: '**************');
131:
124: arp_util.debug('last_update_login: ' || p_dist_rec.last_update_login);
125: arp_util.debug('program_application_id: '
126: || p_dist_rec.program_application_id);
127: arp_util.debug('program_id: ' || p_dist_rec.program_id);
128: arp_util.debug('rounding_correction_flag:'|| p_dist_rec.rounding_correction_flag);
129: arp_util.debug('************** End ra_cust_trx_line_gl_dist record ' ||
130: '**************');
131:
132: arp_util.debug('arp_ctlgd_pkg.display_dist_rec()-');
125: arp_util.debug('program_application_id: '
126: || p_dist_rec.program_application_id);
127: arp_util.debug('program_id: ' || p_dist_rec.program_id);
128: arp_util.debug('rounding_correction_flag:'|| p_dist_rec.rounding_correction_flag);
129: arp_util.debug('************** End ra_cust_trx_line_gl_dist record ' ||
130: '**************');
131:
132: arp_util.debug('arp_ctlgd_pkg.display_dist_rec()-');
133:
128: arp_util.debug('rounding_correction_flag:'|| p_dist_rec.rounding_correction_flag);
129: arp_util.debug('************** End ra_cust_trx_line_gl_dist record ' ||
130: '**************');
131:
132: arp_util.debug('arp_ctlgd_pkg.display_dist_rec()-');
133:
134: EXCEPTION
135: WHEN OTHERS THEN
136: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_rec()');
132: arp_util.debug('arp_ctlgd_pkg.display_dist_rec()-');
133:
134: EXCEPTION
135: WHEN OTHERS THEN
136: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_rec()');
137: RAISE;
138:
139: END;
140:
148: | |
149: | SCOPE - PUBLIC |
150: | |
151: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
152: | arp_util.debug |
153: | |
154: | ARGUMENTS : IN: |
155: | p_cust_trx_line_gl_dist_id |
156: | OUT: |
174: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
175:
176: BEGIN
177:
178: arp_util.debug('arp_ctlgd_pkg.display_dist_p()+');
179:
180: arp_ctlgd_pkg.fetch_p(l_dist_rec, p_cust_trx_line_gl_dist_id);
181:
182: arp_ctlgd_pkg.display_dist_rec(l_dist_rec);
180: arp_ctlgd_pkg.fetch_p(l_dist_rec, p_cust_trx_line_gl_dist_id);
181:
182: arp_ctlgd_pkg.display_dist_rec(l_dist_rec);
183:
184: arp_util.debug('arp_ctlgd_pkg.display_dist_p()-');
185:
186: EXCEPTION
187: WHEN OTHERS THEN
188: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_p()');
184: arp_util.debug('arp_ctlgd_pkg.display_dist_p()-');
185:
186: EXCEPTION
187: WHEN OTHERS THEN
188: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_p()');
189: RAISE;
190:
191: END;
192:
201: | |
202: | SCOPE - PUBLIC |
203: | |
204: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
205: | arp_util.debug |
206: | |
207: | ARGUMENTS : IN: |
208: | p_cust_trx_line_salesrep_id |
209: | OUT: |
236:
237:
238: BEGIN
239:
240: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctls_id()+');
241:
242: arp_util.debug('=====================================================' ||
243: '==========================');
244: arp_util.debug('========== ' ||
238: BEGIN
239:
240: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctls_id()+');
241:
242: arp_util.debug('=====================================================' ||
243: '==========================');
244: arp_util.debug('========== ' ||
245: ' Dump of ra_cust_trx_line_gl_dist records for ctls: '||
246: to_char( p_cust_trx_line_salesrep_id ) || ' ' ||
240: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctls_id()+');
241:
242: arp_util.debug('=====================================================' ||
243: '==========================');
244: arp_util.debug('========== ' ||
245: ' Dump of ra_cust_trx_line_gl_dist records for ctls: '||
246: to_char( p_cust_trx_line_salesrep_id ) || ' ' ||
247: '==========');
248:
249: FOR l_dist_rec IN srep_cursor LOOP
250: arp_ctlgd_pkg.display_dist_p(l_dist_rec.cust_trx_line_gl_dist_id);
251: END LOOP;
252:
253: arp_util.debug('====== End ' ||
254: 'Dump of ra_cust_trx_line_gl_dist records for ctls: '||
255: to_char( p_cust_trx_line_salesrep_id ) || ' ' ||
256: '=======');
257: arp_util.debug('=====================================================' ||
253: arp_util.debug('====== End ' ||
254: 'Dump of ra_cust_trx_line_gl_dist records for ctls: '||
255: to_char( p_cust_trx_line_salesrep_id ) || ' ' ||
256: '=======');
257: arp_util.debug('=====================================================' ||
258: '==========================');
259:
260: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctls_id()-');
261:
256: '=======');
257: arp_util.debug('=====================================================' ||
258: '==========================');
259:
260: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctls_id()-');
261:
262: EXCEPTION
263: WHEN OTHERS THEN
264: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_f_ctls_id()');
260: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctls_id()-');
261:
262: EXCEPTION
263: WHEN OTHERS THEN
264: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_f_ctls_id()');
265: RAISE;
266:
267: END;
268:
276: | |
277: | SCOPE - PUBLIC |
278: | |
279: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
280: | arp_util.debug |
281: | |
282: | ARGUMENTS : IN: |
283: | p_customer_trx_id |
284: | OUT: |
311:
312:
313: BEGIN
314:
315: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ct_id()+');
316:
317: arp_util.debug('=====================================================' ||
318: '==========================');
319: arp_util.debug('========== ' ||
313: BEGIN
314:
315: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ct_id()+');
316:
317: arp_util.debug('=====================================================' ||
318: '==========================');
319: arp_util.debug('========== ' ||
320: ' Dump of ra_cust_trx_line_gl_dist records for ctid: '||
321: to_char( p_customer_trx_id ) || ' ' ||
315: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ct_id()+');
316:
317: arp_util.debug('=====================================================' ||
318: '==========================');
319: arp_util.debug('========== ' ||
320: ' Dump of ra_cust_trx_line_gl_dist records for ctid: '||
321: to_char( p_customer_trx_id ) || ' ' ||
322: '==========');
323:
324: FOR l_dist_rec IN srep_cursor LOOP
325: arp_ctlgd_pkg.display_dist_p(l_dist_rec.cust_trx_line_gl_dist_id);
326: END LOOP;
327:
328: arp_util.debug('====== End ' ||
329: 'Dump of ra_cust_trx_line_gl_dist records for ctid: '||
330: to_char( p_customer_trx_id ) || ' ' ||
331: '=======');
332: arp_util.debug('=====================================================' ||
328: arp_util.debug('====== End ' ||
329: 'Dump of ra_cust_trx_line_gl_dist records for ctid: '||
330: to_char( p_customer_trx_id ) || ' ' ||
331: '=======');
332: arp_util.debug('=====================================================' ||
333: '==========================');
334:
335: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ct_id()-');
336:
331: '=======');
332: arp_util.debug('=====================================================' ||
333: '==========================');
334:
335: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ct_id()-');
336:
337: EXCEPTION
338: WHEN OTHERS THEN
339: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_f_ct_id()');
335: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ct_id()-');
336:
337: EXCEPTION
338: WHEN OTHERS THEN
339: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_f_ct_id()');
340: RAISE;
341:
342: END;
343:
352: | |
353: | SCOPE - PUBLIC |
354: | |
355: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
356: | arp_util.debug |
357: | |
358: | ARGUMENTS : IN: |
359: | p_customer_trx_line_id |
360: | OUT: |
387:
388:
389: BEGIN
390:
391: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctl_id()+');
392:
393: arp_util.debug('=====================================================' ||
394: '==========================');
395: arp_util.debug('========== ' ||
389: BEGIN
390:
391: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctl_id()+');
392:
393: arp_util.debug('=====================================================' ||
394: '==========================');
395: arp_util.debug('========== ' ||
396: ' Dump of ra_cust_trx_line_gl_dist records for ctlid: '||
397: to_char( p_customer_trx_line_id ) || ' ' ||
391: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctl_id()+');
392:
393: arp_util.debug('=====================================================' ||
394: '==========================');
395: arp_util.debug('========== ' ||
396: ' Dump of ra_cust_trx_line_gl_dist records for ctlid: '||
397: to_char( p_customer_trx_line_id ) || ' ' ||
398: '==========');
399:
400: FOR l_dist_rec IN dist_cursor LOOP
401: arp_ctlgd_pkg.display_dist_p(l_dist_rec.cust_trx_line_gl_dist_id);
402: END LOOP;
403:
404: arp_util.debug('====== End ' ||
405: 'Dump of ra_cust_trx_line_gl_dist records for ctlid: '||
406: to_char( p_customer_trx_line_id ) || ' ' ||
407: '=======');
408: arp_util.debug('=====================================================' ||
404: arp_util.debug('====== End ' ||
405: 'Dump of ra_cust_trx_line_gl_dist records for ctlid: '||
406: to_char( p_customer_trx_line_id ) || ' ' ||
407: '=======');
408: arp_util.debug('=====================================================' ||
409: '==========================');
410:
411: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctl_id()-');
412:
407: '=======');
408: arp_util.debug('=====================================================' ||
409: '==========================');
410:
411: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctl_id()-');
412:
413: EXCEPTION
414: WHEN OTHERS THEN
415: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_f_ctl_id()');
411: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctl_id()-');
412:
413: EXCEPTION
414: WHEN OTHERS THEN
415: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_f_ctl_id()');
416: RAISE;
417:
418: END;
419:
426: | |
427: | SCOPE - PUBLIC |
428: | |
429: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
430: | arp_util.debug |
431: | |
432: | ARGUMENTS : IN: |
433: | None |
434: | OUT: |
446: FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number IS
447:
448: BEGIN
449:
450: arp_util.debug('arp_ctgd_pkg.get_number_dummy()+');
451:
452: arp_util.debug('arp_ctgd_pkg.get_number_dummy()-');
453:
454: return(AR_NUMBER_DUMMY);
448: BEGIN
449:
450: arp_util.debug('arp_ctgd_pkg.get_number_dummy()+');
451:
452: arp_util.debug('arp_ctgd_pkg.get_number_dummy()-');
453:
454: return(AR_NUMBER_DUMMY);
455:
456: EXCEPTION
454: return(AR_NUMBER_DUMMY);
455:
456: EXCEPTION
457: WHEN OTHERS THEN
458: arp_util.debug('EXCEPTION: arp_ctgd_pkg.get_number_dummy()');
459: RAISE;
460:
461: END;
462:
472: | |
473: | SCOPE - PUBLIC |
474: | |
475: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
476: | arp_util.debug |
477: | |
478: | ARGUMENTS : IN: |
479: | p_old_dist_rec |
480: | p_new_dist_rec |
501: ) IS
502:
503: BEGIN
504:
505: arp_util.debug('arp_ctls_pkg.merge_dist_recs()+');
506:
507:
508: IF ( p_new_dist_rec.cust_trx_line_gl_dist_id = AR_NUMBER_DUMMY )
509: THEN p_out_dist_rec.cust_trx_line_gl_dist_id :=
774: p_new_dist_rec.program_update_date;
775: END IF;
776:
777:
778: arp_util.debug('arp_ctls_pkg.merge_dist_recs()-');
779:
780: EXCEPTION
781: WHEN OTHERS THEN
782: arp_util.debug('EXCEPTION: merge_dist_recs.merge_dist_recs()');
778: arp_util.debug('arp_ctls_pkg.merge_dist_recs()-');
779:
780: EXCEPTION
781: WHEN OTHERS THEN
782: arp_util.debug('EXCEPTION: merge_dist_recs.merge_dist_recs()');
783: RAISE;
784:
785: END;
786:
796: | SCOPE - PRIVATE |
797: | |
798: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
799: | dbms_sql.bind_variable |
800: | arp_util.debug |
801: | |
802: | ARGUMENTS : IN: |
803: | p_update_cursor - ID of the update cursor |
804: | p_dist_rec - ra_cust_trx_line_gl_dist record |
830: IS
831:
832: BEGIN
833:
834: arp_util.debug('arp_ctlgd_pkg.bind_dist_variables()+');
835:
836: /*------------------+
837: | Dummy constants |
838: +------------------*/
1030: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
1031: p_dist_rec.program_update_date);
1032:
1033:
1034: arp_util.debug('arp_ctlgd_pkg.bind_dist_variables()-');
1035:
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.bind_dist_variables()');
1034: arp_util.debug('arp_ctlgd_pkg.bind_dist_variables()-');
1035:
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.bind_dist_variables()');
1039: RAISE;
1040:
1041: END;
1042:
1053: | SCOPE - PRIVATE |
1054: | |
1055: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1056: | arpcurr.functional_amount |
1057: | arp_util.debug |
1058: | |
1059: | ARGUMENTS : IN: |
1060: | None. |
1061: | OUT: |
1074:
1075: PROCEDURE construct_dist_update_stmt( update_text OUT NOCOPY varchar2) IS
1076:
1077: BEGIN
1078: arp_util.debug('arp_ctlgd_pkg.construct_dist_update_stmt()+');
1079:
1080: update_text :=
1081: 'UPDATE ra_cust_trx_line_gl_dist
1082: SET cust_trx_line_gl_dist_id =
1321: :ar_date_dummy, program_update_date,
1322: :program_update_date)';
1323:
1324:
1325: arp_util.debug('arp_ctlgd_pkg.construct_dist_update_stmt()-');
1326:
1327: EXCEPTION
1328: WHEN OTHERS THEN
1329: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.construct_dist_update_stmt()');
1325: arp_util.debug('arp_ctlgd_pkg.construct_dist_update_stmt()-');
1326:
1327: EXCEPTION
1328: WHEN OTHERS THEN
1329: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.construct_dist_update_stmt()');
1330: RAISE;
1331:
1332: END;
1333:
1343: | |
1344: | SCOPE - PRIVATE |
1345: | |
1346: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1347: | arp_util.debug |
1348: | dbms_sql.open_cursor |
1349: | dbms_sql.parse |
1350: | dbms_sql.execute |
1351: | dbms_sql.close_cursor |
1392: l_update_statement varchar2(25000);
1393: gl_dist_array dbms_sql.number_table; /* mrc */
1394:
1395: BEGIN
1396: arp_util.debug('arp_ctlgd_pkg.generic_update()+');
1397:
1398: /*--------------------------------------------------------------+
1399: | If this update statement has not already been parsed, |
1400: | construct the statement and parse it. |
1458: gl_dist_array);
1459:
1460: l_count := dbms_sql.execute(p_update_cursor);
1461:
1462: arp_util.debug( to_char(l_count) || ' rows updated');
1463:
1464: /*------------------------------------------+
1465: | get RETURNING COLUMN into OUT NOCOPY bind array |
1466: +------------------------------------------*/
1492: END LOOP;
1493:
1494:
1495:
1496: arp_util.debug('arp_ctlgd_pkg.generic_update()-');
1497:
1498: EXCEPTION
1499: WHEN OTHERS THEN
1500: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.generic_update()');
1496: arp_util.debug('arp_ctlgd_pkg.generic_update()-');
1497:
1498: EXCEPTION
1499: WHEN OTHERS THEN
1500: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.generic_update()');
1501: arp_util.debug(l_update_statement);
1502: arp_util.debug('Error at character: ' ||
1503: to_char(dbms_sql.last_error_position));
1504: RAISE;
1497:
1498: EXCEPTION
1499: WHEN OTHERS THEN
1500: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.generic_update()');
1501: arp_util.debug(l_update_statement);
1502: arp_util.debug('Error at character: ' ||
1503: to_char(dbms_sql.last_error_position));
1504: RAISE;
1505: END;
1498: EXCEPTION
1499: WHEN OTHERS THEN
1500: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.generic_update()');
1501: arp_util.debug(l_update_statement);
1502: arp_util.debug('Error at character: ' ||
1503: to_char(dbms_sql.last_error_position));
1504: RAISE;
1505: END;
1506:
1520: | |
1521: | SCOPE - PUBLIC |
1522: | |
1523: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1524: | arp_util.debug |
1525: | |
1526: | ARGUMENTS : IN: |
1527: | None |
1528: | OUT: |
1540: PROCEDURE set_to_dummy( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype) IS
1541:
1542: BEGIN
1543:
1544: arp_util.debug('arp_lgd_pkg.set_to_dummy()+');
1545:
1546: p_dist_rec.cust_trx_line_gl_dist_id := AR_NUMBER_DUMMY;
1547: p_dist_rec.customer_trx_id := AR_NUMBER_DUMMY;
1548: p_dist_rec.customer_trx_line_id := AR_NUMBER_DUMMY;
1591: p_dist_rec.program_id := AR_NUMBER_DUMMY;
1592: p_dist_rec.program_update_date := AR_DATE_DUMMY;
1593: p_dist_rec.rounding_correction_flag := AR_FLAG_DUMMY;
1594:
1595: arp_util.debug('arp_lgd_pkg.set_to_dummy()-');
1596:
1597: EXCEPTION
1598: WHEN OTHERS THEN
1599: arp_util.debug('EXCEPTION: arp_lgd_pkg.set_to_dummy()');
1595: arp_util.debug('arp_lgd_pkg.set_to_dummy()-');
1596:
1597: EXCEPTION
1598: WHEN OTHERS THEN
1599: arp_util.debug('EXCEPTION: arp_lgd_pkg.set_to_dummy()');
1600: RAISE;
1601:
1602: END;
1603:
1612: | |
1613: | SCOPE - PUBLIC |
1614: | |
1615: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1616: | arp_util.debug |
1617: | |
1618: | ARGUMENTS : IN: |
1619: | p_cust_trx_line_gl_dist_id - identifies the row to lock |
1620: | OUT: |
1637: l_cust_trx_line_gl_dist_id
1638: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
1639:
1640: BEGIN
1641: arp_util.debug('arp_ctlgd_pkg.lock_p()+');
1642:
1643:
1644: SELECT cust_trx_line_gl_dist_id
1645: INTO l_cust_trx_line_gl_dist_id
1646: FROM ra_cust_trx_line_gl_dist
1647: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id
1648: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1649:
1650: arp_util.debug('arp_ctlgd_pkg.lock_p()-');
1651:
1652: EXCEPTION
1653: WHEN OTHERS THEN
1654: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_p' );
1650: arp_util.debug('arp_ctlgd_pkg.lock_p()-');
1651:
1652: EXCEPTION
1653: WHEN OTHERS THEN
1654: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_p' );
1655: RAISE;
1656: END;
1657:
1658: /*===========================================================================+
1665: | |
1666: | SCOPE - PUBLIC |
1667: | |
1668: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1669: | arp_util.debug |
1670: | |
1671: | ARGUMENTS : IN: |
1672: | p_customer_trx_id - identifies the rows to lock |
1673: | p_account_set_flag - value is used to restrict lock |
1702: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1703:
1704:
1705: BEGIN
1706: arp_util.debug('arp_ctlgd_pkg.lock_f_ct_id()+');
1707:
1708: OPEN lock_c;
1709: CLOSE lock_c;
1710:
1707:
1708: OPEN lock_c;
1709: CLOSE lock_c;
1710:
1711: arp_util.debug('arp_ctlgd_pkg.lock_f_ct_id()-');
1712:
1713: EXCEPTION
1714: WHEN OTHERS THEN
1715: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ct_id' );
1711: arp_util.debug('arp_ctlgd_pkg.lock_f_ct_id()-');
1712:
1713: EXCEPTION
1714: WHEN OTHERS THEN
1715: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ct_id' );
1716: RAISE;
1717: END;
1718:
1719: /*===========================================================================+
1726: | |
1727: | SCOPE - PUBLIC |
1728: | |
1729: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1730: | arp_util.debug |
1731: | |
1732: | ARGUMENTS : IN: |
1733: | p_customer_trx_line_id - identifies the rows to lock |
1734: | p_account_set_flag - value is used to restrict lock |
1761: AND account_class = nvl(p_account_class, account_class)
1762: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1763:
1764: BEGIN
1765: arp_util.debug('arp_ctlgd_pkg.lock_f_ctl_id()+');
1766:
1767: OPEN lock_c;
1768: CLOSE lock_c;
1769:
1766:
1767: OPEN lock_c;
1768: CLOSE lock_c;
1769:
1770: arp_util.debug('arp_ctlgd_pkg.lock_f_ctl_id()-');
1771:
1772: EXCEPTION
1773: WHEN OTHERS THEN
1774: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctl_id' );
1770: arp_util.debug('arp_ctlgd_pkg.lock_f_ctl_id()-');
1771:
1772: EXCEPTION
1773: WHEN OTHERS THEN
1774: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctl_id' );
1775: RAISE;
1776: END;
1777:
1778:
1786: | |
1787: | SCOPE - PUBLIC |
1788: | |
1789: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1790: | arp_util.debug |
1791: | |
1792: | ARGUMENTS : IN: |
1793: | p_cust_trx_line_salesrep_id - identifies the rows to lock |
1794: | p_account_set_flag - value is used to restrict lock |
1821: AND account_class = nvl(p_account_class, account_class)
1822: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1823:
1824: BEGIN
1825: arp_util.debug('arp_ctlgd_pkg.lock_f_ctls_id()+');
1826:
1827: OPEN lock_c;
1828: CLOSE lock_c;
1829:
1826:
1827: OPEN lock_c;
1828: CLOSE lock_c;
1829:
1830: arp_util.debug('arp_ctlgd_pkg.lock_f_ctls_id()-');
1831:
1832: EXCEPTION
1833: WHEN OTHERS THEN
1834: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctls_id' );
1830: arp_util.debug('arp_ctlgd_pkg.lock_f_ctls_id()-');
1831:
1832: EXCEPTION
1833: WHEN OTHERS THEN
1834: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctls_id' );
1835: RAISE;
1836: END;
1837:
1838: /*===========================================================================+
1846: | |
1847: | SCOPE - PUBLIC |
1848: | |
1849: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1850: | arp_util.debug |
1851: | |
1852: | ARGUMENTS : IN: |
1853: | p_cust_trx_line_gl_dist_id - identifies the row to lock |
1854: | OUT: |
1868: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type
1869: ) IS
1870:
1871: BEGIN
1872: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()+');
1873:
1874: SELECT *
1875: INTO p_dist_rec
1876: FROM ra_cust_trx_line_gl_dist
1876: FROM ra_cust_trx_line_gl_dist
1877: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id
1878: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1879:
1880: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()-');
1881:
1882: EXCEPTION
1883: WHEN OTHERS THEN
1884: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_fetch_p' );
1880: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()-');
1881:
1882: EXCEPTION
1883: WHEN OTHERS THEN
1884: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_fetch_p' );
1885: RAISE;
1886: END;
1887:
1888: /*===========================================================================+
1896: | |
1897: | SCOPE - PUBLIC |
1898: | |
1899: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1900: | arp_util.debug |
1901: | |
1902: | ARGUMENTS : IN: |
1903: | p_cust_trx_line_gl_dist_id - identifies the row to lock |
1904: | p_dist_rec - dist record for comparison |
1926: l_temp_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1927: l_ignore_who_flag varchar2(2);
1928:
1929: BEGIN
1930: arp_util.debug('arp_ctlgd_pkg.lock_compare_p()+');
1931:
1932: IF (p_ignore_who_flag = TRUE)
1933: THEN l_ignore_who_flag := 'Y';
1934: ELSE l_ignore_who_flag := 'N';
2348: )
2349: )
2350: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
2351:
2352: arp_util.debug('arp_ctlgd_pkg.lock_compare_p()-');
2353:
2354: EXCEPTION
2355: WHEN NO_DATA_FOUND THEN
2356:
2353:
2354: EXCEPTION
2355: WHEN NO_DATA_FOUND THEN
2356:
2357: arp_util.debug('');
2358: arp_util.debug('p_cust_trx_line_gl_dist_id = ' ||
2359: p_cust_trx_line_gl_dist_id );
2360: arp_util.debug('-------- new dist record --------');
2361: display_dist_rec( p_dist_rec );
2354: EXCEPTION
2355: WHEN NO_DATA_FOUND THEN
2356:
2357: arp_util.debug('');
2358: arp_util.debug('p_cust_trx_line_gl_dist_id = ' ||
2359: p_cust_trx_line_gl_dist_id );
2360: arp_util.debug('-------- new dist record --------');
2361: display_dist_rec( p_dist_rec );
2362:
2356:
2357: arp_util.debug('');
2358: arp_util.debug('p_cust_trx_line_gl_dist_id = ' ||
2359: p_cust_trx_line_gl_dist_id );
2360: arp_util.debug('-------- new dist record --------');
2361: display_dist_rec( p_dist_rec );
2362:
2363: arp_util.debug('');
2364:
2359: p_cust_trx_line_gl_dist_id );
2360: arp_util.debug('-------- new dist record --------');
2361: display_dist_rec( p_dist_rec );
2362:
2363: arp_util.debug('');
2364:
2365: arp_util.debug('-------- old dist record --------');
2366:
2367: fetch_p( l_temp_dist_rec,
2361: display_dist_rec( p_dist_rec );
2362:
2363: arp_util.debug('');
2364:
2365: arp_util.debug('-------- old dist record --------');
2366:
2367: fetch_p( l_temp_dist_rec,
2368: p_cust_trx_line_gl_dist_id );
2369:
2373: APP_EXCEPTION.Raise_Exception;
2374:
2375:
2376: WHEN OTHERS THEN
2377: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_compare_p' );
2378:
2379: arp_util.debug( SQLERRM );
2380:
2381: arp_util.debug('----- parameters for lock_compare_p -----');
2375:
2376: WHEN OTHERS THEN
2377: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_compare_p' );
2378:
2379: arp_util.debug( SQLERRM );
2380:
2381: arp_util.debug('----- parameters for lock_compare_p -----');
2382:
2383: arp_util.debug('p_cust_trx_line_gl_dist_id = ' ||
2377: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_compare_p' );
2378:
2379: arp_util.debug( SQLERRM );
2380:
2381: arp_util.debug('----- parameters for lock_compare_p -----');
2382:
2383: arp_util.debug('p_cust_trx_line_gl_dist_id = ' ||
2384: p_cust_trx_line_gl_dist_id );
2385: arp_util.debug('p_ignore_who_flag =' ||
2379: arp_util.debug( SQLERRM );
2380:
2381: arp_util.debug('----- parameters for lock_compare_p -----');
2382:
2383: arp_util.debug('p_cust_trx_line_gl_dist_id = ' ||
2384: p_cust_trx_line_gl_dist_id );
2385: arp_util.debug('p_ignore_who_flag =' ||
2386: arp_trx_util.boolean_to_varchar2(p_ignore_who_flag));
2387:
2381: arp_util.debug('----- parameters for lock_compare_p -----');
2382:
2383: arp_util.debug('p_cust_trx_line_gl_dist_id = ' ||
2384: p_cust_trx_line_gl_dist_id );
2385: arp_util.debug('p_ignore_who_flag =' ||
2386: arp_trx_util.boolean_to_varchar2(p_ignore_who_flag));
2387:
2388: arp_util.debug('');
2389: arp_util.debug('-------- new dist record --------');
2384: p_cust_trx_line_gl_dist_id );
2385: arp_util.debug('p_ignore_who_flag =' ||
2386: arp_trx_util.boolean_to_varchar2(p_ignore_who_flag));
2387:
2388: arp_util.debug('');
2389: arp_util.debug('-------- new dist record --------');
2390: display_dist_rec( p_dist_rec );
2391:
2392: arp_util.debug('');
2385: arp_util.debug('p_ignore_who_flag =' ||
2386: arp_trx_util.boolean_to_varchar2(p_ignore_who_flag));
2387:
2388: arp_util.debug('');
2389: arp_util.debug('-------- new dist record --------');
2390: display_dist_rec( p_dist_rec );
2391:
2392: arp_util.debug('');
2393:
2388: arp_util.debug('');
2389: arp_util.debug('-------- new dist record --------');
2390: display_dist_rec( p_dist_rec );
2391:
2392: arp_util.debug('');
2393:
2394: arp_util.debug('-------- old dist record --------');
2395:
2396: fetch_p( l_temp_dist_rec,
2390: display_dist_rec( p_dist_rec );
2391:
2392: arp_util.debug('');
2393:
2394: arp_util.debug('-------- old dist record --------');
2395:
2396: fetch_p( l_temp_dist_rec,
2397: p_cust_trx_line_gl_dist_id );
2398:
2411: | |
2412: | SCOPE - PUBLIC |
2413: | |
2414: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2415: | arp_util.debug |
2416: | |
2417: | ARGUMENTS : IN: |
2418: | p_cust_trx_line_gl_dist_id |
2419: | p_customer_trx_id |
2546:
2547: BEGIN
2548:
2549: IF PG_DEBUG in ('Y', 'C') THEN
2550: arp_util.debug('arp_ctlgd_pkg.lock_compare_cover()+',
2551: pg_msg_level_debug);
2552: END IF;
2553:
2554: /*------------------------------------------------+
2605: TRUE -- ignore who columns
2606: );
2607:
2608: IF PG_DEBUG in ('Y', 'C') THEN
2609: arp_util.debug('arp_ctlgd_pkg.lock_compare_cover()-',
2610: pg_msg_level_debug);
2611: END IF;
2612:
2613: EXCEPTION
2613: EXCEPTION
2614: WHEN OTHERS THEN
2615:
2616: IF PG_DEBUG in ('Y', 'C') THEN
2617: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.lock_compare_cover()',
2618: pg_msg_level_debug);
2619: arp_util.debug('lock_compare_cover: ' || '------- parameters for lock_compare_cove() ' ||
2620: '---------',
2621: pg_msg_level_debug);
2615:
2616: IF PG_DEBUG in ('Y', 'C') THEN
2617: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.lock_compare_cover()',
2618: pg_msg_level_debug);
2619: arp_util.debug('lock_compare_cover: ' || '------- parameters for lock_compare_cove() ' ||
2620: '---------',
2621: pg_msg_level_debug);
2622: arp_util.debug('lock_compare_cover: ' || 'p_cust_trx_line_gl_dist_id = ' ||
2623: p_cust_trx_line_gl_dist_id,
2618: pg_msg_level_debug);
2619: arp_util.debug('lock_compare_cover: ' || '------- parameters for lock_compare_cove() ' ||
2620: '---------',
2621: pg_msg_level_debug);
2622: arp_util.debug('lock_compare_cover: ' || 'p_cust_trx_line_gl_dist_id = ' ||
2623: p_cust_trx_line_gl_dist_id,
2624: pg_msg_level_debug);
2625: arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_id = ' || p_customer_trx_id,
2626: pg_msg_level_debug);
2621: pg_msg_level_debug);
2622: arp_util.debug('lock_compare_cover: ' || 'p_cust_trx_line_gl_dist_id = ' ||
2623: p_cust_trx_line_gl_dist_id,
2624: pg_msg_level_debug);
2625: arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_id = ' || p_customer_trx_id,
2626: pg_msg_level_debug);
2627: arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id,
2628: pg_msg_level_debug);
2629: arp_util.debug('lock_compare_cover: ' || 'p_cust_trx_line_salesrep_id = ' ||
2623: p_cust_trx_line_gl_dist_id,
2624: pg_msg_level_debug);
2625: arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_id = ' || p_customer_trx_id,
2626: pg_msg_level_debug);
2627: arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id,
2628: pg_msg_level_debug);
2629: arp_util.debug('lock_compare_cover: ' || 'p_cust_trx_line_salesrep_id = ' ||
2630: p_cust_trx_line_salesrep_id,
2631: pg_msg_level_debug);
2625: arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_id = ' || p_customer_trx_id,
2626: pg_msg_level_debug);
2627: arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id,
2628: pg_msg_level_debug);
2629: arp_util.debug('lock_compare_cover: ' || 'p_cust_trx_line_salesrep_id = ' ||
2630: p_cust_trx_line_salesrep_id,
2631: pg_msg_level_debug);
2632: arp_util.debug('lock_compare_cover: ' || 'p_account_class = ' || p_account_class,
2633: pg_msg_level_debug);
2628: pg_msg_level_debug);
2629: arp_util.debug('lock_compare_cover: ' || 'p_cust_trx_line_salesrep_id = ' ||
2630: p_cust_trx_line_salesrep_id,
2631: pg_msg_level_debug);
2632: arp_util.debug('lock_compare_cover: ' || 'p_account_class = ' || p_account_class,
2633: pg_msg_level_debug);
2634: arp_util.debug('lock_compare_cover: ' || 'p_percent = ' || p_percent,
2635: pg_msg_level_debug);
2636: arp_util.debug('lock_compare_cover: ' || 'p_amount = ' || p_amount,
2630: p_cust_trx_line_salesrep_id,
2631: pg_msg_level_debug);
2632: arp_util.debug('lock_compare_cover: ' || 'p_account_class = ' || p_account_class,
2633: pg_msg_level_debug);
2634: arp_util.debug('lock_compare_cover: ' || 'p_percent = ' || p_percent,
2635: pg_msg_level_debug);
2636: arp_util.debug('lock_compare_cover: ' || 'p_amount = ' || p_amount,
2637: pg_msg_level_debug);
2638: arp_util.debug('lock_compare_cover: ' || 'p_gl_date = ' || p_gl_date,
2632: arp_util.debug('lock_compare_cover: ' || 'p_account_class = ' || p_account_class,
2633: pg_msg_level_debug);
2634: arp_util.debug('lock_compare_cover: ' || 'p_percent = ' || p_percent,
2635: pg_msg_level_debug);
2636: arp_util.debug('lock_compare_cover: ' || 'p_amount = ' || p_amount,
2637: pg_msg_level_debug);
2638: arp_util.debug('lock_compare_cover: ' || 'p_gl_date = ' || p_gl_date,
2639: pg_msg_level_debug);
2640: arp_util.debug('lock_compare_cover: ' || 'p_gl_posted_date = ' || p_gl_posted_date,
2634: arp_util.debug('lock_compare_cover: ' || 'p_percent = ' || p_percent,
2635: pg_msg_level_debug);
2636: arp_util.debug('lock_compare_cover: ' || 'p_amount = ' || p_amount,
2637: pg_msg_level_debug);
2638: arp_util.debug('lock_compare_cover: ' || 'p_gl_date = ' || p_gl_date,
2639: pg_msg_level_debug);
2640: arp_util.debug('lock_compare_cover: ' || 'p_gl_posted_date = ' || p_gl_posted_date,
2641: pg_msg_level_debug);
2642: arp_util.debug('lock_compare_cover: ' || 'p_original_gl_date = ' || p_original_gl_date,
2636: arp_util.debug('lock_compare_cover: ' || 'p_amount = ' || p_amount,
2637: pg_msg_level_debug);
2638: arp_util.debug('lock_compare_cover: ' || 'p_gl_date = ' || p_gl_date,
2639: pg_msg_level_debug);
2640: arp_util.debug('lock_compare_cover: ' || 'p_gl_posted_date = ' || p_gl_posted_date,
2641: pg_msg_level_debug);
2642: arp_util.debug('lock_compare_cover: ' || 'p_original_gl_date = ' || p_original_gl_date,
2643: pg_msg_level_debug);
2644: arp_util.debug('lock_compare_cover: ' || 'p_code_combination_id = ' || p_code_combination_id,
2638: arp_util.debug('lock_compare_cover: ' || 'p_gl_date = ' || p_gl_date,
2639: pg_msg_level_debug);
2640: arp_util.debug('lock_compare_cover: ' || 'p_gl_posted_date = ' || p_gl_posted_date,
2641: pg_msg_level_debug);
2642: arp_util.debug('lock_compare_cover: ' || 'p_original_gl_date = ' || p_original_gl_date,
2643: pg_msg_level_debug);
2644: arp_util.debug('lock_compare_cover: ' || 'p_code_combination_id = ' || p_code_combination_id,
2645: pg_msg_level_debug);
2646: arp_util.debug('lock_compare_cover: ' || 'p_concatenated_segments = ' || p_concatenated_segments,
2640: arp_util.debug('lock_compare_cover: ' || 'p_gl_posted_date = ' || p_gl_posted_date,
2641: pg_msg_level_debug);
2642: arp_util.debug('lock_compare_cover: ' || 'p_original_gl_date = ' || p_original_gl_date,
2643: pg_msg_level_debug);
2644: arp_util.debug('lock_compare_cover: ' || 'p_code_combination_id = ' || p_code_combination_id,
2645: pg_msg_level_debug);
2646: arp_util.debug('lock_compare_cover: ' || 'p_concatenated_segments = ' || p_concatenated_segments,
2647: pg_msg_level_debug);
2648: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_ccid = ' || p_collected_tax_ccid,
2642: arp_util.debug('lock_compare_cover: ' || 'p_original_gl_date = ' || p_original_gl_date,
2643: pg_msg_level_debug);
2644: arp_util.debug('lock_compare_cover: ' || 'p_code_combination_id = ' || p_code_combination_id,
2645: pg_msg_level_debug);
2646: arp_util.debug('lock_compare_cover: ' || 'p_concatenated_segments = ' || p_concatenated_segments,
2647: pg_msg_level_debug);
2648: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_ccid = ' || p_collected_tax_ccid,
2649: pg_msg_level_debug);
2650: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_concat_seg = ' || p_collected_tax_concat_seg,
2644: arp_util.debug('lock_compare_cover: ' || 'p_code_combination_id = ' || p_code_combination_id,
2645: pg_msg_level_debug);
2646: arp_util.debug('lock_compare_cover: ' || 'p_concatenated_segments = ' || p_concatenated_segments,
2647: pg_msg_level_debug);
2648: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_ccid = ' || p_collected_tax_ccid,
2649: pg_msg_level_debug);
2650: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_concat_seg = ' || p_collected_tax_concat_seg,
2651: pg_msg_level_debug);
2652: arp_util.debug('lock_compare_cover: ' || 'p_comments = ' || p_comments,
2646: arp_util.debug('lock_compare_cover: ' || 'p_concatenated_segments = ' || p_concatenated_segments,
2647: pg_msg_level_debug);
2648: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_ccid = ' || p_collected_tax_ccid,
2649: pg_msg_level_debug);
2650: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_concat_seg = ' || p_collected_tax_concat_seg,
2651: pg_msg_level_debug);
2652: arp_util.debug('lock_compare_cover: ' || 'p_comments = ' || p_comments,
2653: pg_msg_level_debug);
2654: arp_util.debug('lock_compare_cover: ' || 'p_account_set_flag = ' || p_account_set_flag,
2648: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_ccid = ' || p_collected_tax_ccid,
2649: pg_msg_level_debug);
2650: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_concat_seg = ' || p_collected_tax_concat_seg,
2651: pg_msg_level_debug);
2652: arp_util.debug('lock_compare_cover: ' || 'p_comments = ' || p_comments,
2653: pg_msg_level_debug);
2654: arp_util.debug('lock_compare_cover: ' || 'p_account_set_flag = ' || p_account_set_flag,
2655: pg_msg_level_debug);
2656: arp_util.debug('lock_compare_cover: ' || 'p_latest_rec_flag = ' || p_latest_rec_flag,
2650: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_concat_seg = ' || p_collected_tax_concat_seg,
2651: pg_msg_level_debug);
2652: arp_util.debug('lock_compare_cover: ' || 'p_comments = ' || p_comments,
2653: pg_msg_level_debug);
2654: arp_util.debug('lock_compare_cover: ' || 'p_account_set_flag = ' || p_account_set_flag,
2655: pg_msg_level_debug);
2656: arp_util.debug('lock_compare_cover: ' || 'p_latest_rec_flag = ' || p_latest_rec_flag,
2657: pg_msg_level_debug);
2658: arp_util.debug('lock_compare_cover: ' || 'p_ussgl_transaction_code = ' ||
2652: arp_util.debug('lock_compare_cover: ' || 'p_comments = ' || p_comments,
2653: pg_msg_level_debug);
2654: arp_util.debug('lock_compare_cover: ' || 'p_account_set_flag = ' || p_account_set_flag,
2655: pg_msg_level_debug);
2656: arp_util.debug('lock_compare_cover: ' || 'p_latest_rec_flag = ' || p_latest_rec_flag,
2657: pg_msg_level_debug);
2658: arp_util.debug('lock_compare_cover: ' || 'p_ussgl_transaction_code = ' ||
2659: p_ussgl_transaction_code,
2660: pg_msg_level_debug);
2654: arp_util.debug('lock_compare_cover: ' || 'p_account_set_flag = ' || p_account_set_flag,
2655: pg_msg_level_debug);
2656: arp_util.debug('lock_compare_cover: ' || 'p_latest_rec_flag = ' || p_latest_rec_flag,
2657: pg_msg_level_debug);
2658: arp_util.debug('lock_compare_cover: ' || 'p_ussgl_transaction_code = ' ||
2659: p_ussgl_transaction_code,
2660: pg_msg_level_debug);
2661: arp_util.debug('lock_compare_cover: ' || 'p_ussgl_trx_code_context = ' ||
2662: p_ussgl_trx_code_context,
2657: pg_msg_level_debug);
2658: arp_util.debug('lock_compare_cover: ' || 'p_ussgl_transaction_code = ' ||
2659: p_ussgl_transaction_code,
2660: pg_msg_level_debug);
2661: arp_util.debug('lock_compare_cover: ' || 'p_ussgl_trx_code_context = ' ||
2662: p_ussgl_trx_code_context,
2663: pg_msg_level_debug);
2664: arp_util.debug('lock_compare_cover: ' || 'p_attribute_category = ' || p_attribute_category,
2665: pg_msg_level_debug);
2660: pg_msg_level_debug);
2661: arp_util.debug('lock_compare_cover: ' || 'p_ussgl_trx_code_context = ' ||
2662: p_ussgl_trx_code_context,
2663: pg_msg_level_debug);
2664: arp_util.debug('lock_compare_cover: ' || 'p_attribute_category = ' || p_attribute_category,
2665: pg_msg_level_debug);
2666: arp_util.debug('lock_compare_cover: ' || 'p_attribute1 = ' || p_attribute1,
2667: pg_msg_level_debug);
2668: arp_util.debug('lock_compare_cover: ' || 'p_attribute2 = ' || p_attribute2,
2662: p_ussgl_trx_code_context,
2663: pg_msg_level_debug);
2664: arp_util.debug('lock_compare_cover: ' || 'p_attribute_category = ' || p_attribute_category,
2665: pg_msg_level_debug);
2666: arp_util.debug('lock_compare_cover: ' || 'p_attribute1 = ' || p_attribute1,
2667: pg_msg_level_debug);
2668: arp_util.debug('lock_compare_cover: ' || 'p_attribute2 = ' || p_attribute2,
2669: pg_msg_level_debug);
2670: arp_util.debug('lock_compare_cover: ' || 'p_attribute3 = ' || p_attribute3,
2664: arp_util.debug('lock_compare_cover: ' || 'p_attribute_category = ' || p_attribute_category,
2665: pg_msg_level_debug);
2666: arp_util.debug('lock_compare_cover: ' || 'p_attribute1 = ' || p_attribute1,
2667: pg_msg_level_debug);
2668: arp_util.debug('lock_compare_cover: ' || 'p_attribute2 = ' || p_attribute2,
2669: pg_msg_level_debug);
2670: arp_util.debug('lock_compare_cover: ' || 'p_attribute3 = ' || p_attribute3,
2671: pg_msg_level_debug);
2672: arp_util.debug('lock_compare_cover: ' || 'p_attribute4 = ' || p_attribute4,
2666: arp_util.debug('lock_compare_cover: ' || 'p_attribute1 = ' || p_attribute1,
2667: pg_msg_level_debug);
2668: arp_util.debug('lock_compare_cover: ' || 'p_attribute2 = ' || p_attribute2,
2669: pg_msg_level_debug);
2670: arp_util.debug('lock_compare_cover: ' || 'p_attribute3 = ' || p_attribute3,
2671: pg_msg_level_debug);
2672: arp_util.debug('lock_compare_cover: ' || 'p_attribute4 = ' || p_attribute4,
2673: pg_msg_level_debug);
2674: arp_util.debug('lock_compare_cover: ' || 'p_attribute5 = ' || p_attribute5,
2668: arp_util.debug('lock_compare_cover: ' || 'p_attribute2 = ' || p_attribute2,
2669: pg_msg_level_debug);
2670: arp_util.debug('lock_compare_cover: ' || 'p_attribute3 = ' || p_attribute3,
2671: pg_msg_level_debug);
2672: arp_util.debug('lock_compare_cover: ' || 'p_attribute4 = ' || p_attribute4,
2673: pg_msg_level_debug);
2674: arp_util.debug('lock_compare_cover: ' || 'p_attribute5 = ' || p_attribute5,
2675: pg_msg_level_debug);
2676: arp_util.debug('lock_compare_cover: ' || 'p_attribute6 = ' || p_attribute6,
2670: arp_util.debug('lock_compare_cover: ' || 'p_attribute3 = ' || p_attribute3,
2671: pg_msg_level_debug);
2672: arp_util.debug('lock_compare_cover: ' || 'p_attribute4 = ' || p_attribute4,
2673: pg_msg_level_debug);
2674: arp_util.debug('lock_compare_cover: ' || 'p_attribute5 = ' || p_attribute5,
2675: pg_msg_level_debug);
2676: arp_util.debug('lock_compare_cover: ' || 'p_attribute6 = ' || p_attribute6,
2677: pg_msg_level_debug);
2678: arp_util.debug('lock_compare_cover: ' || 'p_attribute7 = ' || p_attribute7,
2672: arp_util.debug('lock_compare_cover: ' || 'p_attribute4 = ' || p_attribute4,
2673: pg_msg_level_debug);
2674: arp_util.debug('lock_compare_cover: ' || 'p_attribute5 = ' || p_attribute5,
2675: pg_msg_level_debug);
2676: arp_util.debug('lock_compare_cover: ' || 'p_attribute6 = ' || p_attribute6,
2677: pg_msg_level_debug);
2678: arp_util.debug('lock_compare_cover: ' || 'p_attribute7 = ' || p_attribute7,
2679: pg_msg_level_debug);
2680: arp_util.debug('lock_compare_cover: ' || 'p_attribute8 = ' || p_attribute8,
2674: arp_util.debug('lock_compare_cover: ' || 'p_attribute5 = ' || p_attribute5,
2675: pg_msg_level_debug);
2676: arp_util.debug('lock_compare_cover: ' || 'p_attribute6 = ' || p_attribute6,
2677: pg_msg_level_debug);
2678: arp_util.debug('lock_compare_cover: ' || 'p_attribute7 = ' || p_attribute7,
2679: pg_msg_level_debug);
2680: arp_util.debug('lock_compare_cover: ' || 'p_attribute8 = ' || p_attribute8,
2681: pg_msg_level_debug);
2682: arp_util.debug('lock_compare_cover: ' || 'p_attribute9 = ' || p_attribute9,
2676: arp_util.debug('lock_compare_cover: ' || 'p_attribute6 = ' || p_attribute6,
2677: pg_msg_level_debug);
2678: arp_util.debug('lock_compare_cover: ' || 'p_attribute7 = ' || p_attribute7,
2679: pg_msg_level_debug);
2680: arp_util.debug('lock_compare_cover: ' || 'p_attribute8 = ' || p_attribute8,
2681: pg_msg_level_debug);
2682: arp_util.debug('lock_compare_cover: ' || 'p_attribute9 = ' || p_attribute9,
2683: pg_msg_level_debug);
2684: arp_util.debug('lock_compare_cover: ' || 'p_attribute10 = ' || p_attribute10,
2678: arp_util.debug('lock_compare_cover: ' || 'p_attribute7 = ' || p_attribute7,
2679: pg_msg_level_debug);
2680: arp_util.debug('lock_compare_cover: ' || 'p_attribute8 = ' || p_attribute8,
2681: pg_msg_level_debug);
2682: arp_util.debug('lock_compare_cover: ' || 'p_attribute9 = ' || p_attribute9,
2683: pg_msg_level_debug);
2684: arp_util.debug('lock_compare_cover: ' || 'p_attribute10 = ' || p_attribute10,
2685: pg_msg_level_debug);
2686: arp_util.debug('lock_compare_cover: ' || 'p_attribute11 = ' || p_attribute11,
2680: arp_util.debug('lock_compare_cover: ' || 'p_attribute8 = ' || p_attribute8,
2681: pg_msg_level_debug);
2682: arp_util.debug('lock_compare_cover: ' || 'p_attribute9 = ' || p_attribute9,
2683: pg_msg_level_debug);
2684: arp_util.debug('lock_compare_cover: ' || 'p_attribute10 = ' || p_attribute10,
2685: pg_msg_level_debug);
2686: arp_util.debug('lock_compare_cover: ' || 'p_attribute11 = ' || p_attribute11,
2687: pg_msg_level_debug);
2688: arp_util.debug('lock_compare_cover: ' || 'p_attribute12 = ' || p_attribute12,
2682: arp_util.debug('lock_compare_cover: ' || 'p_attribute9 = ' || p_attribute9,
2683: pg_msg_level_debug);
2684: arp_util.debug('lock_compare_cover: ' || 'p_attribute10 = ' || p_attribute10,
2685: pg_msg_level_debug);
2686: arp_util.debug('lock_compare_cover: ' || 'p_attribute11 = ' || p_attribute11,
2687: pg_msg_level_debug);
2688: arp_util.debug('lock_compare_cover: ' || 'p_attribute12 = ' || p_attribute12,
2689: pg_msg_level_debug);
2690: arp_util.debug('lock_compare_cover: ' || 'p_attribute13 = ' || p_attribute13,
2684: arp_util.debug('lock_compare_cover: ' || 'p_attribute10 = ' || p_attribute10,
2685: pg_msg_level_debug);
2686: arp_util.debug('lock_compare_cover: ' || 'p_attribute11 = ' || p_attribute11,
2687: pg_msg_level_debug);
2688: arp_util.debug('lock_compare_cover: ' || 'p_attribute12 = ' || p_attribute12,
2689: pg_msg_level_debug);
2690: arp_util.debug('lock_compare_cover: ' || 'p_attribute13 = ' || p_attribute13,
2691: pg_msg_level_debug);
2692: arp_util.debug('lock_compare_cover: ' || 'p_attribute14 = ' || p_attribute14,
2686: arp_util.debug('lock_compare_cover: ' || 'p_attribute11 = ' || p_attribute11,
2687: pg_msg_level_debug);
2688: arp_util.debug('lock_compare_cover: ' || 'p_attribute12 = ' || p_attribute12,
2689: pg_msg_level_debug);
2690: arp_util.debug('lock_compare_cover: ' || 'p_attribute13 = ' || p_attribute13,
2691: pg_msg_level_debug);
2692: arp_util.debug('lock_compare_cover: ' || 'p_attribute14 = ' || p_attribute14,
2693: pg_msg_level_debug);
2694: arp_util.debug('lock_compare_cover: ' || 'p_attribute15 = ' || p_attribute15,
2688: arp_util.debug('lock_compare_cover: ' || 'p_attribute12 = ' || p_attribute12,
2689: pg_msg_level_debug);
2690: arp_util.debug('lock_compare_cover: ' || 'p_attribute13 = ' || p_attribute13,
2691: pg_msg_level_debug);
2692: arp_util.debug('lock_compare_cover: ' || 'p_attribute14 = ' || p_attribute14,
2693: pg_msg_level_debug);
2694: arp_util.debug('lock_compare_cover: ' || 'p_attribute15 = ' || p_attribute15,
2695: pg_msg_level_debug);
2696: arp_util.debug('lock_compare_cover: ' || 'p_posting_control_id = ' || p_posting_control_id,
2690: arp_util.debug('lock_compare_cover: ' || 'p_attribute13 = ' || p_attribute13,
2691: pg_msg_level_debug);
2692: arp_util.debug('lock_compare_cover: ' || 'p_attribute14 = ' || p_attribute14,
2693: pg_msg_level_debug);
2694: arp_util.debug('lock_compare_cover: ' || 'p_attribute15 = ' || p_attribute15,
2695: pg_msg_level_debug);
2696: arp_util.debug('lock_compare_cover: ' || 'p_posting_control_id = ' || p_posting_control_id,
2697: pg_msg_level_debug);
2698: END IF;
2692: arp_util.debug('lock_compare_cover: ' || 'p_attribute14 = ' || p_attribute14,
2693: pg_msg_level_debug);
2694: arp_util.debug('lock_compare_cover: ' || 'p_attribute15 = ' || p_attribute15,
2695: pg_msg_level_debug);
2696: arp_util.debug('lock_compare_cover: ' || 'p_posting_control_id = ' || p_posting_control_id,
2697: pg_msg_level_debug);
2698: END IF;
2699:
2700: RAISE;
2712: | |
2713: | SCOPE - PUBLIC |
2714: | |
2715: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2716: | arp_util.debug |
2717: | |
2718: | ARGUMENTS : IN: |
2719: | p_cust_trx_line_gl_dist_id - identifies the record to fetch |
2720: | OUT: |
2734: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)
2735: IS
2736:
2737: BEGIN
2738: arp_util.debug('arp_ctlgd_pkg.fetch_p()+');
2739:
2740: SELECT *
2741: INTO p_dist_rec
2742: FROM ra_cust_trx_line_gl_dist
2741: INTO p_dist_rec
2742: FROM ra_cust_trx_line_gl_dist
2743: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id;
2744:
2745: arp_util.debug('arp_ctlgd_pkg.fetch_p()-');
2746:
2747: EXCEPTION
2748: WHEN OTHERS THEN
2749: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.fetch_p' );
2745: arp_util.debug('arp_ctlgd_pkg.fetch_p()-');
2746:
2747: EXCEPTION
2748: WHEN OTHERS THEN
2749: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.fetch_p' );
2750: RAISE;
2751: END;
2752:
2753:
2761: | |
2762: | SCOPE - PUBLIC |
2763: | |
2764: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2765: | arp_util.debug |
2766: | |
2767: | ARGUMENTS : IN: |
2768: | p_cust_trx_line_gl_dist_id - identifies the rows to delete |
2769: | OUT: |
2788:
2789: BEGIN
2790:
2791:
2792: arp_util.debug('arp_ctlgd_pkg.delete_p()+');
2793:
2794: DELETE FROM ra_cust_trx_line_gl_dist
2795: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id;
2796:
2794: DELETE FROM ra_cust_trx_line_gl_dist
2795: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id;
2796:
2797: IF ( SQL%ROWCOUNT = 0 )
2798: THEN arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_p()');
2799: RAISE NO_DATA_FOUND;
2800: END IF;
2801:
2802: /* call mrc api to delete */
2807: p_mode => 'SINGLE',
2808: p_key_value => p_cust_trx_line_gl_dist_id);
2809:
2810:
2811: arp_util.debug('arp_ctlgd_pkg.delete_p()-');
2812:
2813: EXCEPTION
2814: WHEN OTHERS THEN
2815: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_p()');
2811: arp_util.debug('arp_ctlgd_pkg.delete_p()-');
2812:
2813: EXCEPTION
2814: WHEN OTHERS THEN
2815: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_p()');
2816:
2817: RAISE;
2818:
2819: END;
2828: | |
2829: | SCOPE - PUBLIC |
2830: | |
2831: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2832: | arp_util.debug |
2833: | |
2834: | ARGUMENTS : IN: |
2835: | p_customer_trx_id - identifies the rows to delete |
2836: | p_account_set_flag - value is used to restrict delete |
2861: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
2862:
2863: BEGIN
2864:
2865: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_id()+');
2866:
2867: DELETE FROM ra_cust_trx_line_gl_dist
2868: WHERE customer_trx_id = p_customer_trx_id
2869: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)
2878: p_mode => 'BATCH',
2879: p_key_value_list => l_gl_dist_key_value_list);
2880:
2881:
2882: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_id()-');
2883:
2884: EXCEPTION
2885: WHEN OTHERS THEN
2886: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_id()');
2882: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_id()-');
2883:
2884: EXCEPTION
2885: WHEN OTHERS THEN
2886: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_id()');
2887:
2888: RAISE;
2889:
2890: END;
2899: | |
2900: | SCOPE - PUBLIC |
2901: | |
2902: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2903: | arp_util.debug |
2904: | |
2905: | ARGUMENTS : IN: |
2906: | p_customer_trx_line_id - identifies the rows to delete |
2907: | p_account_set_flag - value is used to restrict delete |
2933:
2934: BEGIN
2935:
2936:
2937: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()+');
2938:
2939: DELETE FROM ra_cust_trx_line_gl_dist
2940: WHERE customer_trx_line_id = p_customer_trx_line_id
2941: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)
2949: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
2950: p_mode => 'BATCH',
2951: p_key_value_list => l_gl_dist_key_value_list);
2952:
2953: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()-');
2954:
2955: EXCEPTION
2956: WHEN OTHERS THEN
2957: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctl_id()');
2953: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()-');
2954:
2955: EXCEPTION
2956: WHEN OTHERS THEN
2957: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctl_id()');
2958:
2959: RAISE;
2960:
2961: END;
2970: | |
2971: | SCOPE - PUBLIC |
2972: | |
2973: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2974: | arp_util.debug |
2975: | |
2976: | ARGUMENTS : IN: |
2977: | p_cust_trx_line_salesrep - identifies the rows to delete |
2978: | p_account_set_flag - value is used to restrict delete |
3003: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3004:
3005: BEGIN
3006:
3007: arp_util.debug('arp_ctlgd_pkg.delete_f_ctls_id()+');
3008:
3009: DELETE FROM ra_cust_trx_line_gl_dist
3010: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id
3011: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)
3020: p_mode => 'BATCH',
3021: p_key_value_list => l_gl_dist_key_value_list);
3022:
3023:
3024: arp_util.debug('arp_ctlgd_pkg.delete_f_ctls_id()-');
3025:
3026: EXCEPTION
3027: WHEN OTHERS THEN
3028: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctls_id()');
3024: arp_util.debug('arp_ctlgd_pkg.delete_f_ctls_id()-');
3025:
3026: EXCEPTION
3027: WHEN OTHERS THEN
3028: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctls_id()');
3029:
3030: RAISE;
3031:
3032: END;
3042: | |
3043: | SCOPE - PUBLIC |
3044: | |
3045: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3046: | arp_util.debug |
3047: | |
3048: | ARGUMENTS : IN: |
3049: | p_customer_trx_id - identifies the transaction |
3050: | p_link_to_cust_trx_line_id - identifies the parent line |
3082: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3083:
3084: BEGIN
3085:
3086: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()+');
3087:
3088: DELETE FROM ra_cust_trx_line_gl_dist
3089: WHERE customer_trx_id = p_customer_trx_id
3090: AND customer_trx_line_id in
3109: p_mode => 'BATCH',
3110: p_key_value_list => l_gl_dist_key_value_list);
3111:
3112:
3113: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()-');
3114:
3115: EXCEPTION
3116: WHEN OTHERS THEN
3117: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()');
3113: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()-');
3114:
3115: EXCEPTION
3116: WHEN OTHERS THEN
3117: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()');
3118:
3119: RAISE;
3120:
3121: END;
3131: | |
3132: | SCOPE - PUBLIC |
3133: | |
3134: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3135: | arp_util.debug |
3136: | |
3137: | ARGUMENTS : IN: |
3138: | p_cust_trx_line_gl_dist_id - identifies the row to update |
3139: | p_dist_rec - contains the new column values |
3172: l_where varchar2(500);
3173:
3174: BEGIN
3175:
3176: arp_util.debug('arp_ctlgd_pkg.update_p()+ ' ||
3177: to_char(sysdate, 'HH:MI:SS'));
3178:
3179: l_where := ' WHERE cust_trx_line_gl_dist_id = :where_1 ' ||
3180: 'AND account_set_flag = nvl(:where_account_set_flag, '||
3192: p_precision,
3193: p_mau,
3194: p_dist_rec);
3195:
3196: arp_util.debug('arp_ctlgd_pkg.update_p()- ' ||
3197: to_char(sysdate, 'HH:MI:SS'));
3198:
3199:
3200: EXCEPTION
3198:
3199:
3200: EXCEPTION
3201: WHEN OTHERS THEN
3202: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_p()');
3203: RAISE;
3204: END;
3205:
3206:
3214: | |
3215: | SCOPE - PUBLIC |
3216: | |
3217: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3218: | arp_util.debug |
3219: | |
3220: | ARGUMENTS : IN: |
3221: | p_customer_trx_id - identifies the rows to update |
3222: | p_dist_rec - contains the new column values |
3260: l_where varchar2(500);
3261:
3262: BEGIN
3263:
3264: arp_util.debug('arp_ctlgd_pkg.update_f_ct_id()+ ' ||
3265: to_char(sysdate, 'HH:MI:SS'));
3266:
3267: l_where := ' WHERE customer_trx_id = :where_1 ' ||
3268: 'AND account_set_flag = nvl(:where_account_set_flag, '||
3279: p_precision,
3280: p_mau,
3281: p_dist_rec);
3282:
3283: arp_util.debug('arp_ctlgd_pkg.update_f_ct_id()- ' ||
3284: to_char(sysdate, 'HH:MI:SS'));
3285:
3286:
3287: EXCEPTION
3285:
3286:
3287: EXCEPTION
3288: WHEN OTHERS THEN
3289: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_f_ct_id()');
3290: RAISE;
3291: END;
3292:
3293:
3301: | |
3302: | SCOPE - PUBLIC |
3303: | |
3304: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3305: | arp_util.debug |
3306: | |
3307: | ARGUMENTS : IN: |
3308: | p_customer_trx_line_id - identifies the rows to update |
3309: | p_dist_rec - contains the new column values |
3348: l_where varchar2(500);
3349:
3350: BEGIN
3351:
3352: arp_util.debug('arp_ctlgd_pkg.update_f_ctl_id()+ ' ||
3353: to_char(sysdate, 'HH:MI:SS'));
3354:
3355: l_where := ' WHERE customer_trx_line_id = :where_1 ' ||
3356: 'AND account_set_flag = nvl(:where_account_set_flag, '||
3368: p_precision,
3369: p_mau,
3370: p_dist_rec);
3371:
3372: arp_util.debug('arp_ctlgd_pkg.update_f_ctl_id()- ' ||
3373: to_char(sysdate, 'HH:MI:SS'));
3374:
3375:
3376: EXCEPTION
3374:
3375:
3376: EXCEPTION
3377: WHEN OTHERS THEN
3378: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_f_ctl_id()');
3379: RAISE;
3380: END;
3381:
3382: /*===========================================================================+
3389: | |
3390: | SCOPE - PUBLIC |
3391: | |
3392: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3393: | arp_util.debug |
3394: | |
3395: | ARGUMENTS : IN: |
3396: | p_cust_trx_line_salesrep_id - identifies the rows to update |
3397: | p_dist_rec - contains the new column values |
3436: l_where varchar2(500);
3437:
3438: BEGIN
3439:
3440: arp_util.debug('arp_ctlgd_pkg.update_f_ctls_id()+ ' ||
3441: to_char(sysdate, 'HH:MI:SS'));
3442:
3443: l_where := ' WHERE cust_trx_line_salesrep_id = :where_1 ' ||
3444: 'AND account_set_flag = nvl(:where_account_set_flag, '||
3455: p_precision,
3456: p_mau,
3457: p_dist_rec);
3458:
3459: arp_util.debug('arp_ctlgd_pkg.update_f_ctls_id()- ' ||
3460: to_char(sysdate, 'HH:MI:SS'));
3461:
3462:
3463: EXCEPTION
3461:
3462:
3463: EXCEPTION
3464: WHEN OTHERS THEN
3465: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_f_ctls_id()');
3466: RAISE;
3467: END;
3468:
3469:
3478: | |
3479: | SCOPE - PUBLIC |
3480: | |
3481: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3482: | arp_util.debug |
3483: | |
3484: | ARGUMENTS : IN: |
3485: | p_customer_trx_id - required |
3486: | p_base_curr_code - required |
3518: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3519:
3520: BEGIN
3521:
3522: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()+');
3523:
3524: update ra_cust_trx_line_gl_dist
3525: set last_updated_by = pg_user_id,
3526: last_update_date = sysdate,
3548: p_mode => 'BATCH',
3549: p_key_value_list => l_gl_dist_key_value_list);
3550: END IF;
3551:
3552: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3553:
3554: EXCEPTION
3555: WHEN NO_DATA_FOUND THEN
3556: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3552: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3553:
3554: EXCEPTION
3555: WHEN NO_DATA_FOUND THEN
3556: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3557: WHEN OTHERS THEN
3558: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_acctd_amount()');
3559: RAISE;
3560: END;
3554: EXCEPTION
3555: WHEN NO_DATA_FOUND THEN
3556: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3557: WHEN OTHERS THEN
3558: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_acctd_amount()');
3559: RAISE;
3560: END;
3561:
3562: /*===========================================================================+
3570: | |
3571: | SCOPE - PUBLIC |
3572: | |
3573: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3574: | arp_util.debug |
3575: | |
3576: | ARGUMENTS : IN: |
3577: | p_customer_trx_id - required |
3578: | p_line_amount - required |
3616: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3617:
3618: BEGIN
3619:
3620: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()+');
3621:
3622: UPDATE ra_cust_trx_line_gl_dist
3623: SET last_updated_by = pg_user_id,
3624: last_update_date = sysdate,
3652: p_mode => 'BATCH',
3653: p_key_value_list => l_gl_dist_key_value_list);
3654: END IF;
3655: END IF;
3656: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3657:
3658: EXCEPTION
3659: WHEN NO_DATA_FOUND THEN
3660: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3656: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3657:
3658: EXCEPTION
3659: WHEN NO_DATA_FOUND THEN
3660: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3661: WHEN OTHERS THEN
3662: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_amount_f_ctl_id()');
3663: RAISE;
3664: END;
3658: EXCEPTION
3659: WHEN NO_DATA_FOUND THEN
3660: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3661: WHEN OTHERS THEN
3662: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_amount_f_ctl_id()');
3663: RAISE;
3664: END;
3665:
3666:
3675: | SCOPE - PUBLIC |
3676: | |
3677: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3678: | arpcurr.functional_amount |
3679: | arp_util.debug |
3680: | arp_global.set_of_books_id |
3681: | |
3682: | ARGUMENTS : IN: |
3683: | p_dist_rec - contains the new column values |
3725:
3726:
3727: BEGIN
3728:
3729: arp_util.debug('arp_ctlgd_pkg.insert_p()+');
3730:
3731: p_cust_trx_line_gl_dist_id := '';
3732:
3733: /*---------------------------*
3871: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3872: p_mode => 'SINGLE',
3873: p_key_value => p_cust_trx_line_gl_dist_id);
3874:
3875: arp_util.debug('arp_ctlgd_pkg.insert_p()-');
3876:
3877: EXCEPTION
3878: WHEN OTHERS THEN
3879: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.insert_p()');
3875: arp_util.debug('arp_ctlgd_pkg.insert_p()-');
3876:
3877: EXCEPTION
3878: WHEN OTHERS THEN
3879: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.insert_p()');
3880: RAISE;
3881: END;
3882:
3883: /*===========================================================================+
3890: | |
3891: | SCOPE - PUBLIC |
3892: | |
3893: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3894: | arp_util.debug |
3895: | |
3896: | ARGUMENTS : IN: |
3897: | p_customer_trx_id |
3898: | p_customer_trx_line_id |
3949:
3950: BEGIN
3951:
3952: IF PG_DEBUG in ('Y', 'C') THEN
3953: arp_util.debug('arp_ctlgd_pkg.select_summary()+');
3954: END IF;
3955:
3956: SELECT NVL( SUM( NVL(amount, 0) ), 0),
3957: NVL( SUM( NVL(amount, 0) ), 0),
4001: NVL( cust_trx_line_salesrep_id, -10) )
4002: AND account_set_flag = p_account_set_flag;
4003:
4004: IF PG_DEBUG in ('Y', 'C') THEN
4005: arp_util.debug('arp_ctlgd_pkg.select_summary()-');
4006: END IF;
4007:
4008: EXCEPTION
4009: WHEN OTHERS THEN
4007:
4008: EXCEPTION
4009: WHEN OTHERS THEN
4010: IF PG_DEBUG in ('Y', 'C') THEN
4011: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.select_summary()');
4012: END IF;
4013: RAISE;
4014:
4015: END select_summary;