APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on PO_REQ_DISTRIBUTIONS

Line 142: po_req_distributions prd

138: CURSOR c_lock_req IS
139: SELECT 'x'
140: FROM po_requisition_headers prh,
141: po_requisition_lines prl,
142: po_req_distributions prd
143: WHERE prh.requisition_header_id = p_document_id
144: AND prh.requisition_header_id = prl.requisition_header_id
145: AND prl.requisition_line_id = prd.requisition_line_id
146: FOR UPDATE NOWAIT;

Line 1424: po_req_distributions_all prd

1420: Nvl(prd.prevent_encumbrance_flag,'N'),
1421: prl.blanket_po_header_id
1422: FROM
1423: po_requisition_lines_all prl,
1424: po_req_distributions_all prd
1425: WHERE
1426: NVL(prl.closed_code, 'X') NOT IN ('CANCELLED','FINALLY CLOSED')
1427: AND NVL(prl.cancel_flag, 'N') = 'N'
1428: AND NVL(prl.line_location_id, -999) = -999

Line 1986: po_req_distributions prd,

1982: fnd_currencies base_cur,
1983: gl_sets_of_books glsob,
1984: financials_system_parameters fsp,
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

Line 2220: po_req_distributions prd,

2216: fnd_currencies base_cur,
2217: gl_sets_of_books glsob,
2218: financials_system_parameters fsp,
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

Line 2454: po_req_distributions prd,

2450: fnd_currencies base_cur,
2451: gl_sets_of_books glsob,
2452: financials_system_parameters fsp,
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

Line 2675: po_req_distributions prd,

2671: fnd_currencies base_cur,
2672: gl_sets_of_books glsob,
2673: financials_system_parameters fsp,
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

Line 3466: UPDATE po_req_distributions prd

3462: IF p_document_type = 'REQ'
3463: THEN
3464: BEGIN
3465: FORALL l_index IN l_distribution_id_tbl.FIRST .. l_distribution_id_tbl.LAST
3466: UPDATE po_req_distributions prd
3467: SET prd.gl_encumbered_date = p_curr_year_start_date,
3468: prd.gl_encumbered_period_name = p_curr_year_start_period
3469: WHERE prd.distribution_id = l_distribution_id_tbl(l_index);
3470: EXCEPTION

Line 3489: Put_Debug_Msg (l_full_path,p_debug_msg => 'completed update of po_req_distributions table');

3485: x_msg_buf := fnd_message.get;
3486: RETURN;
3487: END;
3488: IF (g_debug_mode = 'Y') THEN
3489: Put_Debug_Msg (l_full_path,p_debug_msg => 'completed update of po_req_distributions table');
3490: END IF;
3491: ELSE
3492: BEGIN
3493: FORALL l_index IN l_distribution_id_tbl.FIRST .. l_distribution_id_tbl.LAST

Line 3672: UPDATE po_req_distributions prd

3668: IF p_document_type = 'REQ'
3669: THEN
3670: BEGIN
3671: FORALL l_index IN l_distribution_id_tbl.FIRST .. l_distribution_id_tbl.LAST
3672: UPDATE po_req_distributions prd
3673: SET prd.gl_encumbered_date = l_gl_enc_date_tbl(l_index),
3674: prd.gl_encumbered_period_name = l_gl_enc_prd_tbl(l_index)
3675: WHERE prd.distribution_id = l_distribution_id_tbl(l_index);
3676: EXCEPTION

Line 3695: Put_Debug_Msg (l_full_path,p_debug_msg => 'completed 2nd update of po_req_distributions table');

3691: x_msg_buf := fnd_message.get;
3692: RETURN;
3693: END;
3694: IF (g_debug_mode = 'Y') THEN
3695: Put_Debug_Msg (l_full_path,p_debug_msg => 'completed 2nd update of po_req_distributions table');
3696: END IF;
3697: ELSE
3698: BEGIN
3699: FORALL l_index IN l_distribution_id_tbl.FIRST .. l_distribution_id_tbl.LAST