114: | |
115: | SCOPE - PUBLIC |
116: | |
117: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
118: | arp_ct_pkg.lock_fetch_p |
119: | arp_trx_complete_chk.do_completion_checking |
120: | FND_SEQNUM.GET_SEQ_VAL |
121: | arp_ct_pkg.update_p |
122: | ARP_PROCESS_HEADER_POST_COMMIT.post_commit |
117: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
118: | arp_ct_pkg.lock_fetch_p |
119: | arp_trx_complete_chk.do_completion_checking |
120: | FND_SEQNUM.GET_SEQ_VAL |
121: | arp_ct_pkg.update_p |
122: | ARP_PROCESS_HEADER_POST_COMMIT.post_commit |
123: | |
124: | ARGUMENTS : |
125: | IN: |
236: IF pg_debug = 'Y' THEN
237: trx_debug ('Calling ar_ct_pkg.lock_fetch_p(+) ');
238: END IF;
239:
240: arp_ct_pkg.lock_fetch_p (l_trx_rec,
241: p_customer_trx_id);
242:
243: IF pg_debug = 'Y' THEN
244: trx_debug ('ar_ct_pkg.lock_fetch_p(-) ');
341: END IF;
342:
343: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
344: l_trx_rec.complete_flag := 'Y';
345: arp_ct_pkg.update_p(l_trx_rec,p_customer_trx_id);
346: IF pg_debug = 'Y' THEN
347: trx_debug ('Calling ARP_PROCESS_HEADER_POST_COMMIT.post_commit(+)');
348: END IF;
349: ARP_PROCESS_HEADER_POST_COMMIT.post_commit (
430: | |
431: | SCOPE - PUBLIC |
432: | |
433: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
434: | arp_ct_pkg.lock_fetch_p |
435: | arpt_sql_func_util.get_posted_flag |
436: | arpt_sql_func_util.get_activity_flag
437: | arp_ct_pkg.update_p |
438: | ARP_PROCESS_HEADER_POST_COMMIT.post_commit |
433: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
434: | arp_ct_pkg.lock_fetch_p |
435: | arpt_sql_func_util.get_posted_flag |
436: | arpt_sql_func_util.get_activity_flag
437: | arp_ct_pkg.update_p |
438: | ARP_PROCESS_HEADER_POST_COMMIT.post_commit |
439: | |
440: | ARGUMENTS : |
441: | IN: |
537: /*-----------------------------------------------------+
538: | Lock and fetch the header record for customer trx id |
539: +-----------------------------------------------------*/
540: IF pg_debug = 'Y' THEN
541: trx_debug ('Calling arp_ct_pkg.lock_fetch_p(+) ');
542: END IF;
543:
544: arp_ct_pkg.lock_fetch_p (l_trx_rec,
545: p_customer_trx_id);
540: IF pg_debug = 'Y' THEN
541: trx_debug ('Calling arp_ct_pkg.lock_fetch_p(+) ');
542: END IF;
543:
544: arp_ct_pkg.lock_fetch_p (l_trx_rec,
545: p_customer_trx_id);
546:
547: IF pg_debug = 'Y' THEN
548: trx_debug ('arp_ct_pkg.lock_fetch_p(-) ');
544: arp_ct_pkg.lock_fetch_p (l_trx_rec,
545: p_customer_trx_id);
546:
547: IF pg_debug = 'Y' THEN
548: trx_debug ('arp_ct_pkg.lock_fetch_p(-) ');
549: END IF;
550:
551: /*----------------------------------------------+
552: | Get the transaction type for trx type id |
642: END IF;
643:
644: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
645: l_trx_rec.complete_flag := 'N';
646: arp_ct_pkg.update_p(l_trx_rec,p_customer_trx_id);
647: IF pg_debug = 'Y' THEN
648: trx_debug ('Calling ARP_PROCESS_HEADER_POST_COMMIT.post_commit(+)');
649: END IF;
650: ARP_PROCESS_HEADER_POST_COMMIT.post_commit (