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: -- checking whether stats needs to be collected on MTL_SYSTEM_ITEMS_INTERFACE
640: SELECT COUNT(1) INTO l_records

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

6444: AND BA.BATCH_ID = OPT.BATCH_ID;
6445: EXCEPTION WHEN NO_DATA_FOUND THEN
6446: -- IF batch not found then getting the default org_id from
6447: -- profile option for the user
6448: l_org := fnd_profile.value('EGO_USER_ORGANIZATION_CONTEXT');
6449: BEGIN
6450: SELECT mp.MASTER_ORGANIZATION_ID, mp1.ORGANIZATION_CODE
6451: INTO l_org_id, l_org_code
6452: FROM MTL_PARAMETERS mp, MTL_PARAMETERS mp1

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

6639: SET PK2_VALUE = ( SELECT VENDOR_SITE_ID
6640: FROM AP_SUPPLIER_SITES_ALL asa
6641: WHERE asa.VENDOR_ID = eiai.PK1_VALUE
6642: AND asa.VENDOR_SITE_CODE = eiai.SUPPLIER_SITE_NAME
6643: AND asa.ORG_ID = FND_PROFILE.Value('ORG_ID')
6644: )
6645: WHERE eiai.BATCH_ID = p_data_set_id
6646: AND (eiai.PROCESS_FLAG IS NULL OR eiai.PROCESS_FLAG IN (0, 1) )
6647: AND eiai.PK2_VALUE IS NULL

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

7942: INTO l_ss_id, l_org_id, l_import_policy, l_import_xref_only, l_enabled_for_data_pool
7943: FROM EGO_IMPORT_BATCHES_B BA, EGO_IMPORT_OPTION_SETS OPT
7944: WHERE BA.BATCH_ID = p_data_set_id AND BA.BATCH_ID = OPT.BATCH_ID;
7945: EXCEPTION WHEN NO_DATA_FOUND THEN
7946: l_org := fnd_profile.value('EGO_USER_ORGANIZATION_CONTEXT');
7947: BEGIN
7948: SELECT mp.MASTER_ORGANIZATION_ID
7949: INTO l_org_id
7950: FROM MTL_PARAMETERS mp

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

10628: ELSE '' -- XXX: hmmm, raise exception here?
10629: END;
10630:
10631: l_date_format := CASE p_attr_type
10632: WHEN G_DATE_TIME_DATA_TYPE THEN FND_PROFILE.VALUE( 'ICX_DATE_FORMAT_MASK' ) || ' HH24:MI:SS'
10633: WHEN G_DATE_DATA_TYPE THEN FND_PROFILE.VALUE( 'ICX_DATE_FORMAT_MASK' )
10634: ELSE NULL
10635: END;
10636:

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

10629: END;
10630:
10631: l_date_format := CASE p_attr_type
10632: WHEN G_DATE_TIME_DATA_TYPE THEN FND_PROFILE.VALUE( 'ICX_DATE_FORMAT_MASK' ) || ' HH24:MI:SS'
10633: WHEN G_DATE_DATA_TYPE THEN FND_PROFILE.VALUE( 'ICX_DATE_FORMAT_MASK' )
10634: ELSE NULL
10635: END;
10636:
10637: l_miss_str := CASE WHEN NOT p_attr_miss_value THEN G_EXCEL_MISS_VS_VAL