eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_OTHER_PULL dependencies on MSC_UTIL

Line 17: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;

13: v_temp_sql4 VARCHAR2(1000);
14: v_schedule_sql VARCHAR2(1000); /* Bug 2634435 */
15:
16: --NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
17: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
18:
19: PROCEDURE LOAD_SAFETY_STOCK IS
20: BEGIN
21:

Line 22: IF MSC_CL_PULL.SS_ENABLED= MSC_UTIL.SYS_YES THEN

18:
19: PROCEDURE LOAD_SAFETY_STOCK IS
20: BEGIN
21:
22: IF MSC_CL_PULL.SS_ENABLED= MSC_UTIL.SYS_YES THEN
23:
24: /* Added this piece of code for Safety stocks by Project/Task */
25: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
26: v_temp_sql := 'x.PROJECT_ID,x.TASK_ID,x.PLANNING_GROUP,';

Line 25: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

21:
22: IF MSC_CL_PULL.SS_ENABLED= MSC_UTIL.SYS_YES THEN
23:
24: /* Added this piece of code for Safety stocks by Project/Task */
25: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
26: v_temp_sql := 'x.PROJECT_ID,x.TASK_ID,x.PLANNING_GROUP,';
27: ELSE
28: v_temp_sql := ' NULL ,NULL,NULL ,';
29: END IF;

Line 56: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

52: ||' 2,'
53: ||' :v_refresh_id,'
54: ||' :v_instance_id'
55: ||' from MRP_AP_SAFETY_STOCKS_V'||MSC_CL_PULL.v_dblink||' x'
56: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
57: ||' AND (x.RN2>'||MSC_CL_PULL.v_lrn||')';
58: /*
59: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
60: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';

Line 81: IF (MSC_CL_PULL.v_schedule_flag = MSC_UTIL.G_MDS) THEN

77: MSC_CL_PULL.v_view_name := 'MRP_AP_DESIGNATORS_V';
78:
79: /* Bug 2634435 */
80:
81: IF (MSC_CL_PULL.v_schedule_flag = MSC_UTIL.G_MDS) THEN
82: v_schedule_sql := ' AND x.SCHEDULE_TYPE = 1 ';
83: ELSIF (MSC_CL_PULL.v_schedule_flag = MSC_UTIL.G_MPS) THEN
84: v_schedule_sql := ' AND x.SCHEDULE_TYPE = 2 ';
85: ELSIF (MSC_CL_PULL.v_schedule_flag = MSC_UTIL.G_BOTH) THEN

Line 83: ELSIF (MSC_CL_PULL.v_schedule_flag = MSC_UTIL.G_MPS) THEN

79: /* Bug 2634435 */
80:
81: IF (MSC_CL_PULL.v_schedule_flag = MSC_UTIL.G_MDS) THEN
82: v_schedule_sql := ' AND x.SCHEDULE_TYPE = 1 ';
83: ELSIF (MSC_CL_PULL.v_schedule_flag = MSC_UTIL.G_MPS) THEN
84: v_schedule_sql := ' AND x.SCHEDULE_TYPE = 2 ';
85: ELSIF (MSC_CL_PULL.v_schedule_flag = MSC_UTIL.G_BOTH) THEN
86: v_schedule_sql := ' ';
87: END IF;

Line 85: ELSIF (MSC_CL_PULL.v_schedule_flag = MSC_UTIL.G_BOTH) THEN

81: IF (MSC_CL_PULL.v_schedule_flag = MSC_UTIL.G_MDS) THEN
82: v_schedule_sql := ' AND x.SCHEDULE_TYPE = 1 ';
83: ELSIF (MSC_CL_PULL.v_schedule_flag = MSC_UTIL.G_MPS) THEN
84: v_schedule_sql := ' AND x.SCHEDULE_TYPE = 2 ';
85: ELSIF (MSC_CL_PULL.v_schedule_flag = MSC_UTIL.G_BOTH) THEN
86: v_schedule_sql := ' ';
87: END IF;
88:
89: v_sql_stmt:=

Line 120: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str||v_schedule_sql;

