DBA Data[Home] [Help]

APPS.CSP_REPAIR_PO_GRP dependencies on CSP_REPAIR_PO_HEADERS

Line 327: select csp_repair_po_headers_s1.nextval

323: FND_MSG_PUB.ADD;
324: RAISE EXCP_USER_DEFINED;
325: End;
326:
327: select csp_repair_po_headers_s1.nextval
328: into l_repair_po_header_id
329: from dual;
330:
331: /* In "CSP_PARTS_ORDER.PROCESS_PURCHASE_REQ" API inserting into

Line 637: /* Insert into CSP_REPAIR_PO_HEADERS table the Requisition Header Id with the Item details */

633: x_line_num := l_line_rec.line_num;
634: x_poreq_line_reservation_id := l_line_rec.reservation_id;
635: x_repair_po_line_id := l_line_rec.requirement_line_id;
636:
637: /* Insert into CSP_REPAIR_PO_HEADERS table the Requisition Header Id with the Item details */
638:
639: INSERT INTO CSP_REPAIR_PO_HEADERS
640: (REPAIR_PO_HEADER_ID
641: ,REQUISITION_HEADER_ID

Line 639: INSERT INTO CSP_REPAIR_PO_HEADERS

635: x_repair_po_line_id := l_line_rec.requirement_line_id;
636:
637: /* Insert into CSP_REPAIR_PO_HEADERS table the Requisition Header Id with the Item details */
638:
639: INSERT INTO CSP_REPAIR_PO_HEADERS
640: (REPAIR_PO_HEADER_ID
641: ,REQUISITION_HEADER_ID
642: ,PURCHASE_ORDER_HEADER_ID
643: ,INTERNAL_ORDER_HEADER_ID

Line 921: CREATE_SNAP_LOG (lv_inv_schema,'CSP_REPAIR_PO_HEADERS',v_applsys_schema);

917: begin
918: lv_retval := FND_INSTALLATION.GET_APP_INFO(
919: 'FND', lv_dummy1,lv_dummy2, v_applsys_schema);
920: lv_inv_schema := GET_SCHEMA_NAME(523);
921: CREATE_SNAP_LOG (lv_inv_schema,'CSP_REPAIR_PO_HEADERS',v_applsys_schema);
922: end CREATE_CSP_SNAP_LOG ;
923:
924:
925: Procedure create_csp_index (p_sql_stmt IN varchar2,p_object IN varchar2) is