[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row (
X_SITE_USE_ID IN OUT NOCOPY NUMBER,
X_CUST_ACCT_SITE_ID IN NUMBER,
X_SITE_USE_CODE IN VARCHAR2,
X_PRIMARY_FLAG IN VARCHAR2,
X_STATUS IN VARCHAR2,
X_LOCATION IN VARCHAR2,
X_CONTACT_ID IN NUMBER,
X_BILL_TO_SITE_USE_ID IN NUMBER,
X_ORIG_SYSTEM_REFERENCE IN VARCHAR2,
X_SIC_CODE IN VARCHAR2,
X_PAYMENT_TERM_ID IN NUMBER,
X_GSA_INDICATOR IN VARCHAR2,
X_SHIP_PARTIAL IN VARCHAR2,
X_SHIP_VIA IN VARCHAR2,
X_FOB_POINT IN VARCHAR2,
X_ORDER_TYPE_ID IN NUMBER,
X_PRICE_LIST_ID IN NUMBER,
X_FREIGHT_TERM IN VARCHAR2,
X_WAREHOUSE_ID IN NUMBER,
X_TERRITORY_ID IN NUMBER,
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_TAX_REFERENCE IN VARCHAR2,
X_SORT_PRIORITY IN NUMBER,
X_TAX_CODE IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_ATTRIBUTE16 IN VARCHAR2,
X_ATTRIBUTE17 IN VARCHAR2,
X_ATTRIBUTE18 IN VARCHAR2,
X_ATTRIBUTE19 IN VARCHAR2,
X_ATTRIBUTE20 IN VARCHAR2,
X_ATTRIBUTE21 IN VARCHAR2,
X_ATTRIBUTE22 IN VARCHAR2,
X_ATTRIBUTE23 IN VARCHAR2,
X_ATTRIBUTE24 IN VARCHAR2,
X_ATTRIBUTE25 IN VARCHAR2,
X_DEMAND_CLASS_CODE IN VARCHAR2,
X_TAX_HEADER_LEVEL_FLAG IN VARCHAR2,
X_TAX_ROUNDING_RULE IN VARCHAR2,
X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_PRIMARY_SALESREP_ID IN NUMBER,
X_FINCHRG_RECEIVABLES_TRX_ID IN NUMBER,
X_DATES_NEGATIVE_TOLERANCE IN NUMBER,
X_DATES_POSITIVE_TOLERANCE IN NUMBER,
X_DATE_TYPE_PREFERENCE IN VARCHAR2,
X_OVER_SHIPMENT_TOLERANCE IN NUMBER,
X_UNDER_SHIPMENT_TOLERANCE IN NUMBER,
X_ITEM_CROSS_REF_PREF IN VARCHAR2,
X_OVER_RETURN_TOLERANCE IN NUMBER,
X_UNDER_RETURN_TOLERANCE IN NUMBER,
X_SHIP_SETS_INCLUDE_LINES_FLAG IN VARCHAR2,
X_ARRIVALSETS_INCLUDE_LINES_FG IN VARCHAR2,
X_SCHED_DATE_PUSH_FLAG IN VARCHAR2,
X_INVOICE_QUANTITY_RULE IN VARCHAR2,
X_PRICING_EVENT IN VARCHAR2,
X_GL_ID_REC IN NUMBER,
X_GL_ID_REV IN NUMBER,
X_GL_ID_TAX IN NUMBER,
X_GL_ID_FREIGHT IN NUMBER,
X_GL_ID_CLEARING IN NUMBER,
X_GL_ID_UNBILLED IN NUMBER,
X_GL_ID_UNEARNED IN NUMBER,
X_GL_ID_UNPAID_REC IN NUMBER,
X_GL_ID_REMITTANCE IN NUMBER,
X_GL_ID_FACTOR IN NUMBER,
X_TAX_CLASSIFICATION IN VARCHAR2,
X_OBJECT_VERSION_NUMBER IN NUMBER,
X_CREATED_BY_MODULE IN VARCHAR2,
X_APPLICATION_ID IN NUMBER,
X_ORG_ID IN NUMBER /* DEFAULT NULL (Commented out in Bug 3456489) */
) IS
l_success VARCHAR2(1) := 'N';
INSERT INTO HZ_CUST_SITE_USES_ALL (
SITE_USE_ID,
CUST_ACCT_SITE_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
SITE_USE_CODE,
PRIMARY_FLAG,
STATUS,
LOCATION,
LAST_UPDATE_LOGIN,
CONTACT_ID,
BILL_TO_SITE_USE_ID,
ORIG_SYSTEM_REFERENCE,
SIC_CODE,
PAYMENT_TERM_ID,
GSA_INDICATOR,
-- SHIP_PARTIAL,
SHIP_VIA,
FOB_POINT,
ORDER_TYPE_ID,
PRICE_LIST_ID,
FREIGHT_TERM,
WAREHOUSE_ID,
TERRITORY_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
TAX_REFERENCE,
SORT_PRIORITY,
TAX_CODE,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
ATTRIBUTE21,
ATTRIBUTE22,
ATTRIBUTE23,
ATTRIBUTE24,
ATTRIBUTE25,
DEMAND_CLASS_CODE,
TAX_HEADER_LEVEL_FLAG,
TAX_ROUNDING_RULE,
GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15,
GLOBAL_ATTRIBUTE16,
GLOBAL_ATTRIBUTE17,
GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20,
GLOBAL_ATTRIBUTE_CATEGORY,
PRIMARY_SALESREP_ID,
FINCHRG_RECEIVABLES_TRX_ID,
DATES_NEGATIVE_TOLERANCE,
DATES_POSITIVE_TOLERANCE,
DATE_TYPE_PREFERENCE,
OVER_SHIPMENT_TOLERANCE,
UNDER_SHIPMENT_TOLERANCE,
ITEM_CROSS_REF_PREF,
OVER_RETURN_TOLERANCE,
UNDER_RETURN_TOLERANCE,
SHIP_SETS_INCLUDE_LINES_FLAG,
ARRIVALSETS_INCLUDE_LINES_FLAG,
SCHED_DATE_PUSH_FLAG,
INVOICE_QUANTITY_RULE,
PRICING_EVENT,
GL_ID_REC,
GL_ID_REV,
GL_ID_TAX,
GL_ID_FREIGHT,
GL_ID_CLEARING,
GL_ID_UNBILLED,
GL_ID_UNEARNED,
GL_ID_UNPAID_REC,
GL_ID_REMITTANCE,
GL_ID_FACTOR,
TAX_CLASSIFICATION,
OBJECT_VERSION_NUMBER,
CREATED_BY_MODULE,
APPLICATION_ID,
ORG_ID
)
VALUES (
DECODE( X_SITE_USE_ID, FND_API.G_MISS_NUM, HZ_CUST_SITE_USES_S.NEXTVAL, NULL, HZ_CUST_SITE_USES_S.NEXTVAL, X_SITE_USE_ID ),
DECODE( X_CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
HZ_UTILITY_V2PUB.CREATION_DATE,
HZ_UTILITY_V2PUB.CREATED_BY,
DECODE( X_SITE_USE_CODE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_CODE ),
DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
DECODE( X_LOCATION, FND_API.G_MISS_CHAR, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), NULL, TO_CHAR(HZ_CUST_SITE_USES_S.NEXTVAL), X_LOCATION ),
HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
DECODE( X_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_ID ),
DECODE( X_BILL_TO_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_BILL_TO_SITE_USE_ID ),
DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_SITE_USE_ID,HZ_CUST_SITE_USES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
DECODE( X_SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
DECODE( X_PAYMENT_TERM_ID, FND_API.G_MISS_NUM, NULL, X_PAYMENT_TERM_ID ),
DECODE( X_GSA_INDICATOR, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_GSA_INDICATOR ),
-- DECODE( X_SHIP_PARTIAL, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_SHIP_PARTIAL ),
DECODE( X_SHIP_VIA, FND_API.G_MISS_CHAR, NULL, X_SHIP_VIA ),
DECODE( X_FOB_POINT, FND_API.G_MISS_CHAR, NULL, X_FOB_POINT ),
DECODE( X_ORDER_TYPE_ID, FND_API.G_MISS_NUM, NULL, X_ORDER_TYPE_ID ),
DECODE( X_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, X_PRICE_LIST_ID ),
DECODE( X_FREIGHT_TERM, FND_API.G_MISS_CHAR, NULL, X_FREIGHT_TERM ),
DECODE( X_WAREHOUSE_ID, FND_API.G_MISS_NUM, NULL, X_WAREHOUSE_ID ),
DECODE( X_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
HZ_UTILITY_V2PUB.REQUEST_ID,
HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
HZ_UTILITY_V2PUB.PROGRAM_ID,
HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
DECODE( X_TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
DECODE( X_SORT_PRIORITY, FND_API.G_MISS_NUM, NULL, X_SORT_PRIORITY ),
DECODE( X_TAX_CODE, FND_API.G_MISS_CHAR, NULL, X_TAX_CODE ),
DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
DECODE( X_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
DECODE( X_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
DECODE( X_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
DECODE( X_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
DECODE( X_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
DECODE( X_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
DECODE( X_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
DECODE( X_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
DECODE( X_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
DECODE( X_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE25 ),
DECODE( X_DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_DEMAND_CLASS_CODE ),
DECODE( X_TAX_HEADER_LEVEL_FLAG, FND_API.G_MISS_CHAR, NULL, X_TAX_HEADER_LEVEL_FLAG ),
DECODE( X_TAX_ROUNDING_RULE, FND_API.G_MISS_CHAR, NULL, X_TAX_ROUNDING_RULE ),
DECODE( X_GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
DECODE( X_GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
DECODE( X_GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
DECODE( X_GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
DECODE( X_GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
DECODE( X_GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
DECODE( X_GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
DECODE( X_GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
DECODE( X_GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
DECODE( X_GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
DECODE( X_GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
DECODE( X_GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
DECODE( X_GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
DECODE( X_GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
DECODE( X_GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
DECODE( X_GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
DECODE( X_PRIMARY_SALESREP_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SALESREP_ID ),
DECODE( X_FINCHRG_RECEIVABLES_TRX_ID, FND_API.G_MISS_NUM, NULL, X_FINCHRG_RECEIVABLES_TRX_ID ),
DECODE( X_DATES_NEGATIVE_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_DATES_NEGATIVE_TOLERANCE ),
DECODE( X_DATES_POSITIVE_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_DATES_POSITIVE_TOLERANCE ),
DECODE( X_DATE_TYPE_PREFERENCE, FND_API.G_MISS_CHAR, NULL, X_DATE_TYPE_PREFERENCE ),
DECODE( X_OVER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_OVER_SHIPMENT_TOLERANCE ),
DECODE( X_UNDER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_UNDER_SHIPMENT_TOLERANCE ),
DECODE( X_ITEM_CROSS_REF_PREF, FND_API.G_MISS_CHAR, NULL, X_ITEM_CROSS_REF_PREF ),
DECODE( X_OVER_RETURN_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_OVER_RETURN_TOLERANCE ),
DECODE( X_UNDER_RETURN_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_UNDER_RETURN_TOLERANCE ),
DECODE( X_SHIP_SETS_INCLUDE_LINES_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_SHIP_SETS_INCLUDE_LINES_FLAG ),
DECODE( X_ARRIVALSETS_INCLUDE_LINES_FG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_ARRIVALSETS_INCLUDE_LINES_FG ),
DECODE( X_SCHED_DATE_PUSH_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_SCHED_DATE_PUSH_FLAG ),
DECODE( X_INVOICE_QUANTITY_RULE, FND_API.G_MISS_CHAR, NULL, X_INVOICE_QUANTITY_RULE ),
DECODE( X_PRICING_EVENT, FND_API.G_MISS_CHAR, NULL, X_PRICING_EVENT ),
DECODE( X_GL_ID_REC, FND_API.G_MISS_NUM, NULL, X_GL_ID_REC ),
DECODE( X_GL_ID_REV, FND_API.G_MISS_NUM, NULL, X_GL_ID_REV ),
DECODE( X_GL_ID_TAX, FND_API.G_MISS_NUM, NULL, X_GL_ID_TAX ),
DECODE( X_GL_ID_FREIGHT, FND_API.G_MISS_NUM, NULL, X_GL_ID_FREIGHT ),
DECODE( X_GL_ID_CLEARING, FND_API.G_MISS_NUM, NULL, X_GL_ID_CLEARING ),
DECODE( X_GL_ID_UNBILLED, FND_API.G_MISS_NUM, NULL, X_GL_ID_UNBILLED ),
DECODE( X_GL_ID_UNEARNED, FND_API.G_MISS_NUM, NULL, X_GL_ID_UNEARNED ),
DECODE( X_GL_ID_UNPAID_REC, FND_API.G_MISS_NUM, NULL, X_GL_ID_UNPAID_REC ),
DECODE( X_GL_ID_REMITTANCE, FND_API.G_MISS_NUM, NULL, X_GL_ID_REMITTANCE ),
DECODE( X_GL_ID_FACTOR, FND_API.G_MISS_NUM, NULL, X_GL_ID_FACTOR ),
DECODE( X_TAX_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, X_TAX_CLASSIFICATION ),
DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
-- Bug 3456489
-- DECODE( X_ORG_ID, NULL, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))), X_ORG_ID)
DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID )
) RETURNING
SITE_USE_ID
INTO
X_SITE_USE_ID;
SELECT HZ_CUST_SITE_USES_S.NEXTVAL
INTO X_SITE_USE_ID FROM dual;
SELECT 'Y' INTO l_dummy
FROM HZ_CUST_SITE_USES_ALL
WHERE SITE_USE_ID = X_SITE_USE_ID;
END Insert_Row;
PROCEDURE Update_Row (
X_Rowid IN OUT NOCOPY VARCHAR2,
X_SITE_USE_ID IN NUMBER,
X_CUST_ACCT_SITE_ID IN NUMBER,
X_SITE_USE_CODE IN VARCHAR2,
X_PRIMARY_FLAG IN VARCHAR2,
X_STATUS IN VARCHAR2,
X_LOCATION IN VARCHAR2,
X_CONTACT_ID IN NUMBER,
X_BILL_TO_SITE_USE_ID IN NUMBER,
X_ORIG_SYSTEM_REFERENCE IN VARCHAR2,
X_SIC_CODE IN VARCHAR2,
X_PAYMENT_TERM_ID IN NUMBER,
X_GSA_INDICATOR IN VARCHAR2,
X_SHIP_PARTIAL IN VARCHAR2,
X_SHIP_VIA IN VARCHAR2,
X_FOB_POINT IN VARCHAR2,
X_ORDER_TYPE_ID IN NUMBER,
X_PRICE_LIST_ID IN NUMBER,
X_FREIGHT_TERM IN VARCHAR2,
X_WAREHOUSE_ID IN NUMBER,
X_TERRITORY_ID IN NUMBER,
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_TAX_REFERENCE IN VARCHAR2,
X_SORT_PRIORITY IN NUMBER,
X_TAX_CODE IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_ATTRIBUTE16 IN VARCHAR2,
X_ATTRIBUTE17 IN VARCHAR2,
X_ATTRIBUTE18 IN VARCHAR2,
X_ATTRIBUTE19 IN VARCHAR2,
X_ATTRIBUTE20 IN VARCHAR2,
X_ATTRIBUTE21 IN VARCHAR2,
X_ATTRIBUTE22 IN VARCHAR2,
X_ATTRIBUTE23 IN VARCHAR2,
X_ATTRIBUTE24 IN VARCHAR2,
X_ATTRIBUTE25 IN VARCHAR2,
X_DEMAND_CLASS_CODE IN VARCHAR2,
X_TAX_HEADER_LEVEL_FLAG IN VARCHAR2,
X_TAX_ROUNDING_RULE IN VARCHAR2,
X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_PRIMARY_SALESREP_ID IN NUMBER,
X_FINCHRG_RECEIVABLES_TRX_ID IN NUMBER,
X_DATES_NEGATIVE_TOLERANCE IN NUMBER,
X_DATES_POSITIVE_TOLERANCE IN NUMBER,
X_DATE_TYPE_PREFERENCE IN VARCHAR2,
X_OVER_SHIPMENT_TOLERANCE IN NUMBER,
X_UNDER_SHIPMENT_TOLERANCE IN NUMBER,
X_ITEM_CROSS_REF_PREF IN VARCHAR2,
X_OVER_RETURN_TOLERANCE IN NUMBER,
X_UNDER_RETURN_TOLERANCE IN NUMBER,
X_SHIP_SETS_INCLUDE_LINES_FLAG IN VARCHAR2,
X_ARRIVALSETS_INCLUDE_LINES_FG IN VARCHAR2,
X_SCHED_DATE_PUSH_FLAG IN VARCHAR2,
X_INVOICE_QUANTITY_RULE IN VARCHAR2,
X_PRICING_EVENT IN VARCHAR2,
X_GL_ID_REC IN NUMBER,
X_GL_ID_REV IN NUMBER,
X_GL_ID_TAX IN NUMBER,
X_GL_ID_FREIGHT IN NUMBER,
X_GL_ID_CLEARING IN NUMBER,
X_GL_ID_UNBILLED IN NUMBER,
X_GL_ID_UNEARNED IN NUMBER,
X_GL_ID_UNPAID_REC IN NUMBER,
X_GL_ID_REMITTANCE IN NUMBER,
X_GL_ID_FACTOR IN NUMBER,
X_TAX_CLASSIFICATION IN VARCHAR2,
X_OBJECT_VERSION_NUMBER IN NUMBER,
X_CREATED_BY_MODULE IN VARCHAR2,
X_APPLICATION_ID IN NUMBER
) IS
BEGIN
UPDATE HZ_CUST_SITE_USES_ALL SET
SITE_USE_ID = DECODE( X_SITE_USE_ID, NULL, SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_SITE_USE_ID ),
CUST_ACCT_SITE_ID = DECODE( X_CUST_ACCT_SITE_ID, NULL, CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCT_SITE_ID ),
LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
CREATION_DATE = CREATION_DATE,
CREATED_BY = CREATED_BY,
SITE_USE_CODE = DECODE( X_SITE_USE_CODE, NULL, SITE_USE_CODE, FND_API.G_MISS_CHAR, NULL, X_SITE_USE_CODE ),
PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),
STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
LOCATION = DECODE( X_LOCATION, NULL, LOCATION, FND_API.G_MISS_CHAR, NULL, X_LOCATION ),
LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
CONTACT_ID = DECODE( X_CONTACT_ID, NULL, CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_CONTACT_ID),
BILL_TO_SITE_USE_ID = DECODE( X_BILL_TO_SITE_USE_ID, NULL, BILL_TO_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_BILL_TO_SITE_USE_ID ),
ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(X_CUST_ACCT_SITE_ID), X_ORIG_SYSTEM_REFERENCE ),
SIC_CODE = DECODE( X_SIC_CODE, NULL, SIC_CODE, FND_API.G_MISS_CHAR, NULL, X_SIC_CODE ),
PAYMENT_TERM_ID = DECODE( X_PAYMENT_TERM_ID, NULL, PAYMENT_TERM_ID, FND_API.G_MISS_NUM, NULL, X_PAYMENT_TERM_ID ),
GSA_INDICATOR = DECODE( X_GSA_INDICATOR, NULL, GSA_INDICATOR, FND_API.G_MISS_CHAR, 'N', X_GSA_INDICATOR ),
-- SHIP_PARTIAL = DECODE( X_SHIP_PARTIAL, NULL, SHIP_PARTIAL, FND_API.G_MISS_CHAR, 'N', X_SHIP_PARTIAL ),
SHIP_VIA = DECODE( X_SHIP_VIA, NULL, SHIP_VIA, FND_API.G_MISS_CHAR, NULL, X_SHIP_VIA ),
FOB_POINT = DECODE( X_FOB_POINT, NULL, FOB_POINT, FND_API.G_MISS_CHAR, NULL, X_FOB_POINT ),
ORDER_TYPE_ID = DECODE( X_ORDER_TYPE_ID, NULL, ORDER_TYPE_ID, FND_API.G_MISS_NUM, NULL, X_ORDER_TYPE_ID ),
PRICE_LIST_ID = DECODE( X_PRICE_LIST_ID, NULL, PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, X_PRICE_LIST_ID ),
FREIGHT_TERM = DECODE( X_FREIGHT_TERM, NULL, FREIGHT_TERM, FND_API.G_MISS_CHAR, NULL, X_FREIGHT_TERM ),
WAREHOUSE_ID = DECODE( X_WAREHOUSE_ID, NULL, WAREHOUSE_ID, FND_API.G_MISS_NUM, NULL, X_WAREHOUSE_ID ),
TERRITORY_ID = DECODE( X_TERRITORY_ID, NULL, TERRITORY_ID, FND_API.G_MISS_NUM, NULL, X_TERRITORY_ID ),
ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
TAX_REFERENCE = DECODE( X_TAX_REFERENCE, NULL, TAX_REFERENCE, FND_API.G_MISS_CHAR, NULL, X_TAX_REFERENCE ),
SORT_PRIORITY = DECODE( X_SORT_PRIORITY, NULL, SORT_PRIORITY, FND_API.G_MISS_NUM, NULL, X_SORT_PRIORITY ),
TAX_CODE = DECODE( X_TAX_CODE, NULL, TAX_CODE, FND_API.G_MISS_CHAR, NULL, X_TAX_CODE ),
ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
ATTRIBUTE16 = DECODE( X_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE16 ),
ATTRIBUTE17 = DECODE( X_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE17 ),
ATTRIBUTE18 = DECODE( X_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE18 ),
ATTRIBUTE19 = DECODE( X_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE19 ),
ATTRIBUTE20 = DECODE( X_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE20 ),
ATTRIBUTE21 = DECODE( X_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE21 ),
ATTRIBUTE22 = DECODE( X_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE22 ),
ATTRIBUTE23 = DECODE( X_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE23 ),
ATTRIBUTE24 = DECODE( X_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE24 ),
ATTRIBUTE25 = DECODE( X_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE25 ),
DEMAND_CLASS_CODE = DECODE( X_DEMAND_CLASS_CODE, NULL, DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_DEMAND_CLASS_CODE ),
TAX_HEADER_LEVEL_FLAG = DECODE( X_TAX_HEADER_LEVEL_FLAG, NULL, TAX_HEADER_LEVEL_FLAG, FND_API.G_MISS_CHAR, NULL, X_TAX_HEADER_LEVEL_FLAG ),
TAX_ROUNDING_RULE = DECODE( X_TAX_ROUNDING_RULE, NULL, TAX_ROUNDING_RULE, FND_API.G_MISS_CHAR, NULL, X_TAX_ROUNDING_RULE ),
GLOBAL_ATTRIBUTE1 = DECODE( X_GLOBAL_ATTRIBUTE1, NULL, GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
GLOBAL_ATTRIBUTE2 = DECODE( X_GLOBAL_ATTRIBUTE2, NULL, GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
GLOBAL_ATTRIBUTE3 = DECODE( X_GLOBAL_ATTRIBUTE3, NULL, GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
GLOBAL_ATTRIBUTE4 = DECODE( X_GLOBAL_ATTRIBUTE4, NULL, GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
GLOBAL_ATTRIBUTE5 = DECODE( X_GLOBAL_ATTRIBUTE5, NULL, GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
GLOBAL_ATTRIBUTE6 = DECODE( X_GLOBAL_ATTRIBUTE6, NULL, GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
GLOBAL_ATTRIBUTE7 = DECODE( X_GLOBAL_ATTRIBUTE7, NULL, GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
GLOBAL_ATTRIBUTE8 = DECODE( X_GLOBAL_ATTRIBUTE8, NULL, GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
GLOBAL_ATTRIBUTE9 = DECODE( X_GLOBAL_ATTRIBUTE9, NULL, GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
GLOBAL_ATTRIBUTE10 = DECODE( X_GLOBAL_ATTRIBUTE10, NULL, GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
GLOBAL_ATTRIBUTE11 = DECODE( X_GLOBAL_ATTRIBUTE11, NULL, GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
GLOBAL_ATTRIBUTE12 = DECODE( X_GLOBAL_ATTRIBUTE12, NULL, GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
GLOBAL_ATTRIBUTE13 = DECODE( X_GLOBAL_ATTRIBUTE13, NULL, GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
GLOBAL_ATTRIBUTE14 = DECODE( X_GLOBAL_ATTRIBUTE14, NULL, GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
GLOBAL_ATTRIBUTE15 = DECODE( X_GLOBAL_ATTRIBUTE15, NULL, GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
GLOBAL_ATTRIBUTE16 = DECODE( X_GLOBAL_ATTRIBUTE16, NULL, GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
GLOBAL_ATTRIBUTE17 = DECODE( X_GLOBAL_ATTRIBUTE17, NULL, GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
GLOBAL_ATTRIBUTE18 = DECODE( X_GLOBAL_ATTRIBUTE18, NULL, GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
GLOBAL_ATTRIBUTE19 = DECODE( X_GLOBAL_ATTRIBUTE19, NULL, GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
GLOBAL_ATTRIBUTE20 = DECODE( X_GLOBAL_ATTRIBUTE20, NULL, GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
GLOBAL_ATTRIBUTE_CATEGORY = DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, NULL, GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
PRIMARY_SALESREP_ID = DECODE( X_PRIMARY_SALESREP_ID, NULL, PRIMARY_SALESREP_ID, FND_API.G_MISS_NUM, NULL, X_PRIMARY_SALESREP_ID ),
FINCHRG_RECEIVABLES_TRX_ID = DECODE( X_FINCHRG_RECEIVABLES_TRX_ID, NULL, FINCHRG_RECEIVABLES_TRX_ID, FND_API.G_MISS_NUM, NULL, X_FINCHRG_RECEIVABLES_TRX_ID ),
DATES_NEGATIVE_TOLERANCE = DECODE( X_DATES_NEGATIVE_TOLERANCE, NULL, DATES_NEGATIVE_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_DATES_NEGATIVE_TOLERANCE ),
DATES_POSITIVE_TOLERANCE = DECODE( X_DATES_POSITIVE_TOLERANCE, NULL, DATES_POSITIVE_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_DATES_POSITIVE_TOLERANCE ),
DATE_TYPE_PREFERENCE = DECODE( X_DATE_TYPE_PREFERENCE, NULL, DATE_TYPE_PREFERENCE, FND_API.G_MISS_CHAR, NULL, X_DATE_TYPE_PREFERENCE ),
OVER_SHIPMENT_TOLERANCE = DECODE( X_OVER_SHIPMENT_TOLERANCE, NULL, OVER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_OVER_SHIPMENT_TOLERANCE ),
UNDER_SHIPMENT_TOLERANCE = DECODE( X_UNDER_SHIPMENT_TOLERANCE, NULL, UNDER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_UNDER_SHIPMENT_TOLERANCE ),
ITEM_CROSS_REF_PREF = DECODE( X_ITEM_CROSS_REF_PREF, NULL, ITEM_CROSS_REF_PREF, FND_API.G_MISS_CHAR, NULL, X_ITEM_CROSS_REF_PREF ),
OVER_RETURN_TOLERANCE = DECODE( X_OVER_RETURN_TOLERANCE, NULL, OVER_RETURN_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_OVER_RETURN_TOLERANCE ),
UNDER_RETURN_TOLERANCE = DECODE( X_UNDER_RETURN_TOLERANCE, NULL, UNDER_RETURN_TOLERANCE, FND_API.G_MISS_NUM, NULL, X_UNDER_RETURN_TOLERANCE ),
SHIP_SETS_INCLUDE_LINES_FLAG = DECODE( X_SHIP_SETS_INCLUDE_LINES_FLAG, NULL, SHIP_SETS_INCLUDE_LINES_FLAG, FND_API.G_MISS_CHAR, 'N', X_SHIP_SETS_INCLUDE_LINES_FLAG ),
ARRIVALSETS_INCLUDE_LINES_FLAG = DECODE( X_ARRIVALSETS_INCLUDE_LINES_FG, NULL, ARRIVALSETS_INCLUDE_LINES_FLAG, FND_API.G_MISS_CHAR, 'N', X_ARRIVALSETS_INCLUDE_LINES_FG ),
SCHED_DATE_PUSH_FLAG = DECODE( X_SCHED_DATE_PUSH_FLAG, NULL, SCHED_DATE_PUSH_FLAG, FND_API.G_MISS_CHAR, 'N', X_SCHED_DATE_PUSH_FLAG ),
INVOICE_QUANTITY_RULE = DECODE( X_INVOICE_QUANTITY_RULE, NULL, INVOICE_QUANTITY_RULE, FND_API.G_MISS_CHAR, NULL, X_INVOICE_QUANTITY_RULE ),
PRICING_EVENT = DECODE( X_PRICING_EVENT, NULL, PRICING_EVENT, FND_API.G_MISS_CHAR, NULL, X_PRICING_EVENT ),
GL_ID_REC = DECODE( X_GL_ID_REC, NULL, GL_ID_REC, FND_API.G_MISS_NUM, NULL, X_GL_ID_REC ),
GL_ID_REV = DECODE( X_GL_ID_REV, NULL, GL_ID_REV, FND_API.G_MISS_NUM, NULL, X_GL_ID_REV ),
GL_ID_TAX = DECODE( X_GL_ID_TAX, NULL, GL_ID_TAX, FND_API.G_MISS_NUM, NULL, X_GL_ID_TAX ),
GL_ID_FREIGHT = DECODE( X_GL_ID_FREIGHT, NULL, GL_ID_FREIGHT, FND_API.G_MISS_NUM, NULL, X_GL_ID_FREIGHT ),
GL_ID_CLEARING = DECODE( X_GL_ID_CLEARING, NULL, GL_ID_CLEARING, FND_API.G_MISS_NUM, NULL, X_GL_ID_CLEARING ),
GL_ID_UNBILLED = DECODE( X_GL_ID_UNBILLED, NULL, GL_ID_UNBILLED, FND_API.G_MISS_NUM, NULL, X_GL_ID_UNBILLED ),
GL_ID_UNEARNED = DECODE( X_GL_ID_UNEARNED, NULL, GL_ID_UNEARNED, FND_API.G_MISS_NUM, NULL, X_GL_ID_UNEARNED ),
GL_ID_UNPAID_REC = DECODE( X_GL_ID_UNPAID_REC, NULL, GL_ID_UNPAID_REC, FND_API.G_MISS_NUM, NULL, X_GL_ID_UNPAID_REC ),
GL_ID_REMITTANCE = DECODE( X_GL_ID_REMITTANCE, NULL, GL_ID_REMITTANCE, FND_API.G_MISS_NUM, NULL, X_GL_ID_REMITTANCE ),
GL_ID_FACTOR = DECODE( X_GL_ID_FACTOR, NULL, GL_ID_FACTOR, FND_API.G_MISS_NUM, NULL, X_GL_ID_FACTOR ),
TAX_CLASSIFICATION = DECODE( X_TAX_CLASSIFICATION, NULL, TAX_CLASSIFICATION, FND_API.G_MISS_CHAR, NULL, X_TAX_CLASSIFICATION ),
OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
WHERE ROWID = X_RowId;
END Update_Row;
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATED_BY IN NUMBER,
X_CREATION_DATE IN DATE,
X_CREATED_BY IN NUMBER,
X_SITE_USE_CODE IN VARCHAR2,
X_PRIMARY_FLAG IN VARCHAR2,
X_STATUS IN VARCHAR2,
X_LOCATION IN VARCHAR2,
X_LAST_UPDATE_LOGIN IN NUMBER,
X_BILL_TO_SITE_USE_ID IN NUMBER,
X_ORIG_SYSTEM_REFERENCE IN VARCHAR2,
X_SIC_CODE IN VARCHAR2,
X_PAYMENT_TERM_ID IN NUMBER,
X_GSA_INDICATOR IN VARCHAR2,
X_SHIP_PARTIAL IN VARCHAR2,
X_SHIP_VIA IN VARCHAR2,
X_FOB_POINT IN VARCHAR2,
X_ORDER_TYPE_ID IN NUMBER,
X_PRICE_LIST_ID IN NUMBER,
X_FREIGHT_TERM IN VARCHAR2,
X_WAREHOUSE_ID IN NUMBER,
X_TERRITORY_ID IN NUMBER,
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_REQUEST_ID IN NUMBER,
X_PROGRAM_APPLICATION_ID IN NUMBER,
X_PROGRAM_ID IN NUMBER,
X_PROGRAM_UPDATE_DATE IN DATE,
X_TAX_REFERENCE IN VARCHAR2,
X_SORT_PRIORITY IN NUMBER,
X_TAX_CODE IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_ATTRIBUTE16 IN VARCHAR2,
X_ATTRIBUTE17 IN VARCHAR2,
X_ATTRIBUTE18 IN VARCHAR2,
X_ATTRIBUTE19 IN VARCHAR2,
X_ATTRIBUTE20 IN VARCHAR2,
X_ATTRIBUTE21 IN VARCHAR2,
X_ATTRIBUTE22 IN VARCHAR2,
X_ATTRIBUTE23 IN VARCHAR2,
X_ATTRIBUTE24 IN VARCHAR2,
X_ATTRIBUTE25 IN VARCHAR2,
X_DEMAND_CLASS_CODE IN VARCHAR2,
X_TAX_HEADER_LEVEL_FLAG IN VARCHAR2,
X_TAX_ROUNDING_RULE IN VARCHAR2,
X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_PRIMARY_SALESREP_ID IN NUMBER,
X_FINCHRG_RECEIVABLES_TRX_ID IN NUMBER,
X_DATES_NEGATIVE_TOLERANCE IN NUMBER,
X_DATES_POSITIVE_TOLERANCE IN NUMBER,
X_DATE_TYPE_PREFERENCE IN VARCHAR2,
X_OVER_SHIPMENT_TOLERANCE IN NUMBER,
X_UNDER_SHIPMENT_TOLERANCE IN NUMBER,
X_ITEM_CROSS_REF_PREF IN VARCHAR2,
X_OVER_RETURN_TOLERANCE IN NUMBER,
X_UNDER_RETURN_TOLERANCE IN NUMBER,
X_SHIP_SETS_INCLUDE_LINES_FLAG IN VARCHAR2,
X_ARRIVALSETS_INCLUDE_LINES_FG IN VARCHAR2,
X_SCHED_DATE_PUSH_FLAG IN VARCHAR2,
X_INVOICE_QUANTITY_RULE IN VARCHAR2,
X_PRICING_EVENT IN VARCHAR2,
X_GL_ID_REC IN NUMBER,
X_GL_ID_REV IN NUMBER,
X_GL_ID_TAX IN NUMBER,
X_GL_ID_FREIGHT IN NUMBER,
X_GL_ID_CLEARING IN NUMBER,
X_GL_ID_UNBILLED IN NUMBER,
X_GL_ID_UNEARNED IN NUMBER,
X_GL_ID_UNPAID_REC IN NUMBER,
X_GL_ID_REMITTANCE IN NUMBER,
X_GL_ID_FACTOR IN NUMBER,
X_TAX_CLASSIFICATION IN VARCHAR2,
X_OBJECT_VERSION_NUMBER IN NUMBER,
X_CREATED_BY_MODULE IN VARCHAR2,
X_APPLICATION_ID IN NUMBER
) IS
CURSOR C IS
SELECT * FROM HZ_CUST_SITE_USES
WHERE ROWID = x_Rowid
FOR UPDATE NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
AND ( ( Recinfo.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE )
OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
AND ( X_LAST_UPDATE_DATE IS NULL ) ) )
AND ( ( Recinfo.LAST_UPDATED_BY = X_LAST_UPDATED_BY )
OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
AND ( X_LAST_UPDATED_BY IS NULL ) ) )
AND ( ( Recinfo.CREATION_DATE = X_CREATION_DATE )
OR ( ( Recinfo.CREATION_DATE IS NULL )
AND ( X_CREATION_DATE IS NULL ) ) )
AND ( ( Recinfo.CREATED_BY = X_CREATED_BY )
OR ( ( Recinfo.CREATED_BY IS NULL )
AND ( X_CREATED_BY IS NULL ) ) )
AND ( ( Recinfo.SITE_USE_CODE = X_SITE_USE_CODE )
OR ( ( Recinfo.SITE_USE_CODE IS NULL )
AND ( X_SITE_USE_CODE IS NULL ) ) )
AND ( ( Recinfo.PRIMARY_FLAG = X_PRIMARY_FLAG )
OR ( ( Recinfo.PRIMARY_FLAG IS NULL )
AND ( X_PRIMARY_FLAG IS NULL ) ) )
AND ( ( Recinfo.STATUS = X_STATUS )
OR ( ( Recinfo.STATUS IS NULL )
AND ( X_STATUS IS NULL ) ) )
AND ( ( Recinfo.LOCATION = X_LOCATION )
OR ( ( Recinfo.LOCATION IS NULL )
AND ( X_LOCATION IS NULL ) ) )
AND ( ( Recinfo.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN )
OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
AND ( X_LAST_UPDATE_LOGIN IS NULL ) ) )
AND ( ( Recinfo.BILL_TO_SITE_USE_ID = X_BILL_TO_SITE_USE_ID )
OR ( ( Recinfo.BILL_TO_SITE_USE_ID IS NULL )
AND ( X_BILL_TO_SITE_USE_ID IS NULL ) ) )
AND ( ( Recinfo.ORIG_SYSTEM_REFERENCE = X_ORIG_SYSTEM_REFERENCE )
OR ( ( Recinfo.ORIG_SYSTEM_REFERENCE IS NULL )
AND ( X_ORIG_SYSTEM_REFERENCE IS NULL ) ) )
AND ( ( Recinfo.SIC_CODE = X_SIC_CODE )
OR ( ( Recinfo.SIC_CODE IS NULL )
AND ( X_SIC_CODE IS NULL ) ) )
AND ( ( Recinfo.PAYMENT_TERM_ID = X_PAYMENT_TERM_ID )
OR ( ( Recinfo.PAYMENT_TERM_ID IS NULL )
AND ( X_PAYMENT_TERM_ID IS NULL ) ) )
AND ( ( Recinfo.GSA_INDICATOR = X_GSA_INDICATOR )
OR ( ( Recinfo.GSA_INDICATOR IS NULL )
AND ( X_GSA_INDICATOR IS NULL ) ) )
AND ( ( Recinfo.SHIP_VIA = X_SHIP_VIA )
OR ( ( Recinfo.SHIP_VIA IS NULL )
AND ( X_SHIP_VIA IS NULL ) ) )
AND ( ( Recinfo.FOB_POINT = X_FOB_POINT )
OR ( ( Recinfo.FOB_POINT IS NULL )
AND ( X_FOB_POINT IS NULL ) ) )
AND ( ( Recinfo.ORDER_TYPE_ID = X_ORDER_TYPE_ID )
OR ( ( Recinfo.ORDER_TYPE_ID IS NULL )
AND ( X_ORDER_TYPE_ID IS NULL ) ) )
AND ( ( Recinfo.PRICE_LIST_ID = X_PRICE_LIST_ID )
OR ( ( Recinfo.PRICE_LIST_ID IS NULL )
AND ( X_PRICE_LIST_ID IS NULL ) ) )
AND ( ( Recinfo.FREIGHT_TERM = X_FREIGHT_TERM )
OR ( ( Recinfo.FREIGHT_TERM IS NULL )
AND ( X_FREIGHT_TERM IS NULL ) ) )
AND ( ( Recinfo.WAREHOUSE_ID = X_WAREHOUSE_ID )
OR ( ( Recinfo.WAREHOUSE_ID IS NULL )
AND ( X_WAREHOUSE_ID IS NULL ) ) )
AND ( ( Recinfo.TERRITORY_ID = X_TERRITORY_ID )
OR ( ( Recinfo.TERRITORY_ID IS NULL )
AND ( X_TERRITORY_ID IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY )
OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
AND ( X_ATTRIBUTE_CATEGORY IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE1 = X_ATTRIBUTE1 )
OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
AND ( X_ATTRIBUTE1 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE2 = X_ATTRIBUTE2 )
OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
AND ( X_ATTRIBUTE2 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE3 = X_ATTRIBUTE3 )
OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
AND ( X_ATTRIBUTE3 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE4 = X_ATTRIBUTE4 )
OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
AND ( X_ATTRIBUTE4 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE5 = X_ATTRIBUTE5 )
OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
AND ( X_ATTRIBUTE5 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE6 = X_ATTRIBUTE6 )
OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
AND ( X_ATTRIBUTE6 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE7 = X_ATTRIBUTE7 )
OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
AND ( X_ATTRIBUTE7 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE8 = X_ATTRIBUTE8 )
OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
AND ( X_ATTRIBUTE8 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE9 = X_ATTRIBUTE9 )
OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
AND ( X_ATTRIBUTE9 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE10 = X_ATTRIBUTE10 )
OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
AND ( X_ATTRIBUTE10 IS NULL ) ) )
AND ( ( Recinfo.REQUEST_ID = X_REQUEST_ID )
OR ( ( Recinfo.REQUEST_ID IS NULL )
AND ( X_REQUEST_ID IS NULL ) ) )
AND ( ( Recinfo.PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID )
OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
AND ( X_PROGRAM_APPLICATION_ID IS NULL ) ) )
AND ( ( Recinfo.PROGRAM_ID = X_PROGRAM_ID )
OR ( ( Recinfo.PROGRAM_ID IS NULL )
AND ( X_PROGRAM_ID IS NULL ) ) )
AND ( ( Recinfo.PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE )
OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
AND ( X_PROGRAM_UPDATE_DATE IS NULL ) ) )
AND ( ( Recinfo.TAX_REFERENCE = X_TAX_REFERENCE )
OR ( ( Recinfo.TAX_REFERENCE IS NULL )
AND ( X_TAX_REFERENCE IS NULL ) ) )
AND ( ( Recinfo.SORT_PRIORITY = X_SORT_PRIORITY )
OR ( ( Recinfo.SORT_PRIORITY IS NULL )
AND ( X_SORT_PRIORITY IS NULL ) ) )
AND ( ( Recinfo.TAX_CODE = X_TAX_CODE )
OR ( ( Recinfo.TAX_CODE IS NULL )
AND ( X_TAX_CODE IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE11 = X_ATTRIBUTE11 )
OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
AND ( X_ATTRIBUTE11 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE12 = X_ATTRIBUTE12 )
OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
AND ( X_ATTRIBUTE12 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE13 = X_ATTRIBUTE13 )
OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
AND ( X_ATTRIBUTE13 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE14 = X_ATTRIBUTE14 )
OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
AND ( X_ATTRIBUTE14 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE15 = X_ATTRIBUTE15 )
OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
AND ( X_ATTRIBUTE15 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE16 = X_ATTRIBUTE16 )
OR ( ( Recinfo.ATTRIBUTE16 IS NULL )
AND ( X_ATTRIBUTE16 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE17 = X_ATTRIBUTE17 )
OR ( ( Recinfo.ATTRIBUTE17 IS NULL )
AND ( X_ATTRIBUTE17 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE18 = X_ATTRIBUTE18 )
OR ( ( Recinfo.ATTRIBUTE18 IS NULL )
AND ( X_ATTRIBUTE18 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE19 = X_ATTRIBUTE19 )
OR ( ( Recinfo.ATTRIBUTE19 IS NULL )
AND ( X_ATTRIBUTE19 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE20 = X_ATTRIBUTE20 )
OR ( ( Recinfo.ATTRIBUTE20 IS NULL )
AND ( X_ATTRIBUTE20 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE21 = X_ATTRIBUTE21 )
OR ( ( Recinfo.ATTRIBUTE21 IS NULL )
AND ( X_ATTRIBUTE21 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE22 = X_ATTRIBUTE22 )
OR ( ( Recinfo.ATTRIBUTE22 IS NULL )
AND ( X_ATTRIBUTE22 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE23 = X_ATTRIBUTE23 )
OR ( ( Recinfo.ATTRIBUTE23 IS NULL )
AND ( X_ATTRIBUTE23 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE24 = X_ATTRIBUTE24 )
OR ( ( Recinfo.ATTRIBUTE24 IS NULL )
AND ( X_ATTRIBUTE24 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE25 = X_ATTRIBUTE25 )
OR ( ( Recinfo.ATTRIBUTE25 IS NULL )
AND ( X_ATTRIBUTE25 IS NULL ) ) )
AND ( ( Recinfo.DEMAND_CLASS_CODE = X_DEMAND_CLASS_CODE )
OR ( ( Recinfo.DEMAND_CLASS_CODE IS NULL )
AND ( X_DEMAND_CLASS_CODE IS NULL ) ) )
AND ( ( Recinfo.TAX_HEADER_LEVEL_FLAG = X_TAX_HEADER_LEVEL_FLAG )
OR ( ( Recinfo.TAX_HEADER_LEVEL_FLAG IS NULL )
AND ( X_TAX_HEADER_LEVEL_FLAG IS NULL ) ) )
AND ( ( Recinfo.TAX_ROUNDING_RULE = X_TAX_ROUNDING_RULE )
OR ( ( Recinfo.TAX_ROUNDING_RULE IS NULL )
AND ( X_TAX_ROUNDING_RULE IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE1 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE1 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE2 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE2 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE3 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE3 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE4 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE4 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE5 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE5 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE6 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE6 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE7 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE7 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE8 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE8 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE9 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE9 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE10 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE10 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE11 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE11 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE12 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE12 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE13 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE13 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE14 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE14 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE15 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE15 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE16 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE16 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE17 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE17 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE18 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE18 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE19 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE19 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE20 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE20 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE_CATEGORY IS NULL )
AND ( X_GLOBAL_ATTRIBUTE_CATEGORY IS NULL ) ) )
AND ( ( Recinfo.PRIMARY_SALESREP_ID = X_PRIMARY_SALESREP_ID )
OR ( ( Recinfo.PRIMARY_SALESREP_ID IS NULL )
AND ( X_PRIMARY_SALESREP_ID IS NULL ) ) )
AND ( ( Recinfo.FINCHRG_RECEIVABLES_TRX_ID = X_FINCHRG_RECEIVABLES_TRX_ID )
OR ( ( Recinfo.FINCHRG_RECEIVABLES_TRX_ID IS NULL )
AND ( X_FINCHRG_RECEIVABLES_TRX_ID IS NULL ) ) )
AND ( ( Recinfo.DATES_NEGATIVE_TOLERANCE = X_DATES_NEGATIVE_TOLERANCE )
OR ( ( Recinfo.DATES_NEGATIVE_TOLERANCE IS NULL )
AND ( X_DATES_NEGATIVE_TOLERANCE IS NULL ) ) )
AND ( ( Recinfo.DATES_POSITIVE_TOLERANCE = X_DATES_POSITIVE_TOLERANCE )
OR ( ( Recinfo.DATES_POSITIVE_TOLERANCE IS NULL )
AND ( X_DATES_POSITIVE_TOLERANCE IS NULL ) ) )
AND ( ( Recinfo.DATE_TYPE_PREFERENCE = X_DATE_TYPE_PREFERENCE )
OR ( ( Recinfo.DATE_TYPE_PREFERENCE IS NULL )
AND ( X_DATE_TYPE_PREFERENCE IS NULL ) ) )
AND ( ( Recinfo.OVER_SHIPMENT_TOLERANCE = X_OVER_SHIPMENT_TOLERANCE )
OR ( ( Recinfo.OVER_SHIPMENT_TOLERANCE IS NULL )
AND ( X_OVER_SHIPMENT_TOLERANCE IS NULL ) ) )
AND ( ( Recinfo.UNDER_SHIPMENT_TOLERANCE = X_UNDER_SHIPMENT_TOLERANCE )
OR ( ( Recinfo.UNDER_SHIPMENT_TOLERANCE IS NULL )
AND ( X_UNDER_SHIPMENT_TOLERANCE IS NULL ) ) )
AND ( ( Recinfo.ITEM_CROSS_REF_PREF = X_ITEM_CROSS_REF_PREF )
OR ( ( Recinfo.ITEM_CROSS_REF_PREF IS NULL )
AND ( X_ITEM_CROSS_REF_PREF IS NULL ) ) )
AND ( ( Recinfo.OVER_RETURN_TOLERANCE = X_OVER_RETURN_TOLERANCE )
OR ( ( Recinfo.OVER_RETURN_TOLERANCE IS NULL )
AND ( X_OVER_RETURN_TOLERANCE IS NULL ) ) )
AND ( ( Recinfo.UNDER_RETURN_TOLERANCE = X_UNDER_RETURN_TOLERANCE )
OR ( ( Recinfo.UNDER_RETURN_TOLERANCE IS NULL )
AND ( X_UNDER_RETURN_TOLERANCE IS NULL ) ) )
AND ( ( Recinfo.SHIP_SETS_INCLUDE_LINES_FLAG = X_SHIP_SETS_INCLUDE_LINES_FLAG )
OR ( ( Recinfo.SHIP_SETS_INCLUDE_LINES_FLAG IS NULL )
AND ( X_SHIP_SETS_INCLUDE_LINES_FLAG IS NULL ) ) )
AND ( ( Recinfo.ARRIVALSETS_INCLUDE_LINES_FLAG = X_ARRIVALSETS_INCLUDE_LINES_FG )
OR ( ( Recinfo.ARRIVALSETS_INCLUDE_LINES_FLAG IS NULL )
AND ( X_ARRIVALSETS_INCLUDE_LINES_FG IS NULL ) ) )
AND ( ( Recinfo.SCHED_DATE_PUSH_FLAG = X_SCHED_DATE_PUSH_FLAG )
OR ( ( Recinfo.SCHED_DATE_PUSH_FLAG IS NULL )
AND ( X_SCHED_DATE_PUSH_FLAG IS NULL ) ) )
AND ( ( Recinfo.INVOICE_QUANTITY_RULE = X_INVOICE_QUANTITY_RULE )
OR ( ( Recinfo.INVOICE_QUANTITY_RULE IS NULL )
AND ( X_INVOICE_QUANTITY_RULE IS NULL ) ) )
AND ( ( Recinfo.PRICING_EVENT = X_PRICING_EVENT )
OR ( ( Recinfo.PRICING_EVENT IS NULL )
AND ( X_PRICING_EVENT IS NULL ) ) )
AND ( ( Recinfo.GL_ID_REC = X_GL_ID_REC )
OR ( ( Recinfo.GL_ID_REC IS NULL )
AND ( X_GL_ID_REC IS NULL ) ) )
AND ( ( Recinfo.GL_ID_REV = X_GL_ID_REV )
OR ( ( Recinfo.GL_ID_REV IS NULL )
AND ( X_GL_ID_REV IS NULL ) ) )
AND ( ( Recinfo.GL_ID_TAX = X_GL_ID_TAX )
OR ( ( Recinfo.GL_ID_TAX IS NULL )
AND ( X_GL_ID_TAX IS NULL ) ) )
AND ( ( Recinfo.GL_ID_FREIGHT = X_GL_ID_FREIGHT )
OR ( ( Recinfo.GL_ID_FREIGHT IS NULL )
AND ( X_GL_ID_FREIGHT IS NULL ) ) )
AND ( ( Recinfo.GL_ID_CLEARING = X_GL_ID_CLEARING )
OR ( ( Recinfo.GL_ID_CLEARING IS NULL )
AND ( X_GL_ID_CLEARING IS NULL ) ) )
AND ( ( Recinfo.GL_ID_UNBILLED = X_GL_ID_UNBILLED )
OR ( ( Recinfo.GL_ID_UNBILLED IS NULL )
AND ( X_GL_ID_UNBILLED IS NULL ) ) )
AND ( ( Recinfo.GL_ID_UNEARNED = X_GL_ID_UNEARNED )
OR ( ( Recinfo.GL_ID_UNEARNED IS NULL )
AND ( X_GL_ID_UNEARNED IS NULL ) ) )
AND ( ( Recinfo.GL_ID_UNPAID_REC = X_GL_ID_UNPAID_REC )
OR ( ( Recinfo.GL_ID_UNPAID_REC IS NULL )
AND ( X_GL_ID_UNPAID_REC IS NULL ) ) )
AND ( ( Recinfo.GL_ID_REMITTANCE = X_GL_ID_REMITTANCE )
OR ( ( Recinfo.GL_ID_REMITTANCE IS NULL )
AND ( X_GL_ID_REMITTANCE IS NULL ) ) )
AND ( ( Recinfo.GL_ID_FACTOR = X_GL_ID_FACTOR )
OR ( ( Recinfo.GL_ID_FACTOR IS NULL )
AND ( X_GL_ID_FACTOR IS NULL ) ) )
AND ( ( Recinfo.TAX_CLASSIFICATION = X_TAX_CLASSIFICATION )
OR ( ( Recinfo.TAX_CLASSIFICATION IS NULL )
AND ( X_TAX_CLASSIFICATION IS NULL ) ) )
AND ( ( Recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER )
OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
AND ( X_OBJECT_VERSION_NUMBER IS NULL ) ) )
AND ( ( Recinfo.CREATED_BY_MODULE = X_CREATED_BY_MODULE )
OR ( ( Recinfo.CREATED_BY_MODULE IS NULL )
AND ( X_CREATED_BY_MODULE IS NULL ) ) )
AND ( ( Recinfo.APPLICATION_ID = X_APPLICATION_ID )
OR ( ( Recinfo.APPLICATION_ID IS NULL )
AND ( X_APPLICATION_ID IS NULL ) ) )
) THEN
RETURN;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
PROCEDURE Select_Row (
X_SITE_USE_ID IN OUT NOCOPY NUMBER,
X_CUST_ACCT_SITE_ID OUT NOCOPY NUMBER,
X_SITE_USE_CODE OUT NOCOPY VARCHAR2,
X_PRIMARY_FLAG OUT NOCOPY VARCHAR2,
X_STATUS OUT NOCOPY VARCHAR2,
X_LOCATION OUT NOCOPY VARCHAR2,
X_BILL_TO_SITE_USE_ID OUT NOCOPY NUMBER,
X_ORIG_SYSTEM_REFERENCE OUT NOCOPY VARCHAR2,
X_SIC_CODE OUT NOCOPY VARCHAR2,
X_PAYMENT_TERM_ID OUT NOCOPY NUMBER,
X_GSA_INDICATOR OUT NOCOPY VARCHAR2,
X_SHIP_PARTIAL OUT NOCOPY VARCHAR2,
X_SHIP_VIA OUT NOCOPY VARCHAR2,
X_FOB_POINT OUT NOCOPY VARCHAR2,
X_ORDER_TYPE_ID OUT NOCOPY NUMBER,
X_PRICE_LIST_ID OUT NOCOPY NUMBER,
X_FREIGHT_TERM OUT NOCOPY VARCHAR2,
X_WAREHOUSE_ID OUT NOCOPY NUMBER,
X_TERRITORY_ID OUT NOCOPY NUMBER,
X_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
X_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
X_TAX_REFERENCE OUT NOCOPY VARCHAR2,
X_SORT_PRIORITY OUT NOCOPY NUMBER,
X_TAX_CODE OUT NOCOPY VARCHAR2,
X_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE16 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE17 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE18 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE19 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE20 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE21 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE22 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE23 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE24 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE25 OUT NOCOPY VARCHAR2,
X_DEMAND_CLASS_CODE OUT NOCOPY VARCHAR2,
X_TAX_HEADER_LEVEL_FLAG OUT NOCOPY VARCHAR2,
X_TAX_ROUNDING_RULE OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE16 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE17 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE18 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE19 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE20 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
X_PRIMARY_SALESREP_ID OUT NOCOPY NUMBER,
X_FINCHRG_RECEIVABLES_TRX_ID OUT NOCOPY NUMBER,
X_DATES_NEGATIVE_TOLERANCE OUT NOCOPY NUMBER,
X_DATES_POSITIVE_TOLERANCE OUT NOCOPY NUMBER,
X_DATE_TYPE_PREFERENCE OUT NOCOPY VARCHAR2,
X_OVER_SHIPMENT_TOLERANCE OUT NOCOPY NUMBER,
X_UNDER_SHIPMENT_TOLERANCE OUT NOCOPY NUMBER,
X_ITEM_CROSS_REF_PREF OUT NOCOPY VARCHAR2,
X_OVER_RETURN_TOLERANCE OUT NOCOPY NUMBER,
X_UNDER_RETURN_TOLERANCE OUT NOCOPY NUMBER,
X_SHIP_SETS_INCLUDE_LINES_FLAG OUT NOCOPY VARCHAR2,
X_ARRIVALSETS_INCLUDE_LINES_FG OUT NOCOPY VARCHAR2,
X_SCHED_DATE_PUSH_FLAG OUT NOCOPY VARCHAR2,
X_INVOICE_QUANTITY_RULE OUT NOCOPY VARCHAR2,
X_PRICING_EVENT OUT NOCOPY VARCHAR2,
X_GL_ID_REC OUT NOCOPY NUMBER,
X_GL_ID_REV OUT NOCOPY NUMBER,
X_GL_ID_TAX OUT NOCOPY NUMBER,
X_GL_ID_FREIGHT OUT NOCOPY NUMBER,
X_GL_ID_CLEARING OUT NOCOPY NUMBER,
X_GL_ID_UNBILLED OUT NOCOPY NUMBER,
X_GL_ID_UNEARNED OUT NOCOPY NUMBER,
X_GL_ID_UNPAID_REC OUT NOCOPY NUMBER,
X_GL_ID_REMITTANCE OUT NOCOPY NUMBER,
X_GL_ID_FACTOR OUT NOCOPY NUMBER,
X_TAX_CLASSIFICATION OUT NOCOPY VARCHAR2,
X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
X_APPLICATION_ID OUT NOCOPY NUMBER,
X_ORG_ID OUT NOCOPY NUMBER -- Bug 3456489
) IS
BEGIN
SELECT
NVL( SITE_USE_ID, FND_API.G_MISS_NUM ),
NVL( CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM ),
NVL( SITE_USE_CODE, FND_API.G_MISS_CHAR ),
NVL( PRIMARY_FLAG, FND_API.G_MISS_CHAR ),
NVL( STATUS, FND_API.G_MISS_CHAR ),
NVL( LOCATION, FND_API.G_MISS_CHAR ),
NVL( BILL_TO_SITE_USE_ID, FND_API.G_MISS_NUM ),
NVL( ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR ),
NVL( SIC_CODE, FND_API.G_MISS_CHAR ),
NVL( PAYMENT_TERM_ID, FND_API.G_MISS_NUM ),
NVL( GSA_INDICATOR, FND_API.G_MISS_CHAR ),
-- NVL( SHIP_PARTIAL, FND_API.G_MISS_CHAR ),
NVL( SHIP_VIA, FND_API.G_MISS_CHAR ),
NVL( FOB_POINT, FND_API.G_MISS_CHAR ),
NVL( ORDER_TYPE_ID, FND_API.G_MISS_NUM ),
NVL( PRICE_LIST_ID, FND_API.G_MISS_NUM ),
NVL( FREIGHT_TERM, FND_API.G_MISS_CHAR ),
NVL( WAREHOUSE_ID, FND_API.G_MISS_NUM ),
NVL( TERRITORY_ID, FND_API.G_MISS_NUM ),
NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
NVL( TAX_REFERENCE, FND_API.G_MISS_CHAR ),
NVL( SORT_PRIORITY, FND_API.G_MISS_NUM ),
NVL( TAX_CODE, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE16, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE17, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE18, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE19, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE20, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE21, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE22, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE23, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE24, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE25, FND_API.G_MISS_CHAR ),
NVL( DEMAND_CLASS_CODE, FND_API.G_MISS_CHAR ),
NVL( TAX_HEADER_LEVEL_FLAG, FND_API.G_MISS_CHAR ),
NVL( TAX_ROUNDING_RULE, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
NVL( PRIMARY_SALESREP_ID, FND_API.G_MISS_NUM ),
NVL( FINCHRG_RECEIVABLES_TRX_ID, FND_API.G_MISS_NUM ),
NVL( DATES_NEGATIVE_TOLERANCE, FND_API.G_MISS_NUM ),
NVL( DATES_POSITIVE_TOLERANCE, FND_API.G_MISS_NUM ),
NVL( DATE_TYPE_PREFERENCE, FND_API.G_MISS_CHAR ),
NVL( OVER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM ),
NVL( UNDER_SHIPMENT_TOLERANCE, FND_API.G_MISS_NUM ),
NVL( ITEM_CROSS_REF_PREF, FND_API.G_MISS_CHAR ),
NVL( OVER_RETURN_TOLERANCE, FND_API.G_MISS_NUM ),
NVL( UNDER_RETURN_TOLERANCE, FND_API.G_MISS_NUM ),
NVL( SHIP_SETS_INCLUDE_LINES_FLAG, FND_API.G_MISS_CHAR ),
NVL( ARRIVALSETS_INCLUDE_LINES_FLAG, FND_API.G_MISS_CHAR ),
NVL( SCHED_DATE_PUSH_FLAG, FND_API.G_MISS_CHAR ),
NVL( INVOICE_QUANTITY_RULE, FND_API.G_MISS_CHAR ),
NVL( PRICING_EVENT, FND_API.G_MISS_CHAR ),
NVL( GL_ID_REC, FND_API.G_MISS_NUM ),
NVL( GL_ID_REV, FND_API.G_MISS_NUM ),
NVL( GL_ID_TAX, FND_API.G_MISS_NUM ),
NVL( GL_ID_FREIGHT, FND_API.G_MISS_NUM ),
NVL( GL_ID_CLEARING, FND_API.G_MISS_NUM ),
NVL( GL_ID_UNBILLED, FND_API.G_MISS_NUM ),
NVL( GL_ID_UNEARNED, FND_API.G_MISS_NUM ),
NVL( GL_ID_UNPAID_REC, FND_API.G_MISS_NUM ),
NVL( GL_ID_REMITTANCE, FND_API.G_MISS_NUM ),
NVL( GL_ID_FACTOR, FND_API.G_MISS_NUM ),
NVL( TAX_CLASSIFICATION, FND_API.G_MISS_CHAR ),
NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
NVL( ORG_ID, FND_API.G_MISS_NUM )
INTO
X_SITE_USE_ID,
X_CUST_ACCT_SITE_ID,
X_SITE_USE_CODE,
X_PRIMARY_FLAG,
X_STATUS,
X_LOCATION,
X_BILL_TO_SITE_USE_ID,
X_ORIG_SYSTEM_REFERENCE,
X_SIC_CODE,
X_PAYMENT_TERM_ID,
X_GSA_INDICATOR,
-- X_SHIP_PARTIAL,
X_SHIP_VIA,
X_FOB_POINT,
X_ORDER_TYPE_ID,
X_PRICE_LIST_ID,
X_FREIGHT_TERM,
X_WAREHOUSE_ID,
X_TERRITORY_ID,
X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_TAX_REFERENCE,
X_SORT_PRIORITY,
X_TAX_CODE,
X_ATTRIBUTE11,
X_ATTRIBUTE12,
X_ATTRIBUTE13,
X_ATTRIBUTE14,
X_ATTRIBUTE15,
X_ATTRIBUTE16,
X_ATTRIBUTE17,
X_ATTRIBUTE18,
X_ATTRIBUTE19,
X_ATTRIBUTE20,
X_ATTRIBUTE21,
X_ATTRIBUTE22,
X_ATTRIBUTE23,
X_ATTRIBUTE24,
X_ATTRIBUTE25,
X_DEMAND_CLASS_CODE,
X_TAX_HEADER_LEVEL_FLAG,
X_TAX_ROUNDING_RULE,
X_GLOBAL_ATTRIBUTE1,
X_GLOBAL_ATTRIBUTE2,
X_GLOBAL_ATTRIBUTE3,
X_GLOBAL_ATTRIBUTE4,
X_GLOBAL_ATTRIBUTE5,
X_GLOBAL_ATTRIBUTE6,
X_GLOBAL_ATTRIBUTE7,
X_GLOBAL_ATTRIBUTE8,
X_GLOBAL_ATTRIBUTE9,
X_GLOBAL_ATTRIBUTE10,
X_GLOBAL_ATTRIBUTE11,
X_GLOBAL_ATTRIBUTE12,
X_GLOBAL_ATTRIBUTE13,
X_GLOBAL_ATTRIBUTE14,
X_GLOBAL_ATTRIBUTE15,
X_GLOBAL_ATTRIBUTE16,
X_GLOBAL_ATTRIBUTE17,
X_GLOBAL_ATTRIBUTE18,
X_GLOBAL_ATTRIBUTE19,
X_GLOBAL_ATTRIBUTE20,
X_GLOBAL_ATTRIBUTE_CATEGORY,
X_PRIMARY_SALESREP_ID,
X_FINCHRG_RECEIVABLES_TRX_ID,
X_DATES_NEGATIVE_TOLERANCE,
X_DATES_POSITIVE_TOLERANCE,
X_DATE_TYPE_PREFERENCE,
X_OVER_SHIPMENT_TOLERANCE,
X_UNDER_SHIPMENT_TOLERANCE,
X_ITEM_CROSS_REF_PREF,
X_OVER_RETURN_TOLERANCE,
X_UNDER_RETURN_TOLERANCE,
X_SHIP_SETS_INCLUDE_LINES_FLAG,
X_ARRIVALSETS_INCLUDE_LINES_FG,
X_SCHED_DATE_PUSH_FLAG,
X_INVOICE_QUANTITY_RULE,
X_PRICING_EVENT,
X_GL_ID_REC,
X_GL_ID_REV,
X_GL_ID_TAX,
X_GL_ID_FREIGHT,
X_GL_ID_CLEARING,
X_GL_ID_UNBILLED,
X_GL_ID_UNEARNED,
X_GL_ID_UNPAID_REC,
X_GL_ID_REMITTANCE,
X_GL_ID_FACTOR,
X_TAX_CLASSIFICATION,
X_CREATED_BY_MODULE,
X_APPLICATION_ID,
X_ORG_ID -- Bug 3456489
FROM HZ_CUST_SITE_USES_ALL
WHERE SITE_USE_ID = X_SITE_USE_ID;
END Select_Row;
PROCEDURE Delete_Row (
X_SITE_USE_ID IN NUMBER
) IS
BEGIN
DELETE FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489
WHERE SITE_USE_ID = X_SITE_USE_ID;
END Delete_Row;