8:
9: -- Function Complete_Record
10:
11: FUNCTION Complete_Record
12: ( p_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
13: , p_old_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
14: ) RETURN WIP_Transaction_PUB.Shopfloormove_Rec_Type
15: IS
16: l_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type := p_ShopFloorMove_rec;
9: -- Function Complete_Record
10:
11: FUNCTION Complete_Record
12: ( p_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
13: , p_old_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
14: ) RETURN WIP_Transaction_PUB.Shopfloormove_Rec_Type
15: IS
16: l_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type := p_ShopFloorMove_rec;
17: BEGIN
10:
11: FUNCTION Complete_Record
12: ( p_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
13: , p_old_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
14: ) RETURN WIP_Transaction_PUB.Shopfloormove_Rec_Type
15: IS
16: l_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type := p_ShopFloorMove_rec;
17: BEGIN
18:
12: ( p_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
13: , p_old_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
14: ) RETURN WIP_Transaction_PUB.Shopfloormove_Rec_Type
15: IS
16: l_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type := p_ShopFloorMove_rec;
17: BEGIN
18:
19: IF l_ShopFloorMove_rec.acct_period_id = FND_API.G_MISS_NUM THEN
20: l_ShopFloorMove_rec.acct_period_id := p_old_ShopFloorMove_rec.acct_period_id;
294:
295: -- Function Convert_Miss_To_Null
296:
297: FUNCTION Convert_Miss_To_Null
298: ( p_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
299: ) RETURN WIP_Transaction_PUB.Shopfloormove_Rec_Type
300: IS
301: l_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type := p_ShopFloorMove_rec;
302: BEGIN
295: -- Function Convert_Miss_To_Null
296:
297: FUNCTION Convert_Miss_To_Null
298: ( p_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
299: ) RETURN WIP_Transaction_PUB.Shopfloormove_Rec_Type
300: IS
301: l_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type := p_ShopFloorMove_rec;
302: BEGIN
303:
297: FUNCTION Convert_Miss_To_Null
298: ( p_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
299: ) RETURN WIP_Transaction_PUB.Shopfloormove_Rec_Type
300: IS
301: l_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type := p_ShopFloorMove_rec;
302: BEGIN
303:
304: IF l_ShopFloorMove_rec.acct_period_id = FND_API.G_MISS_NUM THEN
305: l_ShopFloorMove_rec.acct_period_id := NULL;
582:
583: -- Procedure Insert_Row
584:
585: PROCEDURE Insert_Row
586: ( p_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
587: )
588: IS
589: BEGIN
590:
774: END Delete_Row;
775:
776: FUNCTION Query_Row
777: ( p_transaction_id IN NUMBER
778: ) RETURN WIP_Transaction_PUB.Shopfloormove_Rec_Type
779: IS
780: BEGIN
781:
782: RETURN Query_Rows
793: ( p_transaction_id IN NUMBER :=
794: NULL
795: , p_dummy IN VARCHAR2 :=
796: NULL
797: ) RETURN WIP_Transaction_PUB.Shopfloormove_Tbl_Type
798: IS
799: l_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type;
800: l_ShopFloorMove_tbl WIP_Transaction_PUB.Shopfloormove_Tbl_Type;
801:
795: , p_dummy IN VARCHAR2 :=
796: NULL
797: ) RETURN WIP_Transaction_PUB.Shopfloormove_Tbl_Type
798: IS
799: l_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type;
800: l_ShopFloorMove_tbl WIP_Transaction_PUB.Shopfloormove_Tbl_Type;
801:
802: CURSOR l_ShopFloorMove_csr IS
803: SELECT ACCT_PERIOD_ID
796: NULL
797: ) RETURN WIP_Transaction_PUB.Shopfloormove_Tbl_Type
798: IS
799: l_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type;
800: l_ShopFloorMove_tbl WIP_Transaction_PUB.Shopfloormove_Tbl_Type;
801:
802: CURSOR l_ShopFloorMove_csr IS
803: SELECT ACCT_PERIOD_ID
804: , ATTRIBUTE1
990:
991: END Query_Rows;
992:
993:
994: PROCEDURE print_record(p_ShopFloorMove_rec IN WIP_Transaction_PUB.ShopFloorMove_Rec_Type)
995: IS
996: BEGIN
997:
998: null;