[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
P_PROGRAM_UPDATE_DATE DATE,
P_CLOSED_DATE DATE,
P_CLOSED_REASON VARCHAR2,
P_CLOSED_BY NUMBER,
P_TRANSACTION_REASON_CODE VARCHAR2,
P_ORG_ID NUMBER,
P_QC_GRADE VARCHAR2,
P_BASE_UOM VARCHAR2,
P_BASE_QTY NUMBER,
P_SECONDARY_UOM VARCHAR2,
P_SECONDARY_QTY NUMBER,
P_LINE_REFERENCE_NUM VARCHAR2,
P_PROJECT_ID NUMBER,
P_TASK_ID NUMBER,
P_EXPIRATION_DATE DATE,
P_TAX_CODE_ID NUMBER
) RETURN VARCHAR2
IS
BEGIN
/* This function has be customized not to default location taxes*/
NULL;
P_PROGRAM_UPDATE_DATE DATE,
P_USSGL_TRANSACTION_CODE VARCHAR2,
P_GOVERNMENT_CONTEXT VARCHAR2,
P_RECEIVING_ROUTING_ID NUMBER,
P_ACCRUE_ON_RECEIPT_FLAG VARCHAR2,
P_CLOSED_REASON VARCHAR2,
P_CLOSED_DATE DATE,
P_CLOSED_BY NUMBER,
P_ORG_ID NUMBER ,
P_QUANTITY_SHIPPED NUMBER,
P_COUNTRY_OF_ORIGIN_CODE VARCHAR2,
P_TAX_USER_OVERRIDE_FLAG VARCHAR2,
P_MATCH_OPTION VARCHAR2,
P_TAX_CODE_ID NUMBER,
P_CALCULATE_TAX_FLAG VARCHAR2,
P_CHANGE_PROMISED_DATE_REASON VARCHAR2
) RETURN VARCHAR2
IS
BEGIN
/* This function has be customized not to default location taxes*/
NULL;
FUNCTION oe_lines_insert
(p_line_id NUMBER,
p_org_id NUMBER,
p_line_type_id NUMBER,
p_ship_from_org_id NUMBER,
p_ship_to_org_id NUMBER,
p_invoice_to_org_id NUMBER,
p_sold_to_org_id NUMBER,
p_sold_from_org_id NUMBER,
p_inventory_item_id NUMBER,
p_tax_code VARCHAR2,
p_price_list_id NUMBER,
p_source_document_type_id NUMBER,
p_source_document_line_id NUMBER,
p_reference_line_id NUMBER,
p_reference_header_id NUMBER,
p_salesrep_id NUMBER,
p_order_source_id NUMBER,
p_orig_sys_document_ref VARCHAR2,
p_orig_sys_line_ref VARCHAR2) RETURN VARCHAR2 IS
v_return VARCHAR2(1996);
FILENAME: jai_cmn_hook_pkg.oe_lines_insert.sql
CHANGE HISTORY:
S.No Date Author and Details
1 2002/06/13 Asshukla Function created
--------------------------------------------------------------------------------------------*/
/* this portion of the function is to be used for the customised component,
based on the return value the trigger JA_IN_OE_ORDER_LINES_AIU_TRG will function
the function should return "FALSE" so as not to execute procedure and "TRUE" to run the procedure.
Check for the impact on the trigger JA_IN_OE_ORDER_LINES_AIU_TRG before changing return value.
the functional currency of the operating unit has to be INR*/
NULL;
END oe_lines_insert;
LAST_UPDATE_DATE DATE,
LAST_UPDATED_BY NUMBER,
SOURCE_TYPE_CODE VARCHAR2,
LAST_UPDATE_LOGIN NUMBER,
CREATION_DATE DATE,
CREATED_BY NUMBER,
ITEM_ID NUMBER,
ITEM_REVISION VARCHAR2,
QUANTITY_DELIVERED NUMBER,
SUGGESTED_BUYER_ID NUMBER,
ENCUMBERED_FLAG VARCHAR2,
RFQ_REQUIRED_FLAG VARCHAR2,
NEED_BY_DATE DATE,
LINE_LOCATION_ID NUMBER,
MODIFIED_BY_AGENT_FLAG VARCHAR2,
PARENT_REQ_LINE_ID NUMBER,
JUSTIFICATION VARCHAR2,
NOTE_TO_AGENT VARCHAR2,
NOTE_TO_RECEIVER VARCHAR2,
PURCHASING_AGENT_ID NUMBER,
DOCUMENT_TYPE_CODE VARCHAR2,
BLANKET_PO_HEADER_ID NUMBER,
BLANKET_PO_LINE_NUM NUMBER,
CURRENCY_CODE VARCHAR2,
RATE_TYPE VARCHAR2,
RATE_DATE DATE,
RATE NUMBER,
CURRENCY_UNIT_PRICE NUMBER,
SUGGESTED_VENDOR_NAME VARCHAR2,
SUGGESTED_VENDOR_LOCATION VARCHAR2,
SUGGESTED_VENDOR_CONTACT VARCHAR2,
SUGGESTED_VENDOR_PHONE VARCHAR2,
SUGGESTED_VENDOR_PRODUCT_CODE VARCHAR2,
UN_NUMBER_ID NUMBER,
HAZARD_CLASS_ID NUMBER,
MUST_USE_SUGG_VENDOR_FLAG VARCHAR2,
REFERENCE_NUM VARCHAR2,
ON_RFQ_FLAG VARCHAR2,
URGENT_FLAG VARCHAR2,
CANCEL_FLAG VARCHAR2,
SOURCE_ORGANIZATION_ID NUMBER,
SOURCE_SUBINVENTORY VARCHAR2,
DESTINATION_TYPE_CODE VARCHAR2,
DESTINATION_ORGANIZATION_ID NUMBER,
DESTINATION_SUBINVENTORY VARCHAR2,
QUANTITY_CANCELLED NUMBER,
CANCEL_DATE DATE,
CANCEL_REASON VARCHAR2,
CLOSED_CODE VARCHAR2,
AGENT_RETURN_NOTE VARCHAR2,
CHANGED_AFTER_RESEARCH_FLAG VARCHAR2,
VENDOR_ID NUMBER,
VENDOR_SITE_ID NUMBER,
VENDOR_CONTACT_ID NUMBER,
RESEARCH_AGENT_ID NUMBER,
ON_LINE_FLAG VARCHAR2,
WIP_ENTITY_ID NUMBER,
WIP_LINE_ID NUMBER,
WIP_REPETITIVE_SCHEDULE_ID NUMBER,
WIP_OPERATION_SEQ_NUM NUMBER,
WIP_RESOURCE_SEQ_NUM NUMBER,
ATTRIBUTE_CATEGORY VARCHAR2,
DESTINATION_CONTEXT VARCHAR2,
INVENTORY_SOURCE_CONTEXT VARCHAR2,
VENDOR_SOURCE_CONTEXT VARCHAR2,
ATTRIBUTE1 VARCHAR2,
ATTRIBUTE2 VARCHAR2,
ATTRIBUTE3 VARCHAR2,
ATTRIBUTE4 VARCHAR2,
ATTRIBUTE5 VARCHAR2,
ATTRIBUTE6 VARCHAR2,
ATTRIBUTE7 VARCHAR2,
ATTRIBUTE8 VARCHAR2,
ATTRIBUTE9 VARCHAR2,
ATTRIBUTE10 VARCHAR2,
ATTRIBUTE11 VARCHAR2,
ATTRIBUTE12 VARCHAR2,
ATTRIBUTE13 VARCHAR2,
ATTRIBUTE14 VARCHAR2,
ATTRIBUTE15 VARCHAR2,
BOM_RESOURCE_ID NUMBER,
CLOSED_REASON VARCHAR2,
CLOSED_DATE DATE,
TRANSACTION_REASON_CODE VARCHAR2,
QUANTITY_RECEIVED NUMBER,
SOURCE_REQ_LINE_ID NUMBER,
ORG_ID NUMBER,
KANBAN_CARD_ID NUMBER,
CATALOG_TYPE VARCHAR2,
CATALOG_SOURCE VARCHAR2,
MANUFACTURER_ID NUMBER,
MANUFACTURER_NAME VARCHAR2,
MANUFACTURER_PART_NUMBER VARCHAR2,
REQUESTER_EMAIL VARCHAR2,
REQUESTER_FAX VARCHAR2,
REQUESTER_PHONE VARCHAR2,
UNSPSC_CODE VARCHAR2,
OTHER_CATEGORY_CODE VARCHAR2,
SUPPLIER_DUNS VARCHAR2,
TAX_STATUS_INDICATOR VARCHAR2,
PCARD_FLAG VARCHAR2,
NEW_SUPPLIER_FLAG VARCHAR2,
AUTO_RECEIVE_FLAG VARCHAR2,
TAX_USER_OVERRIDE_FLAG VARCHAR2,
TAX_CODE_ID NUMBER,
NOTE_TO_VENDOR VARCHAR2,
OKE_CONTRACT_VERSION_ID NUMBER,
OKE_CONTRACT_HEADER_ID NUMBER,
ITEM_SOURCE_ID NUMBER,
SUPPLIER_REF_NUMBER VARCHAR2,
SECONDARY_UNIT_OF_MEASURE VARCHAR2,
SECONDARY_QUANTITY NUMBER,
PREFERRED_GRADE VARCHAR2,
SECONDARY_QUANTITY_RECEIVED NUMBER,
SECONDARY_QUANTITY_CANCELLED NUMBER,
VMI_FLAG VARCHAR2,
AUCTION_HEADER_ID NUMBER,
AUCTION_DISPLAY_NUMBER VARCHAR2,
AUCTION_LINE_NUMBER NUMBER,
REQS_IN_POOL_FLAG VARCHAR2,
BID_NUMBER NUMBER,
BID_LINE_NUMBER NUMBER,
NONCAT_TEMPLATE_ID NUMBER,
SUGGESTED_VENDOR_CONTACT_FAX VARCHAR2,
SUGGESTED_VENDOR_CONTACT_EMAIL VARCHAR2,
AMOUNT NUMBER,
CURRENCY_AMOUNT NUMBER,
LABOR_REQ_LINE_ID NUMBER,
JOB_ID NUMBER,
JOB_LONG_DESCRIPTION VARCHAR2,
CONTRACTOR_STATUS VARCHAR2,
CONTACT_INFORMATION VARCHAR2,
SUGGESTED_SUPPLIER_FLAG VARCHAR2,
CANDIDATE_SCREENING_REQD_FLAG VARCHAR2,
CANDIDATE_FIRST_NAME VARCHAR2,
CANDIDATE_LAST_NAME VARCHAR2,
ASSIGNMENT_END_DATE DATE,
OVERTIME_ALLOWED_FLAG VARCHAR2,
CONTRACTOR_REQUISITION_FLAG VARCHAR2,
DROP_SHIP_FLAG VARCHAR2,
ASSIGNMENT_START_DATE DATE,
ORDER_TYPE_LOOKUP_CODE VARCHAR2,
PURCHASE_BASIS VARCHAR2,
MATCHING_BASIS VARCHAR2,
NEGOTIATED_BY_PREPARER_FLAG VARCHAR2,
SHIP_METHOD VARCHAR2,
ESTIMATED_PICKUP_DATE DATE,
SUPPLIER_NOTIFIED_FOR_CANCEL VARCHAR2,
BASE_UNIT_PRICE NUMBER,
AT_SOURCING_FLAG VARCHAR2,
EVENT_ID NUMBER,
LINE_NUMBER NUMBER
) RETURN VARCHAR2 IS
BEGIN
/* This function has be customized not to default location taxes*/
NULL;