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_REL_PLAN_PUB dependencies on MSC_WIP_JOB_DTLS_INTERFACE

Line 2413: DELETE MSC_WIP_JOB_DTLS_INTERFACE

2409: /* IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN
2410: DELETE msc_wip_job_schedule_interface
2411: WHERE sr_instance_id= arg_org_instance;
2412:
2413: DELETE MSC_WIP_JOB_DTLS_INTERFACE
2414: WHERE sr_instance_id= arg_org_instance;
2415: END IF;
2416: */
2417: IF arg_loaded_reqs > 0 THEN

Line 2667: DELETE MSC_WIP_JOB_DTLS_INTERFACE

2663: DELETE msc_wip_job_schedule_interface
2664: WHERE sr_instance_id= arg_org_instance
2665: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2666:
2667: DELETE MSC_WIP_JOB_DTLS_INTERFACE
2668: WHERE sr_instance_id= arg_org_instance
2669: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2670:
2671:

Line 2690: DELETE MSC_WIP_JOB_DTLS_INTERFACE

2686: DELETE msc_wip_job_schedule_interface
2687: WHERE sr_instance_id= arg_org_instance
2688: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2689:
2690: DELETE MSC_WIP_JOB_DTLS_INTERFACE
2691: WHERE sr_instance_id= arg_org_instance
2692: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2693:
2694:

Line 4646: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4642: /* OPERATION NETWORKS */
4643:
4644:
4645: FORALL j IN 1..lv_job_count
4646: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4647: (last_update_date,
4648: last_updated_by,
4649: last_update_login,
4650: creation_date,

Line 4700: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4696:
4697: /* Operations */
4698:
4699: FORALL j IN 1..lv_job_count
4700: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4701: (last_update_date,
4702: last_updated_by,
4703: last_update_login,
4704: creation_date,

Line 4764: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4760: -- res.CUMMULATIVE_QUANTITY);
4761:
4762: /* Resources */
4763: FORALL j IN 1..lv_job_count
4764: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4765: (last_update_date,
4766: last_updated_by,
4767: last_update_login,
4768: creation_date,

Line 4870: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4866:
4867: /*Components*/
4868:
4869: FORALL j IN 1..lv_job_count
4870: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4871: (last_update_date,
4872: last_updated_by,
4873: last_update_login,
4874: creation_date,

Line 4968: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4964:
4965:
4966: /* Resource Usage */
4967: FORALL j IN 1..lv_job_count
4968: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4969: (last_update_date,
4970: last_updated_by,
4971: last_update_login,
4972: creation_date,

Line 5041: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5037: AND param.network_scheduling_method = 1);
5038:
5039: -- dsr begin: Operation Resource Instances
5040: FORALL j IN 1..lv_job_count
5041: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5042: ( last_update_date,
5043: last_updated_by,
5044: last_update_login,
5045: creation_date,

Line 5159: /*print_debug_info( 'Operation Resource Instances: rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = '

5155: AND param.network_scheduling_method = 1
5156: ;
5157:
5158:
5159: /*print_debug_info( 'Operation Resource Instances: rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = '
5160: || SQL%ROWCOUNT
5161: ); */
5162:
5163: -- dsr: RESOURCE INSTANCE USAGES

Line 5166: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5162:
5163: -- dsr: RESOURCE INSTANCE USAGES
5164:
5165: FORALL j IN 1..lv_job_count
5166: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5167: ( last_update_date,
5168: last_updated_by,
5169: last_update_login,
5170: creation_date,

Line 5277: /* print_debug_info( 'Resource Instance Usage: rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = '

5273: AND param.sr_instance_id = s.sr_instance_id
5274: AND param.network_scheduling_method = 1
5275: ;
5276:
5277: /* print_debug_info( 'Resource Instance Usage: rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = '
5278: || SQL%ROWCOUNT
5279: ); */
5280:
5281: -- dsr end

Line 5582: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5578: /* OPERATION NETWORKS */
5579:
5580:
5581: FORALL j IN 1..lv_resched_jobs
5582: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5583: (last_update_date,
5584: last_updated_by,
5585: last_update_login,
5586: creation_date,

Line 5638: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5634:
5635: /* Operations */
5636:
5637: FORALL j IN 1..lv_resched_jobs
5638: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5639: (last_update_date,
5640: last_updated_by,
5641: last_update_login,
5642: creation_date,

Line 5707: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5703: s.JOB_OP_SEQ_NUM);
5704:
5705: /* Resources */
5706: FORALL j IN 1..lv_resched_jobs
5707: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5708: (last_update_date,
5709: last_updated_by,
5710: last_update_login,
5711: creation_date,

Line 5815: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5811:
5812: /*Components*/
5813:
5814: FORALL j IN 1..lv_resched_jobs
5815: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5816: (last_update_date,
5817: last_updated_by,
5818: last_update_login,
5819: creation_date,

Line 5915: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5911:
5912:
5913: /* Resource Usage */
5914: FORALL j IN 1..lv_resched_jobs
5915: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5916: (last_update_date,
5917: last_updated_by,
5918: last_update_login,
5919: creation_date,

Line 5990: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5986:
5987: -- dsr begin: Operation Resource Instances
5988:
5989: FORALL j IN 1..lv_resched_jobs
5990: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5991: ( last_update_date,
5992: last_updated_by,
5993: last_update_login,
5994: creation_date,

Line 6110: /* print_debug_info('Resource Instance: rows inserted into msc_wip_job_dtls_interface = '

6106: AND param.sr_instance_id = s.sr_instance_id
6107: AND param.network_scheduling_method = 1
6108: ;
6109:
6110: /* print_debug_info('Resource Instance: rows inserted into msc_wip_job_dtls_interface = '
6111: || sql%rowcount); */
6112:
6113: FORALL j IN 1..lv_resched_jobs
6114: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

Line 6114: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

6110: /* print_debug_info('Resource Instance: rows inserted into msc_wip_job_dtls_interface = '
6111: || sql%rowcount); */
6112:
6113: FORALL j IN 1..lv_resched_jobs
6114: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
6115: ( last_update_date,
6116: last_updated_by,
6117: last_update_login,
6118: creation_date,

Line 6228: /* print_debug_info('Resource Instance Usage: rows inserted into msc_wip_job_dtls_interface = '

6224: AND param.sr_instance_id = s.sr_instance_id
6225: AND param.network_scheduling_method = 1
6226: ;
6227:
6228: /* print_debug_info('Resource Instance Usage: rows inserted into msc_wip_job_dtls_interface = '
6229: || sql%rowcount); */
6230:
6231:
6232: FORALL j IN 1..lv_resched_jobs

Line 6828: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

6824: are the same as the planned date and quantity */
6825:
6826: /* OPERATIONS */
6827: FORALL j IN 1..lv_job_count
6828: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
6829: (last_update_date,
6830: last_updated_by,
6831: last_update_login,
6832: creation_date,

Line 6936: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

6932: than apply the CY on new_order_qty. This logic to use cummulative_qty is added to remove the calc. errors */
6933:
6934: /* OPERATION RESOURCES */
6935: FORALL j IN 1..lv_job_count
6936: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
6937: ( last_update_date,
6938: last_updated_by,
6939: last_update_login,
6940: creation_date,

Line 7084: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

7080: /* UPDATE EXISTING COMPONENTS *
7081: | We should set inventory_item_id_new to NULL |
7082: * */
7083: FORALL j IN 1..lv_job_count
7084: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
7085: (last_update_date,
7086: last_updated_by,
7087: last_update_login,
7088: creation_date,

Line 7212: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

7208: AND lv_agg_details(j) = 1;
7209:
7210: --Loading Co-products/by-products for OPM orgs
7211: FORALL j IN 1..lv_job_count
7212: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
7213: (last_update_date,
7214: last_updated_by,
7215: last_update_login,
7216: creation_date,

Line 7321: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

7317:
7318: --DBMS_OUTPUT.PUT_LINE('LOAD SUBSTITUTE COMPONENTS');
7319: /* SUBSTITUTE EXISTING COMPONENTS */
7320: FORALL j IN 1..lv_job_count
7321: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
7322: (last_update_date,
7323: last_updated_by,
7324: last_update_login,
7325: creation_date,

Line 7452: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

7448:
7449:
7450: -- RESOURCE USAGE
7451: FORALL j IN 1..lv_job_count
7452: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
7453: ( last_update_date,
7454: last_updated_by,
7455: last_update_login,
7456: creation_date,

Line 7583: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

7579: -- print_debug_info('OPERATION RESOURCE_INSTANCES');
7580: -- OPERATION RESOURCE_INSTANCES
7581:
7582: FORALL j IN 1..lv_job_count
7583: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
7584: ( last_update_date,
7585: last_updated_by,
7586: last_update_login,
7587: creation_date,

Line 7698: -- print_debug_info('load_wip_discrete_jobs# rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = ' || SQL%ROWCOUNT);

7694: AND lv_details_enabled(j)= 1
7695: AND lv_agg_details(j) = 1
7696: ;
7697:
7698: -- print_debug_info('load_wip_discrete_jobs# rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = ' || SQL%ROWCOUNT);
7699: -- RESOURCE INSTANCE USAGES
7700: -- print_debug_info('RESOURCE INSTANCE USAGES ');
7701:
7702: FORALL j IN 1..lv_job_count

Line 7703: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

7699: -- RESOURCE INSTANCE USAGES
7700: -- print_debug_info('RESOURCE INSTANCE USAGES ');
7701:
7702: FORALL j IN 1..lv_job_count
7703: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
7704: ( last_update_date,
7705: last_updated_by,
7706: last_update_login,
7707: creation_date,

Line 7810: -- print_debug_info('load_wip_discrete_jobs# rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = ' || SQL%ROWCOUNT);

7806: AND lv_details_enabled(j)= 1
7807: AND lv_agg_details(j) = 1
7808: ;
7809:
7810: -- print_debug_info('load_wip_discrete_jobs# rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = ' || SQL%ROWCOUNT);
7811:
7812: -- Resource Charges
7813: -- print_debug_info('Resource Charges ');
7814:

Line 7816: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

7812: -- Resource Charges
7813: -- print_debug_info('Resource Charges ');
7814:
7815: FORALL j IN 1..lv_job_count
7816: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
7817: ( last_update_date,
7818: last_updated_by,
7819: last_update_login,
7820: creation_date,

Line 8348: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

8344: /* If it is not a drp plan then l_count = 1 by default so details will be released */
8345: IF l_count = 1 THEN /* Release details as well */
8346: -- OPERATIONS
8347: FORALL j IN 1..lv_job_count
8348: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
8349: (last_update_date,
8350: last_updated_by,
8351: last_update_login,
8352: creation_date,

Line 8457: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

8453: --DBMS_OUTPUT.PUT_LINE('OPERATION_RESOURCE');
8454:
8455: -- OPERATION RESOURCES
8456: FORALL j IN 1..lv_job_count
8457: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
8458: ( last_update_date,
8459: last_updated_by,
8460: last_update_login,
8461: creation_date,

Line 8594: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

8590: /* UPDATE EXISTING COMPONENTS *
8591: | We should set inventory_item_id_new to NULL |
8592: * */
8593: FORALL j IN 1..lv_job_count
8594: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
8595: (last_update_date,
8596: last_updated_by,
8597: last_update_login,
8598: creation_date,

Line 8733: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

8729:
8730: --Load Co-product/by-product component details
8731:
8732: FORALL j IN 1..lv_job_count
8733: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
8734: (last_update_date,
8735: last_updated_by,
8736: last_update_login,
8737: creation_date,

Line 8867: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

8863: --DBMS_OUTPUT.PUT_LINE('RESOURCE_USAGE');
8864:
8865: -- RESOURCE USAGE
8866: FORALL j IN 1..lv_job_count
8867: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
8868: ( last_update_date,
8869: last_updated_by,
8870: last_update_login,
8871: creation_date,

Line 8988: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

8984: -- print_debug_info('OPERATION RESOURCE_INSTANCES');
8985: -- OPERATION RESOURCE_INSTANCES
8986:
8987: FORALL j IN 1..lv_job_count
8988: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
8989: ( last_update_date,
8990: last_updated_by,
8991: last_update_login,
8992: creation_date,

Line 9111: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

9107:
9108: -- RESOURCE INSTANCE USAGES
9109: --print_debug_info('RESOURCE INSTANCE USAGES');
9110: FORALL j IN 1..lv_job_count
9111: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
9112: ( last_update_date,
9113: last_updated_by,
9114: last_update_login,
9115: creation_date,

Line 9231: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

9227:
9228: --print_debug_info('RESOURCE CHARGES');
9229:
9230: FORALL j IN 1..lv_job_count
9231: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
9232: ( last_update_date,
9233: last_updated_by,
9234: last_update_login,
9235: creation_date,

Line 11100: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

11096: /* If it is not a drp plan then l_count = 1 by default so details will be released */
11097: IF l_count = 1 THEN /* Release details as well */
11098: -- OPERATIONS
11099: FORALL j IN 1..lv_job_count
11100: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
11101: (last_update_date,
11102: last_updated_by,
11103: last_update_login,
11104: creation_date,

Line 11211: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

11207: --DBMS_OUTPUT.PUT_LINE('OPERATION_RESOURCE');
11208:
11209: -- OPERATION RESOURCES
11210: FORALL j IN 1..lv_job_count
11211: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
11212: ( last_update_date,
11213: last_updated_by,
11214: last_update_login,
11215: creation_date,

Line 11341: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

11337: /* UPDATE EXISTING COMPONENTS *
11338: | We should set inventory_item_id_new to NULL |
11339: * */
11340: FORALL j IN 1..lv_job_count
11341: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
11342: (last_update_date,
11343: last_updated_by,
11344: last_update_login,
11345: creation_date,

Line 11460: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

11456:
11457: --Load Co-product/by-product component details
11458:
11459: FORALL j IN 1..lv_job_count
11460: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
11461: (last_update_date,
11462: last_updated_by,
11463: last_update_login,
11464: creation_date,

Line 11574: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

11570:
11571:
11572: -- RESOURCE USAGE
11573: FORALL j IN 1..lv_job_count
11574: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
11575: ( last_update_date,
11576: last_updated_by,
11577: last_update_login,
11578: creation_date,

Line 11690: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

11686: -- print_debug_info('OPERATION RESOURCE_INSTANCES');
11687: -- OPERATION RESOURCE_INSTANCES
11688:
11689: FORALL j IN 1..lv_job_count
11690: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
11691: ( last_update_date,
11692: last_updated_by,
11693: last_update_login,
11694: creation_date,

Line 11815: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

11811:
11812: -- RESOURCE INSTANCE USAGES
11813: --print_debug_info('RESOURCE INSTANCE USAGES');
11814: FORALL j IN 1..lv_job_count
11815: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
11816: ( last_update_date,
11817: last_updated_by,
11818: last_update_login,
11819: creation_date,

Line 11937: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

11933:
11934: --print_debug_info('RESOURCE CHARGES');
11935:
11936: FORALL j IN 1..lv_job_count
11937: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
11938: ( last_update_date,
11939: last_updated_by,
11940: last_update_login,
11941: creation_date,

Line 12429: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

12425: /* If it is not a drp plan then l_count = 1 by default so details will be released */
12426: IF l_count = 1 THEN /* Release details as well */
12427: -- OPERATIONS
12428: FORALL j IN 1..lv_job_count
12429: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
12430: (last_update_date,
12431: last_updated_by,
12432: last_update_login,
12433: creation_date,

Line 12540: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

12536: --DBMS_OUTPUT.PUT_LINE('OPERATION_RESOURCE');
12537:
12538: -- OPERATION RESOURCES
12539: FORALL j IN 1..lv_job_count
12540: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
12541: ( last_update_date,
12542: last_updated_by,
12543: last_update_login,
12544: creation_date,

Line 12671: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

12667: /* UPDATE EXISTING COMPONENTS *
12668: | We should set inventory_item_id_new to NULL |
12669: * */
12670: FORALL j IN 1..lv_job_count
12671: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
12672: (last_update_date,
12673: last_updated_by,
12674: last_update_login,
12675: creation_date,

Line 12791: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

12787:
12788: --Load Co-product/by-product component details
12789:
12790: FORALL j IN 1..lv_job_count
12791: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
12792: (last_update_date,
12793: last_updated_by,
12794: last_update_login,
12795: creation_date,

Line 12905: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

12901:
12902:
12903: -- RESOURCE USAGE
12904: FORALL j IN 1..lv_job_count
12905: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
12906: ( last_update_date,
12907: last_updated_by,
12908: last_update_login,
12909: creation_date,

Line 13021: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

13017: -- print_debug_info('OPERATION RESOURCE_INSTANCES');
13018: -- OPERATION RESOURCE_INSTANCES
13019:
13020: FORALL j IN 1..lv_job_count
13021: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
13022: ( last_update_date,
13023: last_updated_by,
13024: last_update_login,
13025: creation_date,

Line 13146: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

13142:
13143: -- RESOURCE INSTANCE USAGES
13144: --print_debug_info('RESOURCE INSTANCE USAGES');
13145: FORALL j IN 1..lv_job_count
13146: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
13147: ( last_update_date,
13148: last_updated_by,
13149: last_update_login,
13150: creation_date,

Line 13268: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

13264:
13265: --print_debug_info('RESOURCE CHARGES');
13266:
13267: FORALL j IN 1..lv_job_count
13268: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
13269: ( last_update_date,
13270: last_updated_by,
13271: last_update_login,
13272: creation_date,

Line 13354: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

13350:
13351: /*Code to insert the subsitute component--new for USAF */
13352:
13353: FORALL j IN 1..lv_job_count
13354: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
13355: (last_update_date,
13356: last_updated_by,
13357: last_update_login,
13358: creation_date,

Line 13508: UPDATE MSC_WIP_JOB_DTLS_INTERFACE

13504: NULL;
13505: end;
13506: -- Then Update the details records
13507: begin
13508: UPDATE MSC_WIP_JOB_DTLS_INTERFACE
13509: SET
13510: start_date =
13511: trunc(start_date) + v_rp_time,
13512: completion_date =