APPS.ICX_PO_REQ_ACCT2 dependencies on PO_REQ_DISTRIBUTIONS

Line 25: from po_req_distributions a,

21: l_account_id number;
22:
23: cursor dist_acct is
24: select a.code_combination_id code_combination_id
25: from po_req_distributions a,
26: po_requisition_lines b,
27: po_requisition_headers c
28: where a.requisition_line_id = v_cart_line_id
29: and a.requisition_line_id = b.requisition_line_id

Line 202: from po_req_distributions a,

198: -- end
199:
200: cursor get_dist_num is
201: select max(a.distribution_num)
202: from po_req_distributions a,
203: po_requisition_lines b,
204: po_requisition_headers c
205: where a.requisition_line_id = v_cart_line_id
206: and b.requisition_line_id = a.requisition_line_id

Line 303: select po_req_distributions_s.nextval into v_distribution_id

299: fetch set_of_books into v_set_of_books_id;
300: close set_of_books;
301:
302: -- bug 689962
303: select po_req_distributions_s.nextval into v_distribution_id
304: from sys.dual;
305: -- end
306:
307: -- Insert the new column in po_req_distribution

Line 308: INSERT INTO po_req_distributions (distribution_id,

304: from sys.dual;
305: -- end
306:
307: -- Insert the new column in po_req_distribution
308: INSERT INTO po_req_distributions (distribution_id,
309: last_update_date,
310: last_updated_by,
311: requisition_line_id,
312: set_of_books_id,

Line 339: UPDATE po_req_distributions

335: -- Update the various other accounts
336: -- The budget and variance accounts are updated with the
337: -- code combination id. This is becuase the Web Reqs alwyas use
338: -- 'EXPENSE' as the destination_type_code.
339: UPDATE po_req_distributions
340: SET accrual_account_id=
341: (SELECT accrued_code_combination_id
342: FROM po_system_parameters),
343: budget_account_id = v_account_id,

Line 390: update po_req_distributions a

386: ACCRUAL_ACCOUNT_ID => v_accrual_acct_id,
387: RETURN_CODE => l_return_code);
388:
389: -- Update the custom returned value if the values are not null
390: update po_req_distributions a
391: set a.ACCRUAL_ACCOUNT_ID = NVL(v_accrual_acct_id, a.accrual_account_id),
392: a.VARIANCE_ACCOUNT_ID = NVL(v_variance_acct_id, a.variance_account_id),
393: a.BUDGET_ACCOUNT_ID = NVL(v_budget_acct_id, a.budget_account_id)
394: where a.requisition_line_id = v_cart_line_id

Line 828: from po_req_distributions a,

824: l_line_number number := NULL;
825:
826: cursor get_dist_num(cartline_id number,oo_id number) is
827: select max(a.distribution_num)
828: from po_req_distributions a,
829: po_requisition_lines b,
830: po_requisition_headers c
831: where a.requisition_line_id = cartline_id
832: and a.requisition_line_id = b.requisition_line_id

Line 961: from po_req_distributions a,

957: l_dist_number number := NULL;
958:
959: cursor get_dist_number(reqline_id number,oo_id number) is
960: select max(a.distribution_num)
961: from po_req_distributions a,
962: po_requisition_lines b,
963: po_requisition_headers c
964: where a.requisition_line_id = reqline_id
965: and a.requisition_line_id = b.requisition_line_id