8:
9: -- Function Complete_Record
10:
11: FUNCTION Complete_Record
12: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
13: , p_old_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
14: , p_ForceCopy IN BOOLEAN := NULL
15: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type
16: IS
9: -- Function Complete_Record
10:
11: FUNCTION Complete_Record
12: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
13: , p_old_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
14: , p_ForceCopy IN BOOLEAN := NULL
15: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type
16: IS
17: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type := p_RepSchedule_rec;
11: FUNCTION Complete_Record
12: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
13: , p_old_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
14: , p_ForceCopy IN BOOLEAN := NULL
15: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type
16: IS
17: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type := p_RepSchedule_rec;
18: BEGIN
19: IF(p_ForceCopy IS NOT NULL) THEN
13: , p_old_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
14: , p_ForceCopy IN BOOLEAN := NULL
15: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type
16: IS
17: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type := p_RepSchedule_rec;
18: BEGIN
19: IF(p_ForceCopy IS NOT NULL) THEN
20: IF(p_ForceCopy = TRUE)
21: THEN
509:
510: -- Function Convert_Miss_To_Null
511:
512: FUNCTION Convert_Miss_To_Null
513: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
514: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type
515: IS
516: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type := p_RepSchedule_rec;
517: BEGIN
510: -- Function Convert_Miss_To_Null
511:
512: FUNCTION Convert_Miss_To_Null
513: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
514: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type
515: IS
516: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type := p_RepSchedule_rec;
517: BEGIN
518:
512: FUNCTION Convert_Miss_To_Null
513: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
514: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type
515: IS
516: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type := p_RepSchedule_rec;
517: BEGIN
518:
519: IF l_RepSchedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
520: l_RepSchedule_rec.alternate_bom_designator := NULL;
762:
763: -- Procedure Update_Row
764:
765: PROCEDURE Update_Row
766: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
767: )
768: IS
769: BEGIN
770:
849:
850: -- Procedure Insert_Row
851:
852: PROCEDURE Insert_Row
853: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
854: )
855: IS
856: BEGIN
857:
1025: -- Function Query_Row
1026:
1027: FUNCTION Query_Row
1028: ( p_repetitive_schedule_id IN NUMBER
1029: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type
1030: IS
1031: BEGIN
1032:
1033: RETURN Query_Rows
1037: END Query_Row;
1038:
1039: FUNCTION Query_Row
1040: ( p_wip_entity_id IN NUMBER
1041: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type
1042: IS
1043: BEGIN
1044:
1045: RETURN Query_Rows
1056: ( p_repetitive_schedule_id IN NUMBER :=
1057: NULL
1058: , p_wip_entity_id IN NUMBER :=
1059: NULL
1060: ) RETURN WIP_Work_Order_PUB.Repschedule_Tbl_Type
1061: IS
1062: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type;
1063: l_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
1064:
1058: , p_wip_entity_id IN NUMBER :=
1059: NULL
1060: ) RETURN WIP_Work_Order_PUB.Repschedule_Tbl_Type
1061: IS
1062: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type;
1063: l_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
1064:
1065: CURSOR l_RepSchedule_csr IS
1066: SELECT ALTERNATE_BOM_DESIGNATOR
1059: NULL
1060: ) RETURN WIP_Work_Order_PUB.Repschedule_Tbl_Type
1061: IS
1062: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type;
1063: l_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;
1064:
1065: CURSOR l_RepSchedule_csr IS
1066: SELECT ALTERNATE_BOM_DESIGNATOR
1067: , ALTERNATE_ROUTING_DESIGNATOR
1263: --
1264:
1265: PROCEDURE Lock_Row
1266: ( x_return_status OUT NOCOPY VARCHAR2
1267: , p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
1268: , x_RepSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Rec_Type
1269: )
1270: IS
1271: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type;
1264:
1265: PROCEDURE Lock_Row
1266: ( x_return_status OUT NOCOPY VARCHAR2
1267: , p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
1268: , x_RepSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Rec_Type
1269: )
1270: IS
1271: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type;
1272: BEGIN
1267: , p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
1268: , x_RepSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Rec_Type
1269: )
1270: IS
1271: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type;
1272: BEGIN
1273:
1274: SELECT ALTERNATE_BOM_DESIGNATOR
1275: , ALTERNATE_ROUTING_DESIGNATOR
1582:
1583: END Lock_Row;
1584:
1585:
1586: FUNCTION Compare(p_RepSchedule_rec1 IN WIP_Work_Order_PUB.Repschedule_Rec_Type,
1587: p_RepSchedule_rec2 IN WIP_Work_Order_PUB.Repschedule_Rec_Type)
1588: RETURN BOOLEAN
1589: IS
1590: BEGIN
1583: END Lock_Row;
1584:
1585:
1586: FUNCTION Compare(p_RepSchedule_rec1 IN WIP_Work_Order_PUB.Repschedule_Rec_Type,
1587: p_RepSchedule_rec2 IN WIP_Work_Order_PUB.Repschedule_Rec_Type)
1588: RETURN BOOLEAN
1589: IS
1590: BEGIN
1591:
1714: END IF;
1715:
1716: END Compare;
1717:
1718: PROCEDURE dprintf(p_RepSchedule_rec IN WIP_Work_Order_PUB.RepSchedule_Rec_Type)
1719: IS
1720: BEGIN
1721:
1722: null;