DBA Data[Home] [Help]

APPS.MRP_ASSIGNMENT_HANDLERS dependencies on MRP_SRC_ASSIGNMENT_PUB

Line 11: ( p_Assignment_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type

7:
8: -- Procedure Update_Row
9:
10: PROCEDURE Update_Row
11: ( p_Assignment_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type
12: )
13: IS
14: BEGIN
15:

Line 76: ( p_Assignment_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type

72:
73: -- Procedure Insert_Row
74:
75: PROCEDURE Insert_Row
76: ( p_Assignment_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type
77: )
78: IS
79: BEGIN
80:

Line 209: , p_Assignment_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type

205: --
206:
207: PROCEDURE Lock_Row
208: ( x_return_status OUT VARCHAR2
209: , p_Assignment_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type
210: , x_Assignment_rec OUT MRP_Src_Assignment_PUB.Assignment_Rec_Type
211: )
212: IS
213: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;

Line 210: , x_Assignment_rec OUT MRP_Src_Assignment_PUB.Assignment_Rec_Type

206:
207: PROCEDURE Lock_Row
208: ( x_return_status OUT VARCHAR2
209: , p_Assignment_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type
210: , x_Assignment_rec OUT MRP_Src_Assignment_PUB.Assignment_Rec_Type
211: )
212: IS
213: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
214: BEGIN

Line 213: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;

209: , p_Assignment_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type
210: , x_Assignment_rec OUT MRP_Src_Assignment_PUB.Assignment_Rec_Type
211: )
212: IS
213: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
214: BEGIN
215:
216: SELECT ASSIGNMENT_ID
217: , ASSIGNMENT_SET_ID

Line 554: ) RETURN MRP_Src_Assignment_PUB.Assignment_Rec_Type

550: -- Function Query_Row
551:
552: FUNCTION Query_Row
553: ( p_Assignment_Id IN NUMBER
554: ) RETURN MRP_Src_Assignment_PUB.Assignment_Rec_Type
555: IS
556: BEGIN
557:
558: RETURN Query_Rows

Line 583: , x_Assignment_rec OUT MRP_Src_Assignment_PUB.Assignment_Rec_Type

579: -- Procedure Query_Entity
580:
581: PROCEDURE Query_Entity
582: ( p_Assignment_Id IN NUMBER
583: , x_Assignment_rec OUT MRP_Src_Assignment_PUB.Assignment_Rec_Type
584: , x_Assignment_val_rec OUT MRP_Src_Assignment_PUB.Assignment_Val_Rec_Type
585: )
586: IS
587: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;

Line 584: , x_Assignment_val_rec OUT MRP_Src_Assignment_PUB.Assignment_Val_Rec_Type

580:
581: PROCEDURE Query_Entity
582: ( p_Assignment_Id IN NUMBER
583: , x_Assignment_rec OUT MRP_Src_Assignment_PUB.Assignment_Rec_Type
584: , x_Assignment_val_rec OUT MRP_Src_Assignment_PUB.Assignment_Val_Rec_Type
585: )
586: IS
587: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
588: l_Assignment_val_tbl MRP_Src_Assignment_PUB.Assignment_Val_Tbl_Type;

Line 587: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;

583: , x_Assignment_rec OUT MRP_Src_Assignment_PUB.Assignment_Rec_Type
584: , x_Assignment_val_rec OUT MRP_Src_Assignment_PUB.Assignment_Val_Rec_Type
585: )
586: IS
587: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
588: l_Assignment_val_tbl MRP_Src_Assignment_PUB.Assignment_Val_Tbl_Type;
589: BEGIN
590:
591: Query_Entities

Line 588: l_Assignment_val_tbl MRP_Src_Assignment_PUB.Assignment_Val_Tbl_Type;

584: , x_Assignment_val_rec OUT MRP_Src_Assignment_PUB.Assignment_Val_Rec_Type
585: )
586: IS
587: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
588: l_Assignment_val_tbl MRP_Src_Assignment_PUB.Assignment_Val_Tbl_Type;
589: BEGIN
590:
591: Query_Entities
592: ( p_Assignment_Id => p_Assignment_Id

Line 628: ) RETURN MRP_Src_Assignment_PUB.Assignment_Tbl_Type

624: ( p_Assignment_Id IN NUMBER :=
625: FND_API.G_MISS_NUM
626: , p_Assignment_Set_Id IN NUMBER :=
627: FND_API.G_MISS_NUM
628: ) RETURN MRP_Src_Assignment_PUB.Assignment_Tbl_Type
629: IS
630: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
631: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
632:

Line 630: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;

626: , p_Assignment_Set_Id IN NUMBER :=
627: FND_API.G_MISS_NUM
628: ) RETURN MRP_Src_Assignment_PUB.Assignment_Tbl_Type
629: IS
630: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
631: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
632:
633: CURSOR l_Assignment_csr IS
634: SELECT ASSIGNMENT_ID

Line 631: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;

627: FND_API.G_MISS_NUM
628: ) RETURN MRP_Src_Assignment_PUB.Assignment_Tbl_Type
629: IS
630: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
631: l_Assignment_tbl MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
632:
633: CURSOR l_Assignment_csr IS
634: SELECT ASSIGNMENT_ID
635: , ASSIGNMENT_SET_ID

Line 795: , x_Assignment_tbl OUT MRP_Src_Assignment_PUB.Assignment_Tbl_Type

791: ( p_Assignment_Id IN NUMBER :=
792: FND_API.G_MISS_NUM
793: , p_Assignment_Set_Id IN NUMBER :=
794: FND_API.G_MISS_NUM
795: , x_Assignment_tbl OUT MRP_Src_Assignment_PUB.Assignment_Tbl_Type
796: , x_Assignment_val_tbl OUT MRP_Src_Assignment_PUB.Assignment_Val_Tbl_Type
797: )
798: IS
799: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;

Line 796: , x_Assignment_val_tbl OUT MRP_Src_Assignment_PUB.Assignment_Val_Tbl_Type

792: FND_API.G_MISS_NUM
793: , p_Assignment_Set_Id IN NUMBER :=
794: FND_API.G_MISS_NUM
795: , x_Assignment_tbl OUT MRP_Src_Assignment_PUB.Assignment_Tbl_Type
796: , x_Assignment_val_tbl OUT MRP_Src_Assignment_PUB.Assignment_Val_Tbl_Type
797: )
798: IS
799: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
800: l_Assignment_val_rec MRP_Src_Assignment_PUB.Assignment_Val_Rec_Type;

Line 799: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;

795: , x_Assignment_tbl OUT MRP_Src_Assignment_PUB.Assignment_Tbl_Type
796: , x_Assignment_val_tbl OUT MRP_Src_Assignment_PUB.Assignment_Val_Tbl_Type
797: )
798: IS
799: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
800: l_Assignment_val_rec MRP_Src_Assignment_PUB.Assignment_Val_Rec_Type;
801: l_rows_fetched BOOLEAN := FALSE;
802:
803: CURSOR l_Assignment_csr IS

Line 800: l_Assignment_val_rec MRP_Src_Assignment_PUB.Assignment_Val_Rec_Type;

796: , x_Assignment_val_tbl OUT MRP_Src_Assignment_PUB.Assignment_Val_Tbl_Type
797: )
798: IS
799: l_Assignment_rec MRP_Src_Assignment_PUB.Assignment_Rec_Type;
800: l_Assignment_val_rec MRP_Src_Assignment_PUB.Assignment_Val_Rec_Type;
801: l_rows_fetched BOOLEAN := FALSE;
802:
803: CURSOR l_Assignment_csr IS
804: SELECT ASSIGNMENT_ID