116: ||' 2,'
117: ||' :v_refresh_id,'
118: ||' :v_instance_id'
119: ||' from MRP_AP_DESIGNATORS_V'||MSC_CL_PULL.v_dblink||' x'
120: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str||v_schedule_sql;
121:
122: --||' AND x.RN1>'||MSC_CL_PULL.v_lrn;
123:
124: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 136: IF MSC_CL_PULL.SOURCING_ENABLED= MSC_UTIL.SYS_YES THEN

132:
133: PROCEDURE LOAD_SOURCING IS
134: BEGIN
135:
136: IF MSC_CL_PULL.SOURCING_ENABLED= MSC_UTIL.SYS_YES THEN
137:
138: MSC_CL_PULL.v_table_name:= 'MSC_ST_ASSIGNMENT_SETS';
139: MSC_CL_PULL.v_view_name := 'MRP_AP_ASSIGNMENT_SETS_V';
140:

Line 194: ||' substrb(x.CATEGORY_NAME,1,'||MSC_UTIL.G_ITEMCAT_LEN||'),' --12640878

190: ||' x.ORGANIZATION_ID,'
191: ||' :v_instance_id,'
192: ||' x.Customer_ID,'
193: ||' x.Ship_To_Site_ID,'
194: ||' substrb(x.CATEGORY_NAME,1,'||MSC_UTIL.G_ITEMCAT_LEN||'),' --12640878
195: ||' x.Category_Set_ID,'
196: ||' 2,'
197: ||' :v_refresh_id,'
198: ||' :v_instance_id'

Line 200: ||' WHERE (x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str

196: ||' 2,'
197: ||' :v_refresh_id,'
198: ||' :v_instance_id'
199: ||' from MRP_AP_SR_ASSIGNMENTS_V'||MSC_CL_PULL.v_dblink||' x'
200: ||' WHERE (x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str
201: ||' OR x.ORGANIZATION_ID IS NULL OR decode(x.assignment_type,3,x.organization_id,-1)=x.organization_id) '
202: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
203: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
204:

Line 236: ||' WHERE (x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str

232: ||' 2,'
233: ||' :v_refresh_id,'
234: ||' :v_instance_id'
235: ||' from MRP_AP_SOURCING_RULES_V'||MSC_CL_PULL.v_dblink||' x'
236: ||' WHERE (x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str
237: ||' OR x.ORGANIZATION_ID IS NULL)'
238: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;
239:
240: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 269: ||' WHERE (x.RECEIPT_ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str

265: ||' 2,'
266: ||' :v_refresh_id,'
267: ||' :v_instance_id'
268: ||' from MRP_AP_SR_RECEIPT_ORG_V'||MSC_CL_PULL.v_dblink||' x'
269: ||' WHERE (x.RECEIPT_ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str
270: ||' OR x.RECEIPT_ORGANIZATION_ID IS NULL)'
271: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;
272:
273: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 312: ||' WHERE (x.SOURCE_ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str

308: ||' 2,'
309: ||' :v_refresh_id,'
310: ||' :v_instance_id'
311: ||' from MRP_AP_SR_SOURCE_ORG_V'||MSC_CL_PULL.v_dblink||' x'
312: ||' WHERE (x.SOURCE_ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str
313: ||' OR x.SOURCE_ORGANIZATION_ID IS NULL)'
314: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;
315:
316: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 325: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

321:
322: MSC_CL_PULL.v_table_name:= 'MSC_ST_INTERORG_SHIP_METHODS';
323: MSC_CL_PULL.v_view_name := 'MRP_AP_INTERORG_SHIP_METHODS_V';
324:
325: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
326: v_temp_sql := ' x.TO_REGION_ID,x.FROM_REGION_ID,x.CURRENCY_CODE,x.SHIP_METHOD_TEXT,';
327: ELSE
328: v_temp_sql := 'NULL,NULL,NULL,';
329: END IF;

Line 393: ||' WHERE (x.FROM_ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str

389: ||' :v_refresh_id,'
390: ||' :v_instance_id,'
391: ||' :v_instance_id'
392: ||' FROM MRP_AP_INTERORG_SHIP_METHODS_V'||MSC_CL_PULL.v_dblink||' x'
393: ||' WHERE (x.FROM_ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str
394: ||' OR x.FROM_ORGANIZATION_ID IS NULL)'
395: ||' AND (x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str
396: ||' OR x.TO_ORGANIZATION_ID IS NULL)';
397:

