[Home] [Help]
122: , nvl(retainage_released_amount, 0) + p_line_loc_changes_rec.retainage_released_amt),
123: last_update_login = nvl(p_line_loc_changes_rec.last_update_login, last_update_login),
124: request_id = nvl(p_line_loc_changes_rec.request_id, request_id) ,
125: last_update_date = SYSDATE, -- Bug 10021100
126: last_updated_by = FND_GLOBAL.USER_ID
127: WHERE pll.line_location_id = p_line_loc_changes_rec.po_line_location_id
128: OR (pll.shipment_type = 'PLANNED'
129: AND pll.line_location_id =
130: (SELECT pll2.source_shipment_id
135: ;
136:
137: d_position := 40;
138: IF PO_LOG.d_stmt THEN
139: PO_LOG.stmt(d_mod,d_position,'Line Locations updated: ' || SQL%ROWCOUNT || '; fnd_global.user_id: ' || fnd_global.user_id);
140: END IF;
141:
142: -- SQL What: Update the AP-related fields on the PO distribution
143: -- SQL Where: For the distribution rows represented in p_dist_changes_rec
179: , nvl(retainage_released_amount, 0) + p_dist_changes_rec.retainage_released_amt_tbl(i)),
180: last_update_login = nvl(p_dist_changes_rec.last_update_login_tbl(i), last_update_login),
181: request_id = nvl(p_dist_changes_rec.request_id_tbl(i), request_id),
182: last_update_date = SYSDATE, -- Bug 10021100
183: last_updated_by = FND_GLOBAL.USER_ID
184: WHERE pod.po_distribution_id = p_dist_changes_rec.po_distribution_id_tbl(i)
185: OR (pod.distribution_type = 'PLANNED'
186: AND pod.po_distribution_id =
187: (SELECT pod2.source_distribution_id
191: ;
192:
193: d_position := 50;
194: IF PO_LOG.d_stmt THEN
195: PO_LOG.stmt(d_mod,d_position,'Distributions updated: ' || SQL%ROWCOUNT || '; fnd_global.user_id: ' || fnd_global.user_id);
196: END IF;
197:
198: IF PO_LOG.d_proc THEN
199: PO_LOG.proc_end(d_mod,'x_return_status', x_return_status);