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_SETUP_PULL dependencies on MSC_UTIL

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

13: v_temp_sql4 VARCHAR2(1000);
14: v_rounding_Sql varchar2(1000);
15:
16: -- NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
17: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
18: v_gmp_routine_name VARCHAR2(50);
19: GMP_ERROR EXCEPTION;
20:
21: --==================================================================

Line 71: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN --when not net collection

67: END IF;
68:
69:
70:
71: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN --when not net collection
72:
73:
74: MSC_CL_PULL.v_table_name:= 'MSC_ST_CALENDAR_ASSIGNMENTS';
75: MSC_CL_PULL.v_view_name := 'MRP_AP_CAL_ASSIGNMENTS_V';

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

252:
253: Begin
254:
255:
256: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
257: v_temp_sql:= 'x.capacity_units , ' ;
258: ELSE
259: v_temp_sql:=' NULL, ' ;
260: END IF ;

Line 283: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str

279: || v_temp_sql
280: ||' :v_refresh_id,'
281: ||' :v_instance_id'
282: ||' FROM MRP_AP_RESOURCE_SHIFTS_V'||MSC_CL_PULL.v_dblink||' x'
283: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str
284: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn
285: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
286:
287: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

461: -- =============================== NETCHAGE OF DELETE ======================
462:
463: /* ds change start */
464:
465: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
466: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
467: MSC_CL_PULL.v_table_name:= 'MSC_ST_RES_INSTANCE_CHANGES';
468: MSC_CL_PULL.v_view_name := 'MRP_AD_RES_INST_CHANGES_V';
469: v_sql_stmt:=

Line 503: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: res_instance change sql = '||v_sql_stmt);

499: ||' :v_instance_id'
500: ||' FROM MRP_AD_RES_INST_CHANGES_V'||MSC_CL_PULL.v_dblink||' x'
501: ||' WHERE x.RN >' ||MSC_CL_PULL.v_lrn;
502:
503: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: res_instance change sql = '||v_sql_stmt);
504: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
505:
506: COMMIT;
507:

Line 553: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: res_instance changes sql = '||v_sql_stmt);

549: ||' FROM MRP_AP_RES_INST_CHANGES_V' ||MSC_CL_PULL.v_dblink ||' x'
550: ||' WHERE x.RN1>' ||MSC_CL_PULL.v_lrn
551: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn;
552:
553: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: res_instance changes sql = '||v_sql_stmt);
554: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
555: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_RES_INST_CHANGES_V='|| SQL%ROWCOUNT);
556:
557: COMMIT;

Line 555: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_RES_INST_CHANGES_V='|| SQL%ROWCOUNT);

551: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn;
552:
553: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: res_instance changes sql = '||v_sql_stmt);
554: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
555: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_RES_INST_CHANGES_V='|| SQL%ROWCOUNT);
556:
557: COMMIT;
558: END IF; /* MSC_CL_PULL.v_lrnn= -1 */
559:

Line 560: END IF; /* MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 */

556:
557: COMMIT;
558: END IF; /* MSC_CL_PULL.v_lrnn= -1 */
559:
560: END IF; /* MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 */
561:
562: END LOAD_CALENDAR_DATE;
563:
564:

Line 573: --IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN /* PREPLACE START */

569: BEGIN
570:
571:
572: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
573: --IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN /* PREPLACE START */
574:
575: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARTNER_CONTACTS';
576: MSC_CL_PULL.v_view_name := 'MRP_AP_BUYER_CONTACTS_V';
577:

Line 604: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str;

600: ||' 2,'
601: ||' :v_refresh_id,'
602: ||' :v_instance_id'
603: ||' FROM MRP_AP_BUYER_CONTACTS_V'||MSC_CL_PULL.v_dblink||' x'
604: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str;
605:
606: EXECUTE IMMEDIATE v_sql_stmt
607: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
608:

Line 638: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