Line 395: ||' AND (x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str

391: ||' :v_instance_id'
392: ||' FROM MRP_AP_INTERORG_SHIP_METHODS_V'||MSC_CL_PULL.v_dblink||' x'
393: ||' WHERE (x.FROM_ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str
394: ||' OR x.FROM_ORGANIZATION_ID IS NULL)'
395: ||' AND (x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str
396: ||' OR x.TO_ORGANIZATION_ID IS NULL)';
397:
398: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mso_trsp_penalty,
399: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_instance_id;

Line 404: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

400:
401: COMMIT;
402:
403:
404: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
405:
406: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
407: v_temp_tp_sql := NULL;
408: ELSE

Line 406: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

402:
403:
404: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
405:
406: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
407: v_temp_tp_sql := NULL;
408: ELSE
409: v_temp_tp_sql := ' WHERE x.LAST_UPDATE_DATE > SYSDATE - :v_msc_tp_coll_window';
410: END IF;

Line 617: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

613: ||' :v_refresh_id,'
614: ||' :v_instance_id'
615: ||' FROM MRP_AP_WSH_REGION_LOCATIONS_V'||MSC_CL_PULL.v_dblink||' x' || v_temp_tp_sql;
616:
617: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
618: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,MSC_CL_PULL.v_instance_id;
619: ELSE
620: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
621: END IF;

Line 620: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;

616:
617: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
618: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,MSC_CL_PULL.v_instance_id;
619: ELSE
620: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
621: END IF;
622:
623: COMMIT;
624:

Line 694: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN

690: BEGIN
691:
692: MSC_CL_PULL.v_view_name := 'MRP_AP_SUB_INVENTORIES_V';
693:
694: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
695: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN
696: MSC_CL_PULL.v_view_name := 'MRP_AP_SUB_INVENTORIES_NEW_V';
697: END IF;
698:

Line 695: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN

691:
692: MSC_CL_PULL.v_view_name := 'MRP_AP_SUB_INVENTORIES_V';
693:
694: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
695: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN
696: MSC_CL_PULL.v_view_name := 'MRP_AP_SUB_INVENTORIES_NEW_V';
697: END IF;
698:
699: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'MSC_UTIL.G_COLLECT_SRP_DATA = Yes');

Line 699: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'MSC_UTIL.G_COLLECT_SRP_DATA = Yes');

695: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN
696: MSC_CL_PULL.v_view_name := 'MRP_AP_SUB_INVENTORIES_NEW_V';
697: END IF;
698:
699: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'MSC_UTIL.G_COLLECT_SRP_DATA = Yes');
700: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUB_INVENTORIES';
701: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP VIew is ' || MSC_CL_PULL.v_view_name);
702:
703: v_sql_stmt:=

Line 701: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP VIew is ' || MSC_CL_PULL.v_view_name);

697: END IF;
698:
699: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'MSC_UTIL.G_COLLECT_SRP_DATA = Yes');
700: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUB_INVENTORIES';
701: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP VIew is ' || MSC_CL_PULL.v_view_name);
702:
703: v_sql_stmt:=
704: ' insert into MSC_ST_SUB_INVENTORIES'
705: ||' ( ORGANIZATION_ID,'

Line 738: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

734: ||' x.condition_type,'
735: ||' x.SR_RESOURCE_NAME,'
736: ||' x.SR_CUSTOMER_ACCT_ID'
737: ||' from ' ||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
738: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
739: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
740: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
741: else
742:

Line 774: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

770: ||' 2,'
771: ||' :v_refresh_id,'
772: ||' :v_instance_id'
773: ||' from MRP_AP_SUB_INVENTORIES_V'||MSC_CL_PULL.v_dblink||' x'
774: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
775: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
776: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
777:
778: end if;

Line 779: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP SQL stmt is ' || v_sql_stmt);

775: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
776: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
777:
778: end if;
779: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP SQL stmt is ' || v_sql_stmt);
780: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
781: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
782:
783: COMMIT;

Line 793: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN

