DBA Data[Home] [Help]

APPS.WIP_DISCRETEJOB_UTIL dependencies on WIP_WORK_ORDER_PUB

Line 12: ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type

8:
9: -- Function Complete_Record
10:
11: FUNCTION Complete_Record
12: ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
13: , p_old_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
14: , p_ForceCopy IN BOOLEAN := NULL
15: ) RETURN WIP_Work_Order_PUB.Discretejob_Rec_Type
16: IS

Line 13: , p_old_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type

9: -- Function Complete_Record
10:
11: FUNCTION Complete_Record
12: ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
13: , p_old_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
14: , p_ForceCopy IN BOOLEAN := NULL
15: ) RETURN WIP_Work_Order_PUB.Discretejob_Rec_Type
16: IS
17: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type := p_DiscreteJob_rec;

Line 15: ) RETURN WIP_Work_Order_PUB.Discretejob_Rec_Type

11: FUNCTION Complete_Record
12: ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
13: , p_old_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
14: , p_ForceCopy IN BOOLEAN := NULL
15: ) RETURN WIP_Work_Order_PUB.Discretejob_Rec_Type
16: IS
17: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type := p_DiscreteJob_rec;
18: BEGIN
19:

Line 17: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type := p_DiscreteJob_rec;

13: , p_old_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
14: , p_ForceCopy IN BOOLEAN := NULL
15: ) RETURN WIP_Work_Order_PUB.Discretejob_Rec_Type
16: IS
17: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type := p_DiscreteJob_rec;
18: BEGIN
19:
20: IF (p_ForceCopy is NOT NULL) THEN
21: IF (p_ForceCopy = TRUE)

Line 835: ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type

831:
832: -- Function Convert_Miss_To_Null
833:
834: FUNCTION Convert_Miss_To_Null
835: ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
836: ) RETURN WIP_Work_Order_PUB.Discretejob_Rec_Type
837: IS
838: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type := p_DiscreteJob_rec;
839: BEGIN

Line 836: ) RETURN WIP_Work_Order_PUB.Discretejob_Rec_Type

832: -- Function Convert_Miss_To_Null
833:
834: FUNCTION Convert_Miss_To_Null
835: ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
836: ) RETURN WIP_Work_Order_PUB.Discretejob_Rec_Type
837: IS
838: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type := p_DiscreteJob_rec;
839: BEGIN
840:

Line 838: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type := p_DiscreteJob_rec;

834: FUNCTION Convert_Miss_To_Null
835: ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
836: ) RETURN WIP_Work_Order_PUB.Discretejob_Rec_Type
837: IS
838: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type := p_DiscreteJob_rec;
839: BEGIN
840:
841: IF l_DiscreteJob_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
842: l_DiscreteJob_rec.alternate_bom_designator := NULL;

Line 1168: ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type

1164:
1165: -- Procedure Update_Row
1166:
1167: PROCEDURE Update_Row
1168: ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
1169: )
1170: IS
1171: BEGIN
1172:

Line 1276: ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type

1272:
1273: -- Procedure Insert_Row
1274:
1275: PROCEDURE Insert_Row
1276: ( p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
1277: )
1278: IS
1279: BEGIN
1280:

Line 1494: ) RETURN WIP_Work_Order_PUB.Discretejob_Rec_Type

1490: -- Function Query_Row
1491:
1492: FUNCTION Query_Row
1493: ( p_wip_entity_id IN NUMBER
1494: ) RETURN WIP_Work_Order_PUB.Discretejob_Rec_Type
1495: IS
1496: BEGIN
1497:
1498: RETURN Query_Rows

Line 1511: ) RETURN WIP_Work_Order_PUB.Discretejob_Tbl_Type

1507:
1508: FUNCTION Query_Rows
1509: ( p_wip_entity_id IN NUMBER :=
1510: NULL
1511: ) RETURN WIP_Work_Order_PUB.Discretejob_Tbl_Type
1512: IS
1513: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type;
1514: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
1515:

Line 1513: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type;

1509: ( p_wip_entity_id IN NUMBER :=
1510: NULL
1511: ) RETURN WIP_Work_Order_PUB.Discretejob_Tbl_Type
1512: IS
1513: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type;
1514: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
1515:
1516: CURSOR l_DiscreteJob_csr IS
1517: SELECT ALTERNATE_BOM_DESIGNATOR

Line 1514: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;

1510: NULL
1511: ) RETURN WIP_Work_Order_PUB.Discretejob_Tbl_Type
1512: IS
1513: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type;
1514: l_DiscreteJob_tbl WIP_Work_Order_PUB.Discretejob_Tbl_Type;
1515:
1516: CURSOR l_DiscreteJob_csr IS
1517: SELECT ALTERNATE_BOM_DESIGNATOR
1518: , ALTERNATE_ROUTING_DESIGNATOR

Line 1735: , p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type

1731: --
1732:
1733: PROCEDURE Lock_Row
1734: ( x_return_status OUT NOCOPY VARCHAR2
1735: , p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
1736: , x_DiscreteJob_rec OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Rec_Type
1737: )
1738: IS
1739: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type;

Line 1736: , x_DiscreteJob_rec OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Rec_Type

1732:
1733: PROCEDURE Lock_Row
1734: ( x_return_status OUT NOCOPY VARCHAR2
1735: , p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
1736: , x_DiscreteJob_rec OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Rec_Type
1737: )
1738: IS
1739: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type;
1740: BEGIN

Line 1739: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type;

1735: , p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type
1736: , x_DiscreteJob_rec OUT NOCOPY WIP_Work_Order_PUB.Discretejob_Rec_Type
1737: )
1738: IS
1739: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type;
1740: BEGIN
1741:
1742: SELECT ALTERNATE_BOM_DESIGNATOR
1743: , ALTERNATE_ROUTING_DESIGNATOR

Line 2139: FUNCTION Compare( p_DiscreteJob_rec1 IN WIP_Work_Order_PUB.Discretejob_Rec_Type,

2135: END Lock_Row;
2136:
2137:
2138:
2139: FUNCTION Compare( p_DiscreteJob_rec1 IN WIP_Work_Order_PUB.Discretejob_Rec_Type,
2140: p_DiscreteJob_rec2 IN WIP_Work_Order_PUB.Discretejob_Rec_Type)
2141: RETURN BOOLEAN
2142: IS
2143: BEGIN

Line 2140: p_DiscreteJob_rec2 IN WIP_Work_Order_PUB.Discretejob_Rec_Type)

2136:
2137:
2138:
2139: FUNCTION Compare( p_DiscreteJob_rec1 IN WIP_Work_Order_PUB.Discretejob_Rec_Type,
2140: p_DiscreteJob_rec2 IN WIP_Work_Order_PUB.Discretejob_Rec_Type)
2141: RETURN BOOLEAN
2142: IS
2143: BEGIN
2144:

Line 2312: PROCEDURE dprintf(p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type)

2308: RETURN FALSE;
2309: END IF;
2310: END Compare;
2311:
2312: PROCEDURE dprintf(p_DiscreteJob_rec IN WIP_Work_Order_PUB.Discretejob_Rec_Type)
2313: IS
2314: BEGIN
2315:
2316: null;