[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: +------------------*/
1031: p_dist_rec.program_update_date);
1032: dbms_sql.bind_variable(p_update_cursor, ':ccid_change_flag',
1033: p_dist_rec.ccid_change_flag); /* Bug 8788491 */
1034:
1035: arp_util.debug('arp_ctlgd_pkg.bind_dist_variables()-');
1036:
1037: EXCEPTION
1038: WHEN OTHERS THEN
1039: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.bind_dist_variables()');
1035: arp_util.debug('arp_ctlgd_pkg.bind_dist_variables()-');
1036:
1037: EXCEPTION
1038: WHEN OTHERS THEN
1039: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.bind_dist_variables()');
1040: RAISE;
1041:
1042: END;
1043:
1054: | SCOPE - PRIVATE |
1055: | |
1056: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1057: | arpcurr.functional_amount |
1058: | arp_util.debug |
1059: | |
1060: | ARGUMENTS : IN: |
1061: | None. |
1062: | OUT: |
1075:
1076: PROCEDURE construct_dist_update_stmt( update_text OUT NOCOPY varchar2) IS
1077:
1078: BEGIN
1079: arp_util.debug('arp_ctlgd_pkg.construct_dist_update_stmt()+');
1080:
1081: update_text :=
1082: 'UPDATE ra_cust_trx_line_gl_dist
1083: SET cust_trx_line_gl_dist_id =
1326: :ar_flag_dummy, ccid_change_flag,
1327: :ccid_change_flag)'; /* Bug 8788491 */
1328:
1329:
1330: arp_util.debug('arp_ctlgd_pkg.construct_dist_update_stmt()-');
1331:
1332: EXCEPTION
1333: WHEN OTHERS THEN
1334: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.construct_dist_update_stmt()');
1330: arp_util.debug('arp_ctlgd_pkg.construct_dist_update_stmt()-');
1331:
1332: EXCEPTION
1333: WHEN OTHERS THEN
1334: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.construct_dist_update_stmt()');
1335: RAISE;
1336:
1337: END;
1338:
1348: | |
1349: | SCOPE - PRIVATE |
1350: | |
1351: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1352: | arp_util.debug |
1353: | dbms_sql.open_cursor |
1354: | dbms_sql.parse |
1355: | dbms_sql.execute |
1356: | dbms_sql.close_cursor |
1397: l_update_statement varchar2(25000);
1398: gl_dist_array dbms_sql.number_table; /* mrc */
1399:
1400: BEGIN
1401: arp_util.debug('arp_ctlgd_pkg.generic_update()+');
1402:
1403: /*--------------------------------------------------------------+
1404: | If this update statement has not already been parsed, |
1405: | construct the statement and parse it. |
1463: gl_dist_array);
1464:
1465: l_count := dbms_sql.execute(p_update_cursor);
1466:
1467: arp_util.debug( to_char(l_count) || ' rows updated');
1468:
1469: /*------------------------------------------+
1470: | get RETURNING COLUMN into OUT NOCOPY bind array |
1471: +------------------------------------------*/
1497: END LOOP;
1498:
1499:
1500:
1501: arp_util.debug('arp_ctlgd_pkg.generic_update()-');
1502:
1503: EXCEPTION
1504: WHEN OTHERS THEN
1505: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.generic_update()');
1501: arp_util.debug('arp_ctlgd_pkg.generic_update()-');
1502:
1503: EXCEPTION
1504: WHEN OTHERS THEN
1505: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.generic_update()');
1506: arp_util.debug(l_update_statement);
1507: arp_util.debug('Error at character: ' ||
1508: to_char(dbms_sql.last_error_position));
1509: RAISE;
1502:
1503: EXCEPTION
1504: WHEN OTHERS THEN
1505: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.generic_update()');
1506: arp_util.debug(l_update_statement);
1507: arp_util.debug('Error at character: ' ||
1508: to_char(dbms_sql.last_error_position));
1509: RAISE;
1510: END;
1503: EXCEPTION
1504: WHEN OTHERS THEN
1505: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.generic_update()');
1506: arp_util.debug(l_update_statement);
1507: arp_util.debug('Error at character: ' ||
1508: to_char(dbms_sql.last_error_position));
1509: RAISE;
1510: END;
1511:
1525: | |
1526: | SCOPE - PUBLIC |
1527: | |
1528: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1529: | arp_util.debug |
1530: | |
1531: | ARGUMENTS : IN: |
1532: | None |
1533: | OUT: |
1545: PROCEDURE set_to_dummy( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype) IS
1546:
1547: BEGIN
1548:
1549: arp_util.debug('arp_lgd_pkg.set_to_dummy()+');
1550:
1551: p_dist_rec.cust_trx_line_gl_dist_id := AR_NUMBER_DUMMY;
1552: p_dist_rec.customer_trx_id := AR_NUMBER_DUMMY;
1553: p_dist_rec.customer_trx_line_id := AR_NUMBER_DUMMY;
1596: p_dist_rec.program_id := AR_NUMBER_DUMMY;
1597: p_dist_rec.program_update_date := AR_DATE_DUMMY;
1598: p_dist_rec.rounding_correction_flag := AR_FLAG_DUMMY;
1599:
1600: arp_util.debug('arp_lgd_pkg.set_to_dummy()-');
1601:
1602: EXCEPTION
1603: WHEN OTHERS THEN
1604: arp_util.debug('EXCEPTION: arp_lgd_pkg.set_to_dummy()');
1600: arp_util.debug('arp_lgd_pkg.set_to_dummy()-');
1601:
1602: EXCEPTION
1603: WHEN OTHERS THEN
1604: arp_util.debug('EXCEPTION: arp_lgd_pkg.set_to_dummy()');
1605: RAISE;
1606:
1607: END;
1608:
1617: | |
1618: | SCOPE - PUBLIC |
1619: | |
1620: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1621: | arp_util.debug |
1622: | |
1623: | ARGUMENTS : IN: |
1624: | p_cust_trx_line_gl_dist_id - identifies the row to lock |
1625: | OUT: |
1642: l_cust_trx_line_gl_dist_id
1643: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
1644:
1645: BEGIN
1646: arp_util.debug('arp_ctlgd_pkg.lock_p()+');
1647:
1648:
1649: SELECT cust_trx_line_gl_dist_id
1650: INTO l_cust_trx_line_gl_dist_id
1651: FROM ra_cust_trx_line_gl_dist
1652: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id
1653: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1654:
1655: arp_util.debug('arp_ctlgd_pkg.lock_p()-');
1656:
1657: EXCEPTION
1658: WHEN OTHERS THEN
1659: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_p' );
1655: arp_util.debug('arp_ctlgd_pkg.lock_p()-');
1656:
1657: EXCEPTION
1658: WHEN OTHERS THEN
1659: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_p' );
1660: RAISE;
1661: END;
1662:
1663: /*===========================================================================+
1670: | |
1671: | SCOPE - PUBLIC |
1672: | |
1673: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1674: | arp_util.debug |
1675: | |
1676: | ARGUMENTS : IN: |
1677: | p_customer_trx_id - identifies the rows to lock |
1678: | p_account_set_flag - value is used to restrict lock |
1707: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1708:
1709:
1710: BEGIN
1711: arp_util.debug('arp_ctlgd_pkg.lock_f_ct_id()+');
1712:
1713: OPEN lock_c;
1714: CLOSE lock_c;
1715:
1712:
1713: OPEN lock_c;
1714: CLOSE lock_c;
1715:
1716: arp_util.debug('arp_ctlgd_pkg.lock_f_ct_id()-');
1717:
1718: EXCEPTION
1719: WHEN OTHERS THEN
1720: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ct_id' );
1716: arp_util.debug('arp_ctlgd_pkg.lock_f_ct_id()-');
1717:
1718: EXCEPTION
1719: WHEN OTHERS THEN
1720: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ct_id' );
1721: RAISE;
1722: END;
1723:
1724: /*===========================================================================+
1731: | |
1732: | SCOPE - PUBLIC |
1733: | |
1734: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1735: | arp_util.debug |
1736: | |
1737: | ARGUMENTS : IN: |
1738: | p_customer_trx_line_id - identifies the rows to lock |
1739: | p_account_set_flag - value is used to restrict lock |
1766: AND account_class = nvl(p_account_class, account_class)
1767: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1768:
1769: BEGIN
1770: arp_util.debug('arp_ctlgd_pkg.lock_f_ctl_id()+');
1771:
1772: OPEN lock_c;
1773: CLOSE lock_c;
1774:
1771:
1772: OPEN lock_c;
1773: CLOSE lock_c;
1774:
1775: arp_util.debug('arp_ctlgd_pkg.lock_f_ctl_id()-');
1776:
1777: EXCEPTION
1778: WHEN OTHERS THEN
1779: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctl_id' );
1775: arp_util.debug('arp_ctlgd_pkg.lock_f_ctl_id()-');
1776:
1777: EXCEPTION
1778: WHEN OTHERS THEN
1779: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctl_id' );
1780: RAISE;
1781: END;
1782:
1783:
1791: | |
1792: | SCOPE - PUBLIC |
1793: | |
1794: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1795: | arp_util.debug |
1796: | |
1797: | ARGUMENTS : IN: |
1798: | p_cust_trx_line_salesrep_id - identifies the rows to lock |
1799: | p_account_set_flag - value is used to restrict lock |
1826: AND account_class = nvl(p_account_class, account_class)
1827: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1828:
1829: BEGIN
1830: arp_util.debug('arp_ctlgd_pkg.lock_f_ctls_id()+');
1831:
1832: OPEN lock_c;
1833: CLOSE lock_c;
1834:
1831:
1832: OPEN lock_c;
1833: CLOSE lock_c;
1834:
1835: arp_util.debug('arp_ctlgd_pkg.lock_f_ctls_id()-');
1836:
1837: EXCEPTION
1838: WHEN OTHERS THEN
1839: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctls_id' );
1835: arp_util.debug('arp_ctlgd_pkg.lock_f_ctls_id()-');
1836:
1837: EXCEPTION
1838: WHEN OTHERS THEN
1839: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctls_id' );
1840: RAISE;
1841: END;
1842:
1843: /*===========================================================================+
1851: | |
1852: | SCOPE - PUBLIC |
1853: | |
1854: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1855: | arp_util.debug |
1856: | |
1857: | ARGUMENTS : IN: |
1858: | p_cust_trx_line_gl_dist_id - identifies the row to lock |
1859: | OUT: |
1873: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type
1874: ) IS
1875:
1876: BEGIN
1877: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()+');
1878:
1879: SELECT *
1880: INTO p_dist_rec
1881: FROM ra_cust_trx_line_gl_dist
1881: FROM ra_cust_trx_line_gl_dist
1882: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id
1883: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1884:
1885: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()-');
1886:
1887: EXCEPTION
1888: WHEN OTHERS THEN
1889: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_fetch_p' );
1885: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()-');
1886:
1887: EXCEPTION
1888: WHEN OTHERS THEN
1889: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_fetch_p' );
1890: RAISE;
1891: END;
1892:
1893: /*===========================================================================+
1901: | |
1902: | SCOPE - PUBLIC |
1903: | |
1904: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1905: | arp_util.debug |
1906: | |
1907: | ARGUMENTS : IN: |
1908: | p_cust_trx_line_gl_dist_id - identifies the row to lock |
1909: | p_dist_rec - dist record for comparison |
1931: l_temp_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1932: l_ignore_who_flag varchar2(2);
1933:
1934: BEGIN
1935: arp_util.debug('arp_ctlgd_pkg.lock_compare_p()+');
1936:
1937: IF (p_ignore_who_flag = TRUE)
1938: THEN l_ignore_who_flag := 'Y';
1939: ELSE l_ignore_who_flag := 'N';
2361: ) /* Bug 8788491 */
2362: )
2363: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
2364:
2365: arp_util.debug('arp_ctlgd_pkg.lock_compare_p()-');
2366:
2367: EXCEPTION
2368: WHEN NO_DATA_FOUND THEN
2369:
2366:
2367: EXCEPTION
2368: WHEN NO_DATA_FOUND THEN
2369:
2370: arp_util.debug('');
2371: arp_util.debug('p_cust_trx_line_gl_dist_id = ' ||
2372: p_cust_trx_line_gl_dist_id );
2373: arp_util.debug('-------- new dist record --------');
2374: display_dist_rec( p_dist_rec );
2367: EXCEPTION
2368: WHEN NO_DATA_FOUND THEN
2369:
2370: arp_util.debug('');
2371: arp_util.debug('p_cust_trx_line_gl_dist_id = ' ||
2372: p_cust_trx_line_gl_dist_id );
2373: arp_util.debug('-------- new dist record --------');
2374: display_dist_rec( p_dist_rec );
2375:
2369:
2370: arp_util.debug('');
2371: arp_util.debug('p_cust_trx_line_gl_dist_id = ' ||
2372: p_cust_trx_line_gl_dist_id );
2373: arp_util.debug('-------- new dist record --------');
2374: display_dist_rec( p_dist_rec );
2375:
2376: arp_util.debug('');
2377:
2372: p_cust_trx_line_gl_dist_id );
2373: arp_util.debug('-------- new dist record --------');
2374: display_dist_rec( p_dist_rec );
2375:
2376: arp_util.debug('');
2377:
2378: arp_util.debug('-------- old dist record --------');
2379:
2380: fetch_p( l_temp_dist_rec,
2374: display_dist_rec( p_dist_rec );
2375:
2376: arp_util.debug('');
2377:
2378: arp_util.debug('-------- old dist record --------');
2379:
2380: fetch_p( l_temp_dist_rec,
2381: p_cust_trx_line_gl_dist_id );
2382:
2386: APP_EXCEPTION.Raise_Exception;
2387:
2388:
2389: WHEN OTHERS THEN
2390: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_compare_p' );
2391:
2392: arp_util.debug( SQLERRM );
2393:
2394: arp_util.debug('----- parameters for lock_compare_p -----');
2388:
2389: WHEN OTHERS THEN
2390: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_compare_p' );
2391:
2392: arp_util.debug( SQLERRM );
2393:
2394: arp_util.debug('----- parameters for lock_compare_p -----');
2395:
2396: arp_util.debug('p_cust_trx_line_gl_dist_id = ' ||
2390: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_compare_p' );
2391:
2392: arp_util.debug( SQLERRM );
2393:
2394: arp_util.debug('----- parameters for lock_compare_p -----');
2395:
2396: arp_util.debug('p_cust_trx_line_gl_dist_id = ' ||
2397: p_cust_trx_line_gl_dist_id );
2398: arp_util.debug('p_ignore_who_flag =' ||
2392: arp_util.debug( SQLERRM );
2393:
2394: arp_util.debug('----- parameters for lock_compare_p -----');
2395:
2396: arp_util.debug('p_cust_trx_line_gl_dist_id = ' ||
2397: p_cust_trx_line_gl_dist_id );
2398: arp_util.debug('p_ignore_who_flag =' ||
2399: arp_trx_util.boolean_to_varchar2(p_ignore_who_flag));
2400:
2394: arp_util.debug('----- parameters for lock_compare_p -----');
2395:
2396: arp_util.debug('p_cust_trx_line_gl_dist_id = ' ||
2397: p_cust_trx_line_gl_dist_id );
2398: arp_util.debug('p_ignore_who_flag =' ||
2399: arp_trx_util.boolean_to_varchar2(p_ignore_who_flag));
2400:
2401: arp_util.debug('');
2402: arp_util.debug('-------- new dist record --------');
2397: p_cust_trx_line_gl_dist_id );
2398: arp_util.debug('p_ignore_who_flag =' ||
2399: arp_trx_util.boolean_to_varchar2(p_ignore_who_flag));
2400:
2401: arp_util.debug('');
2402: arp_util.debug('-------- new dist record --------');
2403: display_dist_rec( p_dist_rec );
2404:
2405: arp_util.debug('');
2398: arp_util.debug('p_ignore_who_flag =' ||
2399: arp_trx_util.boolean_to_varchar2(p_ignore_who_flag));
2400:
2401: arp_util.debug('');
2402: arp_util.debug('-------- new dist record --------');
2403: display_dist_rec( p_dist_rec );
2404:
2405: arp_util.debug('');
2406:
2401: arp_util.debug('');
2402: arp_util.debug('-------- new dist record --------');
2403: display_dist_rec( p_dist_rec );
2404:
2405: arp_util.debug('');
2406:
2407: arp_util.debug('-------- old dist record --------');
2408:
2409: fetch_p( l_temp_dist_rec,
2403: display_dist_rec( p_dist_rec );
2404:
2405: arp_util.debug('');
2406:
2407: arp_util.debug('-------- old dist record --------');
2408:
2409: fetch_p( l_temp_dist_rec,
2410: p_cust_trx_line_gl_dist_id );
2411:
2424: | |
2425: | SCOPE - PUBLIC |
2426: | |
2427: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2428: | arp_util.debug |
2429: | |
2430: | ARGUMENTS : IN: |
2431: | p_cust_trx_line_gl_dist_id |
2432: | p_customer_trx_id |
2561:
2562: BEGIN
2563:
2564: IF PG_DEBUG in ('Y', 'C') THEN
2565: arp_util.debug('arp_ctlgd_pkg.lock_compare_cover()+',
2566: pg_msg_level_debug);
2567: END IF;
2568:
2569: /*------------------------------------------------+
2621: TRUE -- ignore who columns
2622: );
2623:
2624: IF PG_DEBUG in ('Y', 'C') THEN
2625: arp_util.debug('arp_ctlgd_pkg.lock_compare_cover()-',
2626: pg_msg_level_debug);
2627: END IF;
2628:
2629: EXCEPTION
2629: EXCEPTION
2630: WHEN OTHERS THEN
2631:
2632: IF PG_DEBUG in ('Y', 'C') THEN
2633: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.lock_compare_cover()',
2634: pg_msg_level_debug);
2635: arp_util.debug('lock_compare_cover: ' || '------- parameters for lock_compare_cove() ' ||
2636: '---------',
2637: pg_msg_level_debug);
2631:
2632: IF PG_DEBUG in ('Y', 'C') THEN
2633: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.lock_compare_cover()',
2634: pg_msg_level_debug);
2635: arp_util.debug('lock_compare_cover: ' || '------- parameters for lock_compare_cove() ' ||
2636: '---------',
2637: pg_msg_level_debug);
2638: arp_util.debug('lock_compare_cover: ' || 'p_cust_trx_line_gl_dist_id = ' ||
2639: p_cust_trx_line_gl_dist_id,
2634: pg_msg_level_debug);
2635: arp_util.debug('lock_compare_cover: ' || '------- parameters for lock_compare_cove() ' ||
2636: '---------',
2637: pg_msg_level_debug);
2638: arp_util.debug('lock_compare_cover: ' || 'p_cust_trx_line_gl_dist_id = ' ||
2639: p_cust_trx_line_gl_dist_id,
2640: pg_msg_level_debug);
2641: arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_id = ' || p_customer_trx_id,
2642: pg_msg_level_debug);
2637: pg_msg_level_debug);
2638: arp_util.debug('lock_compare_cover: ' || 'p_cust_trx_line_gl_dist_id = ' ||
2639: p_cust_trx_line_gl_dist_id,
2640: pg_msg_level_debug);
2641: arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_id = ' || p_customer_trx_id,
2642: pg_msg_level_debug);
2643: arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id,
2644: pg_msg_level_debug);
2645: arp_util.debug('lock_compare_cover: ' || 'p_cust_trx_line_salesrep_id = ' ||
2639: p_cust_trx_line_gl_dist_id,
2640: pg_msg_level_debug);
2641: arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_id = ' || p_customer_trx_id,
2642: pg_msg_level_debug);
2643: arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id,
2644: pg_msg_level_debug);
2645: arp_util.debug('lock_compare_cover: ' || 'p_cust_trx_line_salesrep_id = ' ||
2646: p_cust_trx_line_salesrep_id,
2647: pg_msg_level_debug);
2641: arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_id = ' || p_customer_trx_id,
2642: pg_msg_level_debug);
2643: arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id,
2644: pg_msg_level_debug);
2645: arp_util.debug('lock_compare_cover: ' || 'p_cust_trx_line_salesrep_id = ' ||
2646: p_cust_trx_line_salesrep_id,
2647: pg_msg_level_debug);
2648: arp_util.debug('lock_compare_cover: ' || 'p_account_class = ' || p_account_class,
2649: pg_msg_level_debug);
2644: pg_msg_level_debug);
2645: arp_util.debug('lock_compare_cover: ' || 'p_cust_trx_line_salesrep_id = ' ||
2646: p_cust_trx_line_salesrep_id,
2647: pg_msg_level_debug);
2648: arp_util.debug('lock_compare_cover: ' || 'p_account_class = ' || p_account_class,
2649: pg_msg_level_debug);
2650: arp_util.debug('lock_compare_cover: ' || 'p_percent = ' || p_percent,
2651: pg_msg_level_debug);
2652: arp_util.debug('lock_compare_cover: ' || 'p_amount = ' || p_amount,
2646: p_cust_trx_line_salesrep_id,
2647: pg_msg_level_debug);
2648: arp_util.debug('lock_compare_cover: ' || 'p_account_class = ' || p_account_class,
2649: pg_msg_level_debug);
2650: arp_util.debug('lock_compare_cover: ' || 'p_percent = ' || p_percent,
2651: pg_msg_level_debug);
2652: arp_util.debug('lock_compare_cover: ' || 'p_amount = ' || p_amount,
2653: pg_msg_level_debug);
2654: arp_util.debug('lock_compare_cover: ' || 'p_gl_date = ' || p_gl_date,
2648: arp_util.debug('lock_compare_cover: ' || 'p_account_class = ' || p_account_class,
2649: pg_msg_level_debug);
2650: arp_util.debug('lock_compare_cover: ' || 'p_percent = ' || p_percent,
2651: pg_msg_level_debug);
2652: arp_util.debug('lock_compare_cover: ' || 'p_amount = ' || p_amount,
2653: pg_msg_level_debug);
2654: arp_util.debug('lock_compare_cover: ' || 'p_gl_date = ' || p_gl_date,
2655: pg_msg_level_debug);
2656: arp_util.debug('lock_compare_cover: ' || 'p_gl_posted_date = ' || p_gl_posted_date,
2650: arp_util.debug('lock_compare_cover: ' || 'p_percent = ' || p_percent,
2651: pg_msg_level_debug);
2652: arp_util.debug('lock_compare_cover: ' || 'p_amount = ' || p_amount,
2653: pg_msg_level_debug);
2654: arp_util.debug('lock_compare_cover: ' || 'p_gl_date = ' || p_gl_date,
2655: pg_msg_level_debug);
2656: arp_util.debug('lock_compare_cover: ' || 'p_gl_posted_date = ' || p_gl_posted_date,
2657: pg_msg_level_debug);
2658: arp_util.debug('lock_compare_cover: ' || 'p_original_gl_date = ' || p_original_gl_date,
2652: arp_util.debug('lock_compare_cover: ' || 'p_amount = ' || p_amount,
2653: pg_msg_level_debug);
2654: arp_util.debug('lock_compare_cover: ' || 'p_gl_date = ' || p_gl_date,
2655: pg_msg_level_debug);
2656: arp_util.debug('lock_compare_cover: ' || 'p_gl_posted_date = ' || p_gl_posted_date,
2657: pg_msg_level_debug);
2658: arp_util.debug('lock_compare_cover: ' || 'p_original_gl_date = ' || p_original_gl_date,
2659: pg_msg_level_debug);
2660: arp_util.debug('lock_compare_cover: ' || 'p_code_combination_id = ' || p_code_combination_id,
2654: arp_util.debug('lock_compare_cover: ' || 'p_gl_date = ' || p_gl_date,
2655: pg_msg_level_debug);
2656: arp_util.debug('lock_compare_cover: ' || 'p_gl_posted_date = ' || p_gl_posted_date,
2657: pg_msg_level_debug);
2658: arp_util.debug('lock_compare_cover: ' || 'p_original_gl_date = ' || p_original_gl_date,
2659: pg_msg_level_debug);
2660: arp_util.debug('lock_compare_cover: ' || 'p_code_combination_id = ' || p_code_combination_id,
2661: pg_msg_level_debug);
2662: arp_util.debug('lock_compare_cover: ' || 'p_concatenated_segments = ' || p_concatenated_segments,
2656: arp_util.debug('lock_compare_cover: ' || 'p_gl_posted_date = ' || p_gl_posted_date,
2657: pg_msg_level_debug);
2658: arp_util.debug('lock_compare_cover: ' || 'p_original_gl_date = ' || p_original_gl_date,
2659: pg_msg_level_debug);
2660: arp_util.debug('lock_compare_cover: ' || 'p_code_combination_id = ' || p_code_combination_id,
2661: pg_msg_level_debug);
2662: arp_util.debug('lock_compare_cover: ' || 'p_concatenated_segments = ' || p_concatenated_segments,
2663: pg_msg_level_debug);
2664: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_ccid = ' || p_collected_tax_ccid,
2658: arp_util.debug('lock_compare_cover: ' || 'p_original_gl_date = ' || p_original_gl_date,
2659: pg_msg_level_debug);
2660: arp_util.debug('lock_compare_cover: ' || 'p_code_combination_id = ' || p_code_combination_id,
2661: pg_msg_level_debug);
2662: arp_util.debug('lock_compare_cover: ' || 'p_concatenated_segments = ' || p_concatenated_segments,
2663: pg_msg_level_debug);
2664: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_ccid = ' || p_collected_tax_ccid,
2665: pg_msg_level_debug);
2666: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_concat_seg = ' || p_collected_tax_concat_seg,
2660: arp_util.debug('lock_compare_cover: ' || 'p_code_combination_id = ' || p_code_combination_id,
2661: pg_msg_level_debug);
2662: arp_util.debug('lock_compare_cover: ' || 'p_concatenated_segments = ' || p_concatenated_segments,
2663: pg_msg_level_debug);
2664: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_ccid = ' || p_collected_tax_ccid,
2665: pg_msg_level_debug);
2666: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_concat_seg = ' || p_collected_tax_concat_seg,
2667: pg_msg_level_debug);
2668: arp_util.debug('lock_compare_cover: ' || 'p_comments = ' || p_comments,
2662: arp_util.debug('lock_compare_cover: ' || 'p_concatenated_segments = ' || p_concatenated_segments,
2663: pg_msg_level_debug);
2664: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_ccid = ' || p_collected_tax_ccid,
2665: pg_msg_level_debug);
2666: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_concat_seg = ' || p_collected_tax_concat_seg,
2667: pg_msg_level_debug);
2668: arp_util.debug('lock_compare_cover: ' || 'p_comments = ' || p_comments,
2669: pg_msg_level_debug);
2670: arp_util.debug('lock_compare_cover: ' || 'p_account_set_flag = ' || p_account_set_flag,
2664: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_ccid = ' || p_collected_tax_ccid,
2665: pg_msg_level_debug);
2666: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_concat_seg = ' || p_collected_tax_concat_seg,
2667: pg_msg_level_debug);
2668: arp_util.debug('lock_compare_cover: ' || 'p_comments = ' || p_comments,
2669: pg_msg_level_debug);
2670: arp_util.debug('lock_compare_cover: ' || 'p_account_set_flag = ' || p_account_set_flag,
2671: pg_msg_level_debug);
2672: arp_util.debug('lock_compare_cover: ' || 'p_latest_rec_flag = ' || p_latest_rec_flag,
2666: arp_util.debug('lock_compare_cover: ' || 'p_collected_tax_concat_seg = ' || p_collected_tax_concat_seg,
2667: pg_msg_level_debug);
2668: arp_util.debug('lock_compare_cover: ' || 'p_comments = ' || p_comments,
2669: pg_msg_level_debug);
2670: arp_util.debug('lock_compare_cover: ' || 'p_account_set_flag = ' || p_account_set_flag,
2671: pg_msg_level_debug);
2672: arp_util.debug('lock_compare_cover: ' || 'p_latest_rec_flag = ' || p_latest_rec_flag,
2673: pg_msg_level_debug);
2674: arp_util.debug('lock_compare_cover: ' || 'p_ussgl_transaction_code = ' ||
2668: arp_util.debug('lock_compare_cover: ' || 'p_comments = ' || p_comments,
2669: pg_msg_level_debug);
2670: arp_util.debug('lock_compare_cover: ' || 'p_account_set_flag = ' || p_account_set_flag,
2671: pg_msg_level_debug);
2672: arp_util.debug('lock_compare_cover: ' || 'p_latest_rec_flag = ' || p_latest_rec_flag,
2673: pg_msg_level_debug);
2674: arp_util.debug('lock_compare_cover: ' || 'p_ussgl_transaction_code = ' ||
2675: p_ussgl_transaction_code,
2676: pg_msg_level_debug);
2670: arp_util.debug('lock_compare_cover: ' || 'p_account_set_flag = ' || p_account_set_flag,
2671: pg_msg_level_debug);
2672: arp_util.debug('lock_compare_cover: ' || 'p_latest_rec_flag = ' || p_latest_rec_flag,
2673: pg_msg_level_debug);
2674: arp_util.debug('lock_compare_cover: ' || 'p_ussgl_transaction_code = ' ||
2675: p_ussgl_transaction_code,
2676: pg_msg_level_debug);
2677: arp_util.debug('lock_compare_cover: ' || 'p_ussgl_trx_code_context = ' ||
2678: p_ussgl_trx_code_context,
2673: pg_msg_level_debug);
2674: arp_util.debug('lock_compare_cover: ' || 'p_ussgl_transaction_code = ' ||
2675: p_ussgl_transaction_code,
2676: pg_msg_level_debug);
2677: arp_util.debug('lock_compare_cover: ' || 'p_ussgl_trx_code_context = ' ||
2678: p_ussgl_trx_code_context,
2679: pg_msg_level_debug);
2680: arp_util.debug('lock_compare_cover: ' || 'p_attribute_category = ' || p_attribute_category,
2681: pg_msg_level_debug);
2676: pg_msg_level_debug);
2677: arp_util.debug('lock_compare_cover: ' || 'p_ussgl_trx_code_context = ' ||
2678: p_ussgl_trx_code_context,
2679: pg_msg_level_debug);
2680: arp_util.debug('lock_compare_cover: ' || 'p_attribute_category = ' || p_attribute_category,
2681: pg_msg_level_debug);
2682: arp_util.debug('lock_compare_cover: ' || 'p_attribute1 = ' || p_attribute1,
2683: pg_msg_level_debug);
2684: arp_util.debug('lock_compare_cover: ' || 'p_attribute2 = ' || p_attribute2,
2678: p_ussgl_trx_code_context,
2679: pg_msg_level_debug);
2680: arp_util.debug('lock_compare_cover: ' || 'p_attribute_category = ' || p_attribute_category,
2681: pg_msg_level_debug);
2682: arp_util.debug('lock_compare_cover: ' || 'p_attribute1 = ' || p_attribute1,
2683: pg_msg_level_debug);
2684: arp_util.debug('lock_compare_cover: ' || 'p_attribute2 = ' || p_attribute2,
2685: pg_msg_level_debug);
2686: arp_util.debug('lock_compare_cover: ' || 'p_attribute3 = ' || p_attribute3,
2680: arp_util.debug('lock_compare_cover: ' || 'p_attribute_category = ' || p_attribute_category,
2681: pg_msg_level_debug);
2682: arp_util.debug('lock_compare_cover: ' || 'p_attribute1 = ' || p_attribute1,
2683: pg_msg_level_debug);
2684: arp_util.debug('lock_compare_cover: ' || 'p_attribute2 = ' || p_attribute2,
2685: pg_msg_level_debug);
2686: arp_util.debug('lock_compare_cover: ' || 'p_attribute3 = ' || p_attribute3,
2687: pg_msg_level_debug);
2688: arp_util.debug('lock_compare_cover: ' || 'p_attribute4 = ' || p_attribute4,
2682: arp_util.debug('lock_compare_cover: ' || 'p_attribute1 = ' || p_attribute1,
2683: pg_msg_level_debug);
2684: arp_util.debug('lock_compare_cover: ' || 'p_attribute2 = ' || p_attribute2,
2685: pg_msg_level_debug);
2686: arp_util.debug('lock_compare_cover: ' || 'p_attribute3 = ' || p_attribute3,
2687: pg_msg_level_debug);
2688: arp_util.debug('lock_compare_cover: ' || 'p_attribute4 = ' || p_attribute4,
2689: pg_msg_level_debug);
2690: arp_util.debug('lock_compare_cover: ' || 'p_attribute5 = ' || p_attribute5,
2684: arp_util.debug('lock_compare_cover: ' || 'p_attribute2 = ' || p_attribute2,
2685: pg_msg_level_debug);
2686: arp_util.debug('lock_compare_cover: ' || 'p_attribute3 = ' || p_attribute3,
2687: pg_msg_level_debug);
2688: arp_util.debug('lock_compare_cover: ' || 'p_attribute4 = ' || p_attribute4,
2689: pg_msg_level_debug);
2690: arp_util.debug('lock_compare_cover: ' || 'p_attribute5 = ' || p_attribute5,
2691: pg_msg_level_debug);
2692: arp_util.debug('lock_compare_cover: ' || 'p_attribute6 = ' || p_attribute6,
2686: arp_util.debug('lock_compare_cover: ' || 'p_attribute3 = ' || p_attribute3,
2687: pg_msg_level_debug);
2688: arp_util.debug('lock_compare_cover: ' || 'p_attribute4 = ' || p_attribute4,
2689: pg_msg_level_debug);
2690: arp_util.debug('lock_compare_cover: ' || 'p_attribute5 = ' || p_attribute5,
2691: pg_msg_level_debug);
2692: arp_util.debug('lock_compare_cover: ' || 'p_attribute6 = ' || p_attribute6,
2693: pg_msg_level_debug);
2694: arp_util.debug('lock_compare_cover: ' || 'p_attribute7 = ' || p_attribute7,
2688: arp_util.debug('lock_compare_cover: ' || 'p_attribute4 = ' || p_attribute4,
2689: pg_msg_level_debug);
2690: arp_util.debug('lock_compare_cover: ' || 'p_attribute5 = ' || p_attribute5,
2691: pg_msg_level_debug);
2692: arp_util.debug('lock_compare_cover: ' || 'p_attribute6 = ' || p_attribute6,
2693: pg_msg_level_debug);
2694: arp_util.debug('lock_compare_cover: ' || 'p_attribute7 = ' || p_attribute7,
2695: pg_msg_level_debug);
2696: arp_util.debug('lock_compare_cover: ' || 'p_attribute8 = ' || p_attribute8,
2690: arp_util.debug('lock_compare_cover: ' || 'p_attribute5 = ' || p_attribute5,
2691: pg_msg_level_debug);
2692: arp_util.debug('lock_compare_cover: ' || 'p_attribute6 = ' || p_attribute6,
2693: pg_msg_level_debug);
2694: arp_util.debug('lock_compare_cover: ' || 'p_attribute7 = ' || p_attribute7,
2695: pg_msg_level_debug);
2696: arp_util.debug('lock_compare_cover: ' || 'p_attribute8 = ' || p_attribute8,
2697: pg_msg_level_debug);
2698: arp_util.debug('lock_compare_cover: ' || 'p_attribute9 = ' || p_attribute9,
2692: arp_util.debug('lock_compare_cover: ' || 'p_attribute6 = ' || p_attribute6,
2693: pg_msg_level_debug);
2694: arp_util.debug('lock_compare_cover: ' || 'p_attribute7 = ' || p_attribute7,
2695: pg_msg_level_debug);
2696: arp_util.debug('lock_compare_cover: ' || 'p_attribute8 = ' || p_attribute8,
2697: pg_msg_level_debug);
2698: arp_util.debug('lock_compare_cover: ' || 'p_attribute9 = ' || p_attribute9,
2699: pg_msg_level_debug);
2700: arp_util.debug('lock_compare_cover: ' || 'p_attribute10 = ' || p_attribute10,
2694: arp_util.debug('lock_compare_cover: ' || 'p_attribute7 = ' || p_attribute7,
2695: pg_msg_level_debug);
2696: arp_util.debug('lock_compare_cover: ' || 'p_attribute8 = ' || p_attribute8,
2697: pg_msg_level_debug);
2698: arp_util.debug('lock_compare_cover: ' || 'p_attribute9 = ' || p_attribute9,
2699: pg_msg_level_debug);
2700: arp_util.debug('lock_compare_cover: ' || 'p_attribute10 = ' || p_attribute10,
2701: pg_msg_level_debug);
2702: arp_util.debug('lock_compare_cover: ' || 'p_attribute11 = ' || p_attribute11,
2696: arp_util.debug('lock_compare_cover: ' || 'p_attribute8 = ' || p_attribute8,
2697: pg_msg_level_debug);
2698: arp_util.debug('lock_compare_cover: ' || 'p_attribute9 = ' || p_attribute9,
2699: pg_msg_level_debug);
2700: arp_util.debug('lock_compare_cover: ' || 'p_attribute10 = ' || p_attribute10,
2701: pg_msg_level_debug);
2702: arp_util.debug('lock_compare_cover: ' || 'p_attribute11 = ' || p_attribute11,
2703: pg_msg_level_debug);
2704: arp_util.debug('lock_compare_cover: ' || 'p_attribute12 = ' || p_attribute12,
2698: arp_util.debug('lock_compare_cover: ' || 'p_attribute9 = ' || p_attribute9,
2699: pg_msg_level_debug);
2700: arp_util.debug('lock_compare_cover: ' || 'p_attribute10 = ' || p_attribute10,
2701: pg_msg_level_debug);
2702: arp_util.debug('lock_compare_cover: ' || 'p_attribute11 = ' || p_attribute11,
2703: pg_msg_level_debug);
2704: arp_util.debug('lock_compare_cover: ' || 'p_attribute12 = ' || p_attribute12,
2705: pg_msg_level_debug);
2706: arp_util.debug('lock_compare_cover: ' || 'p_attribute13 = ' || p_attribute13,
2700: arp_util.debug('lock_compare_cover: ' || 'p_attribute10 = ' || p_attribute10,
2701: pg_msg_level_debug);
2702: arp_util.debug('lock_compare_cover: ' || 'p_attribute11 = ' || p_attribute11,
2703: pg_msg_level_debug);
2704: arp_util.debug('lock_compare_cover: ' || 'p_attribute12 = ' || p_attribute12,
2705: pg_msg_level_debug);
2706: arp_util.debug('lock_compare_cover: ' || 'p_attribute13 = ' || p_attribute13,
2707: pg_msg_level_debug);
2708: arp_util.debug('lock_compare_cover: ' || 'p_attribute14 = ' || p_attribute14,
2702: arp_util.debug('lock_compare_cover: ' || 'p_attribute11 = ' || p_attribute11,
2703: pg_msg_level_debug);
2704: arp_util.debug('lock_compare_cover: ' || 'p_attribute12 = ' || p_attribute12,
2705: pg_msg_level_debug);
2706: arp_util.debug('lock_compare_cover: ' || 'p_attribute13 = ' || p_attribute13,
2707: pg_msg_level_debug);
2708: arp_util.debug('lock_compare_cover: ' || 'p_attribute14 = ' || p_attribute14,
2709: pg_msg_level_debug);
2710: arp_util.debug('lock_compare_cover: ' || 'p_attribute15 = ' || p_attribute15,
2704: arp_util.debug('lock_compare_cover: ' || 'p_attribute12 = ' || p_attribute12,
2705: pg_msg_level_debug);
2706: arp_util.debug('lock_compare_cover: ' || 'p_attribute13 = ' || p_attribute13,
2707: pg_msg_level_debug);
2708: arp_util.debug('lock_compare_cover: ' || 'p_attribute14 = ' || p_attribute14,
2709: pg_msg_level_debug);
2710: arp_util.debug('lock_compare_cover: ' || 'p_attribute15 = ' || p_attribute15,
2711: pg_msg_level_debug);
2712: arp_util.debug('lock_compare_cover: ' || 'p_posting_control_id = ' || p_posting_control_id,
2706: arp_util.debug('lock_compare_cover: ' || 'p_attribute13 = ' || p_attribute13,
2707: pg_msg_level_debug);
2708: arp_util.debug('lock_compare_cover: ' || 'p_attribute14 = ' || p_attribute14,
2709: pg_msg_level_debug);
2710: arp_util.debug('lock_compare_cover: ' || 'p_attribute15 = ' || p_attribute15,
2711: pg_msg_level_debug);
2712: arp_util.debug('lock_compare_cover: ' || 'p_posting_control_id = ' || p_posting_control_id,
2713: pg_msg_level_debug);
2714: END IF;
2708: arp_util.debug('lock_compare_cover: ' || 'p_attribute14 = ' || p_attribute14,
2709: pg_msg_level_debug);
2710: arp_util.debug('lock_compare_cover: ' || 'p_attribute15 = ' || p_attribute15,
2711: pg_msg_level_debug);
2712: arp_util.debug('lock_compare_cover: ' || 'p_posting_control_id = ' || p_posting_control_id,
2713: pg_msg_level_debug);
2714: END IF;
2715:
2716: RAISE;
2728: | |
2729: | SCOPE - PUBLIC |
2730: | |
2731: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2732: | arp_util.debug |
2733: | |
2734: | ARGUMENTS : IN: |
2735: | p_cust_trx_line_gl_dist_id - identifies the record to fetch |
2736: | OUT: |
2750: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)
2751: IS
2752:
2753: BEGIN
2754: arp_util.debug('arp_ctlgd_pkg.fetch_p()+');
2755:
2756: SELECT *
2757: INTO p_dist_rec
2758: FROM ra_cust_trx_line_gl_dist
2757: INTO p_dist_rec
2758: FROM ra_cust_trx_line_gl_dist
2759: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id;
2760:
2761: arp_util.debug('arp_ctlgd_pkg.fetch_p()-');
2762:
2763: EXCEPTION
2764: WHEN OTHERS THEN
2765: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.fetch_p' );
2761: arp_util.debug('arp_ctlgd_pkg.fetch_p()-');
2762:
2763: EXCEPTION
2764: WHEN OTHERS THEN
2765: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.fetch_p' );
2766: RAISE;
2767: END;
2768:
2769:
2777: | |
2778: | SCOPE - PUBLIC |
2779: | |
2780: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2781: | arp_util.debug |
2782: | |
2783: | ARGUMENTS : IN: |
2784: | p_cust_trx_line_gl_dist_id - identifies the rows to delete |
2785: | OUT: |
2804:
2805: BEGIN
2806:
2807:
2808: arp_util.debug('arp_ctlgd_pkg.delete_p()+');
2809:
2810: DELETE FROM ra_cust_trx_line_gl_dist
2811: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id;
2812:
2810: DELETE FROM ra_cust_trx_line_gl_dist
2811: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id;
2812:
2813: IF ( SQL%ROWCOUNT = 0 )
2814: THEN arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_p()');
2815: RAISE NO_DATA_FOUND;
2816: END IF;
2817:
2818: /* call mrc api to delete */
2823: p_mode => 'SINGLE',
2824: p_key_value => p_cust_trx_line_gl_dist_id);
2825:
2826:
2827: arp_util.debug('arp_ctlgd_pkg.delete_p()-');
2828:
2829: EXCEPTION
2830: WHEN OTHERS THEN
2831: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_p()');
2827: arp_util.debug('arp_ctlgd_pkg.delete_p()-');
2828:
2829: EXCEPTION
2830: WHEN OTHERS THEN
2831: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_p()');
2832:
2833: RAISE;
2834:
2835: END;
2844: | |
2845: | SCOPE - PUBLIC |
2846: | |
2847: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2848: | arp_util.debug |
2849: | |
2850: | ARGUMENTS : IN: |
2851: | p_customer_trx_id - identifies the rows to delete |
2852: | p_account_set_flag - value is used to restrict delete |
2877: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
2878:
2879: BEGIN
2880:
2881: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_id()+');
2882:
2883: DELETE FROM ra_cust_trx_line_gl_dist
2884: WHERE customer_trx_id = p_customer_trx_id
2885: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)
2892: p_mode => 'BATCH',
2893: p_key_value_list => l_gl_dist_key_value_list);
2894:
2895:
2896: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_id()-');
2897:
2898: EXCEPTION
2899: WHEN OTHERS THEN
2900: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_id()');
2896: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_id()-');
2897:
2898: EXCEPTION
2899: WHEN OTHERS THEN
2900: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_id()');
2901:
2902: RAISE;
2903:
2904: END;
2913: | |
2914: | SCOPE - PUBLIC |
2915: | |
2916: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2917: | arp_util.debug |
2918: | |
2919: | ARGUMENTS : IN: |
2920: | p_customer_trx_line_id - identifies the rows to delete |
2921: | p_account_set_flag - value is used to restrict delete |
2949:
2950: BEGIN
2951:
2952:
2953: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()+');
2954:
2955: DELETE FROM ra_cust_trx_line_gl_dist
2956: WHERE customer_trx_line_id = p_customer_trx_line_id
2957: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)
2992: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
2993: p_mode => 'BATCH',
2994: p_key_value_list => l_gl_dist_key_value_list);
2995:
2996: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()-');
2997:
2998: EXCEPTION
2999: WHEN OTHERS THEN
3000: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctl_id()');
2996: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()-');
2997:
2998: EXCEPTION
2999: WHEN OTHERS THEN
3000: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctl_id()');
3001:
3002: RAISE;
3003:
3004: END;
3013: | |
3014: | SCOPE - PUBLIC |
3015: | |
3016: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3017: | arp_util.debug |
3018: | |
3019: | ARGUMENTS : IN: |
3020: | p_cust_trx_line_salesrep - identifies the rows to delete |
3021: | p_account_set_flag - value is used to restrict delete |
3046: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3047:
3048: BEGIN
3049:
3050: arp_util.debug('arp_ctlgd_pkg.delete_f_ctls_id()+');
3051:
3052: DELETE FROM ra_cust_trx_line_gl_dist
3053: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id
3054: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)
3063: p_mode => 'BATCH',
3064: p_key_value_list => l_gl_dist_key_value_list);
3065:
3066:
3067: arp_util.debug('arp_ctlgd_pkg.delete_f_ctls_id()-');
3068:
3069: EXCEPTION
3070: WHEN OTHERS THEN
3071: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctls_id()');
3067: arp_util.debug('arp_ctlgd_pkg.delete_f_ctls_id()-');
3068:
3069: EXCEPTION
3070: WHEN OTHERS THEN
3071: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctls_id()');
3072:
3073: RAISE;
3074:
3075: END;
3085: | |
3086: | SCOPE - PUBLIC |
3087: | |
3088: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3089: | arp_util.debug |
3090: | |
3091: | ARGUMENTS : IN: |
3092: | p_customer_trx_id - identifies the transaction |
3093: | p_link_to_cust_trx_line_id - identifies the parent line |
3125: l_acctd_amt NUMBER := 0;
3126:
3127: BEGIN
3128:
3129: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()+');
3130:
3131: DELETE FROM ra_cust_trx_line_gl_dist
3132: WHERE customer_trx_id = p_customer_trx_id
3133: AND customer_trx_line_id in
3165: WHERE customer_trx_id = p_customer_trx_id
3166: and account_class = 'REC'
3167: and account_set_flag = 'N';
3168:
3169: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()-');
3170:
3171: EXCEPTION
3172: WHEN OTHERS THEN
3173: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()');
3169: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()-');
3170:
3171: EXCEPTION
3172: WHEN OTHERS THEN
3173: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()');
3174:
3175: RAISE;
3176:
3177: END;
3187: | |
3188: | SCOPE - PUBLIC |
3189: | |
3190: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3191: | arp_util.debug |
3192: | |
3193: | ARGUMENTS : IN: |
3194: | p_cust_trx_line_gl_dist_id - identifies the row to update |
3195: | p_dist_rec - contains the new column values |
3228: l_where varchar2(500);
3229:
3230: BEGIN
3231:
3232: arp_util.debug('arp_ctlgd_pkg.update_p()+ ' ||
3233: to_char(sysdate, 'HH:MI:SS'));
3234:
3235: l_where := ' WHERE cust_trx_line_gl_dist_id = :where_1 ' ||
3236: 'AND account_set_flag = nvl(:where_account_set_flag, '||
3248: p_precision,
3249: p_mau,
3250: p_dist_rec);
3251:
3252: arp_util.debug('arp_ctlgd_pkg.update_p()- ' ||
3253: to_char(sysdate, 'HH:MI:SS'));
3254:
3255:
3256: EXCEPTION
3254:
3255:
3256: EXCEPTION
3257: WHEN OTHERS THEN
3258: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_p()');
3259: RAISE;
3260: END;
3261:
3262:
3270: | |
3271: | SCOPE - PUBLIC |
3272: | |
3273: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3274: | arp_util.debug |
3275: | |
3276: | ARGUMENTS : IN: |
3277: | p_customer_trx_id - identifies the rows to update |
3278: | p_dist_rec - contains the new column values |
3316: l_where varchar2(500);
3317:
3318: BEGIN
3319:
3320: arp_util.debug('arp_ctlgd_pkg.update_f_ct_id()+ ' ||
3321: to_char(sysdate, 'HH:MI:SS'));
3322:
3323: l_where := ' WHERE customer_trx_id = :where_1 ' ||
3324: 'AND account_set_flag = nvl(:where_account_set_flag, '||
3335: p_precision,
3336: p_mau,
3337: p_dist_rec);
3338:
3339: arp_util.debug('arp_ctlgd_pkg.update_f_ct_id()- ' ||
3340: to_char(sysdate, 'HH:MI:SS'));
3341:
3342:
3343: EXCEPTION
3341:
3342:
3343: EXCEPTION
3344: WHEN OTHERS THEN
3345: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_f_ct_id()');
3346: RAISE;
3347: END;
3348:
3349:
3357: | |
3358: | SCOPE - PUBLIC |
3359: | |
3360: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3361: | arp_util.debug |
3362: | |
3363: | ARGUMENTS : IN: |
3364: | p_customer_trx_line_id - identifies the rows to update |
3365: | p_dist_rec - contains the new column values |
3404: l_where varchar2(500);
3405:
3406: BEGIN
3407:
3408: arp_util.debug('arp_ctlgd_pkg.update_f_ctl_id()+ ' ||
3409: to_char(sysdate, 'HH:MI:SS'));
3410:
3411: l_where := ' WHERE customer_trx_line_id = :where_1 ' ||
3412: 'AND account_set_flag = nvl(:where_account_set_flag, '||
3424: p_precision,
3425: p_mau,
3426: p_dist_rec);
3427:
3428: arp_util.debug('arp_ctlgd_pkg.update_f_ctl_id()- ' ||
3429: to_char(sysdate, 'HH:MI:SS'));
3430:
3431:
3432: EXCEPTION
3430:
3431:
3432: EXCEPTION
3433: WHEN OTHERS THEN
3434: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_f_ctl_id()');
3435: RAISE;
3436: END;
3437:
3438: /*===========================================================================+
3445: | |
3446: | SCOPE - PUBLIC |
3447: | |
3448: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3449: | arp_util.debug |
3450: | |
3451: | ARGUMENTS : IN: |
3452: | p_cust_trx_line_salesrep_id - identifies the rows to update |
3453: | p_dist_rec - contains the new column values |
3492: l_where varchar2(500);
3493:
3494: BEGIN
3495:
3496: arp_util.debug('arp_ctlgd_pkg.update_f_ctls_id()+ ' ||
3497: to_char(sysdate, 'HH:MI:SS'));
3498:
3499: l_where := ' WHERE cust_trx_line_salesrep_id = :where_1 ' ||
3500: 'AND account_set_flag = nvl(:where_account_set_flag, '||
3511: p_precision,
3512: p_mau,
3513: p_dist_rec);
3514:
3515: arp_util.debug('arp_ctlgd_pkg.update_f_ctls_id()- ' ||
3516: to_char(sysdate, 'HH:MI:SS'));
3517:
3518:
3519: EXCEPTION
3517:
3518:
3519: EXCEPTION
3520: WHEN OTHERS THEN
3521: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_f_ctls_id()');
3522: RAISE;
3523: END;
3524:
3525:
3534: | |
3535: | SCOPE - PUBLIC |
3536: | |
3537: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3538: | arp_util.debug |
3539: | |
3540: | ARGUMENTS : IN: |
3541: | p_customer_trx_id - required |
3542: | p_base_curr_code - required |
3574: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3575:
3576: BEGIN
3577:
3578: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()+');
3579:
3580: update ra_cust_trx_line_gl_dist
3581: set last_updated_by = pg_user_id,
3582: last_update_date = sysdate,
3602: p_mode => 'BATCH',
3603: p_key_value_list => l_gl_dist_key_value_list);
3604: END IF;
3605:
3606: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3607:
3608: EXCEPTION
3609: WHEN NO_DATA_FOUND THEN
3610: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3606: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3607:
3608: EXCEPTION
3609: WHEN NO_DATA_FOUND THEN
3610: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3611: WHEN OTHERS THEN
3612: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_acctd_amount()');
3613: RAISE;
3614: END;
3608: EXCEPTION
3609: WHEN NO_DATA_FOUND THEN
3610: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3611: WHEN OTHERS THEN
3612: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_acctd_amount()');
3613: RAISE;
3614: END;
3615:
3616: /*===========================================================================+
3624: | |
3625: | SCOPE - PUBLIC |
3626: | |
3627: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3628: | arp_util.debug |
3629: | |
3630: | ARGUMENTS : IN: |
3631: | p_customer_trx_id - required |
3632: | p_line_amount - required |
3670: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3671:
3672: BEGIN
3673:
3674: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()+');
3675:
3676: UPDATE ra_cust_trx_line_gl_dist
3677: SET last_updated_by = pg_user_id,
3678: last_update_date = sysdate,
3706: p_mode => 'BATCH',
3707: p_key_value_list => l_gl_dist_key_value_list);
3708: END IF;
3709: END IF;
3710: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3711:
3712: EXCEPTION
3713: WHEN NO_DATA_FOUND THEN
3714: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3710: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3711:
3712: EXCEPTION
3713: WHEN NO_DATA_FOUND THEN
3714: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3715: WHEN OTHERS THEN
3716: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_amount_f_ctl_id()');
3717: RAISE;
3718: END;
3712: EXCEPTION
3713: WHEN NO_DATA_FOUND THEN
3714: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3715: WHEN OTHERS THEN
3716: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_amount_f_ctl_id()');
3717: RAISE;
3718: END;
3719:
3720:
3729: | SCOPE - PUBLIC |
3730: | |
3731: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3732: | arpcurr.functional_amount |
3733: | arp_util.debug |
3734: | arp_global.set_of_books_id |
3735: | |
3736: | ARGUMENTS : IN: |
3737: | p_dist_rec - contains the new column values |
3779:
3780:
3781: BEGIN
3782:
3783: arp_util.debug('arp_ctlgd_pkg.insert_p()+');
3784:
3785: p_cust_trx_line_gl_dist_id := '';
3786:
3787: /*---------------------------*
3927: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3928: p_mode => 'SINGLE',
3929: p_key_value => p_cust_trx_line_gl_dist_id);
3930:
3931: arp_util.debug('arp_ctlgd_pkg.insert_p()-');
3932:
3933: EXCEPTION
3934: WHEN OTHERS THEN
3935: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.insert_p()');
3931: arp_util.debug('arp_ctlgd_pkg.insert_p()-');
3932:
3933: EXCEPTION
3934: WHEN OTHERS THEN
3935: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.insert_p()');
3936: RAISE;
3937: END;
3938:
3939: /*===========================================================================+
3946: | |
3947: | SCOPE - PUBLIC |
3948: | |
3949: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3950: | arp_util.debug |
3951: | |
3952: | ARGUMENTS : IN: |
3953: | p_customer_trx_id |
3954: | p_customer_trx_line_id |
4005:
4006: BEGIN
4007:
4008: IF PG_DEBUG in ('Y', 'C') THEN
4009: arp_util.debug('arp_ctlgd_pkg.select_summary()+');
4010: END IF;
4011:
4012: SELECT NVL( SUM( NVL(amount, 0) ), 0),
4013: NVL( SUM( NVL(amount, 0) ), 0),
4057: NVL( cust_trx_line_salesrep_id, -10) )
4058: AND account_set_flag = p_account_set_flag;
4059:
4060: IF PG_DEBUG in ('Y', 'C') THEN
4061: arp_util.debug('arp_ctlgd_pkg.select_summary()-');
4062: END IF;
4063:
4064: EXCEPTION
4065: WHEN OTHERS THEN
4063:
4064: EXCEPTION
4065: WHEN OTHERS THEN
4066: IF PG_DEBUG in ('Y', 'C') THEN
4067: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.select_summary()');
4068: END IF;
4069: RAISE;
4070:
4071: END select_summary;