DBA Data[Home] [Help]

APPS.WIP_REPSCHEDULE_UTIL dependencies on WIP_WORK_ORDER_PUB

Line 12: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type

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

Line 13: , p_old_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type

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;

Line 15: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type

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

Line 17: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type := p_RepSchedule_rec;

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

Line 513: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type

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

Line 514: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type

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:

Line 516: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type := p_RepSchedule_rec;

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;

Line 766: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type

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:

Line 853: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type

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:

Line 1029: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type

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

Line 1041: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type

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

Line 1060: ) RETURN WIP_Work_Order_PUB.Repschedule_Tbl_Type

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:

Line 1062: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type;

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

Line 1063: l_RepSchedule_tbl WIP_Work_Order_PUB.Repschedule_Tbl_Type;

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

Line 1267: , p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type

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;

Line 1268: , x_RepSchedule_rec OUT NOCOPY 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

Line 1271: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type;

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

Line 1586: FUNCTION Compare(p_RepSchedule_rec1 IN WIP_Work_Order_PUB.Repschedule_Rec_Type,

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

Line 1587: p_RepSchedule_rec2 IN WIP_Work_Order_PUB.Repschedule_Rec_Type)

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:

Line 1718: PROCEDURE dprintf(p_RepSchedule_rec IN WIP_Work_Order_PUB.RepSchedule_Rec_Type)

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;