38: | |
39: | SCOPE - PRIVATE |
40: | |
41: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
42: | arp_util.debug |
43: | |
44: | ARGUMENTS : IN: |
45: | p_batch_rec |
46: | OUT: |
72:
73:
74: BEGIN
75:
76: arp_util.debug('arp_tbat_pgk.display_batch_rec()+');
77:
78:
79: arp_util.debug('************** Dump of ra_batches record **************');
80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);
75:
76: arp_util.debug('arp_tbat_pgk.display_batch_rec()+');
77:
78:
79: arp_util.debug('************** Dump of ra_batches record **************');
80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);
81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
76: arp_util.debug('arp_tbat_pgk.display_batch_rec()+');
77:
78:
79: arp_util.debug('************** Dump of ra_batches record **************');
80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);
81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
77:
78:
79: arp_util.debug('************** Dump of ra_batches record **************');
80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);
81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
78:
79: arp_util.debug('************** Dump of ra_batches record **************');
80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);
81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);
79: arp_util.debug('************** Dump of ra_batches record **************');
80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);
81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);
81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
122: arp_util.debug('request_id: ' || p_batch_rec.request_id);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
122: arp_util.debug('request_id: ' || p_batch_rec.request_id);
123: arp_util.debug('************** End ra_batches record **************');
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
122: arp_util.debug('request_id: ' || p_batch_rec.request_id);
123: arp_util.debug('************** End ra_batches record **************');
124:
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
122: arp_util.debug('request_id: ' || p_batch_rec.request_id);
123: arp_util.debug('************** End ra_batches record **************');
124:
125: arp_util.debug('arp_tbat_pgk.display_batch_rec()-');
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
122: arp_util.debug('request_id: ' || p_batch_rec.request_id);
123: arp_util.debug('************** End ra_batches record **************');
124:
125: arp_util.debug('arp_tbat_pgk.display_batch_rec()-');
126:
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
122: arp_util.debug('request_id: ' || p_batch_rec.request_id);
123: arp_util.debug('************** End ra_batches record **************');
124:
125: arp_util.debug('arp_tbat_pgk.display_batch_rec()-');
126:
127: EXCEPTION
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
122: arp_util.debug('request_id: ' || p_batch_rec.request_id);
123: arp_util.debug('************** End ra_batches record **************');
124:
125: arp_util.debug('arp_tbat_pgk.display_batch_rec()-');
126:
127: EXCEPTION
128: WHEN OTHERS THEN
129: arp_util.debug('EXCEPTION: arp_tbat_pgk.display_batch_rec()');
125: arp_util.debug('arp_tbat_pgk.display_batch_rec()-');
126:
127: EXCEPTION
128: WHEN OTHERS THEN
129: arp_util.debug('EXCEPTION: arp_tbat_pgk.display_batch_rec()');
130: RAISE;
131:
132: END;
133:
142: | |
143: | SCOPE - PRIVATE |
144: | |
145: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
146: | arp_util.debug |
147: | |
148: | ARGUMENTS : IN: |
149: | p_batch_id |
150: | OUT: |
167: l_batch_rec ra_batches%rowtype;
168:
169: BEGIN
170:
171: arp_util.debug('arp_tbat_pgk.display_batch()+');
172:
173: arp_tbat_pkg.fetch_p(l_batch_rec, p_batch_id);
174:
175: arp_tbat_pkg.display_batch_rec (l_batch_rec);
173: arp_tbat_pkg.fetch_p(l_batch_rec, p_batch_id);
174:
175: arp_tbat_pkg.display_batch_rec (l_batch_rec);
176:
177: arp_util.debug('arp_tbat_pgk.display_batch()-');
178:
179: EXCEPTION
180: WHEN OTHERS THEN
181: arp_util.debug('EXCEPTION: arp_tbat_pgk.display_batch()');
177: arp_util.debug('arp_tbat_pgk.display_batch()-');
178:
179: EXCEPTION
180: WHEN OTHERS THEN
181: arp_util.debug('EXCEPTION: arp_tbat_pgk.display_batch()');
182: RAISE;
183:
184: END;
185:
195: | SCOPE - PRIVATE |
196: | |
197: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
198: | dbms_sql.bind_variable |
199: | arp_util.debug |
200: | |
201: | ARGUMENTS : IN: |
202: | p_update_cursor - ID of the update cursor |
203: | p_batch_rec - ra_batches record |
228: p_batch_rec IN ra_batches%rowtype) IS
229:
230: BEGIN
231:
232: arp_util.debug('arp_tbat_pkg.bind_batch_variables()+');
233:
234: /*------------------+
235: | Dummy constants |
236: +------------------*/
355: p_batch_rec.selection_criteria_id);
356: dbms_sql.bind_variable(p_update_cursor, ':request_id',
357: p_batch_rec.request_id);
358:
359: arp_util.debug('arp_tbat_pkg.bind_batch_variables()-');
360:
361: EXCEPTION
362: WHEN OTHERS THEN
363: arp_util.debug('EXCEPTION: arp_tbat_pkg.bind_batch_variables()');
359: arp_util.debug('arp_tbat_pkg.bind_batch_variables()-');
360:
361: EXCEPTION
362: WHEN OTHERS THEN
363: arp_util.debug('EXCEPTION: arp_tbat_pkg.bind_batch_variables()');
364: RAISE;
365:
366: END;
367:
377: | |
378: | SCOPE - PRIVATE |
379: | |
380: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
381: | arp_util.debug |
382: | |
383: | ARGUMENTS : IN: |
384: | None. |
385: | OUT: |
408:
409: PROCEDURE construct_batch_update_stmt( update_text OUT NOCOPY varchar2) IS
410:
411: BEGIN
412: arp_util.debug('arp_tbat_pkg.construct_batch_update_stmt()+');
413:
414: update_text :=
415: 'update ra_batches
416: SET batch_id =
598: DECODE(:request_id,
599: :ar_number_dummy, request_id,
600: :request_id) ';
601:
602: arp_util.debug('arp_tbat_pkg.construct_batch_update_stmt()-');
603:
604: EXCEPTION
605: WHEN OTHERS THEN
606: arp_util.debug('EXCEPTION: arp_tbat_pkg.construct_batch_update_stmt()');
602: arp_util.debug('arp_tbat_pkg.construct_batch_update_stmt()-');
603:
604: EXCEPTION
605: WHEN OTHERS THEN
606: arp_util.debug('EXCEPTION: arp_tbat_pkg.construct_batch_update_stmt()');
607: RAISE;
608:
609: END;
610:
620: | |
621: | SCOPE - PRIVATE |
622: | |
623: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
624: | arp_util.debug |
625: | dbms_sql.open_cursor |
626: | dbms_sql.parse |
627: | dbms_sql.execute |
628: | dbms_sql.close_cursor |
654: l_ra_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;
655: ra_batch_array dbms_sql.number_table;
656:
657: BEGIN
658: arp_util.debug('arp_tbat_pkg.generic_update()+');
659:
660: /*--------------------------------------------------------------+
661: | If this update statement has not already been parsed, |
662: | construct the statement and parse it. |
709: p_where1);
710:
711: l_count := dbms_sql.execute(p_update_cursor);
712:
713: arp_util.debug( to_char(l_count) || ' rows updated');
714:
715: /*------------------------------------------+
716: | get RETURNING COLUMN into OUT NOCOPY bind array |
717: +------------------------------------------*/
740: -- p_key_value => ra_batch_array(I));
741: -- END LOOP;
742: --}
743:
744: arp_util.debug('arp_tbat_pkg.generic_update()-');
745:
746: EXCEPTION
747: WHEN OTHERS THEN
748: arp_util.debug('EXCEPTION: arp_tbat_pkg.generic_update()');
744: arp_util.debug('arp_tbat_pkg.generic_update()-');
745:
746: EXCEPTION
747: WHEN OTHERS THEN
748: arp_util.debug('EXCEPTION: arp_tbat_pkg.generic_update()');
749: arp_util.debug(l_update_statement);
750: arp_util.debug('Error at character: ' ||
751: to_char(dbms_sql.last_error_position));
752: RAISE;
745:
746: EXCEPTION
747: WHEN OTHERS THEN
748: arp_util.debug('EXCEPTION: arp_tbat_pkg.generic_update()');
749: arp_util.debug(l_update_statement);
750: arp_util.debug('Error at character: ' ||
751: to_char(dbms_sql.last_error_position));
752: RAISE;
753: END;
746: EXCEPTION
747: WHEN OTHERS THEN
748: arp_util.debug('EXCEPTION: arp_tbat_pkg.generic_update()');
749: arp_util.debug(l_update_statement);
750: arp_util.debug('Error at character: ' ||
751: to_char(dbms_sql.last_error_position));
752: RAISE;
753: END;
754:
768: | |
769: | SCOPE - PUBLIC |
770: | |
771: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
772: | arp_util.debug |
773: | |
774: | ARGUMENTS : IN: |
775: | None |
776: | OUT: |
798: PROCEDURE set_to_dummy( p_batch_rec OUT NOCOPY ra_batches%rowtype) IS
799:
800: BEGIN
801:
802: arp_util.debug('arp_tbat_pkg.set_to_dummy()+');
803:
804: p_batch_rec.batch_id := AR_NUMBER_DUMMY;
805: p_batch_rec.last_update_date := AR_DATE_DUMMY;
806: p_batch_rec.last_updated_by := AR_NUMBER_DUMMY;
847: p_batch_rec.batch_process_status := AR_TEXT_DUMMY;
848: p_batch_rec.selection_criteria_id := AR_NUMBER_DUMMY;
849: p_batch_rec.request_id := AR_NUMBER_DUMMY;
850:
851: arp_util.debug('arp_tbat_pkg.set_to_dummy()-');
852:
853: EXCEPTION
854: WHEN OTHERS THEN
855: arp_util.debug('EXCEPTION: arp_tbat_pkg.set_to_dummy()');
851: arp_util.debug('arp_tbat_pkg.set_to_dummy()-');
852:
853: EXCEPTION
854: WHEN OTHERS THEN
855: arp_util.debug('EXCEPTION: arp_tbat_pkg.set_to_dummy()');
856: RAISE;
857:
858: END;
859:
867: | |
868: | SCOPE - PUBLIC |
869: | |
870: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
871: | arp_util.debug |
872: | |
873: | ARGUMENTS : IN: |
874: | p_batch_id - identifies the record to fetch |
875: | OUT: |
887: PROCEDURE fetch_p( p_batch_rec OUT NOCOPY ra_batches%rowtype,
888: p_batch_id IN ra_batches.batch_id%type ) IS
889:
890: BEGIN
891: arp_util.debug('arp_tbat_pkg.fetch_p()+');
892:
893: SELECT *
894: INTO p_batch_rec
895: FROM ra_batches
894: INTO p_batch_rec
895: FROM ra_batches
896: WHERE batch_id = p_batch_id;
897:
898: arp_util.debug('arp_tbat_pkg.fetch_p()-');
899:
900: EXCEPTION
901: WHEN OTHERS THEN
902: arp_util.debug('EXCEPTION: arp_tbat_pkg.fetch_p' );
898: arp_util.debug('arp_tbat_pkg.fetch_p()-');
899:
900: EXCEPTION
901: WHEN OTHERS THEN
902: arp_util.debug('EXCEPTION: arp_tbat_pkg.fetch_p' );
903: RAISE;
904: END;
905:
906: /*===========================================================================+
913: | |
914: | SCOPE - PUBLIC |
915: | |
916: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
917: | arp_util.debug |
918: | |
919: | ARGUMENTS : IN: |
920: | p_batch_id - identifies the row to lock |
921: | OUT: |
934:
935: l_batch_id ra_batches.batch_id%type;
936:
937: BEGIN
938: arp_util.debug('arp_tbat_pkg.lock_p()+');
939:
940: SELECT batch_id
941: INTO l_batch_id
942: FROM ra_batches
942: FROM ra_batches
943: WHERE batch_id = p_batch_id
944: FOR UPDATE OF batch_id NOWAIT;
945:
946: arp_util.debug('arp_tbat_pkg.lock_p()-');
947:
948: EXCEPTION
949: WHEN OTHERS THEN
950: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_p' );
946: arp_util.debug('arp_tbat_pkg.lock_p()-');
947:
948: EXCEPTION
949: WHEN OTHERS THEN
950: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_p' );
951: RAISE;
952: END;
953:
954: /*===========================================================================+
962: | |
963: | SCOPE - PUBLIC |
964: | |
965: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
966: | arp_util.debug |
967: | |
968: | ARGUMENTS : IN: |
969: | p_batch_id - identifies the row to lock |
970: | OUT: |
982: PROCEDURE lock_fetch_p( p_batch_rec IN OUT NOCOPY ra_batches%rowtype,
983: p_batch_id IN ra_batches.batch_id%type ) IS
984:
985: BEGIN
986: arp_util.debug('arp_tbat_pkg.lock_fetch_p()+');
987:
988: SELECT *
989: INTO p_batch_rec
990: FROM ra_batches
990: FROM ra_batches
991: WHERE batch_id = p_batch_id
992: FOR UPDATE OF batch_id NOWAIT;
993:
994: arp_util.debug('arp_tbat_pkg.lock_fetch_p()-');
995:
996: EXCEPTION
997: WHEN OTHERS THEN
998: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_fetch_p' );
994: arp_util.debug('arp_tbat_pkg.lock_fetch_p()-');
995:
996: EXCEPTION
997: WHEN OTHERS THEN
998: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_fetch_p' );
999: RAISE;
1000: END;
1001:
1002: /*===========================================================================+
1010: | |
1011: | SCOPE - PUBLIC |
1012: | |
1013: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1014: | arp_util.debug |
1015: | |
1016: | ARGUMENTS : IN: |
1017: | p_batch_id - identifies the row to lock |
1018: | p_batch_rec - batch record for comparison |
1044:
1045: l_new_batch_rec ra_batches%rowtype;
1046:
1047: BEGIN
1048: arp_util.debug('arp_tbat_pkg.lock_compare_p()+');
1049:
1050: SELECT *
1051: INTO l_new_batch_rec
1052: FROM ra_batches tbat
1422: )
1423: )
1424: FOR UPDATE OF batch_id NOWAIT;
1425:
1426: arp_util.debug('arp_tbat_pkg.lock_compare_p()-');
1427:
1428: EXCEPTION
1429: WHEN OTHERS THEN
1430: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_compare_p' );
1426: arp_util.debug('arp_tbat_pkg.lock_compare_p()-');
1427:
1428: EXCEPTION
1429: WHEN OTHERS THEN
1430: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_compare_p' );
1431: RAISE;
1432: END;
1433:
1434: /*===========================================================================+
1440: | |
1441: | SCOPE - PRIVATE |
1442: | |
1443: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1444: | arp_util.debug |
1445: | |
1446: | ARGUMENTS : IN: |
1447: | p_form_name |
1448: | p_form_version |
1515: p_attribute15 IN ra_batches.attribute15%type)
1516: IS
1517: l_batch_rec ra_batches%rowtype;
1518: BEGIN
1519: arp_util.debug('arp_tbat_pkg.lock_compare_cover()+');
1520:
1521: arp_tbat_pkg.set_to_dummy(l_batch_rec);
1522:
1523: l_batch_rec.batch_id := p_batch_id;
1556:
1557: arp_tbat_pkg.lock_compare_p(l_batch_rec,
1558: p_batch_id);
1559:
1560: arp_util.debug('arp_tbat_pkg.lock_compare_cover()-');
1561:
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');
1560: arp_util.debug('arp_tbat_pkg.lock_compare_cover()-');
1561:
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');
1565: arp_util.debug('p_batch_id : '||p_batch_id);
1566: arp_util.debug('p_name : '||p_name);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1561:
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');
1565: arp_util.debug('p_batch_id : '||p_batch_id);
1566: arp_util.debug('p_name : '||p_name);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');
1565: arp_util.debug('p_batch_id : '||p_batch_id);
1566: arp_util.debug('p_name : '||p_name);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);
1563: WHEN OTHERS THEN
1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');
1565: arp_util.debug('p_batch_id : '||p_batch_id);
1566: arp_util.debug('p_name : '||p_name);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);
1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');
1565: arp_util.debug('p_batch_id : '||p_batch_id);
1566: arp_util.debug('p_name : '||p_name);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1565: arp_util.debug('p_batch_id : '||p_batch_id);
1566: arp_util.debug('p_name : '||p_name);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1566: arp_util.debug('p_name : '||p_name);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);
1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);
1594: arp_util.debug('p_attribute13 : '||p_attribute13);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);
1594: arp_util.debug('p_attribute13 : '||p_attribute13);
1595: arp_util.debug('p_attribute14 : '||p_attribute14);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);
1594: arp_util.debug('p_attribute13 : '||p_attribute13);
1595: arp_util.debug('p_attribute14 : '||p_attribute14);
1596: arp_util.debug('p_attribute15 : '||p_attribute15);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);
1594: arp_util.debug('p_attribute13 : '||p_attribute13);
1595: arp_util.debug('p_attribute14 : '||p_attribute14);
1596: arp_util.debug('p_attribute15 : '||p_attribute15);
1597:
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);
1594: arp_util.debug('p_attribute13 : '||p_attribute13);
1595: arp_util.debug('p_attribute14 : '||p_attribute14);
1596: arp_util.debug('p_attribute15 : '||p_attribute15);
1597:
1598: RAISE;
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);
1594: arp_util.debug('p_attribute13 : '||p_attribute13);
1595: arp_util.debug('p_attribute14 : '||p_attribute14);
1596: arp_util.debug('p_attribute15 : '||p_attribute15);
1597:
1598: RAISE;
1599: END;
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);
1594: arp_util.debug('p_attribute13 : '||p_attribute13);
1595: arp_util.debug('p_attribute14 : '||p_attribute14);
1596: arp_util.debug('p_attribute15 : '||p_attribute15);
1597:
1598: RAISE;
1599: END;
1600:
1608: | |
1609: | SCOPE - PUBLIC |
1610: | |
1611: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1612: | arp_util.debug |
1613: | |
1614: | ARGUMENTS : IN: |
1615: | p_batch_id - identifies the row to delete |
1616: | OUT: |
1630: l_count number;
1631:
1632: BEGIN
1633:
1634: arp_util.debug('arp_tbat_pkg.delete_p()+');
1635:
1636: /*-----------------------------------------------------+
1637: | Determine the number of transactions in the batch. |
1638: | The procedure only deletes batches that do not |
1663: fnd_message.set_name('AR', '250');
1664: app_exception.raise_exception;
1665: END IF;
1666:
1667: arp_util.debug('arp_tbat_pkg.delete_p()-');
1668:
1669: EXCEPTION
1670: WHEN OTHERS THEN
1671: arp_util.debug('EXCEPTION: arp_tbat_pkg.delete_p()');
1667: arp_util.debug('arp_tbat_pkg.delete_p()-');
1668:
1669: EXCEPTION
1670: WHEN OTHERS THEN
1671: arp_util.debug('EXCEPTION: arp_tbat_pkg.delete_p()');
1672: RAISE;
1673:
1674: END;
1675:
1683: | |
1684: | SCOPE - PUBLIC |
1685: | |
1686: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1687: | arp_util.debug |
1688: | |
1689: | ARGUMENTS : IN: |
1690: | p_batch_source_id - identifies the rows to delete |
1691: | OUT: |
1706: l_count number;
1707:
1708: BEGIN
1709:
1710: arp_util.debug('arp_tbat_pkg.delete_f_bs_id()+');
1711:
1712: /*-----------------------------------------------------+
1713: | Determine the number of transactions in the batch. |
1714: | The procedure only deletes batches that do not |
1739: fnd_message.set_name('AR', '250');
1740: app_exception.raise_exception;
1741: END IF;
1742:
1743: arp_util.debug('arp_tbat_pkg.delete_f_bs_id()-');
1744:
1745: EXCEPTION
1746: WHEN OTHERS THEN
1747:
1744:
1745: EXCEPTION
1746: WHEN OTHERS THEN
1747:
1748: arp_util.debug('EXCEPTION: arp_tbat_pkg.delete_f_bs_id()');
1749: RAISE;
1750:
1751: END;
1752:
1760: | |
1761: | SCOPE - PUBLIC |
1762: | |
1763: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1764: | arp_util.debug |
1765: | |
1766: | ARGUMENTS : IN: |
1767: | p_batch_id - identifies the row to update |
1768: | p_batch_rec - contains the new column values |
1785:
1786:
1787: BEGIN
1788:
1789: arp_util.debug('arp_tbat_pkg.update_p()+');
1790:
1791: arp_tbat_pkg.generic_update( pg_cursor1,
1792: ' WHERE batch_id = :where_1',
1793: p_batch_id,
1792: ' WHERE batch_id = :where_1',
1793: p_batch_id,
1794: p_batch_rec);
1795:
1796: arp_util.debug('arp_tbat_pkg.update_p()-');
1797:
1798:
1799: EXCEPTION
1800: WHEN OTHERS THEN
1797:
1798:
1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: arp_util.debug('EXCEPTION: arp_tbat_pkg.update_p()');
1802: RAISE;
1803: END;
1804:
1805: /*===========================================================================+
1812: | |
1813: | SCOPE - PUBLIC |
1814: | |
1815: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1816: | arp_util.debug |
1817: | |
1818: | ARGUMENTS : IN: |
1819: | p_batch_source_id - identifies the rows to delete |
1820: | p_batch_rec - contains the new column values |
1838:
1839:
1840: BEGIN
1841:
1842: arp_util.debug('arp_tbat_pkg.update_f_bs_id()+');
1843:
1844: arp_tbat_pkg.generic_update( pg_cursor2,
1845: ' WHERE batch_source_id = :where_1',
1846: p_batch_source_id,
1845: ' WHERE batch_source_id = :where_1',
1846: p_batch_source_id,
1847: p_batch_rec);
1848:
1849: arp_util.debug('arp_tbat_pkg.update_f_bs_id()-');
1850:
1851:
1852: EXCEPTION
1853: WHEN OTHERS THEN
1850:
1851:
1852: EXCEPTION
1853: WHEN OTHERS THEN
1854: arp_util.debug('EXCEPTION: arp_tbat_pkg.update_f_bs_id()');
1855: RAISE;
1856: END;
1857:
1858: /*===========================================================================+
1865: | |
1866: | SCOPE - PUBLIC |
1867: | |
1868: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1869: | arp_util.debug |
1870: | arp_global.set_of_books_id |
1871: | |
1872: | ARGUMENTS : IN: |
1873: | p_batch_rec - contains the new column values |
1905: l_ra_batches_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */
1906:
1907: BEGIN
1908:
1909: arp_util.debug('arp_tbat_pkg.insert_p()+');
1910:
1911: p_batch_id := '';
1912:
1913: /*---------------------------*
2058: -- p_table_name => 'RA_BATCHES',
2059: -- p_mode => 'SINGLE',
2060: -- p_key_value => l_batch_id);
2061: --}
2062: arp_util.debug('arp_tbat_pkg.insert_p()-');
2063:
2064: EXCEPTION
2065: WHEN OTHERS THEN
2066: arp_util.debug('EXCEPTION: arp_tbat_pkg.insert_p()');
2062: arp_util.debug('arp_tbat_pkg.insert_p()-');
2063:
2064: EXCEPTION
2065: WHEN OTHERS THEN
2066: arp_util.debug('EXCEPTION: arp_tbat_pkg.insert_p()');
2067: RAISE;
2068: END;
2069:
2070: