APPS.MSC_X_CUST_FACING_RELEASE dependencies on MSC_SO_RELEASE_INTERFACE

Line 398: delete msc_so_release_interface

394: BEGIN
395:
396: /* delete from the interface table */
397:
398: delete msc_so_release_interface
399: where release_id = lv_delete_release_id;
400:
401: commit;
402:

Line 782: UPDATE MSC_SO_RELEASE_INTERFACE

778: lv_atp_override := 'Y';
779: lv_action := G_UPDATE;
780: lv_rel_id := l_release_id;
781:
782: UPDATE MSC_SO_RELEASE_INTERFACE
783: SET action = lv_action,
784: atp_override = 'Y'
785: WHERE release_id = lv_rel_id;
786:

Line 811: insert into MSC_SO_RELEASE_INTERFACE(

807:
808: /* Consigned CVMI Enh : Bug # 4247230 : Insert [ Order Number or Line Number or Release Number or
809: End Order Number or End Order Line Number or End Order Release Number] also */
810:
811: insert into MSC_SO_RELEASE_INTERFACE(
812: RELEASE_ID ,
813: SR_INSTANCE_ID ,
814: SR_CUSTOMER_ID ,
815: SR_CUSTOMER_SITE_ID ,

Line 865: log_debug('Inserted into msc_so_release_interface: ' || lv_rel_id );

861:
862: log_debug('VMI transaction Type (3-Cons. Advice,2-ATP override,1-Replenish) : ' || l_transaction_type );
863: log_debug('ATP override flag = : ' || lv_atp_override );
864: log_debug('Action(1-create, 2-update) : ' || lv_action );
865: log_debug('Inserted into msc_so_release_interface: ' || lv_rel_id );
866:
867: SELECT DECODE(apps.m2a_dblink
868: ,NULL,' '
869: ,'@' || m2a_dblink),

Line 937: from msc_so_release_interface

933:
934: select substr('Request Id '||lv_sr_req_id||' failed on the Source instance. Error Message:'
935: ||ERROR_MESSAGE,1,1000)
936: INTO lv_error_message
937: from msc_so_release_interface
938: where RELEASE_ID = lv_rel_id;
939:
940: ELSE
941: lv_return_status := G_SUCCESSFUL;

Line 961: from msc_so_release_interface

957: lv_schedule_ship_date,
958: lv_schedule_arrival_date,
959: lv_schedule_date_change,
960: lv_error_message
961: from msc_so_release_interface
962: where RELEASE_ID = lv_rel_id;
963:
964: END IF;
965:

Line 1011: update msc_so_release_interface

1007: /* update the interface table with Line Id
1008: and Header Id of the Sales order created.
1009: This information is required for updating the Sales Order
1010: if planner overrides ATP schedule date */
1011: update msc_so_release_interface
1012: set oe_header_id = lv_header_id,
1013: oe_line_id = lv_line_id
1014: where release_id = lv_rel_id;
1015:

Line 1074: update msc_so_release_interface

1070:
1071: ---- send notification to planner with the error message
1072:
1073: /* update the interface table with error message */
1074: update msc_so_release_interface
1075: set error_message = lv_error_message
1076: where release_id = lv_rel_id;
1077:
1078: /* set the Release_id attribute to system-generated sequence */

Line 1169: lv_sql_stmt := 'update msc_so_release_interface'||dest_dblink

1165: OUT lv_error_message;
1166:
1167: log_message(' after call MSC_X_VMI_POREQ.LD_SO_RELEASE_INTERFACE in the source') ;
1168:
1169: lv_sql_stmt := 'update msc_so_release_interface'||dest_dblink
1170: ||' set return_status = :lv_return_status, '
1171: ||' OE_HEADER_ID = :lv_header_id, '
1172: ||' OE_LINE_ID = :lv_line_id, '
1173: ||' sales_order_number = :lv_sales_order_number, '

Line 1195: log_message(' after update msc_so_release_interface in destination ') ;

1191: lv_error_message,
1192: lv_instance_id,
1193: pRelease_ID;
1194:
1195: log_message(' after update msc_so_release_interface in destination ') ;
1196:
1197: IF (lv_return_status = G_ERROR) then
1198: RETCODE := G_ERROR;
1199: ELSE