eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_SOURCING_RULE_PVT dependencies on MRP_SOURCING_RULE_PUB

Line 30: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=

26: MRP_GLOBALS.G_MISS_CONTROL_REC
27: , x_return_status OUT VARCHAR2
28: , x_msg_count OUT NUMBER
29: , x_msg_data OUT VARCHAR2
30: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
31: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
32: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
33: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
34: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=

Line 31: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC

27: , x_return_status OUT VARCHAR2
28: , x_msg_count OUT NUMBER
29: , x_msg_data OUT VARCHAR2
30: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
31: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
32: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
33: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
34: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
35: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL

Line 32: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=

28: , x_msg_count OUT NUMBER
29: , x_msg_data OUT VARCHAR2
30: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
31: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
32: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
33: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
34: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
35: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
36: , p_old_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=

Line 33: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC

29: , x_msg_data OUT VARCHAR2
30: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
31: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
32: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
33: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
34: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
35: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
36: , p_old_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
37: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL

Line 34: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=

30: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
31: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
32: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
33: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
34: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
35: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
36: , p_old_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
37: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
38: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=

Line 35: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL

31: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
32: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
33: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
34: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
35: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
36: , p_old_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
37: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
38: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
39: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL

Line 36: , p_old_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=

32: , p_old_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
33: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
34: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
35: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
36: , p_old_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
37: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
38: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
39: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
40: , p_old_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=

Line 37: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL

33: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
34: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
35: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
36: , p_old_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
37: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
38: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
39: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
40: , p_old_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
41: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL

Line 38: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=

34: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
35: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
36: , p_old_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
37: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
38: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
39: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
40: , p_old_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
41: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
42: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

Line 39: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL

35: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
36: , p_old_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
37: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
38: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
39: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
40: , p_old_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
41: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
42: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
43: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type

Line 40: , p_old_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=

36: , p_old_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
37: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
38: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
39: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
40: , p_old_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
41: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
42: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
43: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
44: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type

Line 41: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL

37: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
38: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
39: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
40: , p_old_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
41: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
42: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
43: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
44: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
45: );

Line 42: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

38: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
39: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
40: , p_old_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
41: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
42: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
43: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
44: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
45: );
46:

Line 43: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type

39: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
40: , p_old_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
41: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
42: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
43: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
44: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
45: );
46:
47: -- Start of Comments

Line 44: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type

40: , p_old_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
41: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
42: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
43: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
44: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
45: );
46:
47: -- Start of Comments
48: -- API name Lock_Sourcing_Rule

Line 69: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=

65: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
66: , x_return_status OUT VARCHAR2
67: , x_msg_count OUT NUMBER
68: , x_msg_data OUT VARCHAR2
69: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
70: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
71: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
72: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
73: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=

Line 70: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC

66: , x_return_status OUT VARCHAR2
67: , x_msg_count OUT NUMBER
68: , x_msg_data OUT VARCHAR2
69: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
70: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
71: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
72: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
73: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
74: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL

Line 71: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=

67: , x_msg_count OUT NUMBER
68: , x_msg_data OUT VARCHAR2
69: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
70: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
71: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
72: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
73: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
74: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
75: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

Line 72: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL

68: , x_msg_data OUT VARCHAR2
69: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
70: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
71: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
72: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
73: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
74: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
75: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
76: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type

Line 73: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=

69: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type :=
70: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
71: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
72: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
73: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
74: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
75: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
76: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
77: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type

Line 74: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL

70: MRP_Sourcing_Rule_PUB.G_MISS_SOURCING_RULE_REC
71: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
72: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
73: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
74: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
75: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
76: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
77: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
78: );

Line 75: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

71: , p_Receiving_Org_tbl IN MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type :=
72: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
73: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
74: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
75: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
76: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
77: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
78: );
79:

Line 76: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type

72: MRP_Sourcing_Rule_PUB.G_MISS_RECEIVING_ORG_TBL
73: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
74: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
75: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
76: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
77: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
78: );
79:
80: -- Start of Comments

Line 77: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type

73: , p_Shipping_Org_tbl IN MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type :=
74: MRP_Sourcing_Rule_PUB.G_MISS_SHIPPING_ORG_TBL
75: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
76: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
77: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
78: );
79:
80: -- Start of Comments
81: -- API name Get_Sourcing_Rule

Line 103: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type

99: , x_return_status OUT VARCHAR2
100: , x_msg_count OUT NUMBER
101: , x_msg_data OUT VARCHAR2
102: , p_Sourcing_Rule_Id IN NUMBER
103: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
104: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
105: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
106: );
107:

Line 104: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type

100: , x_msg_count OUT NUMBER
101: , x_msg_data OUT VARCHAR2
102: , p_Sourcing_Rule_Id IN NUMBER
103: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
104: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
105: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
106: );
107:
108: END MRP_Sourcing_Rule_PVT;

Line 105: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type

101: , x_msg_data OUT VARCHAR2
102: , p_Sourcing_Rule_Id IN NUMBER
103: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
104: , x_Receiving_Org_tbl OUT MRP_Sourcing_Rule_PUB.Receiving_Org_Tbl_Type
105: , x_Shipping_Org_tbl OUT MRP_Sourcing_Rule_PUB.Shipping_Org_Tbl_Type
106: );
107:
108: END MRP_Sourcing_Rule_PVT;