DBA Data[Home] [Help]

APPS.AR_TRX_SUMMARY_PKG dependencies on FND_PROFILE

Line 5: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1: PACKAGE BODY AR_TRX_SUMMARY_PKG AS
2: /* $Header: ARCMUPGB.pls 120.25.12020000.2 2012/07/11 18:10:23 rravikir ship $ */
3:
4: /* Globals */
5: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
6: TYPE l_cust_id_type IS TABLE OF
7: ar_payment_schedules_all.customer_id%type
8: INDEX BY BINARY_INTEGER;
9:

Line 39: l_po_value := fnd_profile.value('AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH');

35: l_po_value VARCHAR2(10);
36: l_at_risk_exists VARCHAR2(1);
37: BEGIN
38: fnd_file.put_line(fnd_file.log,'AR_TRX_SUMMARY_PKG.refresh_all(+)');
39: l_po_value := fnd_profile.value('AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH');
40:
41: IF nvl(l_po_value,'N') IN ('Y','A') THEN
42:
43: /* 6149811 - clear summary table data */

Line 1121: l_return := fnd_profile.save('AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH',

1117: submit_held_events;
1118:
1119: IF l_po_value = 'Y'
1120: THEN
1121: l_return := fnd_profile.save('AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH',
1122: 'N','APPL',222);
1123: END IF;
1124:
1125: ELSE

Line 2359: l_po_value := fnd_profile.value('AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH');

2355: arp_standard.debug(' p_skip_secondary_processes = ' || p_skip_secondary_processes);
2356: END IF;
2357:
2358: /* Check profile, if set to N, then terminate program */
2359: l_po_value := fnd_profile.value('AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH');
2360:
2361: IF nvl(l_po_value,'N') = 'N'
2362: THEN
2363: fnd_file.put_line(fnd_file.log,

Line 2483: l_return := fnd_profile.save('AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH',

2479:
2480: /* Set profile back to N */
2481: IF l_po_value = 'Y'
2482: THEN
2483: l_return := fnd_profile.save('AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH',
2484: 'N','APPL',222);
2485: END IF;
2486:
2487: /* Final commit of new data */