APPS.MRP_RELEASE_SO dependencies on OE_SCHEDULE_GRP

Line 19: p_so_table OE_SCHEDULE_GRP.Sch_Tbl_Type;

15: sql_stmt varchar2(2000);
16: x_return_status varchar2(1) :=FND_API.G_RET_STS_SUCCESS;
17: x_crm_return_status varchar2(1) :=FND_API.G_RET_STS_SUCCESS;
18: a number;
19: p_so_table OE_SCHEDULE_GRP.Sch_Tbl_Type;
20: p_crm_so_table AHL_LTP_ASCP_ORDERS_PVT.Sched_Orders_Tbl;
21:
22: CURSOR line_c(p_line_id number) is
23: select header_id, top_model_line_id,org_id, item_type_code,

Line 86: PROCEDURE show_so_details(p_so_table OE_SCHEDULE_GRP.Sch_Tbl_Type , a number) IS

82: p_latest_date_index number;
83: p_isSMC_PTO boolean;
84: currIndex number;
85:
86: PROCEDURE show_so_details(p_so_table OE_SCHEDULE_GRP.Sch_Tbl_Type , a number) IS
87: BEGIN
88: FND_FILE.PUT_LINE(FND_FILE.LOG,'rec ='||a);
89: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_ship_date='||to_char(p_so_table(a).schedule_ship_date,'MM-DD-RRRR HH24:MI:SS'));
90: FND_FILE.PUT_LINE(FND_FILE.LOG,'schedule_arrival_date='||to_char(p_so_table(a).schedule_arrival_date,'MM-DD-RRRR HH24:MI:SS'));

Line 123: FUNCTION reGroup RETURN OE_SCHEDULE_GRP.Sch_Tbl_Type IS

119: EXCEPTION WHEN OTHERS THEN
120: raise;
121: END isSOIncluded;
122:
123: FUNCTION reGroup RETURN OE_SCHEDULE_GRP.Sch_Tbl_Type IS
124:
125: p_so_table_new OE_SCHEDULE_GRP.Sch_Tbl_Type;
126: cursor so_cursor is
127: select

Line 125: p_so_table_new OE_SCHEDULE_GRP.Sch_Tbl_Type;

121: END isSOIncluded;
122:
123: FUNCTION reGroup RETURN OE_SCHEDULE_GRP.Sch_Tbl_Type IS
124:
125: p_so_table_new OE_SCHEDULE_GRP.Sch_Tbl_Type;
126: cursor so_cursor is
127: select
128: date1, --schedule_ship_date,
129: date2, --schedule_arrival_date,

Line 574: OE_SCHEDULE_GRP.Update_Scheduling_Results(

570: p_so_table := reGroup;
571: end if;
572:
573: mo_global.init('ONT');
574: OE_SCHEDULE_GRP.Update_Scheduling_Results(
575: p_so_table,
576: p_batch_id,
577: x_return_status);
578: commit;