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 352: ( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type

348:
349: -- Procedure Update_Row
350:
351: PROCEDURE Update_Row
352: ( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
353: )
354: IS
355: BEGIN
356:

Line 464: ( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type

460:
461: -- Procedure Insert_Row
462:
463: PROCEDURE Insert_Row
464: ( p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
465: )
466: IS
467: BEGIN
468:

Line 690: ) RETURN WIP_Transaction_PUB.Res_Rec_Type

686: -- Function Query_Row
687:
688: FUNCTION Query_Row
689: ( p_po_header_id IN NUMBER
690: ) RETURN WIP_Transaction_PUB.Res_Rec_Type
691: IS
692: BEGIN
693:
694: RETURN Query_Rows

Line 709: ) RETURN WIP_Transaction_PUB.Res_Tbl_Type

705: ( p_po_header_id IN NUMBER :=
706: NULL
707: , p_dummy IN VARCHAR2 :=
708: NULL
709: ) RETURN WIP_Transaction_PUB.Res_Tbl_Type
710: IS
711: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;
712: l_Res_tbl WIP_Transaction_PUB.Res_Tbl_Type;
713:

Line 711: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;

707: , p_dummy IN VARCHAR2 :=
708: NULL
709: ) RETURN WIP_Transaction_PUB.Res_Tbl_Type
710: IS
711: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;
712: l_Res_tbl WIP_Transaction_PUB.Res_Tbl_Type;
713:
714: CURSOR l_Res_csr IS
715: SELECT ACCT_PERIOD_ID

Line 712: l_Res_tbl WIP_Transaction_PUB.Res_Tbl_Type;

708: NULL
709: ) RETURN WIP_Transaction_PUB.Res_Tbl_Type
710: IS
711: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;
712: l_Res_tbl WIP_Transaction_PUB.Res_Tbl_Type;
713:
714: CURSOR l_Res_csr IS
715: SELECT ACCT_PERIOD_ID
716: , ACTIVITY_ID

Line 937: , p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type

933: --
934:
935: PROCEDURE Lock_Row
936: ( x_return_status OUT NOCOPY VARCHAR2
937: , p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
938: , x_Res_rec OUT NOCOPY WIP_Transaction_PUB.Res_Rec_Type
939: )
940: IS
941: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;

Line 938: , x_Res_rec OUT NOCOPY WIP_Transaction_PUB.Res_Rec_Type

934:
935: PROCEDURE Lock_Row
936: ( x_return_status OUT NOCOPY VARCHAR2
937: , p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
938: , x_Res_rec OUT NOCOPY WIP_Transaction_PUB.Res_Rec_Type
939: )
940: IS
941: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;
942: BEGIN

Line 941: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;

937: , p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
938: , x_Res_rec OUT NOCOPY WIP_Transaction_PUB.Res_Rec_Type
939: )
940: IS
941: l_Res_rec WIP_Transaction_PUB.Res_Rec_Type;
942: BEGIN
943:
944: SELECT ACCT_PERIOD_ID
945: , ACTIVITY_ID

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

1343:
1344: END Lock_Row;
1345:
1346:
1347: procedure print_record(p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type)
1348: is
1349: begin
1350:
1351: null;