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
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:
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;
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:
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:
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
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:
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
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
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;
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
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
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;