APPS.MRP_VENDORMERGE_GRP dependencies on MRP_SR_SOURCE_ORG

Line 32: FROM mrp_sr_source_org

28: l_sourcing_rule_name mrp_sourcing_rules.sourcing_rule_name%TYPE;
29:
30: CURSOR c1(receipt_id NUMBER) IS
31: SELECT SUM(allocation_percent) , rank
32: FROM mrp_sr_source_org
33: WHERE sr_receipt_id = receipt_id
34: GROUP BY rank
35: HAVING sum(allocation_percent) <> 100;
36: BEGIN

Line 57: UPDATE mrp_sr_source_org mrp1

53: IF FND_API.to_Boolean( p_init_msg_list) THEN
54: FND_MSG_PUB.initialize;
55: END IF;
56:
57: UPDATE mrp_sr_source_org mrp1
58: SET mrp1.vendor_id = p_vendor_id,
59: mrp1.vendor_site_id = p_vendor_site_id
60: WHERE mrp1.vendor_id = p_dup_vendor_id and
61: mrp1.vendor_site_id = p_dup_vendor_site_id

Line 64: from mrp_sr_source_org mrp2

60: WHERE mrp1.vendor_id = p_dup_vendor_id and
61: mrp1.vendor_site_id = p_dup_vendor_site_id
62: AND not exists
63: (select mrp2.vendor_id
64: from mrp_sr_source_org mrp2
65: where mrp2.vendor_id = p_vendor_id and
66: mrp2.vendor_site_id = p_vendor_site_id and
67: mrp2.sr_receipt_id = mrp1.sr_receipt_id) ;
68:

Line 69: UPDATE mrp_sr_source_org mrp1

65: where mrp2.vendor_id = p_vendor_id and
66: mrp2.vendor_site_id = p_vendor_site_id and
67: mrp2.sr_receipt_id = mrp1.sr_receipt_id) ;
68:
69: UPDATE mrp_sr_source_org mrp1
70: SET mrp1.vendor_id = p_vendor_id
71: WHERE mrp1.vendor_id = p_dup_vendor_id
72: AND mrp1.vendor_site_id is null
73: AND not exists

Line 75: from mrp_sr_source_org mrp2

71: WHERE mrp1.vendor_id = p_dup_vendor_id
72: AND mrp1.vendor_site_id is null
73: AND not exists
74: (select mrp2.vendor_id
75: from mrp_sr_source_org mrp2
76: where mrp2.vendor_id = p_vendor_id
77: and mrp2.vendor_site_id is null
78: and mrp2.sr_receipt_id = mrp1.sr_receipt_id) ;
79:

Line 81: UPDATE mrp_sr_source_org mrp1

77: and mrp2.vendor_site_id is null
78: and mrp2.sr_receipt_id = mrp1.sr_receipt_id) ;
79:
80:
81: UPDATE mrp_sr_source_org mrp1
82: SET mrp1.allocation_percent
83: = (SELECT sum (mrp3.allocation_percent)
84: FROM mrp_sr_source_org mrp3
85: WHERE mrp3.sr_receipt_id = mrp1.sr_receipt_id

Line 84: FROM mrp_sr_source_org mrp3

80:
81: UPDATE mrp_sr_source_org mrp1
82: SET mrp1.allocation_percent
83: = (SELECT sum (mrp3.allocation_percent)
84: FROM mrp_sr_source_org mrp3
85: WHERE mrp3.sr_receipt_id = mrp1.sr_receipt_id
86: AND mrp3.rank = mrp1.rank
87: AND mrp3.vendor_id IN
88: (p_vendor_id, p_dup_vendor_id)

Line 95: from mrp_sr_source_org mrp2

91: WHERE mrp1.vendor_id = p_vendor_id
92: AND mrp1.vendor_site_id = p_vendor_site_id
93: AND exists
94: ( select mrp2.vendor_id
95: from mrp_sr_source_org mrp2
96: where mrp2.vendor_id = p_dup_vendor_id
97: and mrp2.vendor_site_id = p_dup_vendor_site_id
98: and mrp2.rank = mrp1.rank
99: and mrp2.sr_receipt_id = mrp1.sr_receipt_id) ;

Line 102: DELETE from mrp_sr_source_org mrp1

98: and mrp2.rank = mrp1.rank
99: and mrp2.sr_receipt_id = mrp1.sr_receipt_id) ;
100:
101:
102: DELETE from mrp_sr_source_org mrp1
103: WHERE vendor_id = p_dup_vendor_id
104: AND vendor_site_id = p_dup_vendor_site_id
105: RETURNING sr_receipt_id
106: BULK COLLECT INTO l_sr_receipt_id;

Line 115: FND_MESSAGE.SET_NAME('MRP','MRP_SR_SOURCE_ORG_DELETED');

111: l_row_count := 0;
112: END IF;
113:
114: -- Prepare message name
115: FND_MESSAGE.SET_NAME('MRP','MRP_SR_SOURCE_ORG_DELETED');
116: FND_MESSAGE.SET_TOKEN('ROWS_DELETED',l_row_count);
117: -- Add message to API message list.
118: FND_MSG_PUB.Add;
119: