APPS.PO_AUTO_DIST_PROCESS_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 60: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;

56: l_encumbered_flag VARCHAR2(1);
57: l_budget_account_id NUMBER;
58: l_dist_id_tbl po_tbl_number;
59: l_dist_count NUMBER;
60: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
61: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
62: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
63: x_kanban_card_id NUMBER:='';
64: x_accrued_flag VARCHAR2(1);

Line 61: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;

57: l_budget_account_id NUMBER;
58: l_dist_id_tbl po_tbl_number;
59: l_dist_count NUMBER;
60: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
61: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
62: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
63: x_kanban_card_id NUMBER:='';
64: x_accrued_flag VARCHAR2(1);
65: l_fund_source_not_known VARCHAR2(1);

Line 62: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;

58: l_dist_id_tbl po_tbl_number;
59: l_dist_count NUMBER;
60: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
61: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
62: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
63: x_kanban_card_id NUMBER:='';
64: x_accrued_flag VARCHAR2(1);
65: l_fund_source_not_known VARCHAR2(1);
66: --Bug13553227

Line 104: FROM PO_REQUISITION_LINES_ALL prl

100: BEGIN
101:
102: SELECT prl.fund_source_not_known
103: INTO l_fund_source_not_known
104: FROM PO_REQUISITION_LINES_ALL prl
105: WHERE prl.requisition_line_id = p_lines.requisition_line_id_tbl(i);
106:
107: EXCEPTION
108: WHEN No_Data_Found THEN

Line 182: FROM po_requisition_lines_all pol --

178: --Even sourcing need to execute this when backed by a req.
179: BEGIN
180: SELECT KANBAN_CARD_ID
181: INTO x_kanban_card_id
182: FROM po_requisition_lines_all pol --
183: WHERE pol.REQUISITION_LINE_ID = p_lines.requisition_line_id_tbl(i);
184: EXCEPTION
185: WHEN NO_DATA_FOUND THEN
186: /* Not all req has kanban id */

Line 443: FROM po_requisition_lines_all PRL

439: SELECT PRL.currency_code,
440: NVL(PRL.rate,1)
441: INTO x_req_currency_code,
442: x_req_rate
443: FROM po_requisition_lines_all PRL
444: WHERE PRL.requisition_line_id = p_lines.requisition_line_id_tbl(i);
445: EXCEPTION
446: WHEN OTHERS THEN
447: NULL;

Line 1157: po_requisition_lines_all prl

1153: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1154: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used*/
1155: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll ,
1156: po_req_distributions_all prd ,
1157: po_requisition_lines_all prl
1158: WHERE poll.po_line_id = p_lines.po_line_id_tbl(i)
1159: AND prd.requisition_line_id = p_lines.requisition_line_id_tbl(i)
1160: AND prl.requisition_line_id = prd.requisition_line_id
1161: AND poll.payment_type <> 'ADVANCE';