634: lv_profile_inherit_op_seq := 2;
635:
636: END ;
637:
638: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
639: v_temp_tp_sql := NULL;
640: ELSE
641: v_temp_tp_sql := ' AND x.LAST_UPDATE_DATE > SYSDATE - :v_msc_tp_coll_window';
642: END IF;

Line 644: IF MSC_CL_PULL.VENDOR_ENABLED= MSC_UTIL.SYS_YES THEN

640: ELSE
641: v_temp_tp_sql := ' AND x.LAST_UPDATE_DATE > SYSDATE - :v_msc_tp_coll_window';
642: END IF;
643:
644: IF MSC_CL_PULL.VENDOR_ENABLED= MSC_UTIL.SYS_YES THEN
645:
646: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';
647: MSC_CL_PULL.v_view_name := 'MRP_AP_VENDORS_V';
648:

Line 672: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

668: ||' from MRP_AP_VENDORS_V'||MSC_CL_PULL.v_dblink||' x'
669: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
670: ||v_temp_tp_sql;
671:
672: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
673: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
674: ELSE
675: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
676: END IF;

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

671:
672: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
673: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
674: ELSE
675: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
676: END IF;
677:
678: COMMIT;
679:

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

680: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';
681: MSC_CL_PULL.v_view_name := 'MRP_AP_VENDOR_SITES_V';
682:
683: /* for bug: 2459612, added code to collect OPERATING_UNIT from Vendor sites for 11i source instance */
684: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
685: v_temp_sql := ' x.OPERATING_UNIT,x.shipping_control, ';
686: ELSE
687: v_temp_sql := ' NULL,NULL,';
688: END IF;

Line 748: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

744: ||' WHERE (x.RN1>'||MSC_CL_PULL.v_lrn
745: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')'
746: ||v_temp_tp_sql;
747:
748: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
749: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
750: ELSE
751: 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;
752: END IF;

Line 751: 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;

747:
748: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
749: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
750: ELSE
751: 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;
752: END IF;
753:
754: COMMIT;
755:

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

754: COMMIT;
755:
756: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
757:
758: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
759: v_temp_sql := 'x.ORGANIZATION_ID, ';
760: ELSE
761: v_temp_sql := ' NULL, ';
762: END IF;

Line 832: IF MSC_CL_PULL.CUSTOMER_ENABLED= MSC_UTIL.SYS_YES THEN

828:
829: END IF; -- MSC_CL_PULL.VENDOR_ENABLED
830:
831:
832: IF MSC_CL_PULL.CUSTOMER_ENABLED= MSC_UTIL.SYS_YES THEN
833:
834: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';
835: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMERS_V';
836:

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

835: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMERS_V';
836:
837: BEGIN
838:
839: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
840: v_temp_sql2 := ' x.AGGREGATE_DEMAND_FLAG, ';
841: ELSE
842: v_temp_sql2 := ' NULL,';
843: END IF;

Line 844: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS107 THEN

840: v_temp_sql2 := ' x.AGGREGATE_DEMAND_FLAG, ';
841: ELSE
842: v_temp_sql2 := ' NULL,';
843: END IF;
844: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS107 THEN
845: v_temp_sql1 := ' NULL,';
846: ELSE
847: v_temp_sql1 := ' x.CUSTOMER_CLASS_CODE,';
848: END IF;

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

