DBA Data[Home] [Help]

APPS.WIP_RES_UTIL dependencies on WIP_TRANSACTION_PUB

Line 11: ( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type

7:
8: -- Function Convert_Miss_To_Null
9:
10: FUNCTION Convert_Miss_To_Null
11: ( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
12: ) RETURN WIP_Transaction_PUB.Res_Rec_Type
13: IS
14: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type := p_Res_rec;
15: BEGIN

Line 12: ) RETURN WIP_Transaction_PUB.Res_Rec_Type

8: -- Function Convert_Miss_To_Null
9:
10: FUNCTION Convert_Miss_To_Null
11: ( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
12: ) RETURN WIP_Transaction_PUB.Res_Rec_Type
13: IS
14: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type := p_Res_rec;
15: BEGIN
16:

Line 14: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type := p_Res_rec;

10: FUNCTION Convert_Miss_To_Null
11: ( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
12: ) RETURN WIP_Transaction_PUB.Res_Rec_Type
13: IS
14: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type := p_Res_rec;
15: BEGIN
16:
17: IF l_Res_rec.acct_period_id = FND_API.G_MISS_NUM THEN
18: l_Res_rec.acct_period_id := NULL;

Line 370: ( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type

366:
367: -- Procedure Update_Row
368:
369: PROCEDURE Update_Row
370: ( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
371: )
372: IS
373: BEGIN
374:

Line 482: ( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type

478:
479: -- Procedure Insert_Row
480:
481: PROCEDURE Insert_Row
482: ( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
483: )
484: IS
485: BEGIN
486:

Line 718: ) RETURN WIP_Transaction_PUB.Res_Rec_Type

714: -- Function Query_Row
715:
716: FUNCTION Query_Row
717: ( p_po_header_id IN NUMBER
718: ) RETURN WIP_Transaction_PUB.Res_Rec_Type
719: IS
720: BEGIN
721:
722: RETURN Query_Rows

Line 737: ) RETURN WIP_Transaction_PUB.Res_Tbl_Type

733: ( p_po_header_id IN NUMBER :=
734: NULL
735: , p_dummy IN VARCHAR2 :=
736: NULL
737: ) RETURN WIP_Transaction_PUB.Res_Tbl_Type
738: IS
739: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;
740: l_Res_tbl WIP_Transaction_PUB.Res_Tbl_Type;
741:

Line 739: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;

735: , p_dummy IN VARCHAR2 :=
736: NULL
737: ) RETURN WIP_Transaction_PUB.Res_Tbl_Type
738: IS
739: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;
740: l_Res_tbl WIP_Transaction_PUB.Res_Tbl_Type;
741:
742: CURSOR l_Res_csr IS
743: SELECT ACCT_PERIOD_ID

Line 740: l_Res_tbl WIP_Transaction_PUB.Res_Tbl_Type;

736: NULL
737: ) RETURN WIP_Transaction_PUB.Res_Tbl_Type
738: IS
739: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;
740: l_Res_tbl WIP_Transaction_PUB.Res_Tbl_Type;
741:
742: CURSOR l_Res_csr IS
743: SELECT ACCT_PERIOD_ID
744: , ACTIVITY_ID

Line 965: , p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type

961: --
962:
963: PROCEDURE Lock_Row
964: ( x_return_status OUT NOCOPY VARCHAR2
965: , p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
966: , x_Res_rec OUT NOCOPY WIP_Transaction_PUB.Res_Rec_Type
967: )
968: IS
969: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;

Line 966: , x_Res_rec OUT NOCOPY WIP_Transaction_PUB.Res_Rec_Type

962:
963: PROCEDURE Lock_Row
964: ( x_return_status OUT NOCOPY VARCHAR2
965: , p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
966: , x_Res_rec OUT NOCOPY WIP_Transaction_PUB.Res_Rec_Type
967: )
968: IS
969: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;
970: BEGIN

Line 969: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;

965: , p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
966: , x_Res_rec OUT NOCOPY WIP_Transaction_PUB.Res_Rec_Type
967: )
968: IS
969: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;
970: BEGIN
971:
972: SELECT ACCT_PERIOD_ID
973: , ACTIVITY_ID

Line 1375: procedure print_record(p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type)

1371:
1372: END Lock_Row;
1373:
1374:
1375: procedure print_record(p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type)
1376: is
1377: begin
1378:
1379: null;