APPS.MSD_COLLECT_LEVEL_VALUES dependencies on FND_PROFILE

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

133:
134: /* IF this is one step collection then
135: call PULL internally and execute 2 step collection */
136:
137: IF (fnd_profile.value('MSD_ONE_STEP_COLLECTION') = 'Y') THEN
138: msd_pull_level_values.pull_level_values_data( errbuf => errbuf,
139: retcode => retcode,
140: p_comp_refresh => 1);
141: END IF;

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

868:
869: FUNCTION get_dest_table return varchar2 IS
870: x_direct_load_profile boolean;
871: BEGIN
872: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
873:
874: if (x_direct_load_profile) then
875: return MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE ;
876: else

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

881:
882: FUNCTION get_assoc_table return varchar2 IS
883: x_direct_load_profile boolean;
884: BEGIN
885: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
886:
887: if (x_direct_load_profile) then
888: return MSD_COMMON_UTILITIES.LEVEL_ASSOC_FACT_TABLE ;
889: else

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

894:
895: Procedure Delete_duplicate(p_instance_id in number, p_dest_table in varchar2) is
896:
897: lb_FetchComplete BOOLEAN := FALSE;
898: ln_rows_to_fetch Number := nvl(TO_NUMBER(FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
899:
900: TYPE CharTblTyp IS TABLE OF VARCHAR2(240);
901: TYPE NumTblTyp IS TABLE OF NUMBER;
902:

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

1085: BEGIN
1086:
1087: /* 1 step collection */
1088: /* Bug# 4919130 - Always delete childless parents from staging table.
1089: IF (fnd_profile.value('MSD_ONE_STEP_COLLECTION') = 'Y') THEN
1090:
1091: l_dest_table := MSD_COMMON_UTILITIES.LEVEL_VALUES_FACT_TABLE;
1092:
1093: FOR Level_Rec IN c_level LOOP