[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT count(*)
INTO x_temp
FROM po_headers
WHERE segment1 = x_segment1
AND type_lookup_code in ('BLANKET', 'CONTRACT', 'PLANNED', 'STANDARD')
AND (rowid <> x_rowid OR x_rowid is null);
SELECT count(*)
INTO x_temp
FROM po_headers
WHERE segment1 = x_segment1
AND type_lookup_code = X_type_lookup_code
AND (rowid <> x_rowid OR x_rowid is null);
SELECT COUNT(*)
INTO x_temp
FROM po_headers
WHERE po_header_id = x_po_header_id
AND (rowid <> x_rowid OR x_rowid is null);
SELECT fsp.set_of_books_id
INTO X_set_of_books_id
FROM financials_system_parameters fsp,
gl_sets_of_books sob
WHERE fsp.set_of_books_id = sob.set_of_books_id;
SELECT count(*)
INTO x_temp
FROM po_lookup_codes
WHERE lookup_type = X_lookup_type
AND sysdate < nvl(inactive_date, sysdate+1)
AND lookup_code = X_lookup_code;
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATED_BY IN NUMBER,
X_SEGMENT1 IN VARCHAR2,
X_SUMMARY_FLAG IN VARCHAR2,
X_ENABLED_FLAG IN VARCHAR2,
X_SEGMENT2 IN VARCHAR2,
X_SEGMENT3 IN VARCHAR2,
X_SEGMENT4 IN VARCHAR2,
X_SEGMENT5 IN VARCHAR2,
X_START_DATE_ACTIVE IN DATE,
X_END_DATE_ACTIVE IN DATE,
X_LAST_UPDATE_LOGIN IN NUMBER,
X_CREATION_DATE IN DATE,
X_CREATED_BY IN NUMBER,
X_VENDOR_ID IN NUMBER,
X_VENDOR_SITE_ID IN NUMBER,
X_VENDOR_CONTACT_ID IN NUMBER,
X_SHIP_TO_LOCATION_ID IN NUMBER,
X_BILL_TO_LOCATION_ID IN NUMBER,
X_TERMS_ID IN NUMBER,
X_SHIP_VIA_LOOKUP_CODE IN VARCHAR2,
X_FOB_LOOKUP_CODE IN VARCHAR2,
X_FREIGHT_TERMS_LOOKUP_CODE IN VARCHAR2,
X_STATUS_LOOKUP_CODE IN VARCHAR2,
X_CURRENCY_CODE IN VARCHAR2,
X_RATE_TYPE IN VARCHAR2,
X_RATE_DATE IN DATE,
X_RATE IN NUMBER,
X_FROM_HEADER_ID IN NUMBER,
X_FROM_TYPE_LOOKUP_CODE IN VARCHAR2,
X_START_DATE IN DATE,
X_END_DATE IN DATE,
X_BLANKET_TOTAL_AMOUNT IN NUMBER,
X_AUTHORIZATION_STATUS IN VARCHAR2,
X_REVISION_NUM IN NUMBER,
-- Bug 902976, zxzhang, 10/04/99
-- Change REVISED_DATE from VarChar(25) to Date.
-- X_REVISED_DATE IN VARCHAR2,
X_REVISED_DATE IN DATE,
X_APPROVED_FLAG IN VARCHAR2,
X_APPROVED_DATE IN DATE,
X_AMOUNT_LIMIT IN NUMBER,
X_MIN_RELEASE_AMOUNT IN NUMBER,
X_NOTE_TO_AUTHORIZER IN VARCHAR2,
X_NOTE_TO_VENDOR IN VARCHAR2,
X_NOTE_TO_RECEIVER IN VARCHAR2,
X_PRINT_COUNT IN NUMBER,
X_PRINTED_DATE IN DATE,
X_VENDOR_ORDER_NUM IN VARCHAR2,
X_CONFIRMING_ORDER_FLAG IN VARCHAR2,
X_COMMENTS IN VARCHAR2,
X_REPLY_DATE IN DATE,
X_REPLY_METHOD_LOOKUP_CODE IN VARCHAR2,
X_RFQ_CLOSE_DATE IN DATE,
X_QUOTE_TYPE_LOOKUP_CODE IN VARCHAR2,
X_QUOTATION_CLASS_CODE IN VARCHAR2,
X_QUOTE_WARNING_DELAY IN NUMBER,
X_QUOTE_VENDOR_QUOTE_NUM IN VARCHAR2,
X_ACCEPTANCE_REQUIRED_FLAG IN VARCHAR2,
X_ACCEPTANCE_DUE_DATE IN DATE,
X_CLOSED_DATE IN DATE,
X_USER_HOLD_FLAG IN VARCHAR2,
X_APPROVAL_REQUIRED_FLAG IN VARCHAR2,
X_CANCEL_FLAG IN VARCHAR2,
X_FIRM_STATUS_LOOKUP_CODE IN VARCHAR2,
X_FIRM_DATE IN DATE,
X_FROZEN_FLAG IN VARCHAR2,
X_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_ATTRIBUTE1 IN VARCHAR2,
X_ATTRIBUTE2 IN VARCHAR2,
X_ATTRIBUTE3 IN VARCHAR2,
X_ATTRIBUTE4 IN VARCHAR2,
X_ATTRIBUTE5 IN VARCHAR2,
X_ATTRIBUTE6 IN VARCHAR2,
X_ATTRIBUTE7 IN VARCHAR2,
X_ATTRIBUTE8 IN VARCHAR2,
X_ATTRIBUTE9 IN VARCHAR2,
X_ATTRIBUTE10 IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_CLOSED_CODE IN VARCHAR2,
X_USSGL_TRANSACTION_CODE IN VARCHAR2,
X_GOVERNMENT_CONTEXT IN VARCHAR2,
X_REQUEST_ID IN NUMBER,
X_PROGRAM_APPLICATION_ID IN NUMBER,
X_PROGRAM_ID IN NUMBER,
X_PROGRAM_UPDATE_DATE IN DATE,
X_INTERFACE_SOURCE_CODE IN VARCHAR2,
X_INTERFACE_HEADER_ID IN NUMBER,
X_REFERENCE_NUM IN VARCHAR2,
X_ORG_ID IN NUMBER,
X_QUOTE_WARNING_DELAY_UNIT IN VARCHAR2,
X_APPROVAL_STATUS IN VARCHAR2,
X_release_num IN NUMBER,
X_po_release_id IN NUMBER,
X_release_date IN DATE,
X_manual_quote_num_type IN VARCHAR2,
X_manual_po_num_type IN VARCHAR2,
X_amount_agreed IN NUMBER,
X_base_currency_code IN VARCHAR2,
X_chart_of_accounts_id IN NUMBER,
X_def_inv_org_id IN NUMBER,
X_header_processable_flag IN OUT NOCOPY VARCHAR2,
X_action_code IN VARCHAR2,
p_shipping_control IN VARCHAR2 --
)
IS
X_progress VARCHAR2(3) := NULL;
SELECT count(*)
INTO x_temp_count
FROM po_document_types
WHERE document_type_code = X_type_lookup_code
AND document_subtype = x_quote_type_lookup_code;
IF (X_action_code <> 'UPDATE' AND X_revision_num <> 0) THEN
po_interface_errors_sv1.handle_interface_errors(
'PO_DOCS_OPEN_INTERFACE',
'FATAL',
null,
X_interface_header_id,
X_interface_line_id,
'PO_PDOI_COLUMN_NOT_ZERO',
'PO_HEADERS_INTERFACE',
'REVISION_NUM',
'COLUMN_NAME',
null,null,null,null,null,
'REVISION_NUM',
null,null,null,null,null,
x_header_processable_flag);
IF (X_last_updated_by IS NULL ) THEN
po_interface_errors_sv1.handle_interface_errors(
'PO_DOCS_OPEN_INTERFACE',
'FATAL',
null,
X_interface_header_id,
X_interface_line_id,
'PO_PDOI_COLUMN_NOT_NULL',
'PO_HEADERS_INTERFACE',
'LAST_UPDATED_BY',
'COLUMN_NAME',
null,null,null,null,null,
'LAST_UPDATED_BY',
null,null,null,null,null,
x_header_processable_flag);
IF (X_last_update_date IS NULL ) THEN
po_interface_errors_sv1.handle_interface_errors(
'PO_DOCS_OPEN_INTERFACE',
'FATAL',
null,
X_interface_header_id,
X_interface_line_id,
'PO_PDOI_COLUMN_NOT_NULL',
'PO_HEADERS_INTERFACE',
'LAST_UPDATE_DATE',
'COLUMN_NAME',
null,null,null,null,null,
'LAST_UPDATE_DATE',
null,null,null,null,null,
x_header_processable_flag);