789:
790: PROCEDURE LOAD_UNIT_NUMBER IS
791: BEGIN
792:
793: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
794:
795: MSC_CL_PULL.v_table_name:= 'MSC_ST_UNIT_NUMBERS';
796: MSC_CL_PULL.v_view_name := 'MRP_AP_UNIT_NUMBERS_V';
797:

Line 816: ||' WHERE x.MASTER_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

812: ||' 2,'
813: ||' :v_refresh_id,'
814: ||' :v_instance_id'
815: ||' from MRP_AP_Unit_Numbers_V'||MSC_CL_PULL.v_dblink||' x'
816: ||' WHERE x.MASTER_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
817: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
818: ||' x.RN2>'||MSC_CL_PULL.v_lrn||')';
819: --||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
820:

Line 877: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

873: ||' 2,'
874: ||' :v_refresh_id,'
875: ||' :v_instance_id'
876: ||' from MRP_AP_PROJECTS_V'||MSC_CL_PULL.v_dblink||' x'
877: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
878: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
879: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
880: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
881:

Line 919: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

915: ||' 2,'
916: ||' :v_refresh_id,'
917: ||' :v_instance_id'
918: ||' from MRP_AP_PROJECT_TASKS_V'||MSC_CL_PULL.v_dblink||' x'
919: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
920: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
921: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
922: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
923:

Line 980: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

976: ||' x.QUARTER_START_DATE,'
977: ||' :v_refresh_id,'
978: ||' :v_instance_id'
979: ||' FROM MRP_AP_BIS_PERIODS_V'||MSC_CL_PULL.v_dblink||' x'
980: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
981: ||' AND x.ADJUSTMENT_PERIOD_FLAG = ''N'' '; --svikas
982:
983:
984: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 1038: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1034: ||' x.QUARTER_START_DATE,'
1035: ||' :v_refresh_id,'
1036: ||' :v_instance_id'
1037: ||' FROM MRP_AP_BIS_PERIODS_V'||MSC_CL_PULL.v_dblink||' x'
1038: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1039: ||' AND x.ADJUSTMENT_PERIOD_FLAG = ''N'' '; --svikas
1040:
1041: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1042:

Line 1303: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1299: ||' x.QUARTER_START_DATE,'
1300: ||' :v_refresh_id,'
1301: ||' :v_instance_id'
1302: ||' FROM MRP_AP_BIS_PERIODS_V'||MSC_CL_PULL.v_dblink||' x'
1303: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1304: ||' AND x.ADJUSTMENT_PERIOD_FLAG = ''N'' '; --svikas
1305:
1306: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1307:

Line 1651: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

1647: ||' 2,'
1648: ||' :v_refresh_id,'
1649: ||' :v_instance_id'
1650: ||' FROM MRP_AP_PLANNERS_V'||MSC_CL_PULL.v_dblink||' x'
1651: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1652:
1653: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1654:
1655: COMMIT;

Line 1709: IF MSC_CL_PULL.TRIP_ENABLED= MSC_UTIL.SYS_YES AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

1705:
1706: PROCEDURE LOAD_TRIP IS
1707: BEGIN
1708:
1709: IF MSC_CL_PULL.TRIP_ENABLED= MSC_UTIL.SYS_YES AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1710:
1711: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1712:
1713: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRIPS';

Line 1834: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN -- complete refresh

1830:
1831: PROCEDURE LOAD_SALES_CHANNEL IS
1832: BEGIN
1833:
1834: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN -- complete refresh
1835: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Sales Channel');
1836:
1837: MSC_CL_PULL.v_table_name:= 'MSC_ST_SR_LOOKUPS';
1838: MSC_CL_PULL.v_view_name := 'MRP_AP_SALES_CHANNEL_V';

Line 1835: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Sales Channel');

1831: PROCEDURE LOAD_SALES_CHANNEL IS
1832: BEGIN
1833:
1834: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN -- complete refresh
1835: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Sales Channel');
1836:
1837: MSC_CL_PULL.v_table_name:= 'MSC_ST_SR_LOOKUPS';
1838: MSC_CL_PULL.v_view_name := 'MRP_AP_SALES_CHANNEL_V';
1839:

Line 1876: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN -- complete refresh

