8:
9: -- Function Complete_Record
10:
11: FUNCTION Complete_Record
12: ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
13: , p_old_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
14: , p_ForceCopy IN BOOLEAN := FALSE
15: ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type
16: IS
9: -- Function Complete_Record
10:
11: FUNCTION Complete_Record
12: ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
13: , p_old_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
14: , p_ForceCopy IN BOOLEAN := FALSE
15: ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type
16: IS
17: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type := p_FlowSchedule_rec;
11: FUNCTION Complete_Record
12: ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
13: , p_old_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
14: , p_ForceCopy IN BOOLEAN := FALSE
15: ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type
16: IS
17: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type := p_FlowSchedule_rec;
18: BEGIN
19:
13: , p_old_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
14: , p_ForceCopy IN BOOLEAN := FALSE
15: ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type
16: IS
17: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type := p_FlowSchedule_rec;
18: BEGIN
19:
20: IF p_ForceCopy = TRUE
21: THEN
573:
574: -- Function Convert_Miss_To_Null
575:
576: FUNCTION Convert_Miss_To_Null
577: ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
578: ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type
579: IS
580: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type := p_FlowSchedule_rec;
581: BEGIN
574: -- Function Convert_Miss_To_Null
575:
576: FUNCTION Convert_Miss_To_Null
577: ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
578: ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type
579: IS
580: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type := p_FlowSchedule_rec;
581: BEGIN
582:
576: FUNCTION Convert_Miss_To_Null
577: ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
578: ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type
579: IS
580: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type := p_FlowSchedule_rec;
581: BEGIN
582:
583: IF l_FlowSchedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
584: l_FlowSchedule_rec.alternate_bom_designator := NULL;
858:
859: -- Procedure Update_Row
860:
861: PROCEDURE Update_Row
862: ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
863: )
864: IS
865: BEGIN
866:
954:
955: -- Procedure Insert_Row
956:
957: PROCEDURE Insert_Row
958: ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
959: )
960: IS
961: BEGIN
962:
1148: -- Function Query_Row
1149:
1150: FUNCTION Query_Row
1151: ( p_schedule_number IN VARCHAR2
1152: ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type
1153: IS
1154: BEGIN
1155:
1156: RETURN Query_Rows
1161:
1162:
1163: FUNCTION Query_Row
1164: ( p_wip_entity_id IN NUMBER
1165: ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type
1166: IS
1167: BEGIN
1168:
1169: RETURN Query_Rows
1180: ( p_schedule_number IN VARCHAR2 :=
1181: FND_API.G_MISS_CHAR
1182: , p_wip_entity_id IN NUMBER :=
1183: FND_API.G_MISS_NUM
1184: ) RETURN WIP_Work_Order_PUB.Flowschedule_Tbl_Type
1185: IS
1186: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;
1187: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
1188:
1182: , p_wip_entity_id IN NUMBER :=
1183: FND_API.G_MISS_NUM
1184: ) RETURN WIP_Work_Order_PUB.Flowschedule_Tbl_Type
1185: IS
1186: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;
1187: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
1188:
1189: CURSOR l_FlowSchedule_csr IS
1190: SELECT ALTERNATE_BOM_DESIGNATOR
1183: FND_API.G_MISS_NUM
1184: ) RETURN WIP_Work_Order_PUB.Flowschedule_Tbl_Type
1185: IS
1186: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;
1187: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
1188:
1189: CURSOR l_FlowSchedule_csr IS
1190: SELECT ALTERNATE_BOM_DESIGNATOR
1191: , ALTERNATE_ROUTING_DESIGNATOR
1405: --
1406:
1407: PROCEDURE Lock_Row
1408: ( x_return_status OUT NOCOPY VARCHAR2
1409: , p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
1410: , x_FlowSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Rec_Type
1411: )
1412: IS
1413: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;
1406:
1407: PROCEDURE Lock_Row
1408: ( x_return_status OUT NOCOPY VARCHAR2
1409: , p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
1410: , x_FlowSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Rec_Type
1411: )
1412: IS
1413: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;
1414: BEGIN
1409: , p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type
1410: , x_FlowSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Flowschedule_Rec_Type
1411: )
1412: IS
1413: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;
1414: BEGIN
1415:
1416: SELECT ALTERNATE_BOM_DESIGNATOR
1417: , ALTERNATE_ROUTING_DESIGNATOR
1760:
1761: END Lock_Row;
1762:
1763:
1764: FUNCTION Compare( p_FlowSchedule_rec1 IN WIP_Work_Order_PUB.Flowschedule_Rec_Type,
1765: p_FlowSchedule_rec2 IN WIP_Work_Order_PUB.Flowschedule_Rec_Type)
1766: RETURN BOOLEAN
1767: IS
1768: BEGIN
1761: END Lock_Row;
1762:
1763:
1764: FUNCTION Compare( p_FlowSchedule_rec1 IN WIP_Work_Order_PUB.Flowschedule_Rec_Type,
1765: p_FlowSchedule_rec2 IN WIP_Work_Order_PUB.Flowschedule_Rec_Type)
1766: RETURN BOOLEAN
1767: IS
1768: BEGIN
1769:
1910: END IF;
1911:
1912: END Compare;
1913:
1914: PROCEDURE dprintf(p_FlowSchedule_rec IN WIP_Work_Order_PUB.FlowSchedule_Rec_Type)
1915: IS
1916: BEGIN
1917:
1918: null;