[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:
1300: pod.quantity_billed,
1301: NVL(pod.encumbered_flag,'N'),
1302: pod.gl_encumbered_date,
1303: pod.gl_encumbered_period_name
1304: FROM po_distributions_all pod,
1305: po_line_locations_all poll,
1306: po_lines_all pol
1307: WHERE DECODE(poll.accrue_on_receipt_flag,
1308: 'N',
1513: pod.unencumbered_quantity,
1514: Nvl(pod.encumbered_flag,'N'),
1515: pod.gl_encumbered_date,
1516: pod.gl_encumbered_period_name
1517: FROM po_distributions_all pod,
1518: po_headers_all poh
1519: WHERE (Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) > 0
1520: AND Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) <> Nvl(pod.unencumbered_amount,0)
1521: OR Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) <> Nvl(poh.blanket_total_amount,0))
1984: po_requisition_lines prl,
1985: po_req_distributions prd,
1986: po_requisition_headers prh,
1987: po_line_locations poll,
1988: po_distributions pod,
1989: po_lines pol
1990: WHERE
1991: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')
1992: AND NVL(prl.cancel_flag,'N') = 'N'
2218: po_requisition_lines prl,
2219: po_req_distributions prd,
2220: po_requisition_headers prh,
2221: po_line_locations poll,
2222: po_distributions pod,
2223: po_lines pol
2224: WHERE
2225: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')
2226: AND NVL(prl.cancel_flag,'N') = 'N'
2452: po_requisition_lines prl,
2453: po_req_distributions prd,
2454: po_requisition_headers prh,
2455: po_line_locations poll,
2456: po_distributions pod,
2457: po_lines pol
2458: WHERE
2459: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')
2460: AND NVL(prl.cancel_flag,'N') = 'N'
2673: po_requisition_lines prl,
2674: po_req_distributions prd,
2675: po_requisition_headers prh,
2676: po_line_locations poll,
2677: po_distributions pod,
2678: po_lines pol
2679: WHERE
2680: NVL(prl.closed_code,'OPEN') NOT IN ('CANCELLED','FINALLY CLOSED')
2681: AND NVL(prl.cancel_flag,'N') = 'N'
2870: financials_system_parameters fsp,
2871: po_headers poh,
2872: po_line_locations poll,
2873: po_line_locations prll,
2874: po_distributions pod,
2875: po_distributions prd,
2876: po_lines pol
2877: WHERE
2878: NVL(poll.closed_code,'OPEN') <> ('FINALLY CLOSED')
2871: po_headers poh,
2872: po_line_locations poll,
2873: po_line_locations prll,
2874: po_distributions pod,
2875: po_distributions prd,
2876: po_lines pol
2877: WHERE
2878: NVL(poll.closed_code,'OPEN') <> ('FINALLY CLOSED')
2879: AND NVL(poll.cancel_flag,'N') = 'N'
3064: financials_system_parameters fsp,
3065: po_headers poh,
3066: po_line_locations poll,
3067: po_line_locations prll,
3068: po_distributions pod,
3069: po_distributions prd,
3070: po_lines pol
3071: WHERE
3072: NVL(poll.closed_code,'OPEN') <> ('FINALLY CLOSED')
3065: po_headers poh,
3066: po_line_locations poll,
3067: po_line_locations prll,
3068: po_distributions pod,
3069: po_distributions prd,
3070: po_lines pol
3071: WHERE
3072: NVL(poll.closed_code,'OPEN') <> ('FINALLY CLOSED')
3073: AND NVL(poll.cancel_flag,'N') = 'N'
3489: END IF;
3490: ELSE
3491: BEGIN
3492: FORALL l_index IN l_distribution_id_tbl.FIRST .. l_distribution_id_tbl.LAST
3493: UPDATE po_distributions pod
3494: SET pod.gl_encumbered_date = p_curr_year_start_date,
3495: pod.gl_encumbered_period_name = p_curr_year_start_period
3496: WHERE pod.po_distribution_id = l_distribution_id_tbl(l_index);
3497: EXCEPTION
3512: x_msg_buf := fnd_message.get;
3513: RETURN;
3514: END;
3515: IF (g_debug_mode = 'Y') THEN
3516: Put_Debug_Msg (l_full_path,p_debug_msg => 'completed update of po_distributions table');
3517: END IF;
3518: END IF ; -- p_document_type = 'REQ'
3519:
3520:
3695: END IF;
3696: ELSE
3697: BEGIN
3698: FORALL l_index IN l_distribution_id_tbl.FIRST .. l_distribution_id_tbl.LAST
3699: UPDATE po_distributions pod
3700: SET pod.gl_encumbered_date = l_gl_enc_date_tbl(l_index),
3701: pod.gl_encumbered_period_name = l_gl_enc_prd_tbl(l_index)
3702: WHERE pod.po_distribution_id = l_distribution_id_tbl(l_index);
3703: EXCEPTION
3718: x_msg_buf := fnd_message.get;
3719: RETURN;
3720: END;
3721: IF (g_debug_mode = 'Y') THEN
3722: Put_Debug_Msg (l_full_path,p_debug_msg => 'completed 2nd update of po_distributions table');
3723: END IF;
3724: END IF ; -- p_document_type = 'REQ'
3725:
3726: -- commit update transaction
3909: AND ipe.conc_request_id = p_conc_request_id ;
3910:
3911: CURSOR c_get_po_future(p_req_id NUMBER) IS
3912: SELECT 'x'
3913: FROM po_distributions pod,
3914: po_requisition_lines porl,
3915: po_headers poh
3916: WHERE porl.requisition_header_id = p_req_id
3917: AND porl.line_location_id = pod.line_location_id
3926:
3927: CURSOR c_get_release_future(p_header_id NUMBER) IS
3928: SELECT 'x'
3929: FROM po_releases por,
3930: po_distributions pod
3931: WHERE por.po_header_id = p_header_id
3932: AND por.po_release_id = pod.po_release_id
3933: AND pod.gl_encumbered_date >= p_curr_year_start_date
3934: AND (