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 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 692: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' and MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN

688:
689: PROCEDURE LOAD_SUB_INVENTORY IS
690: BEGIN
691:
692: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' and MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
693:
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'MSC_UTIL.G_COLLECT_SRP_DATA = Yes');
695: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUB_INVENTORIES';
696: MSC_CL_PULL.v_view_name := 'MRP_AP_SUB_INVENTORIES_NEW_V';

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

690: BEGIN
691:
692: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' and MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
693:
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'MSC_UTIL.G_COLLECT_SRP_DATA = Yes');
695: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUB_INVENTORIES';
696: MSC_CL_PULL.v_view_name := 'MRP_AP_SUB_INVENTORIES_NEW_V';
697:
698: v_sql_stmt:=

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

729: ||' x.condition_type,'
730: ||' x.SR_RESOURCE_NAME,'
731: ||' x.SR_CUSTOMER_ACCT_ID'
732: ||' from MRP_AP_SUB_INVENTORIES_NEW_V'||MSC_CL_PULL.v_dblink||' x'
733: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
734: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
735: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
736: else
737:

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

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

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

785:
786: PROCEDURE LOAD_UNIT_NUMBER IS
787: BEGIN
788:
789: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
790:
791: MSC_CL_PULL.v_table_name:= 'MSC_ST_UNIT_NUMBERS';
792: MSC_CL_PULL.v_view_name := 'MRP_AP_UNIT_NUMBERS_V';
793:

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

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

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

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

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

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

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

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

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

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

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

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

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

1643: ||' 2,'
1644: ||' :v_refresh_id,'
1645: ||' :v_instance_id'
1646: ||' FROM MRP_AP_PLANNERS_V'||MSC_CL_PULL.v_dblink||' x'
1647: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1648:
1649: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1650:
1651: COMMIT;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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