DBA Data[Home] [Help]

APPS.CSP_REPAIR_PO_GRP dependencies on CSP_REPAIR_PO_HEADERS

Line 322: select csp_repair_po_headers_s1.nextval

318: FND_MSG_PUB.ADD;
319: RAISE EXCP_USER_DEFINED;
320: End;
321:
322: select csp_repair_po_headers_s1.nextval
323: into l_repair_po_header_id
324: from dual;
325:
326: /* In "CSP_PARTS_ORDER.PROCESS_PURCHASE_REQ" API inserting into

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

626: x_line_num := l_line_rec.line_num;
627: x_poreq_line_reservation_id := l_line_rec.reservation_id;
628: x_repair_po_line_id := l_line_rec.requirement_line_id;
629:
630: /* Insert into CSP_REPAIR_PO_HEADERS table the Requisition Header Id with the Item details */
631:
632: INSERT INTO CSP_REPAIR_PO_HEADERS
633: (REPAIR_PO_HEADER_ID
634: ,REQUISITION_HEADER_ID

Line 632: INSERT INTO CSP_REPAIR_PO_HEADERS

628: x_repair_po_line_id := l_line_rec.requirement_line_id;
629:
630: /* Insert into CSP_REPAIR_PO_HEADERS table the Requisition Header Id with the Item details */
631:
632: INSERT INTO CSP_REPAIR_PO_HEADERS
633: (REPAIR_PO_HEADER_ID
634: ,REQUISITION_HEADER_ID
635: ,PURCHASE_ORDER_HEADER_ID
636: ,INTERNAL_ORDER_HEADER_ID

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

908: begin
909: lv_retval := FND_INSTALLATION.GET_APP_INFO(
910: 'FND', lv_dummy1,lv_dummy2, v_applsys_schema);
911: lv_inv_schema := GET_SCHEMA_NAME(523);
912: CREATE_SNAP_LOG (lv_inv_schema,'CSP_REPAIR_PO_HEADERS',v_applsys_schema);
913: end CREATE_CSP_SNAP_LOG ;
914:
915:
916: Procedure create_csp_index (p_sql_stmt IN varchar2,p_object IN varchar2) is