DBA Data[Home] [Help]

APPS.MRP_SOURCING_RULE_HANDLERS dependencies on MRP_SOURCING_RULE_PUB

Line 11: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

7:
8: -- Procedure Update_Row
9:
10: PROCEDURE Update_Row
11: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
12: )
13: IS
14: BEGIN
15:

Line 71: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

67:
68: -- Procedure Insert_Row
69:
70: PROCEDURE Insert_Row
71: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
72: )
73: IS
74: BEGIN
75:

Line 221: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

217: --
218:
219: PROCEDURE Lock_Row
220: ( x_return_status OUT VARCHAR2
221: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
222: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
223: )
224: IS
225: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;

Line 222: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

218:
219: PROCEDURE Lock_Row
220: ( x_return_status OUT VARCHAR2
221: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
222: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
223: )
224: IS
225: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
226: BEGIN

Line 225: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;

221: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
222: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
223: )
224: IS
225: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
226: BEGIN
227:
228: SELECT SOURCING_RULE_ID
229: , ATTRIBUTE1

Line 531: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

527: -- Function Query_Row
528:
529: FUNCTION Query_Row
530: ( p_Sourcing_Rule_Id IN NUMBER
531: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
532: IS
533: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
534: BEGIN
535:

Line 533: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;

529: FUNCTION Query_Row
530: ( p_Sourcing_Rule_Id IN NUMBER
531: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
532: IS
533: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
534: BEGIN
535:
536: SELECT SOURCING_RULE_ID
537: , ATTRIBUTE1

Line 626: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

622: -- Procedure Query_Entity
623:
624: PROCEDURE Query_Entity
625: ( p_Sourcing_Rule_Id IN NUMBER
626: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
627: , x_Sourcing_Rule_val_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
628: )
629: IS
630: BEGIN

Line 627: , x_Sourcing_Rule_val_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type

623:
624: PROCEDURE Query_Entity
625: ( p_Sourcing_Rule_Id IN NUMBER
626: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
627: , x_Sourcing_Rule_val_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
628: )
629: IS
630: BEGIN
631: