APPS.EGO_IMPORT_PVT dependencies on FND_PROFILE

Line 636: l_stats_profile NUMBER := NVL(FND_PROFILE.VALUE('EGO_GATHER_STATS'),100);

632: l_schema VARCHAR2(1000);
633: l_inv_installed BOOLEAN;
634: l_ego_installed BOOLEAN;
635: --6602290 : Stats gather through profile
636: l_stats_profile NUMBER := NVL(FND_PROFILE.VALUE('EGO_GATHER_STATS'),100);
637: BEGIN
638: Debug_Conc_Log('Starting Gather_Stats_For_Intf_Tables');
639: l_inv_installed := FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema);
640:

Line 6530: l_org := fnd_profile.value('EGO_USER_ORGANIZATION_CONTEXT');

6526: AND BA.BATCH_ID = OPT.BATCH_ID;
6527: EXCEPTION WHEN NO_DATA_FOUND THEN
6528: -- IF batch not found then getting the default org_id from
6529: -- profile option for the user
6530: l_org := fnd_profile.value('EGO_USER_ORGANIZATION_CONTEXT');
6531: BEGIN
6532: SELECT mp.MASTER_ORGANIZATION_ID, mp1.ORGANIZATION_CODE
6533: INTO l_org_id, l_org_code
6534: FROM MTL_PARAMETERS mp, MTL_PARAMETERS mp1

Line 6727: AND asa.ORG_ID = FND_PROFILE.Value('ORG_ID')

6723: SET PK2_VALUE = ( SELECT VENDOR_SITE_ID
6724: FROM AP_SUPPLIER_SITES_ALL asa
6725: WHERE asa.VENDOR_ID = eiai.PK1_VALUE
6726: AND asa.VENDOR_SITE_CODE = eiai.SUPPLIER_SITE_NAME
6727: AND asa.ORG_ID = FND_PROFILE.Value('ORG_ID')
6728: and nvl(asa.inactive_date,SYSDATE + 1) >SYSDATE --bug11072046
6729: )
6730: WHERE eiai.BATCH_ID = p_data_set_id
6731: AND (eiai.PROCESS_FLAG IS NULL OR eiai.PROCESS_FLAG IN (0, 1) )

Line 8048: l_org := fnd_profile.value('EGO_USER_ORGANIZATION_CONTEXT');

8044: INTO l_ss_id, l_org_id, l_import_policy, l_import_xref_only, l_enabled_for_data_pool
8045: FROM EGO_IMPORT_BATCHES_B BA, EGO_IMPORT_OPTION_SETS OPT
8046: WHERE BA.BATCH_ID = p_data_set_id AND BA.BATCH_ID = OPT.BATCH_ID;
8047: EXCEPTION WHEN NO_DATA_FOUND THEN
8048: l_org := fnd_profile.value('EGO_USER_ORGANIZATION_CONTEXT');
8049: BEGIN
8050: SELECT mp.MASTER_ORGANIZATION_ID
8051: INTO l_org_id
8052: FROM MTL_PARAMETERS mp

Line 10735: WHEN G_DATE_TIME_DATA_TYPE THEN FND_PROFILE.VALUE( 'ICX_DATE_FORMAT_MASK' ) || ' HH24:MI:SS'

10731: ELSE '' -- XXX: hmmm, raise exception here?
10732: END;
10733:
10734: l_date_format := CASE p_attr_type
10735: WHEN G_DATE_TIME_DATA_TYPE THEN FND_PROFILE.VALUE( 'ICX_DATE_FORMAT_MASK' ) || ' HH24:MI:SS'
10736: WHEN G_DATE_DATA_TYPE THEN FND_PROFILE.VALUE( 'ICX_DATE_FORMAT_MASK' )
10737: ELSE NULL
10738: END;
10739:

Line 10736: WHEN G_DATE_DATA_TYPE THEN FND_PROFILE.VALUE( 'ICX_DATE_FORMAT_MASK' )

10732: END;
10733:
10734: l_date_format := CASE p_attr_type
10735: WHEN G_DATE_TIME_DATA_TYPE THEN FND_PROFILE.VALUE( 'ICX_DATE_FORMAT_MASK' ) || ' HH24:MI:SS'
10736: WHEN G_DATE_DATA_TYPE THEN FND_PROFILE.VALUE( 'ICX_DATE_FORMAT_MASK' )
10737: ELSE NULL
10738: END;
10739:
10740: l_miss_str := CASE WHEN NOT p_attr_miss_value THEN G_EXCEL_MISS_VS_VAL