1872:
1873: PROCEDURE LOAD_FISCAL_CALENDAR IS
1874: BEGIN
1875:
1876: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN -- complete refresh
1877: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Fiscal Calendar');
1878:
1879: MSC_CL_PULL.v_table_name:= 'MSC_ST_CALENDAR_MONTHS';
1880: MSC_CL_PULL.v_view_name := 'MRP_AP_FISCAL_TIME_V';

Line 1877: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Fiscal Calendar');

1873: PROCEDURE LOAD_FISCAL_CALENDAR IS
1874: BEGIN
1875:
1876: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN -- complete refresh
1877: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Fiscal Calendar');
1878:
1879: MSC_CL_PULL.v_table_name:= 'MSC_ST_CALENDAR_MONTHS';
1880: MSC_CL_PULL.v_view_name := 'MRP_AP_FISCAL_TIME_V';
1881:

Line 1932: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN -- complete refresh

1928: -- for bug # 6469722
1929: PROCEDURE LOAD_CURRENCY_CONVERSION IS
1930: BEGIN
1931:
1932: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN -- complete refresh
1933: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Currency Conversion');
1934:
1935: MSC_CL_PULL.v_table_name:= 'MSC_ST_CURRENCY_CONVERSIONS';
1936: MSC_CL_PULL.v_view_name := 'MRP_AP_CURRENCY_CONV_V';

Line 1933: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Currency Conversion');

1929: PROCEDURE LOAD_CURRENCY_CONVERSION IS
1930: BEGIN
1931:
1932: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN -- complete refresh
1933: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Currency Conversion');
1934:
1935: MSC_CL_PULL.v_table_name:= 'MSC_ST_CURRENCY_CONVERSIONS';
1936: MSC_CL_PULL.v_view_name := 'MRP_AP_CURRENCY_CONV_V';
1937:

Line 1984: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 THEN -- complete refresh

1980:
1981: PROCEDURE LOAD_DELIVERY_DETAILS IS
1982: BEGIN
1983:
1984: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 THEN -- complete refresh
1985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Delivery Details');
1986:
1987: MSC_CL_PULL.v_table_name:= 'MSC_ST_DELIVERY_DETAILS';
1988: MSC_CL_PULL.v_view_name := 'MRP_AP_DELIVERY_DETAILS_V';

Line 1985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Delivery Details');

1981: PROCEDURE LOAD_DELIVERY_DETAILS IS
1982: BEGIN
1983:
1984: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 THEN -- complete refresh
1985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Delivery Details');
1986:
1987: MSC_CL_PULL.v_table_name:= 'MSC_ST_DELIVERY_DETAILS';
1988: MSC_CL_PULL.v_view_name := 'MRP_AP_DELIVERY_DETAILS_V';
1989:

Line 2061: ||' WHERE XY.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

2057: ||' XY.CREATION_DATE,'
2058: ||' XY.CREATED_BY,'
2059: ||' nvl(XY.LAST_UPDATE_LOGIN,1)'
2060: ||' FROM MRP_AP_DELIVERY_DETAILS_V' ||MSC_CL_PULL.v_dblink||' XY'
2061: ||' WHERE XY.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2062:
2063:
2064: EXECUTE IMMEDIATE v_sql_stmt
2065: USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;

Line 2081: IF MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y' THEN

2077: v_last_ibuc_coll_date DATE ;
2078:
2079: BEGIN
2080:
2081: IF MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y' THEN
2082: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2083: v_condition_sql := ' ' ; -- complete/TARGET refresh
2084:
2085: ELSIF MSC_CL_PULL.v_lrnn<> -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN

Line 2082: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN

2078:
2079: BEGIN
2080:
2081: IF MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y' THEN
2082: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2083: v_condition_sql := ' ' ; -- complete/TARGET refresh
2084:
2085: ELSIF MSC_CL_PULL.v_lrnn<> -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2086:

Line 2085: ELSIF MSC_CL_PULL.v_lrnn<> -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN

2081: IF MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y' THEN
2082: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2083: v_condition_sql := ' ' ; -- complete/TARGET refresh
2084:
2085: ELSIF MSC_CL_PULL.v_lrnn<> -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2086:
2087: lv_sql_stmt := 'SELECT LAST_IBUC_COLL_DATE FROM MSC_APPS_INSTANCES
2088: WHERE INSTANCE_ID= :v_instance_id';
2089: EXECUTE IMMEDIATE lv_sql_stmt INTO v_last_ibuc_coll_date

