DBA Data[Home] [Help]

APPS.MSC_LAUNCH_PLAN_PK dependencies on FND_REQUEST

Line 17: lvs_request_id := FND_REQUEST.SUBMIT_REQUEST(

13: l_dev_status varchar2(80);
14: l_message varchar2(2048);
15: BEGIN
16:
17: lvs_request_id := FND_REQUEST.SUBMIT_REQUEST(
18: 'MSC', -- application
19: 'MSCREFSN', -- program
20: NULL, -- description
21: NULL, -- start time

Line 708: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(

704: IF l_platform_type = 0 THEN
705: MSC_UTIL.msc_Debug('Launching Snapshot for 32 bit');
706: var_snapshot_req_id := NULL;
707: IF (arg_netchange_mode = SYS_NO) THEN
708: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
709: 'MSC', -- application
710: 'MSCNSP', -- program
711: NULL, -- description
712: NULL, -- start time

Line 723: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(

719: 1, -- Netchange_mode
720: p_snap_static_entities);
721:
722: ELSE
723: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
724: 'MSC', -- application
725: 'MSCNSP', -- program
726: NULL, -- description
727: NULL, -- start time

Line 743: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(

739: ELSIF l_platform_type = 1 THEN
740: MSC_UTIL.msc_Debug('Launching Snapshot for 64 bit Sun');
741: var_snapshot_req_id := NULL;
742: IF (arg_netchange_mode = SYS_NO) THEN
743: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
744: 'MSC', -- application
745: 'MSCNSPWS64', -- program
746: NULL, -- description
747: NULL, -- start time

Line 758: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(

754: 1, -- Netchange_mode
755: p_snap_static_entities);
756:
757: ELSE
758: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
759: 'MSC', -- application
760: 'MSCNSPWS64', -- program
761: NULL, -- description
762: NULL, -- start time

Line 777: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(

773: ELSIF l_platform_type = 2 THEN
774: MSC_UTIL.msc_Debug('Launching Snapshot for 64 bit HP');
775: var_snapshot_req_id := NULL;
776: IF (arg_netchange_mode = SYS_NO) THEN
777: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
778: 'MSC', -- application
779: 'MSCNSPWH64', -- program
780: NULL, -- description
781: NULL, -- start time

Line 792: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(

788: 1, -- Netchange_mode
789: p_snap_static_entities);
790:
791: ELSE
792: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
793: 'MSC', -- application
794: 'MSCNSPWH64', -- program
795: NULL, -- description
796: NULL, -- start time

Line 811: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(

807: ELSIF l_platform_type = 3 THEN
808: MSC_UTIL.msc_Debug('Launching Snapshot for 64 bit AIX');
809: var_snapshot_req_id := NULL;
810: IF (arg_netchange_mode = SYS_NO) THEN
811: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
812: 'MSC', -- application
813: 'MSCNSPWA64', -- program
814: NULL, -- description
815: NULL, -- start time

Line 826: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(

822: 1, -- Netchange_mode
823: p_snap_static_entities);
824:
825: ELSE
826: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
827: 'MSC', -- application
828: 'MSCNSPWA64', -- program
829: NULL, -- description
830: NULL, -- start time

Line 846: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(

842: ELSIF l_platform_type = 4 THEN
843: MSC_UTIL.msc_Debug('Launching Snapshot for Linux 64bit');
844: var_snapshot_req_id := NULL;
845: IF (arg_netchange_mode = SYS_NO) THEN
846: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
847: 'MSC', -- application
848: 'MSCNSPWL64', -- program
849: NULL, -- description
850: NULL, -- start time

Line 860: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(

856: 0, -- monitor_request_id
857: 1, -- Netchange_mode
858: p_snap_static_entities);
859: ELSE
860: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
861: 'MSC', -- application
862: 'MSCNSPWL64', -- program
863: NULL, -- description
864: NULL, -- start time

Line 880: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(

876: ELSIF l_platform_type = 5 THEN
877: MSC_UTIL.msc_Debug('Launching Snapshot for HP Itanium 64bit');
878: var_snapshot_req_id := NULL;
879: IF (arg_netchange_mode = SYS_NO) THEN
880: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
881: 'MSC', -- application
882: 'MSCNSPWHPIA64', -- program
883: NULL, -- description
884: NULL, -- start time

Line 894: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(

890: 0, -- monitor_request_id
891: 1, -- Netchange_mode
892: p_snap_static_entities);
893: ELSE
894: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
895: 'MSC', -- application
896: 'MSCNSPWHPIA64', -- program
897: NULL, -- description
898: NULL, -- start time

Line 914: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(

910: ELSIF l_platform_type = 6 THEN
911: MSC_UTIL.msc_Debug('Launching Snapshot for Z-Linux 64bit');
912: var_snapshot_req_id := NULL;
913: IF (arg_netchange_mode = SYS_NO) THEN
914: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
915: 'MSC', -- application
916: 'MSCNSPWZ64', -- program
917: NULL, -- description
918: NULL, -- start time

Line 928: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(

924: 0, -- monitor_request_id
925: 1, -- Netchange_mode
926: p_snap_static_entities);
927: ELSE
928: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST(
929: 'MSC', -- application
930: 'MSCNSPWZ64', -- program
931: NULL, -- description
932: NULL, -- start time

Line 984: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(

980: errbuf := 'Error checking installation status of MSO';
981: ELSE
982: IF l_status = 'I' THEN
983: IF l_platform_type = 0 THEN
984: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(
985: 'MSO', -- application
986: 'MSONEW', -- program
987: NULL, -- description
988: NULL, -- start time

Line 993: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(

989: FALSE, -- sub_request
990: v_plan_id,
991: 0);
992: ELSIF l_platform_type = 1 THEN
993: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(
994: 'MSO', -- application
995: 'MSONWS64', -- program
996: NULL, -- description
997: NULL, -- start time

Line 1002: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(

998: FALSE, -- sub_request
999: v_plan_id,
1000: 0);
1001: ELSIF l_platform_type = 2 THEN
1002: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(
1003: 'MSO', -- application
1004: 'MSONWH64', -- program
1005: NULL, -- description
1006: NULL, -- start time

Line 1011: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(

1007: FALSE, -- sub_request
1008: v_plan_id,
1009: 0);
1010: ELSIF l_platform_type = 3 THEN
1011: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(
1012: 'MSO', -- application
1013: 'MSONWA64', -- program
1014: NULL, -- description
1015: NULL, -- start time

Line 1020: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(

1016: FALSE, -- sub_request
1017: v_plan_id,
1018: 0);
1019: ELSIF l_platform_type = 4 THEN
1020: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(
1021: 'MSO', -- application
1022: 'MSONWL64', -- program
1023: NULL, -- description
1024: NULL, -- start time

Line 1029: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(

1025: FALSE, -- sub_request
1026: v_plan_id,
1027: 0);
1028: ELSIF l_platform_type = 5 THEN
1029: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(
1030: 'MSO', -- application
1031: 'MSONWHPIA64', -- program
1032: NULL, -- description
1033: NULL, -- start time

Line 1045: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(

1041: return;
1042: END IF;
1043: ELSE
1044: IF l_platform_type = 0 THEN
1045: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(
1046: 'MSC', -- application
1047: 'MSCNEW', -- program
1048: NULL, -- description
1049: NULL, -- start time

Line 1054: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(

1050: FALSE, -- sub_request
1051: v_plan_id,
1052: 0);
1053: ELSIF l_platform_type = 1 THEN
1054: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(
1055: 'MSC', -- application
1056: 'MSCNWS64', -- program
1057: NULL, -- description
1058: NULL, -- start time

Line 1063: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(

1059: FALSE, -- sub_request
1060: v_plan_id,
1061: 0);
1062: ELSIF l_platform_type = 2 THEN
1063: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(
1064: 'MSC', -- application
1065: 'MSCNWH64', -- program
1066: NULL, -- description
1067: NULL, -- start time

Line 1072: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(

1068: FALSE, -- sub_request
1069: v_plan_id,
1070: 0);
1071: ELSIF l_platform_type = 3 THEN
1072: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(
1073: 'MSC', -- application
1074: 'MSCNWA64', -- program
1075: NULL, -- description
1076: NULL, -- start time

Line 1082: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(

1078: v_plan_id,
1079: 0);
1080:
1081: ELSIF l_platform_type = 4 THEN
1082: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(
1083: 'MSC', -- application
1084: 'MSCNWL64', -- program
1085: NULL, -- description
1086: NULL, -- start time

Line 1091: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(

1087: FALSE, -- sub_request
1088: v_plan_id,
1089: 0);
1090: ELSIF l_platform_type = 5 THEN
1091: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST(
1092: 'MSC', -- application
1093: 'MSCNWHPIA64', -- program
1094: NULL, -- description
1095: NULL, -- start time

Line 1872: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST( 'MSC' -- application

1868: end if;
1869:
1870: IF (arg_launch_snapshot = SYS_YES) THEN
1871: var_snapshot_req_id := NULL;
1872: var_snapshot_req_id := FND_REQUEST.SUBMIT_REQUEST( 'MSC' -- application
1873: , 'MSCNSP' -- program
1874: , NULL -- description
1875: , NULL -- start time
1876: , FALSE -- sub_request

Line 1921: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST('MSO' -- application

1917: END CASE;
1918:
1919: MSC_UTIL.msc_Debug('Launched Program:'||l_executable_name);
1920:
1921: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST('MSO' -- application
1922: , l_executable_name
1923: , NULL -- description
1924: , NULL -- start time
1925: , FALSE -- sub_request

Line 1944: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST('MSO' -- application

1940: END CASE;
1941:
1942: MSC_UTIL.msc_Debug('Launched Program:'||l_executable_name);
1943:
1944: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST('MSO' -- application
1945: , l_executable_name
1946: , NULL -- description
1947: , NULL -- start time
1948: , FALSE -- sub_request

Line 1956: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST( 'MSC' -- application

1952: END IF;
1953:
1954: ELSE
1955: IF l_platform_type = 0 THEN
1956: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST( 'MSC' -- application
1957: , 'MSCNEW' -- program
1958: , NULL -- description
1959: , NULL -- start time
1960: , FALSE -- sub_request

Line 1965: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST( 'MSC' -- application

1961: , v_plan_id
1962: , 0
1963: );
1964: ELSIF l_platform_type = 1 THEN
1965: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST( 'MSC' -- application
1966: , 'MSCNWS64' -- program
1967: , NULL -- description
1968: , NULL -- start time
1969: , FALSE -- sub_request

Line 1974: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST( 'MSC' -- application

1970: , v_plan_id
1971: , 0
1972: );
1973: ELSIF l_platform_type = 2 THEN
1974: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST( 'MSC' -- application
1975: , 'MSCNWH64' -- program
1976: , NULL -- description
1977: , NULL -- start time
1978: , FALSE -- sub_request

Line 1982: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST( 'MSC' -- application

1978: , FALSE -- sub_request
1979: , v_plan_id
1980: , 0);
1981: ELSIF l_platform_type = 3 THEN
1982: var_planner_req_id := FND_REQUEST.SUBMIT_REQUEST( 'MSC' -- application
1983: , 'MSCNWA64' -- program
1984: , NULL -- description
1985: , NULL -- start time
1986: , FALSE -- sub_request

Line 2321: 3. Launch MBP Snaphsot by calling the fnd_request

2317: Logic for pl/sql program
2318: 1. Check if the plan row can be locked, if not wait for n attempts and error out.
2319: a. Lock the row with nowait, on successful lock, update the lateness_constraints to 1 or 0 based on the param.
2320: 2. Process_child_rp_plans
2321: 3. Launch MBP Snaphsot by calling the fnd_request
2322:
2323: --MSC_LAUNCH_PLAN_PK.MSC_LAUNCH_PLAN(out_char,out_num,'AJ-MASTC',18553,1,1,2,to_char(sysdate,'yyyy-mm-dd'));
2324: */
2325: