DBA Data[Home] [Help]

APPS.POR_HISTORY_FEED_PKG dependencies on FND_PROFILE

Line 35: g_created_by NUMBER := TO_NUMBER(fnd_profile.value ('USER_ID'));

31: --table should be created where the primary key should be format_id. This is
32: --the hook for future use. Format_id replaces need for card issuer ID and
33: --card issuer site ID to identify the field formats.
34:
35: g_created_by NUMBER := TO_NUMBER(fnd_profile.value ('USER_ID'));
36: g_last_updated_by NUMBER := TO_NUMBER (fnd_profile.value ('USER_ID'));
37: g_last_update_login NUMBER := TO_NUMBER (fnd_profile.value ('LOGIN_ID'));
38: g_conc_req_id NUMBER := TO_NUMBER (FND_PROFILE.value('CONC_REQUEST_ID'));
39: g_org_id NUMBER := TO_NUMBER (FND_PROFILE.value('ORG_ID'));

Line 36: g_last_updated_by NUMBER := TO_NUMBER (fnd_profile.value ('USER_ID'));

32: --the hook for future use. Format_id replaces need for card issuer ID and
33: --card issuer site ID to identify the field formats.
34:
35: g_created_by NUMBER := TO_NUMBER(fnd_profile.value ('USER_ID'));
36: g_last_updated_by NUMBER := TO_NUMBER (fnd_profile.value ('USER_ID'));
37: g_last_update_login NUMBER := TO_NUMBER (fnd_profile.value ('LOGIN_ID'));
38: g_conc_req_id NUMBER := TO_NUMBER (FND_PROFILE.value('CONC_REQUEST_ID'));
39: g_org_id NUMBER := TO_NUMBER (FND_PROFILE.value('ORG_ID'));
40:

Line 37: g_last_update_login NUMBER := TO_NUMBER (fnd_profile.value ('LOGIN_ID'));

33: --card issuer site ID to identify the field formats.
34:
35: g_created_by NUMBER := TO_NUMBER(fnd_profile.value ('USER_ID'));
36: g_last_updated_by NUMBER := TO_NUMBER (fnd_profile.value ('USER_ID'));
37: g_last_update_login NUMBER := TO_NUMBER (fnd_profile.value ('LOGIN_ID'));
38: g_conc_req_id NUMBER := TO_NUMBER (FND_PROFILE.value('CONC_REQUEST_ID'));
39: g_org_id NUMBER := TO_NUMBER (FND_PROFILE.value('ORG_ID'));
40:
41: g_po_num_err VARCHAR2(2000) := NULL;

Line 38: g_conc_req_id NUMBER := TO_NUMBER (FND_PROFILE.value('CONC_REQUEST_ID'));

34:
35: g_created_by NUMBER := TO_NUMBER(fnd_profile.value ('USER_ID'));
36: g_last_updated_by NUMBER := TO_NUMBER (fnd_profile.value ('USER_ID'));
37: g_last_update_login NUMBER := TO_NUMBER (fnd_profile.value ('LOGIN_ID'));
38: g_conc_req_id NUMBER := TO_NUMBER (FND_PROFILE.value('CONC_REQUEST_ID'));
39: g_org_id NUMBER := TO_NUMBER (FND_PROFILE.value('ORG_ID'));
40:
41: g_po_num_err VARCHAR2(2000) := NULL;
42: g_card_num_err VARCHAR2(2000) := NULL;

Line 39: g_org_id NUMBER := TO_NUMBER (FND_PROFILE.value('ORG_ID'));

35: g_created_by NUMBER := TO_NUMBER(fnd_profile.value ('USER_ID'));
36: g_last_updated_by NUMBER := TO_NUMBER (fnd_profile.value ('USER_ID'));
37: g_last_update_login NUMBER := TO_NUMBER (fnd_profile.value ('LOGIN_ID'));
38: g_conc_req_id NUMBER := TO_NUMBER (FND_PROFILE.value('CONC_REQUEST_ID'));
39: g_org_id NUMBER := TO_NUMBER (FND_PROFILE.value('ORG_ID'));
40:
41: g_po_num_err VARCHAR2(2000) := NULL;
42: g_card_num_err VARCHAR2(2000) := NULL;
43: g_max_card_num_size NUMBER := 0; -- maximum card size that is acceptable by AMEX :16

Line 1949: FND_PROFILE.GET('ECE_OUT_FILE_PATH',l_outdir);

1945: --Trim_Card_Numbers;
1946:
1947: l_progress := '800';
1948:
1949: FND_PROFILE.GET('ECE_OUT_FILE_PATH',l_outdir);
1950:
1951: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1952: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Output Directory = ' || l_outdir);
1953: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Filename = ' || g_output_filename);