Line 2096: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading IB Contracts History');

2092: v_condition_sql := ' WHERE x.sample_date >= '||' :v_last_ibuc_coll_date' ; -- Net change
2093:
2094: END IF ;
2095:
2096: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading IB Contracts History');
2097: MSC_CL_PULL.v_table_name:= 'MSC_ST_ZN_AGGR_IBUC';
2098: MSC_CL_PULL.v_view_name := 'MSC_SR_ZN_AGGR_IBUC';
2099:
2100: v_sql_stmt:=

Line 2128: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt' ||v_sql_stmt);

2124: ||' x.CREATED_BY'
2125: ||' FROM MSC_SR_ZN_AGGR_IBUC'||MSC_CL_PULL.v_dblink ||' x'
2126: || v_condition_sql ;
2127:
2128: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt' ||v_sql_stmt);
2129:
2130: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2131: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id,MSC_CL_PULL.v_refresh_id;
2132:

Line 2130: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN

2126: || v_condition_sql ;
2127:
2128: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt' ||v_sql_stmt);
2129:
2130: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2131: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id,MSC_CL_PULL.v_refresh_id;
2132:
2133: ELSIF MSC_CL_PULL.v_lrnn<> -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2134:

Line 2133: ELSIF MSC_CL_PULL.v_lrnn<> -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN

2129:
2130: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2131: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id,MSC_CL_PULL.v_refresh_id;
2132:
2133: ELSIF MSC_CL_PULL.v_lrnn<> -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2134:
2135: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id,
2136: MSC_CL_PULL.v_refresh_id,trunc(v_last_ibuc_coll_date);
2137:

Line 2150: IF MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y' THEN

2146: is
2147:
2148: BEGIN
2149:
2150: IF MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y' THEN
2151: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2152:
2153:
2154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Attached Documents');

Line 2151: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN

2147:
2148: BEGIN
2149:
2150: IF MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y' THEN
2151: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2152:
2153:
2154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Attached Documents');
2155:

Line 2154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Attached Documents');

2150: IF MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y' THEN
2151: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2152:
2153:
2154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Attached Documents');
2155:
2156: MSC_CL_PULL.v_table_name:= 'MSC_ST_DOC_ATTACHMENTS';
2157: MSC_CL_PULL.v_view_name := 'MSC_AP_ATTACHED_DOCS_V';
2158:

Line 2252: IF MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y' THEN

2248: NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
2249: -- v_sql_stmt := null;
2250: BEGIN
2251:
2252: IF MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y' THEN
2253: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2254:
2255:
2256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Long text');

Line 2253: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN

2249: -- v_sql_stmt := null;
2250: BEGIN
2251:
2252: IF MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y' THEN
2253: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2254:
2255:
2256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Long text');
2257: MSC_CL_PULL.v_table_name:= 'MSC_ST_LONG_TEXT';

Line 2256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Long text');

2252: IF MSC_UTIL.G_COLLECT_SRP_PH2_ENABLE = 'Y' THEN
2253: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
2254:
2255:
2256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading Long text');
2257: MSC_CL_PULL.v_table_name:= 'MSC_ST_LONG_TEXT';
2258: MSC_CL_PULL.v_view_name := 'MSC_AP_LONG_TEXT_V'; --Changed the view name from MSC_AP_LONG_TEXT_V to MSC_AP_CLOB_TEXT_V w.r.t bug 13628509
2259:
2260: --Have below common code whether db link is NULL or not w.r.t bug 13628509

Line 2286: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Long Text sql stmt - ' || v_sql_stmt );

2282: ||' MLT.LAST_UPDATE_LOGIN'
2283: ||' FROM MSC_AP_CLOB_TEXT_V' ||MSC_CL_PULL.v_dblink||' MLT';
2284: --Using the view MSC_AP_CLOB_TEXT_V w.r.t bug 13628509
2285:
2286: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Long Text sql stmt - ' || v_sql_stmt );
2287: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2288: COMMIT;
2289:
2290: END IF;