APPS.CSP_PARTS_ORDER dependencies on PO_REQ_DISTRIBUTIONS

Line 1194: SELECT po_req_distributions_s.nextval

1190: FROM sys.dual;
1191:
1192: -- Cursor to get unique Distribution_id
1193: CURSOR dist_line_id_cur IS
1194: SELECT po_req_distributions_s.nextval
1195: FROM sys.dual;
1196:
1197: -- Cursor to get Accrual Account ID and Variance Account ID
1198: -- For Destination Type Code INVENTORY get accrual account id

Line 1218: -- Get Set of Books ID for a given Org_ID - Mandatory in PO_REQ_DISTRIBUTIONS

1214: AND mic.organization_id = p_destination_org_id
1215: AND mic.category_set_id = mdsv.category_set_id
1216: AND mdsv.functional_area_id = 2;
1217:
1218: -- Get Set of Books ID for a given Org_ID - Mandatory in PO_REQ_DISTRIBUTIONS
1219:
1220: CURSOR set_of_books_cur (p_organization_id NUMBER) IS
1221: SELECT set_of_books_id
1222: FROM hr_operating_units

Line 1240: -- in PO_REQ_DISTRIBUTIONS

1236: AND mp.organization_id = msi.organization_id;
1237:
1238: -- Get Requisition Encumbrance Flag for the Set of Books
1239: -- Based on this flag Budget Account will be populated
1240: -- in PO_REQ_DISTRIBUTIONS
1241: CURSOR req_encumbrance_cur (p_set_of_books_id NUMBER) IS
1242: SELECT nvl (fsp.req_encumbrance_flag,'N')
1243: FROM financials_system_parameters fsp
1244: WHERE fsp.set_of_books_id = p_set_of_books_id;

Line 1718: -- this is a required field for po_Req_distributions

1714: null;
1715: END;
1716:
1717: -- Get Set of Books Id.
1718: -- this is a required field for po_Req_distributions
1719: OPEN set_of_books_cur (l_org_id);
1720: FETCH set_of_books_cur INTO l_set_of_books_id;
1721: CLOSE set_of_books_cur;
1722:

Line 3375: 'Inserting data into po_req_distributions ...');

3371: 'prevent_encumbrance_flag = ' || l_dist_rec.prevent_encumbrance_flag
3372: || ', encumbered_flag = ' || l_dist_rec.encumbered_flag);
3373: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3374: 'csp.plsql.csp_parts_order.process_order',
3375: 'Inserting data into po_req_distributions ...');
3376: end if;
3377:
3378: -- create po_req_distributions
3379: INSERT INTO po_req_distributions(

Line 3378: -- create po_req_distributions

3374: 'csp.plsql.csp_parts_order.process_order',
3375: 'Inserting data into po_req_distributions ...');
3376: end if;
3377:
3378: -- create po_req_distributions
3379: INSERT INTO po_req_distributions(
3380: distribution_id
3381: ,last_update_date
3382: ,last_updated_by

Line 3379: INSERT INTO po_req_distributions(

3375: 'Inserting data into po_req_distributions ...');
3376: end if;
3377:
3378: -- create po_req_distributions
3379: INSERT INTO po_req_distributions(
3380: distribution_id
3381: ,last_update_date
3382: ,last_updated_by
3383: ,requisition_line_id

Line 3643: update po_req_distributions

3639: set quantity = l_line_tbl(I).ordered_quantity
3640: where requisition_line_id = l_line_Tbl(I).requisition_line_id;
3641:
3642: -- update req distributions with new quantity
3643: update po_req_distributions
3644: set req_line_quantity = l_line_tbl(i).ordered_quantity
3645: where requisition_line_id = l_line_tbl(i).requisition_line_id;
3646:
3647: -- update mtl_supply data for the requisition

Line 4199: update po_req_distributions

4195: where requisition_line_id = lx_oe_line_Tbl(I).source_document_line_id;
4196:
4197:
4198: -- update req distributions
4199: update po_req_distributions
4200: set req_line_quantity = lx_oe_line_tbl(I).ordered_quantity
4201: where requisition_line_id = lx_oe_line_Tbl(I).source_document_line_id;
4202:
4203: