APPS.MSD_COLLECT_LEVEL_VALUES dependencies on FND_PROFILE

Line 144: IF (fnd_profile.value('MSD_ONE_STEP_COLLECTION') = 'Y') THEN

140:
141: /* IF this is one step collection then
142: call PULL internally and execute 2 step collection */
143:
144: IF (fnd_profile.value('MSD_ONE_STEP_COLLECTION') = 'Y') THEN
145:
146: if retcode = '-1' then
147:
148: BEGIN

Line 955: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');

951:
952: FUNCTION get_dest_table return varchar2 IS
953: x_direct_load_profile boolean;
954: BEGIN
955: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
956:
957: if (x_direct_load_profile) then
958: return MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE ;
959: else

Line 968: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');

964:
965: FUNCTION get_assoc_table return varchar2 IS
966: x_direct_load_profile boolean;
967: BEGIN
968: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
969:
970: if (x_direct_load_profile) then
971: return MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE ;
972: else

Line 981: ln_rows_to_fetch Number := nvl(TO_NUMBER(FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);

977:
978: Procedure Delete_duplicate(p_instance_id in number, p_dest_table in varchar2) is
979:
980: lb_FetchComplete BOOLEAN := FALSE;
981: ln_rows_to_fetch Number := nvl(TO_NUMBER(FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
982:
983: TYPE CharTblTyp IS TABLE OF VARCHAR2(240);
984: TYPE NumTblTyp IS TABLE OF NUMBER;
985:

Line 1172: IF (fnd_profile.value('MSD_ONE_STEP_COLLECTION') = 'Y') THEN

1168: BEGIN
1169:
1170: /* 1 step collection */
1171: /* Bug# 4919130 - Always delete childless parents from staging table.
1172: IF (fnd_profile.value('MSD_ONE_STEP_COLLECTION') = 'Y') THEN
1173:
1174: l_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE;
1175:
1176: FOR Level_Rec IN c_level LOOP