APPS.PO_REQ_DIST_SV1 dependencies on PO_REQ_DISTRIBUTIONS

Line 22: FROM po_req_distributions

18: x_progress := '001';
19:
20: SELECT count(distribution_id)
21: INTO x_num_of_dist
22: FROM po_req_distributions
23: WHERE requisition_line_id = x_requisition_line_id;
24:
25: --
26: -- If there is one distribution then obtain

Line 39: FROM po_req_distributions

35: x_progress := '020';
36:
37: SELECT code_combination_id
38: INTO x_code_combination_id
39: FROM po_req_distributions
40: WHERE requisition_line_id = x_requisition_line_id;
41:
42: END IF;
43:

Line 74: FROM po_req_distributions_all

70: x_progress := '001';
71: -- Bug: 1702850 use _all table instead of stripe table
72: SELECT count(distribution_id)
73: INTO x_num_of_dist
74: FROM po_req_distributions_all
75: WHERE requisition_line_id = x_requisition_line_id;
76:
77: --
78: -- If there is one distribution then obtain

Line 96: FROM po_req_distributions_all

92: -- Bug: 1702850 use _all table instead of stripe table
93:
94: SELECT code_combination_id
95: INTO x_code_combination_id
96: FROM po_req_distributions_all
97: WHERE requisition_line_id = x_requisition_line_id;
98:
99: return(x_code_combination_id);
100:

Line 128: Recinfo po_req_distributions%rowtype;

124: IS
125:
126: x_progress VARCHAR2(3) := NULL;
127: x_num_of_dist NUMBER := NULL;
128: Recinfo po_req_distributions%rowtype;
129:
130: BEGIN
131: x_progress := '001';
132:

Line 135: FROM po_req_distributions

131: x_progress := '001';
132:
133: SELECT count(distribution_id)
134: INTO x_num_of_dist
135: FROM po_req_distributions
136: WHERE requisition_line_id = x_requisition_line_id
137: AND NOT EXISTS (SELECT 'there are encumbered distributions'
138: FROM po_req_distributions prd2
139: WHERE prd2.requisition_line_id = x_requisition_line_id

Line 138: FROM po_req_distributions prd2

134: INTO x_num_of_dist
135: FROM po_req_distributions
136: WHERE requisition_line_id = x_requisition_line_id
137: AND NOT EXISTS (SELECT 'there are encumbered distributions'
138: FROM po_req_distributions prd2
139: WHERE prd2.requisition_line_id = x_requisition_line_id
140: AND ( nvl(prd2.encumbered_flag, 'N') <> 'N')
141: );
142:

Line 162: FROM po_req_distributions

158:
159:
160: SELECT *
161: INTO Recinfo
162: FROM po_req_distributions
163: WHERE requisition_line_id = x_requisition_line_id
164: FOR UPDATE OF req_line_quantity NOWAIT;
165:
166: x_progress := '030';

Line 168: UPDATE po_req_distributions prd

164: FOR UPDATE OF req_line_quantity NOWAIT;
165:
166: x_progress := '030';
167:
168: UPDATE po_req_distributions prd
169: SET req_line_quantity = x_line_quantity
170: WHERE prd.requisition_line_id = x_requisition_line_id;
171:
172: END IF;