APPS.CSP_PARTS_ORDER dependencies on PO_REQ_DISTRIBUTIONS

Line 1072: SELECT po_req_distributions_s.nextval

1068: FROM sys.dual;
1069:
1070: -- Cursor to get unique Distribution_id
1071: CURSOR dist_line_id_cur IS
1072: SELECT po_req_distributions_s.nextval
1073: FROM sys.dual;
1074:
1075: -- Cursor to get Accrual Account ID and Variance Account ID
1076: -- For Destination Type Code INVENTORY get accrual account id

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

1092: AND mic.organization_id = p_destination_org_id
1093: AND mic.category_set_id = mdsv.category_set_id
1094: AND mdsv.functional_area_id = 2;
1095:
1096: -- Get Set of Books ID for a given Org_ID - Mandatory in PO_REQ_DISTRIBUTIONS
1097:
1098: CURSOR set_of_books_cur (p_organization_id NUMBER) IS
1099: SELECT set_of_books_id
1100: FROM hr_operating_units

Line 1118: -- in PO_REQ_DISTRIBUTIONS

1114: AND mp.organization_id = msi.organization_id;
1115:
1116: -- Get Requisition Encumbrance Flag for the Set of Books
1117: -- Based on this flag Budget Account will be populated
1118: -- in PO_REQ_DISTRIBUTIONS
1119: CURSOR req_encumbrance_cur (p_set_of_books_id NUMBER) IS
1120: SELECT nvl (fsp.req_encumbrance_flag,'N')
1121: FROM financials_system_parameters fsp
1122: WHERE fsp.set_of_books_id = p_set_of_books_id;

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

1309: null;
1310: END;
1311:
1312: -- Get Set of Books Id.
1313: -- this is a required field for po_Req_distributions
1314: OPEN set_of_books_cur (l_org_id);
1315: FETCH set_of_books_cur INTO l_set_of_books_id;
1316: CLOSE set_of_books_cur;
1317:

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

2150:
2151: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2153: 'csp.plsql.csp_parts_order.process_order',
2154: 'Inserting data into po_req_distributions ...');
2155: end if;
2156:
2157: -- create po_req_distributions
2158: INSERT INTO po_req_distributions(

Line 2157: -- create po_req_distributions

2153: 'csp.plsql.csp_parts_order.process_order',
2154: 'Inserting data into po_req_distributions ...');
2155: end if;
2156:
2157: -- create po_req_distributions
2158: INSERT INTO po_req_distributions(
2159: distribution_id
2160: ,last_update_date
2161: ,last_updated_by

Line 2158: INSERT INTO po_req_distributions(

2154: 'Inserting data into po_req_distributions ...');
2155: end if;
2156:
2157: -- create po_req_distributions
2158: INSERT INTO po_req_distributions(
2159: distribution_id
2160: ,last_update_date
2161: ,last_updated_by
2162: ,requisition_line_id

Line 2378: update po_req_distributions

2374: set quantity = l_line_tbl(I).ordered_quantity
2375: where requisition_line_id = l_line_Tbl(I).requisition_line_id;
2376:
2377: -- update req distributions with new quantity
2378: update po_req_distributions
2379: set req_line_quantity = l_line_tbl(i).ordered_quantity
2380: where requisition_line_id = l_line_tbl(i).requisition_line_id;
2381:
2382: -- update mtl_supply data for the requisition

Line 2735: update po_req_distributions

2731: where requisition_line_id = lx_oe_line_Tbl(I).source_document_line_id;
2732:
2733:
2734: -- update req distributions
2735: update po_req_distributions
2736: set req_line_quantity = lx_oe_line_tbl(I).ordered_quantity
2737: where requisition_line_id = lx_oe_line_Tbl(I).source_document_line_id;
2738:
2739: