DBA Data[Home] [Help]

APPS.WIP_FLOWSCHEDULE_UTIL dependencies on WIP_WORK_ORDER_PUB

Line 12: ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type

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

Line 13: , p_old_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type

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;

Line 15: ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type

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:

Line 17: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type := p_FlowSchedule_rec;

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

Line 577: ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type

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

Line 578: ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type

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:

Line 580: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type := p_FlowSchedule_rec;

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;

Line 862: ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type

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:

Line 958: ( p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type

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:

Line 1152: ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type

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

Line 1165: ) RETURN WIP_Work_Order_PUB.Flowschedule_Rec_Type

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

Line 1184: ) RETURN WIP_Work_Order_PUB.Flowschedule_Tbl_Type

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:

Line 1186: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;

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

Line 1187: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;

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

Line 1409: , p_FlowSchedule_rec IN WIP_Work_Order_PUB.Flowschedule_Rec_Type

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;

Line 1410: , x_FlowSchedule_rec OUT NOCOPY 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

Line 1413: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;

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

Line 1764: FUNCTION Compare( p_FlowSchedule_rec1 IN WIP_Work_Order_PUB.Flowschedule_Rec_Type,

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

Line 1765: p_FlowSchedule_rec2 IN WIP_Work_Order_PUB.Flowschedule_Rec_Type)

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:

Line 1914: PROCEDURE dprintf(p_FlowSchedule_rec IN WIP_Work_Order_PUB.FlowSchedule_Rec_Type)

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;