The following lines contain the word 'select', 'insert', 'update' or 'delete':
FND_API.g_attr_tbl.DELETE;
FND_API.g_attr_tbl(I).name := 'last_updated_by';
FND_API.g_attr_tbl(I).name := 'last_update_date';
FND_API.g_attr_tbl(I).name := 'last_update_login';
FND_API.g_attr_tbl(I).name := 'program_update_date';
FND_API.g_attr_tbl(I).name := 'updated_flag';
FND_API.g_attr_tbl(I).name := 'update_allowed';
FND_API.g_attr_tbl(I).name := 'dw_update_advice';
FND_API.g_attr_tbl(I).name := 'wh_update_date';
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'HEADER_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORG_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
/* SELECT 'VALID'
INTO l_dummy
FROM OE_ORDER_TYPES_V
WHERE ORDER_TYPE_ID = p_order_type_id
AND SYSDATE BETWEEN NVL( START_DATE_ACTIVE, SYSDATE )
AND NVL( END_DATE_ACTIVE, SYSDATE );
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDER_TYPE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
select type into t
from FND_DOCUMENT_SEQUENCES
where DOC_SEQUENCE_ID = x_doc_sequence_id;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDER_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'VERSION_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'EXPIRATION_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_ORDER_SOURCES
WHERE ORDER_SOURCE_ID = p_order_source_id
AND ENABLED_FLAG = 'Y';
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDER_SOURCE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_ORDER_SOURCES
WHERE ORDER_SOURCE_ID = p_source_document_type_id
AND ENABLED_FLAG = 'Y';
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOURCE_DOCUMENT_TYPE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_source_type_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOURCE_TYPE_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOURCE_DOCUMENT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORIG_SYS_DOCUMENT_REF');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DATE_ORDERED');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DATE_REQUESTED');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_shipment_priority_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPMENT_PRIORITY_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_FND_COMMON_LOOKUPS_V
WHERE LOOKUP_CODE = p_demand_class_code
AND LOOKUP_TYPE = l_lookup_type
AND APPLICATION_ID = 700
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DEMAND_CLASS_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
/*SELECT 'VALID'
INTO l_dummy
FROM qp_list_headers_vl
WHERE list_header_id = p_price_list_id
and list_type_code in ('PRL', 'AGR') and
nvl(active_flag,'Y') ='Y';
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_LIST_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM fnd_lookups
WHERE LOOKUP_CODE = p_tax_exempt_flag
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_EXEMPT_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_EXEMPT_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM fnd_lookups
WHERE LOOKUP_CODE = p_tax_exempt_reason_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_EXEMPT_REASON_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONVERSION_RATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_PREFERENCE_SET_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_GL_DAILY_CONVERSION_TYPES_V
WHERE CONVERSION_TYPE = p_conversion_type_code;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONVERSION_TYPE_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONVERSION_RATE_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_FND_COMMON_LOOKUPS_V
WHERE LOOKUP_CODE = p_partial_shipments_allowed
AND LOOKUP_TYPE = l_lookup_type
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE );
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PARTIAL_SHIPMENTS_ALLOWED');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIP_TOLERANCE_ABOVE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIP_TOLERANCE_BELOW');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPABLE_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_INTERFACED_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_INSTRUCTIONS');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAQCKING_INSTRUCTIONS');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UNDER_SHIPMENT_TOLERANCE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OVER_SHIPMENT_TOLERANCE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OVER_RETURN_TOLERANCE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UNDER_RETURN_TOLERANCE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_FND_CURRENCIES_V
WHERE CURRENCY_CODE = p_transactional_curr_code
AND CURRENCY_FLAG = 'Y'
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TRANSACTIONAL_CURR_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_AGREEMENTS_B A
WHERE A.AGREEMENT_ID = p_agreement_id;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'AGREEMENT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_tax_point_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_POINT_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUST_PO_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_RA_RULES_V
WHERE RULE_ID = p_invoicing_rule_id
AND STATUS = 'A'
AND TYPE = 'I';
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVOICING_RULE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
/*SELECT 'VALID'
INTO l_dummy
FROM OE_RA_TERMS_V
WHERE TERM_ID = p_payment_term_id
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAYMENT_TERM_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context
(p_attribute_code => 'PLANNING_PRIORITY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_SHIP_METHODS_V
WHERE lookup_code = p_shipping_method_code
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE)
AND ROWNUM = 1;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FREIGHT_CARRIER_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_AR_LOOKUPS_V
WHERE LOOKUP_CODE = p_fob_point_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FOB_POINT_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_freight_terms_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FREIGHT_TERMS_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_SOLD_TO_ORGS_V
WHERE ORGANIZATION_ID =p_sold_to_org_id
AND STATUS = 'A'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOLD_TO_ORG_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM HZ_CONTACT_POINTS
WHERE CONTACT_POINT_ID =p_sold_to_phone_id
AND STATUS = 'A';
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOLD_TO_PHONE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_SOLD_TO_ORGS_V
WHERE ORGANIZATION_ID =p_customer_id
AND STATUS = 'A'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INTERNAL_ITEM_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUST_ITEM_SETTING_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIP_FROM_ORG_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SUBINVENTORY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVENTORY_ORG_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIP_TO_ORG_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SITE_USE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INTERMED_SHIP_TO_ORG_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
/*SELECT 'VALID'
INTO l_dummy
FROM OE_INVOICE_TO_ORGS_V INV
WHERE INV.ORGANIZATION_ID =p_invoice_to_org_id
AND INV.STATUS = 'A'
AND INV.ADDRESS_STATUS ='A' --bug 2752321
AND SYSDATE BETWEEN NVL(INV.START_DATE_ACTIVE, SYSDATE)
AND NVL(INV.END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVOICE_TO_ORG_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_DELIVER_TO_ORGS_V DEL
WHERE DEL.ORGANIZATION_ID =p_deliver_to_org_id
AND DEL.STATUS = 'A'
AND DEL.ADDRESS_STATUS ='A' --bug 2752321
AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)
AND NVL(DEL.END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DELIVER_TO_ORG_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM HZ_CUST_ACCOUNT_ROLES
WHERE CUST_ACCOUNT_ROLE_ID = p_sold_to_contact_id
AND ROLE_TYPE = 'CONTACT'
AND STATUS = 'A';
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOLD_TO_CONTACT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_ROLE_RESPONSIBILITY ROL
WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_ship_to_contact_id
AND ACCT_ROLE.STATUS = 'A'
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = ROL.CUST_ACCOUNT_ROLE_ID (+)
AND NVL( ROL.RESPONSIBILITY_TYPE,l_resp_type)=l_resp_type;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIP_TO_CONTACT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_ROLE_RESPONSIBILITY ROL
WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_intermed_ship_to_contact_id
AND ACCT_ROLE.STATUS = 'A'
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = ROL.CUST_ACCOUNT_ROLE_ID (+)
AND NVL( ROL.RESPONSIBILITY_TYPE,l_resp_type)=l_resp_type;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INTERMED_SHIP_TO_CONTACT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_ROLE_RESPONSIBILITY ROL
WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_invoice_to_contact_id
AND ACCT_ROLE.STATUS = 'A'
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = ROL.CUST_ACCOUNT_ROLE_ID (+)
AND NVL( ROL.RESPONSIBILITY_TYPE,l_resp_type)=l_resp_type;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVOICE_TO_CONTACT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_ROLE_RESPONSIBILITY ROL
WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_deliver_to_contact_id
AND ACCT_ROLE.STATUS = 'A'
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = ROL.CUST_ACCOUNT_ROLE_ID (+)
AND NVL( ROL.RESPONSIBILITY_TYPE,'DELIVER_TO') in ('DELIVER_TO','SHIP_TO');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DELIVER_TO_CONTACT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
FUNCTION Last_Updated_By ( p_last_updated_by IN NUMBER )
RETURN BOOLEAN
IS
l_dummy VARCHAR2(10);
IF p_last_updated_by IS NULL OR
p_last_updated_by = FND_API.G_MISS_NUM
THEN
RETURN TRUE;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATED_BY');
OE_Order_Util.Get_Attribute_Name('last_updated_by'));
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
, 'Last_Updated_By'
);
END Last_Updated_By;
FUNCTION Last_Update_Date ( p_last_update_date IN DATE )
RETURN BOOLEAN
IS
l_dummy VARCHAR2(10);
IF p_last_update_date IS NULL OR
p_last_update_date = FND_API.G_MISS_DATE
THEN
RETURN TRUE;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATE_DATE');
OE_Order_Util.Get_Attribute_Name('last_update_date'));
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
, 'Last_Update_Date'
);
END Last_Update_Date;
FUNCTION Last_Update_Login ( p_last_update_login IN NUMBER )
RETURN BOOLEAN
IS
l_dummy VARCHAR2(10);
IF p_last_update_login IS NULL OR
p_last_update_login = FND_API.G_MISS_NUM
THEN
RETURN TRUE;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATE_LOGIN');
OE_Order_Util.Get_Attribute_Name('last_update_login'));
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
, 'Last_Update_Login'
);
END Last_Update_Login;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_APPLICATION_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
FUNCTION Program_Update_Date ( p_program_update_date IN DATE )
RETURN BOOLEAN
IS
l_dummy VARCHAR2(10);
IF p_program_update_date IS NULL OR
p_program_update_date = FND_API.G_MISS_DATE
THEN
RETURN TRUE;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_UPDATE_DATE');
OE_Order_Util.Get_Attribute_Name('program_update_date'));
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
, 'Program_Update_Date'
);
END Program_Update_Date;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REQUEST_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'GLOBAL_ATTRIBUTE1');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_ADJUSTMENT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DISCOUNT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DISCOUNT_LINE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'AUTOMATIC_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PERCENT');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LINE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPLIED_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_change_reason_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_TEXT');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_HEADER_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_LINE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_LINE_TYPE_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIED_FROM');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIED_TO');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIER_MECHANISM_TYPE_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
FUNCTION Updated_Flag(p_Updated_Flag IN VARCHAR2)
RETURN BOOLEAN
IS
l_dummy VARCHAR2(10);
IF p_Updated_Flag IS NULL OR
p_Updated_Flag = FND_API.G_MISS_NUM
THEN
RETURN TRUE;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UPDATED_FLAG');
OE_Order_Util.Get_Attribute_Name('Updated_Flag'));
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
, 'Updated_Flag'
);
END Updated_Flag;
FUNCTION Update_Allowed(p_Update_Allowed IN VARCHAR2)
RETURN BOOLEAN
IS
l_dummy VARCHAR2(10);
IF p_Update_Allowed IS NULL OR
p_Update_Allowed = FND_API.G_MISS_NUM
THEN
RETURN TRUE;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UPDATE_ALLOWED');
OE_Order_Util.Get_Attribute_Name('Update_Allowed'));
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
, 'Update_Allowed'
);
END Update_Allowed;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SALES_CREDIT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
select 'VALID'
from oe_sales_credit_types
where Sales_credit_type_id = p_Sales_credit_type_id;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Sales_credit_type_id');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
select 'VALID'
from ra_salesreps --Bug 3358986.Changed ra_salesreps_all to ra_salesreps
where salesrep_id = p_salesrep_id
and sysdate between NVL(start_date_active,sysdate)
and NVL(end_date_active,sysdate);
select /* MOAC_SQL_CHANGE */ 'VALID'
from jtf_rs_salesreps jrs,
jtf_rs_resource_extns b
where jrs.salesrep_id = p_salesrep_id
and jrs.resource_id = b.resource_id
and b.category in ('EMPLOYEE','OTHER','PARTY','PARTNER','SUPPLIER_CONTACT')
and jrs.org_id =l_org_id
and sysdate between nvl(jrs.start_date_active,sysdate)
and nvl(jrs.end_date_active,sysdate);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SALESREP_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SALESREP_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SALESREP_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
FUNCTION Dw_Update_Advice ( p_dw_update_advice_flag IN VARCHAR2 )
RETURN BOOLEAN
IS
l_dummy VARCHAR2(10);
IF p_dw_update_advice_flag IS NULL OR
p_dw_update_advice_flag = FND_API.G_MISS_CHAR
THEN
RETURN TRUE;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DW_UPDATE_ADVICE_FLAG');
OE_Order_Util.Get_Attribute_Name('dw_update_advice_flag'));
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
, 'Dw_Update_Advice'
);
END Dw_Update_Advice;
FUNCTION Wh_Update_Date ( p_wh_update_date IN DATE )
RETURN BOOLEAN
IS
l_dummy VARCHAR2(10);
IF p_wh_update_date IS NULL OR
p_wh_update_date = FND_API.G_MISS_DATE
THEN
RETURN TRUE;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'WH_UPDATE_DATE');
OE_Order_Util.Get_Attribute_Name('wh_update_date'));
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
, 'Wh_Update_Date'
);
END Wh_Update_Date;
/* SELECT 'VALID'
INTO l_dummy
FROM OE_LINE_TYPES_V
WHERE LINE_TYPE_ID = p_line_type_id
AND SYSDATE BETWEEN NVL( START_DATE_ACTIVE, SYSDATE )
AND NVL( END_DATE_ACTIVE, SYSDATE );
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LINE_TYPE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LINE_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDERED_ITEM_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ITEM_IDENTIFIER_TYPE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDERED_ITEM');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DATE_AND_TIME_REQUESTED');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DATE_AND_TIME_PROMISED');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DATE_AND_TIME_SCHEDULED');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDER_QUANTITY_UOM');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDERED_QUANTITY_UOM2');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM MTL_GRADES_B
WHERE grade_code = p_preferred_grade -- INVCONV
AND DISABLE_FLAG <> 'Y'; -- INVCONV
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PREFERRED_GRADE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_REQUEST_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICING_QUANTITY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICING_QUANTITY_UOM');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'QUANTITY_CANCELLED');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'QUANTITY_SHIPPED');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'QUANTITY_ORDERED');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'QUANTITY_FULFILLED');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FULFILLED_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CALCULATE_PRICE_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FULFILLMENT_METHOD_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FULFILLMENT_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_QUANTITY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_QUANTITY_UOM');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DELIVERY_LEAD_TIME');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DEMAND_BUCKET_TYPE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SCHEDULE_ITEM_DETAIL_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DEMAND_STREAM_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUST_DOCK_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUST_JOB');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUST_PRODUCTION_LINE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUST_MODEL_SERIAL_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PLANNING_PROD_SEQ_NO');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM pjm_projects_org_v
WHERE project_id = p_project_id
AND rownum = 1;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROJECT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVENTORY_ITEM_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICING_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPMENT_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORIG_SYS_LINE_REF');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOURCE_DOCUMENT_LINE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REFERENCE_LINE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REFERENCE_TYPE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REFERENCE_HEADER_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REVISION');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UNIT_SELLING_PRICE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UNIT_SELLING_PRICE_PER_PQTY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UNIT_LIST_PRICE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UNIT_LIST_PRICE_PER_PQTY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_VALUE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDER_NUMBER_SOURCE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'NAME');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SEQUENCE_STARTING_POINT');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DESCRIPTION');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'START_DATE_ACTIVE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_DATE_ACTIVE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PERCENT');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONFIGURATION_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TOP_MODEL_LINE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LINK_TO_LINE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COMPONENT_SEQUENCE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONFIG_HEADER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONFIG_REV_NBR');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COMPONENT_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONFIG_DISPLAY_SEQUENCE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SORT_ORDER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OE_ITEM_TYPE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OPTION_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COMPONENT_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'EXPLOSION_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'EXPLOSION_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_RA_RULES_V
WHERE RULE_ID = p_accounting_rule_id
AND STATUS = 'A'
AND TYPE IN ('A', 'ACC_DUR','PP_DR_ALL','PP_DR_PP');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ACCOUNTING_RULE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ACCOUNTING_RULE_DURATION');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREATED_BY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREATION_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDERED_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_order_date_type_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDER_DATE_TYPE_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REQUEST_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'RESERVED_QUANTITY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ACTUAL_ARRIVAL_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ACTUAL_SHIPMENT_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ATO_LINE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
FUNCTION Auto_Selected_Quantity ( p_auto_selected_quantity IN NUMBER )
RETURN BOOLEAN
IS
l_dummy VARCHAR2(10);
IF p_auto_selected_quantity IS NULL OR
p_auto_selected_quantity = FND_API.G_MISS_NUM
THEN
RETURN TRUE;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'AUTO_SELECTED_QUANTITY');
OE_Order_Util.Get_Attribute_Name('auto_selected_quantity'));
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
, 'Auto_Selected_Quantity'
);
END Auto_Selected_Quantity;
SELECT 'VALID'
INTO l_dummy
FROM OE_BLANKET_HEADERS BH,OE_BLANKET_HEADERS_EXT BHE
WHERE BH.ORDER_NUMBER = p_blanket_number
AND TRUNC(SYSDATE) BETWEEN TRUNC(BHE.START_DATE_ACTIVE )
AND TRUNC(NVL( BHE.END_DATE_ACTIVE, SYSDATE )) AND
BHE.ON_HOLD_FLAG = 'N'
AND BH.ORDER_NUMBER = BHE.ORDER_NUMBER
AND BH.SALES_DOCUMENT_TYPE_CODE = 'B';
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'BLANKET_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'BOOKED_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CANCELLED_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CANCELLED_QUANTITY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_INVOICE_LINE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_DOCK_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_JOB');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_PRODUCTION_LINE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_TRX_LINE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DEP_PLAN_REQUIRED_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FULFILLED_QUANTITY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVOICE_INTERFACE_STATUS_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ITEM_REVISION');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ITEM_TYPE_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LINE_CATEGORY_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OPEN_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OPTION_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ORDERED_QUANTITY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY2');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROMISE_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'RE_SOURCE_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'RLA_SCHEDULE_TYPE_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SCHEDULE_SHIP_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LATE_DEMAND_PENALTY_FACTOR');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SCHEDULE_STATUS_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_RATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'VISIBLE_DEMAND_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPED_QUANTITY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'EARLIEST_ACCEPTABLE_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'EARLIEST_SCHEDULE_LIMIT');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LATEST_ACCEPTABLE_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LATEST_SCHEDULE_LIMIT');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODEL_GROUP_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context
(p_attribute_code => 'MFG_COMPONENT_SEQUENCE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SCHEDULE_ARRIVAL_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIP_MODEL_COMPLETE_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FROM_SERIAL_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LOT_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SUBLOT_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LOT_SERIAL_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'QUANTITY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'QUANTITY2');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TO_SERIAL_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Line_Set_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'AMOUNT');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPEAR_ON_ACK_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPEAR_ON_INVOICE_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHARGE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHARGE_TYPE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONVERSION_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COST_OR_CHARGE_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CURRENCY_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DEPARTURE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ESTIMATED_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INC_IN_SALES_PERFORMANCE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVOICED_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LPN');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PARENT_CHARGE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'RETURNABLE_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_GROUP_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_AR_LOOKUPS_V
WHERE LOOKUP_CODE = p_return_reason_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'RETURN_REASON_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SPLIT_FROM_LINE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUST_PRODUCTION_SEQ_NUM');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'AUTHORIZED_TO_SHIP_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'VEH_CUS_ITEM_CUM_KEY_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ARRIVAL_SET_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIP_SET_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OVER_SHIP_REASON_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OVER_SHIP_RESOLVED_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM oe_payment_types_vl
WHERE payment_type_code = p_payment_type_code
AND ENABLED_FLAG = 'Y';
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_payment_type_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAYMENT_TYPE_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAYMENT_AMOUNT');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHECK_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
/*SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_credit_card_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);*/
select 'VALID'
into l_dummy
from iby_creditcard_issuers_v
where card_issuer_code = p_credit_card_code
and rownum=1;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_CARD_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_CARD_HOLDER_NAME');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_CARD_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_CARD_APPROVAL_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_CARD_EXPIRATION_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_CARD_APPROVAL_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FIRST_ACK_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FIRST_ACK_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_ACK_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_ACK_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM pjm_unit_numbers_lov_v
WHERE unit_number = p_end_item_unit_number;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_ITEM_UNIT_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INVOICED_QUANTITY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_TXN_TYPE_REASON');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_TXN_TYPE_COMMENTS');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Serviced_Duration');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_Period');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_Start_Date');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_End_Date');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_Coterminate');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Unit_List_Percent');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Unit_Selling_Percent');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Unit_Percent_base_Price');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_Number');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_Reference_Type_Code');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_Reference_Line_id');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Service_Reference_System_id');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_flow_status_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FLOW_STATUS_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_flow_status_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FLOW_STATUS_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SPLIT_ACTION_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Marketing_Source_Code_id');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COST_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM QP_CHARGE_LOOKUP
WHERE LOOKUP_CODE = p_charge_type_code;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHARGE_TYPE_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHARGE_SUBTYPE_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COMMITMENT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_credit_or_charge_flag
AND LOOKUP_TYPE = l_lookup_type
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE );
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREDIT_OR_CHARGE_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_FND_COMMON_LOOKUPS_V
WHERE LOOKUP_CODE = p_Include_On_Returns_Flag
AND LOOKUP_TYPE = l_lookup_type
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE );
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'INCLUDE_ON_RETURNS_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_sales_channel_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE );
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SALES_CHANNEL_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'USER_ITEM_DESCRIPTION');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM MFG_LOOKUPS
WHERE LOOKUP_CODE = p_Item_Relationship_Type
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ITEM_RELATIONSHIP_TYPE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Default_Fulfillment_Set');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Fulfillment_Set_Name');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Line_Set_Name');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Customer_Shipment_Number');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_transaction_phase_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TRANSACTION_PHASE_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_user_status_code
AND LOOKUP_TYPE = l_lookup_type
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'USER_STATUS_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM HZ_CUST_SITE_USES SITE
WHERE SITE.SITE_USE_ID =p_sold_to_site_use_id
AND SITE.SITE_USE_CODE = 'SOLD_TO'
AND SITE.STATUS = 'A';
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SOLD_TO_SITE_USE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
l_sql_stat := 'select 1 from IBE_MSITES_B where msite_id= :bind_minisite_id';
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MINISITE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE lookup_code = p_ib_owner AND
( lookup_type = l_lookup_type1 OR lookup_type=l_lookup_type2);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_OWNER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE lookup_code = p_ib_installed_at_location AND
(lookup_type = l_lookup_type1 OR lookup_type= l_lookup_type2);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE lookup_code = p_ib_current_location AND
(lookup_type = l_lookup_type1 OR lookup_type=l_lookup_type2);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_CURRENT_LOCATION');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_SOLD_TO_ORGS_V
WHERE ORGANIZATION_ID =p_end_customer_id
AND STATUS = 'A'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
AND NVL(END_DATE_ACTIVE, SYSDATE);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM HZ_CUST_ACCOUNT_ROLES
WHERE CUST_ACCOUNT_ROLE_ID = p_end_customer_contact_id
AND ROLE_TYPE = 'CONTACT'
AND STATUS = 'A';
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_CONTACT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_SITE_USE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SUPPLIER_SIGNATURE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SUPPLIER_SIGNATURE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_SIGNATURE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CUSTOMER_SIGNATURE_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONTRACT_TEMPLATE_ID
');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONTRACT_SOURCE_DOC_TYPE_CODE
');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONTRACT_SOURCE_DOCUMENT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Payment_Level_Code');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COMMITMENT_APPLIED_AMOUNT');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'COMMITMENT_INTERFACED_AMOUNT');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM OE_LOOKUPS
WHERE lookup_type = l_lookup_type
AND lookup_code = p_payment_collection_event;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAYMENT_COLLECTION_EVENT');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAYMENT_TRX_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAYMENT_SET_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PREPAID_AMOUNT');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM ar_receipt_methods rm,
ar_receipt_classes rc
Where nvl(rc.bill_of_exchange_flag, 'N') = 'N'
and rc.receipt_class_id = rm.receipt_class_id
and rm.receipt_method_id = p_receipt_method_id;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'RECEIPT_METHOD');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TANGIBLE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PAYMENT_NUMBER');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT uom_class
INTO l_uom_class
FROM MTL_UNITS_OF_MEASURE_VL
WHERE uom_code = p_charge_periodicity
AND uom_class = FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHARGE_PERIODICITY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => NULL);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPED_QUANTITY2');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'FULFILLED_QUANTITY2');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_QUANTITY2');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_QUANTITY_UOM2');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM IBY_FNDCPT_TX_EXTENSIONS
Where trxn_extension_id = p_trxn_extension_id;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TRXN_EXTENSION_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TAX_RATE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);