APPS.MSC_CL_ITEM_PULL dependencies on FND_PROFILE

Line 19: v_maxnum_of_orgstr NUMBER := NVL(FND_PROFILE.VALUE('MSC_MAXNUM_FOR_ORGSTR'),500); -- Default num of org is 500

15: -- NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
16: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
17:
18: v_gmp_routine_name VARCHAR2(50);
19: v_maxnum_of_orgstr NUMBER := NVL(FND_PROFILE.VALUE('MSC_MAXNUM_FOR_ORGSTR'),500); -- Default num of org is 500
20:
21: GMP_ERROR EXCEPTION;
22:
23:

Line 362: ||' where uom_class = FND_PROFILE.VALUE'||MSC_CL_PULL.v_dblink||'(''FM_YIELD_TYPE'')'

358: BEGIN
359: -- check if the UOM class is defined for the class in profile option-FM_YIELD_TYPE in source instance
360: v_sql_stmt := ' select uom_code '
361: ||' from mtl_units_of_measure'||MSC_CL_PULL.v_dblink
362: ||' where uom_class = FND_PROFILE.VALUE'||MSC_CL_PULL.v_dblink||'(''FM_YIELD_TYPE'')'
363: ||' and base_uom_flag = ''Y'' ';
364:
365: execute immediate v_sql_stmt into lv_uom_code;
366: v_temp_sql := v_temp_sql ||' x.CONV_FACTOR, ';

Line 458: ||' where uom_class = FND_PROFILE.VALUE'||MSC_CL_PULL.v_dblink||'(''FM_YIELD_TYPE'')'

454: BEGIN
455: -- check if the UOM class is defined for the class in profile option-FM_YIELD_TYPE in source instance
456: v_sql_stmt := ' select uom_code '
457: ||' from mtl_units_of_measure'||MSC_CL_PULL.v_dblink
458: ||' where uom_class = FND_PROFILE.VALUE'||MSC_CL_PULL.v_dblink||'(''FM_YIELD_TYPE'')'
459: ||' and base_uom_flag = ''Y'' ';
460:
461: execute immediate v_sql_stmt into lv_uom_code;
462: v_temp_sql := v_temp_sql ||' x.CONV_FACTOR, ';

Line 1570: lv_item_name := NVL(FND_PROFILE.VALUE('MSC_EAM_NO_ACTIVITY_ITEM'),'No Activity Item');

1566: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))
1567: );
1568: commit;
1569:
1570: lv_item_name := NVL(FND_PROFILE.VALUE('MSC_EAM_NO_ACTIVITY_ITEM'),'No Activity Item');
1571: insert into MSC_ST_SYSTEM_ITEMS (
1572: ORGANIZATION_ID,
1573: SR_INVENTORY_ITEM_ID,
1574: SR_INSTANCE_ID,

Line 1626: lv_item_name := NVL(FND_PROFILE.VALUE('MSC_WIP_NONSTD_JOB_ITEM'),'Non Standard Job Item');

1622: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (org_group = MSC_CL_PULL.v_org_group));
1623:
1624: commit;
1625:
1626: lv_item_name := NVL(FND_PROFILE.VALUE('MSC_WIP_NONSTD_JOB_ITEM'),'Non Standard Job Item');
1627:
1628: insert into MSC_ST_SYSTEM_ITEMS (
1629: ORGANIZATION_ID,
1630: SR_INVENTORY_ITEM_ID,

Line 1871: lv_category_set_name := NVL(FND_PROFILE.VALUE('MSC_NO_ACTIVITY_ITEM_CATEGORY_SET'),'Unspecified Items');

1867: delete from MSC_ST_CATEGORY_SETS st_item_category_set
1868: where st_item_category_set.sr_instance_id = MSC_CL_PULL.v_instance_id
1869: and st_item_category_set.SR_CATEGORY_SET_ID = -5000;
1870: commit;
1871: lv_category_set_name := NVL(FND_PROFILE.VALUE('MSC_NO_ACTIVITY_ITEM_CATEGORY_SET'),'Unspecified Items');
1872: BEGIN
1873: lv_table_name:= 'MRP_AP_CATEGORY_SETS_V'||MSC_CL_PULL.v_dblink;
1874: lv_sql_stmt:= 'SELECT category_set_id FROM '||lv_table_name
1875: ||' WHERE category_set_name = '''||lv_category_set_name

Line 1924: lv_category_name := NVL(FND_PROFILE.VALUE('MSC_NO_ACTIVITY_ITEM_CATEGORY'),'NEW.MISC');

1920: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))
1921: );
1922: commit;
1923:
1924: lv_category_name := NVL(FND_PROFILE.VALUE('MSC_NO_ACTIVITY_ITEM_CATEGORY'),'NEW.MISC');
1925: BEGIN
1926: lv_table_name:= 'MRP_AP_ITEM_CATEGORIES_V'||MSC_CL_PULL.v_dblink;
1927: lv_sql_stmt:= 'SELECT category_id,description FROM ' ||lv_table_name
1928: || ' WHERE category_name = '''||lv_category_name