847: v_temp_sql1 := ' x.CUSTOMER_CLASS_CODE,';
848: END IF;
849:
850: ------ ===== # SRP Changes ======
851: IF (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
852: v_temp_sql2 := v_temp_sql2||' x.RESOURCE_TYPE, ';
853: ELSE
854: v_temp_sql2 := v_temp_sql2||' NULL,';
855: END IF;

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

853: ELSE
854: v_temp_sql2 := v_temp_sql2||' NULL,';
855: END IF;
856:
857: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
858: v_temp_sql2 := v_temp_sql2 || ' x.customer_type, x.CUST_ACCOUNT_NUMBER, ';
859: ELSE
860: v_temp_sql2 := v_temp_sql2 || ' NULL, NULL, ';
861: END IF;

Line 895: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

891: ||' from MRP_AP_CUSTOMERS_V'||MSC_CL_PULL.v_dblink||' x'
892: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
893: ||v_temp_tp_sql;
894:
895: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
896: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
897: ELSE
898: 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;
899: END IF;

Line 898: 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;

894:
895: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
896: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
897: ELSE
898: 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;
899: END IF;
900:
901: COMMIT;
902:

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

902:
903: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';
904: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMER_SITES_V';
905:
906: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
907: v_temp_sql := ' x.POSTAL_CODE, x.CITY, x.STATE, x.COUNTRY,x.LOCATION_ID,x.SHIPPING_CONTROL, ';
908: ELSE
909: v_temp_sql := ' NULL,NULL,NULL,NULL,NULL,NULL, ';
910: END IF;

Line 971: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

967: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
968: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')'
969: ||v_temp_tp_sql;
970:
971: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
972: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
973: ELSE
974: 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;
975: END IF;

Line 974: 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;

970:
971: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
972: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
973: ELSE
974: 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;
975: END IF;
976:
977: COMMIT;
978:

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

977: COMMIT;
978:
979: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
980:
981: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
982: v_temp_sql := 'x.ORGANIZATION_ID, ';
983: ELSE
984: v_temp_sql := ' NULL, ';
985: END IF;

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

1053:
1054: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';
1055: MSC_CL_PULL.v_view_name := 'MRP_AP_ORGANIZATIONS_V';
1056:
1057: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1058: v_temp_sql:= 'x.BUSINESS_GROUP_ID,x.LEGAL_ENTITY, x.SET_OF_BOOKS_ID, x.CHART_OF_ACCOUNTS_ID, x.BUSINESS_GROUP_NAME,x.LEGAL_ENTITY_NAME, x.OPERATING_UNIT_NAME, ';
1059: ELSE
1060: v_temp_sql := 'NULL,NULL,NULL,NULL,NULL,NULL,NULL,';
1061: END IF;

Line 1207: ||' AND x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str

1203: ||' :v_instance_id,'
1204: ||' :lv_profile_inherit_op_seq'
1205: ||' from MRP_AP_ORGANIZATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1206: ||' where NVL( x.LANGUAGE, :v_lang)= :v_lang'
1207: ||' AND x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str
1208: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn
1209: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1210: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1211:

Line 1276: ||' WHERE x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str

1272: ||' 2,'
1273: ||' :v_refresh_id,'
1274: ||' :v_instance_id'
1275: ||' from MRP_AP_ORGANIZATION_SITES_V'||MSC_CL_PULL.v_dblink||' x'
1276: ||' WHERE x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str
1277: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1278: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1279: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1280:

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

1284:
1285: /* added this fix for bug # 2198339 to collect location associations for the Orgs */
1286: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete,targeted refresh
1287:
1288: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1289: v_temp_sql := 'x.ORGANIZATION_ID, ';
1290: ELSE
1291: v_temp_sql := ' NULL, ';
1292: END IF;

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

1388: ||' 2,'
1389: ||' :v_refresh_id,'
1390: ||' :v_instance_id'
1391: ||' from MRP_AP_PARAMETERS_V'||MSC_CL_PULL.v_dblink||' x'
1392: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1393:
1394: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1395:
1396: COMMIT;

Line 1407: IF MSC_CL_PULL.UOM_ENABLED= MSC_UTIL.SYS_YES THEN

1403:
1404: PROCEDURE LOAD_UOM IS
1405: BEGIN
1406:
1407: IF MSC_CL_PULL.UOM_ENABLED= MSC_UTIL.SYS_YES THEN
1408:
1409: MSC_CL_PULL.v_table_name:= 'MSC_ST_UNITS_OF_MEASURE';
1410: MSC_CL_PULL.v_view_name := 'MRP_AP_UNITS_OF_MEASURE_V';
1411: