APPS.MRP_RESCHEDULE_CMRO_WO_PS dependencies on AHL_MATERIALS_GRP

Line 480: l_alt_item_tbl AHL_MATERIALS_GRP.Alt_Item_Tbl_Type;

476: l_x_msg_data_ahl2 VARCHAR2(1000);
477: l_x_msg_count_ahl2 NUMBER;
478: Cur_wo_items CurTyp;
479: lv_sql_stmt VARCHAR2(1000);
480: l_alt_item_tbl AHL_MATERIALS_GRP.Alt_Item_Tbl_Type;
481: BEGIN
482:
483: var_proc := 'Process_Single_WO' ;
484:

Line 984: ' AHL_MATERIALS_GRP.UPDATE_WO_MATERIALS'||

980: var_buf := 'Group ID : '||g_group_id;
981:
982: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
983: 'Calling API '||
984: ' AHL_MATERIALS_GRP.UPDATE_WO_MATERIALS'||
985: 'with wip_entity_id ='||V_WIP_ENTITY_ID);
986:
987: log_output(' '||rpad(L_X_EAM_WO_TBL(1).WIP_ENTITY_NAME, 20)||' '||
988: to_char(L_X_EAM_WO_TBL(1).SCHEDULED_START_DATE, 'DD-MON-YYYY hh24:mi:ss') || ' '||

Line 1020: AHL_MATERIALS_GRP.UPDATE_WO_MATERIALS

1016: CLOSE Cur_wo_items;
1017:
1018: FND_MSG_PUB.initialize;
1019: /*new api -- UPDATE_WO_MATERIALS*/
1020: AHL_MATERIALS_GRP.UPDATE_WO_MATERIALS
1021: (
1022: p_api_version => 1.0,
1023: p_init_msg_list => FND_API.G_FALSE,
1024: p_commit => FND_API.G_FALSE,

Line 1035: ' AHL_MATERIALS_GRP.UPDATE_WO_MATERIALS'||

1031:
1032: IF(l_x_return_status_ahl2 = FND_API.G_RET_STS_SUCCESS)
1033: THEN
1034: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1035: ' AHL_MATERIALS_GRP.UPDATE_WO_MATERIALS'||
1036: ' returns SUCCESS ');
1037: FOR i IN 1..l_x_msg_count_ahl2 LOOP
1038: FND_MSG_PUB.get (
1039: p_msg_index => i,

Line 1048: 'AHL_MATERIALS_GRP.UPDATE_WO_MATERIALS '||

1044: SubStr('x_msg_data2 = '||l_x_msg_data_ahl2,1,255));
1045: END LOOP;
1046: ELSE
1047: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1048: 'AHL_MATERIALS_GRP.UPDATE_WO_MATERIALS '||
1049: 'FAILED');
1050: FOR i IN 1..l_x_msg_count_ahl2 LOOP
1051: FND_MSG_PUB.get (
1052: p_msg_index => i,