[Home] [Help]
146: APPLICATION_ID,
147: ORG_ID
148: )
149: VALUES (
150: DECODE( X_CUST_ACCT_SITE_ID, FND_API.G_MISS_NUM, HZ_CUST_ACCT_SITES_S.NEXTVAL, NULL, HZ_CUST_ACCT_SITES_S.NEXTVAL, X_CUST_ACCT_SITE_ID ),
151: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
152: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
153: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
154: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
200: DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
201: DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
202: DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
203: DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
204: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_CUST_ACCT_SITE_ID, HZ_CUST_ACCT_SITES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
205: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
206: DECODE( X_CUSTOMER_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, X_CUSTOMER_CATEGORY_CODE ),
207: DECODE( X_KEY_ACCOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, X_KEY_ACCOUNT_FLAG ),
208: DECODE( X_TP_HEADER_ID, FND_API.G_MISS_NUM, NULL, X_TP_HEADER_ID ),
235: l_dummy VARCHAR2(1);
236: BEGIN
237: l_count := 1;
238: WHILE l_count > 0 LOOP
239: SELECT HZ_CUST_ACCT_SITES_S.NEXTVAL
240: INTO X_CUST_ACCT_SITE_ID FROM dual;
241: BEGIN
242: SELECT 'Y' INTO l_dummy
243: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
257: l_dummy VARCHAR2(1);
258: BEGIN
259: l_count := 1;
260: WHILE l_count > 0 LOOP
261: SELECT HZ_CUST_ACCT_SITES_S.NEXTVAL
262: INTO X_CUST_ACCT_SITE_ID FROM dual;
263: BEGIN
264: SELECT 'Y' INTO l_dummy
265: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489