[Home] [Help]
150: SELECT 'x'
151: FROM po_headers poh,
152: po_lines pol ,
153: po_line_locations poll,
154: po_distributions pod
155: WHERE poh.po_header_id = p_document_id
156: AND poh.po_header_id = pol.po_header_id
157: AND pol.po_header_id = poll.po_header_id
158: AND poll.po_header_id = pod.po_header_id
161: CURSOR c_lock_release IS
162: SELECT 'x'
163: FROM po_releases por,
164: po_line_locations poll,
165: po_distributions pod
166: WHERE por.po_release_id = p_document_id
167: AND por.po_release_id = poll.po_release_id
168: AND poll.po_release_id = pod.po_release_id
169: FOR UPDATE NOWAIT;
170:
171: CURSOR c_lock_bpa IS
172: SELECT 'x'
173: FROM po_headers poh,
174: po_distributions pod
175: WHERE poh.po_header_id = p_document_id
176: AND poh.po_header_id = pod.po_header_id
177: FOR UPDATE NOWAIT;
178:
1301: pod.quantity_billed,
1302: NVL(pod.encumbered_flag,'N'),
1303: pod.gl_encumbered_date,
1304: pod.gl_encumbered_period_name
1305: FROM po_distributions_all pod,
1306: po_line_locations_all poll,
1307: po_lines_all pol
1308: WHERE DECODE(poll.accrue_on_receipt_flag,
1309: 'N',
1514: pod.unencumbered_quantity,
1515: Nvl(pod.encumbered_flag,'N'),
1516: pod.gl_encumbered_date,
1517: pod.gl_encumbered_period_name
1518: FROM po_distributions_all pod,
1519: po_headers_all poh
1520: WHERE (Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) > 0
1521: AND Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) <> Nvl(pod.unencumbered_amount,0)
1522: OR Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) <> Nvl(poh.blanket_total_amount,0))
1985: po_requisition_lines prl,
1986: po_req_distributions prd,
1987: po_requisition_headers prh,
1988: po_line_locations poll,
1989: po_distributions pod,
1990: po_lines pol
1991: WHERE
1992: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')
1993: AND NVL(prl.cancel_flag,'N') = 'N'
2219: po_requisition_lines prl,
2220: po_req_distributions prd,
2221: po_requisition_headers prh,
2222: po_line_locations poll,
2223: po_distributions pod,
2224: po_lines pol
2225: WHERE
2226: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')
2227: AND NVL(prl.cancel_flag,'N') = 'N'
2453: po_requisition_lines prl,
2454: po_req_distributions prd,
2455: po_requisition_headers prh,
2456: po_line_locations poll,
2457: po_distributions pod,
2458: po_lines pol
2459: WHERE
2460: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')
2461: AND NVL(prl.cancel_flag,'N') = 'N'
2674: po_requisition_lines prl,
2675: po_req_distributions prd,
2676: po_requisition_headers prh,
2677: po_line_locations poll,
2678: po_distributions pod,
2679: po_lines pol
2680: WHERE
2681: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')
2682: AND NVL(prl.cancel_flag,'N') = 'N'
2871: financials_system_parameters fsp,
2872: po_headers poh,
2873: po_line_locations poll,
2874: po_line_locations prll,
2875: po_distributions pod,
2876: po_distributions prd,
2877: po_lines pol
2878: WHERE
2879: NVL(poll.closed_code,'OPEN') <> ('FINALLY CLOSED')
2872: po_headers poh,
2873: po_line_locations poll,
2874: po_line_locations prll,
2875: po_distributions pod,
2876: po_distributions prd,
2877: po_lines pol
2878: WHERE
2879: NVL(poll.closed_code,'OPEN') <> ('FINALLY CLOSED')
2880: AND NVL(poll.cancel_flag,'N') = 'N'
3065: financials_system_parameters fsp,
3066: po_headers poh,
3067: po_line_locations poll,
3068: po_line_locations prll,
3069: po_distributions pod,
3070: po_distributions prd,
3071: po_lines pol
3072: WHERE
3073: NVL(poll.closed_code,'OPEN') <> ('FINALLY CLOSED')
3066: po_headers poh,
3067: po_line_locations poll,
3068: po_line_locations prll,
3069: po_distributions pod,
3070: po_distributions prd,
3071: po_lines pol
3072: WHERE
3073: NVL(poll.closed_code,'OPEN') <> ('FINALLY CLOSED')
3074: AND NVL(poll.cancel_flag,'N') = 'N'
3490: END IF;
3491: ELSE
3492: BEGIN
3493: FORALL l_index IN l_distribution_id_tbl.FIRST .. l_distribution_id_tbl.LAST
3494: UPDATE po_distributions pod
3495: SET pod.gl_encumbered_date = p_curr_year_start_date,
3496: pod.gl_encumbered_period_name = p_curr_year_start_period
3497: WHERE pod.po_distribution_id = l_distribution_id_tbl(l_index);
3498: EXCEPTION
3513: x_msg_buf := fnd_message.get;
3514: RETURN;
3515: END;
3516: IF (g_debug_mode = 'Y') THEN
3517: Put_Debug_Msg (l_full_path,p_debug_msg => 'completed update of po_distributions table');
3518: END IF;
3519: END IF ; -- p_document_type = 'REQ'
3520:
3521:
3696: END IF;
3697: ELSE
3698: BEGIN
3699: FORALL l_index IN l_distribution_id_tbl.FIRST .. l_distribution_id_tbl.LAST
3700: UPDATE po_distributions pod
3701: SET pod.gl_encumbered_date = l_gl_enc_date_tbl(l_index),
3702: pod.gl_encumbered_period_name = l_gl_enc_prd_tbl(l_index)
3703: WHERE pod.po_distribution_id = l_distribution_id_tbl(l_index);
3704: EXCEPTION
3719: x_msg_buf := fnd_message.get;
3720: RETURN;
3721: END;
3722: IF (g_debug_mode = 'Y') THEN
3723: Put_Debug_Msg (l_full_path,p_debug_msg => 'completed 2nd update of po_distributions table');
3724: END IF;
3725: END IF ; -- p_document_type = 'REQ'
3726:
3727: -- commit update transaction
3910: AND ipe.conc_request_id = p_conc_request_id ;
3911:
3912: CURSOR c_get_po_future(p_req_id NUMBER) IS
3913: SELECT 'x'
3914: FROM po_distributions pod,
3915: po_requisition_lines porl,
3916: po_headers poh
3917: WHERE porl.requisition_header_id = p_req_id
3918: AND porl.line_location_id = pod.line_location_id
3927:
3928: CURSOR c_get_release_future(p_header_id NUMBER) IS
3929: SELECT 'x'
3930: FROM po_releases por,
3931: po_distributions pod
3932: WHERE por.po_header_id = p_header_id
3933: AND por.po_release_id = pod.po_release_id
3934: AND pod.gl_encumbered_date >= p_curr_year_start_date
3935: AND (