95: ,DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
96: ,DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE)
97: ,DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID)
98: ,DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, p_BILL_TO_ACCT_SITE_ID)
99: ,LNS_UTILITY_PUB.CREATED_BY
100: ,LNS_UTILITY_PUB.CREATION_DATE
101: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
102: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
103: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
96: ,DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE)
97: ,DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID)
98: ,DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, p_BILL_TO_ACCT_SITE_ID)
99: ,LNS_UTILITY_PUB.CREATED_BY
100: ,LNS_UTILITY_PUB.CREATION_DATE
101: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
102: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
103: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
104: ,DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, 1)
97: ,DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID)
98: ,DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, p_BILL_TO_ACCT_SITE_ID)
99: ,LNS_UTILITY_PUB.CREATED_BY
100: ,LNS_UTILITY_PUB.CREATION_DATE
101: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
102: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
103: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
104: ,DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, 1)
105: ,DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_CATEGORY)
98: ,DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, p_BILL_TO_ACCT_SITE_ID)
99: ,LNS_UTILITY_PUB.CREATED_BY
100: ,LNS_UTILITY_PUB.CREATION_DATE
101: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
102: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
103: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
104: ,DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, 1)
105: ,DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_CATEGORY)
106: ,DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
99: ,LNS_UTILITY_PUB.CREATED_BY
100: ,LNS_UTILITY_PUB.CREATION_DATE
101: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
102: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
103: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
104: ,DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, 1)
105: ,DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_CATEGORY)
106: ,DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
107: ,DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
187: ,START_DATE_ACTIVE = DECODE(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, START_DATE_ACTIVE, p_START_DATE_ACTIVE)
188: ,END_DATE_ACTIVE = DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, END_DATE_ACTIVE, p_END_DATE_ACTIVE)
189: ,CUST_ACCOUNT_ID = DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, NULL, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID)
190: ,BILL_TO_ACCT_SITE_ID = DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, NULL, BILL_TO_ACCT_SITE_ID, p_BILL_TO_ACCT_SITE_ID)
191: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
192: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
193: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
194: ,OBJECT_VERSION_NUMBER = DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
195: ,ATTRIBUTE_CATEGORY = DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
188: ,END_DATE_ACTIVE = DECODE(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, NULL, END_DATE_ACTIVE, p_END_DATE_ACTIVE)
189: ,CUST_ACCOUNT_ID = DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, NULL, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID)
190: ,BILL_TO_ACCT_SITE_ID = DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, NULL, BILL_TO_ACCT_SITE_ID, p_BILL_TO_ACCT_SITE_ID)
191: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
192: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
193: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
194: ,OBJECT_VERSION_NUMBER = DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
195: ,ATTRIBUTE_CATEGORY = DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
196: ,ATTRIBUTE1 = DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
189: ,CUST_ACCOUNT_ID = DECODE(p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, NULL, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID)
190: ,BILL_TO_ACCT_SITE_ID = DECODE(p_BILL_TO_ACCT_SITE_ID, FND_API.G_MISS_NUM, NULL, NULL, BILL_TO_ACCT_SITE_ID, p_BILL_TO_ACCT_SITE_ID)
191: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
192: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
193: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
194: ,OBJECT_VERSION_NUMBER = DECODE(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
195: ,ATTRIBUTE_CATEGORY = DECODE(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
196: ,ATTRIBUTE1 = DECODE(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
197: ,ATTRIBUTE2 = DECODE(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)