DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on FND_PROFILE

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

1: PACKAGE BODY AR_AUTOREM_API AS
2: /* $Header: ARATREMB.pls 120.82.12020000.13 2013/01/15 22:38:51 rravikir ship $ */
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5: PG_PARALLEL varchar2(1) := NVL(FND_PROFILE.value('AR_USE_PARALLEL_HINT'), 'N');
6: PG_APPEND varchar2(1) := NVL(FND_PROFILE.value('AR_USE_APPEND_HINT'), 'Y');
7: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE);
8: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE);

Line 5: PG_PARALLEL varchar2(1) := NVL(FND_PROFILE.value('AR_USE_PARALLEL_HINT'), 'N');

1: PACKAGE BODY AR_AUTOREM_API AS
2: /* $Header: ARATREMB.pls 120.82.12020000.13 2013/01/15 22:38:51 rravikir ship $ */
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5: PG_PARALLEL varchar2(1) := NVL(FND_PROFILE.value('AR_USE_PARALLEL_HINT'), 'N');
6: PG_APPEND varchar2(1) := NVL(FND_PROFILE.value('AR_USE_APPEND_HINT'), 'Y');
7: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE);
8: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE);
9:

Line 6: PG_APPEND varchar2(1) := NVL(FND_PROFILE.value('AR_USE_APPEND_HINT'), 'Y');

2: /* $Header: ARATREMB.pls 120.82.12020000.13 2013/01/15 22:38:51 rravikir ship $ */
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5: PG_PARALLEL varchar2(1) := NVL(FND_PROFILE.value('AR_USE_PARALLEL_HINT'), 'N');
6: PG_APPEND varchar2(1) := NVL(FND_PROFILE.value('AR_USE_APPEND_HINT'), 'Y');
7: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE);
8: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE);
9:
10: G_ERROR varchar2(1) := 'N';

Line 5604: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));

5600: END IF;
5601:
5602: --Start of Bug 5519913
5603:
5604: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
5605: l_org_id := mo_global.get_current_org_id;
5606:
5607: if l_org_id is null then
5608:

Line 5616: l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));

5612: where batch_id = p_batch_id;
5613: EXCEPTION
5614: when others then
5615: arp_util.debug('ar_autorem_api.submit Report ...OTHERS');
5616: l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
5617: end;
5618:
5619: end if;
5620: -- end of Bug 5519913

Line 5678: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));

5674: fnd_file.put_line(FND_FILE.LOG,'Submitting the report..');
5675: END IF;
5676:
5677: --Start of Bug 5519913
5678: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
5679: l_org_id := mo_global.get_current_org_id;
5680:
5681: if l_org_id is null then
5682: BEGIN

Line 5690: l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));

5686: where batch_id = p_batch_id;
5687: EXCEPTION
5688: when others then
5689: arp_util.debug('ar_autorem_api.submit Report ...OTHERS');
5690: l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
5691: end;
5692: end if;
5693: --End of Bug fix 5519913
5694: