75: ORG_ID, -- Bug 3456489
76: CUST_ACCT_RELATE_ID -- Bug 4529413
77: )
78: VALUES (
79: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
80: DECODE( X_RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_RELATED_CUST_ACCOUNT_ID ),
81: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
82: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
83: HZ_UTILITY_V2PUB.CREATION_DATE,
76: CUST_ACCT_RELATE_ID -- Bug 4529413
77: )
78: VALUES (
79: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
80: DECODE( X_RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_RELATED_CUST_ACCOUNT_ID ),
81: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
82: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
83: HZ_UTILITY_V2PUB.CREATION_DATE,
84: HZ_UTILITY_V2PUB.CREATED_BY,
82: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
83: HZ_UTILITY_V2PUB.CREATION_DATE,
84: HZ_UTILITY_V2PUB.CREATED_BY,
85: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
86: DECODE( X_RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
87: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
88: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
89: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
90: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
83: HZ_UTILITY_V2PUB.CREATION_DATE,
84: HZ_UTILITY_V2PUB.CREATED_BY,
85: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
86: DECODE( X_RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
87: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
88: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
89: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
90: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
91: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
84: HZ_UTILITY_V2PUB.CREATED_BY,
85: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
86: DECODE( X_RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
87: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
88: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
89: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
90: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
91: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
92: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
85: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
86: DECODE( X_RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
87: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
88: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
89: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
90: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
91: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
92: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
93: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
86: DECODE( X_RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
87: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
88: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
89: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
90: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
91: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
92: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
93: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
94: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
87: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
88: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
89: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
90: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
91: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
92: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
93: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
94: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
95: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
88: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
89: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
90: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
91: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
92: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
93: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
94: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
95: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
96: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
89: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
90: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
91: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
92: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
93: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
94: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
95: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
96: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
97: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
90: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
91: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
92: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
93: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
94: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
95: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
96: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
97: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
98: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
91: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
92: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
93: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
94: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
95: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
96: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
97: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
98: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
99: HZ_UTILITY_V2PUB.REQUEST_ID,
92: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
93: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
94: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
95: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
96: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
97: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
98: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
99: HZ_UTILITY_V2PUB.REQUEST_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
93: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
94: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
95: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
96: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
97: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
98: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
99: HZ_UTILITY_V2PUB.REQUEST_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
101: HZ_UTILITY_V2PUB.PROGRAM_ID,
94: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
95: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
96: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
97: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
98: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
99: HZ_UTILITY_V2PUB.REQUEST_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
101: HZ_UTILITY_V2PUB.PROGRAM_ID,
102: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
99: HZ_UTILITY_V2PUB.REQUEST_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
101: HZ_UTILITY_V2PUB.PROGRAM_ID,
102: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
103: DECODE( X_CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
104: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
105: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
106: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
107: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
100: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
101: HZ_UTILITY_V2PUB.PROGRAM_ID,
102: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
103: DECODE( X_CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
104: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
105: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
106: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
107: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
108: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
101: HZ_UTILITY_V2PUB.PROGRAM_ID,
102: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
103: DECODE( X_CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
104: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
105: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
106: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
107: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
108: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
109: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
102: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
103: DECODE( X_CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
104: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
105: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
106: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
107: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
108: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
109: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
110: DECODE( X_BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_BILL_TO_FLAG ),
103: DECODE( X_CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
104: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
105: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
106: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
107: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
108: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
109: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
110: DECODE( X_BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_BILL_TO_FLAG ),
111: DECODE( X_SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_SHIP_TO_FLAG ),
104: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
105: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
106: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
107: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
108: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
109: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
110: DECODE( X_BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_BILL_TO_FLAG ),
111: DECODE( X_SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_SHIP_TO_FLAG ),
112: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
105: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
106: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
107: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
108: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
109: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
110: DECODE( X_BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_BILL_TO_FLAG ),
111: DECODE( X_SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_SHIP_TO_FLAG ),
112: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
113: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
106: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
107: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
108: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
109: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
110: DECODE( X_BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_BILL_TO_FLAG ),
111: DECODE( X_SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_SHIP_TO_FLAG ),
112: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
113: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
114: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
107: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
108: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
109: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
110: DECODE( X_BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_BILL_TO_FLAG ),
111: DECODE( X_SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_SHIP_TO_FLAG ),
112: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
113: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
114: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
115: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ), -- Bug 3456489
108: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
109: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
110: DECODE( X_BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_BILL_TO_FLAG ),
111: DECODE( X_SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_SHIP_TO_FLAG ),
112: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
113: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
114: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
115: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ), -- Bug 3456489
116: DECODE( X_CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM,HZ_CUST_ACCT_RELATE_S.NEXTVAL, NULL ,HZ_CUST_ACCT_RELATE_S.NEXTVAL,X_CUST_ACCT_RELATE_ID) --Bug 4529413
109: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
110: DECODE( X_BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_BILL_TO_FLAG ),
111: DECODE( X_SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_SHIP_TO_FLAG ),
112: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
113: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
114: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
115: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ), -- Bug 3456489
116: DECODE( X_CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM,HZ_CUST_ACCT_RELATE_S.NEXTVAL, NULL ,HZ_CUST_ACCT_RELATE_S.NEXTVAL,X_CUST_ACCT_RELATE_ID) --Bug 4529413
117: )
110: DECODE( X_BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_BILL_TO_FLAG ),
111: DECODE( X_SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_SHIP_TO_FLAG ),
112: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
113: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
114: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
115: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ), -- Bug 3456489
116: DECODE( X_CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM,HZ_CUST_ACCT_RELATE_S.NEXTVAL, NULL ,HZ_CUST_ACCT_RELATE_S.NEXTVAL,X_CUST_ACCT_RELATE_ID) --Bug 4529413
117: )
118: RETURNING
111: DECODE( X_SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_SHIP_TO_FLAG ),
112: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
113: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
114: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
115: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ), -- Bug 3456489
116: DECODE( X_CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM,HZ_CUST_ACCT_RELATE_S.NEXTVAL, NULL ,HZ_CUST_ACCT_RELATE_S.NEXTVAL,X_CUST_ACCT_RELATE_ID) --Bug 4529413
117: )
118: RETURNING
119: CUST_ACCT_RELATE_ID
112: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
113: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
114: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
115: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ), -- Bug 3456489
116: DECODE( X_CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM,HZ_CUST_ACCT_RELATE_S.NEXTVAL, NULL ,HZ_CUST_ACCT_RELATE_S.NEXTVAL,X_CUST_ACCT_RELATE_ID) --Bug 4529413
117: )
118: RETURNING
119: CUST_ACCT_RELATE_ID
120: INTO
156:
157: BEGIN
158:
159: UPDATE HZ_CUST_ACCT_RELATE_ALL SET -- Bug 3456489
160: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
161: RELATED_CUST_ACCOUNT_ID = DECODE( X_RELATED_CUST_ACCOUNT_ID, NULL, RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_RELATED_CUST_ACCOUNT_ID ),
162: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
163: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
164: CREATION_DATE = CREATION_DATE,
157: BEGIN
158:
159: UPDATE HZ_CUST_ACCT_RELATE_ALL SET -- Bug 3456489
160: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
161: RELATED_CUST_ACCOUNT_ID = DECODE( X_RELATED_CUST_ACCOUNT_ID, NULL, RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_RELATED_CUST_ACCOUNT_ID ),
162: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
163: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
164: CREATION_DATE = CREATION_DATE,
165: CREATED_BY = CREATED_BY,
163: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
164: CREATION_DATE = CREATION_DATE,
165: CREATED_BY = CREATED_BY,
166: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
167: RELATIONSHIP_TYPE = DECODE( X_RELATIONSHIP_TYPE, NULL, RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
168: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
169: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
170: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
171: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
164: CREATION_DATE = CREATION_DATE,
165: CREATED_BY = CREATED_BY,
166: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
167: RELATIONSHIP_TYPE = DECODE( X_RELATIONSHIP_TYPE, NULL, RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
168: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
169: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
170: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
171: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
172: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
165: CREATED_BY = CREATED_BY,
166: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
167: RELATIONSHIP_TYPE = DECODE( X_RELATIONSHIP_TYPE, NULL, RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
168: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
169: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
170: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
171: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
172: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
173: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
166: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
167: RELATIONSHIP_TYPE = DECODE( X_RELATIONSHIP_TYPE, NULL, RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
168: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
169: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
170: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
171: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
172: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
173: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
174: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
167: RELATIONSHIP_TYPE = DECODE( X_RELATIONSHIP_TYPE, NULL, RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),
168: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
169: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
170: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
171: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
172: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
173: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
174: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
175: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
168: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
169: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
170: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
171: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
172: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
173: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
174: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
175: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
176: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
169: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
170: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
171: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
172: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
173: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
174: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
175: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
176: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
177: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
170: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
171: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
172: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
173: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
174: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
175: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
176: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
177: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
178: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
171: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
172: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
173: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
174: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
175: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
176: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
177: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
178: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
179: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
172: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
173: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
174: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
175: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
176: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
177: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
178: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
179: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
180: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
173: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
174: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
175: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
176: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
177: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
178: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
179: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
180: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
181: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
174: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
175: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
176: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
177: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
178: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
179: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
180: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
181: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
182: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
175: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
176: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
177: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
178: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
179: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
180: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
181: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
182: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
183: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
180: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
181: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
182: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
183: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
184: CUSTOMER_RECIPROCAL_FLAG = DECODE( X_CUSTOMER_RECIPROCAL_FLAG, NULL, CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
185: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
186: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
187: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
188: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
181: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
182: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
183: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
184: CUSTOMER_RECIPROCAL_FLAG = DECODE( X_CUSTOMER_RECIPROCAL_FLAG, NULL, CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
185: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
186: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
187: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
188: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
189: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
182: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
183: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
184: CUSTOMER_RECIPROCAL_FLAG = DECODE( X_CUSTOMER_RECIPROCAL_FLAG, NULL, CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
185: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
186: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
187: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
188: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
189: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
190: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
183: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
184: CUSTOMER_RECIPROCAL_FLAG = DECODE( X_CUSTOMER_RECIPROCAL_FLAG, NULL, CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
185: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
186: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
187: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
188: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
189: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
190: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
191: BILL_TO_FLAG = DECODE( X_BILL_TO_FLAG, NULL, BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_BILL_TO_FLAG ),
184: CUSTOMER_RECIPROCAL_FLAG = DECODE( X_CUSTOMER_RECIPROCAL_FLAG, NULL, CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),
185: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
186: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
187: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
188: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
189: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
190: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
191: BILL_TO_FLAG = DECODE( X_BILL_TO_FLAG, NULL, BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_BILL_TO_FLAG ),
192: SHIP_TO_FLAG = DECODE( X_SHIP_TO_FLAG, NULL, SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_SHIP_TO_FLAG ),
185: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
186: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
187: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
188: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
189: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
190: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
191: BILL_TO_FLAG = DECODE( X_BILL_TO_FLAG, NULL, BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_BILL_TO_FLAG ),
192: SHIP_TO_FLAG = DECODE( X_SHIP_TO_FLAG, NULL, SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_SHIP_TO_FLAG ),
193: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
186: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
187: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
188: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
189: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
190: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
191: BILL_TO_FLAG = DECODE( X_BILL_TO_FLAG, NULL, BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_BILL_TO_FLAG ),
192: SHIP_TO_FLAG = DECODE( X_SHIP_TO_FLAG, NULL, SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_SHIP_TO_FLAG ),
193: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
194: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
187: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
188: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
189: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
190: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
191: BILL_TO_FLAG = DECODE( X_BILL_TO_FLAG, NULL, BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_BILL_TO_FLAG ),
192: SHIP_TO_FLAG = DECODE( X_SHIP_TO_FLAG, NULL, SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_SHIP_TO_FLAG ),
193: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
194: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
195: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
188: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
189: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
190: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
191: BILL_TO_FLAG = DECODE( X_BILL_TO_FLAG, NULL, BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_BILL_TO_FLAG ),
192: SHIP_TO_FLAG = DECODE( X_SHIP_TO_FLAG, NULL, SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_SHIP_TO_FLAG ),
193: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
194: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
195: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
196: WHERE CUST_ACCT_RELATE_ID = X_CUST_ACCT_RELATE_ID; --Bug 4529413
189: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
190: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
191: BILL_TO_FLAG = DECODE( X_BILL_TO_FLAG, NULL, BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_BILL_TO_FLAG ),
192: SHIP_TO_FLAG = DECODE( X_SHIP_TO_FLAG, NULL, SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_SHIP_TO_FLAG ),
193: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
194: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
195: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
196: WHERE CUST_ACCT_RELATE_ID = X_CUST_ACCT_RELATE_ID; --Bug 4529413
197:
190: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
191: BILL_TO_FLAG = DECODE( X_BILL_TO_FLAG, NULL, BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_BILL_TO_FLAG ),
192: SHIP_TO_FLAG = DECODE( X_SHIP_TO_FLAG, NULL, SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_SHIP_TO_FLAG ),
193: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
194: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
195: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
196: WHERE CUST_ACCT_RELATE_ID = X_CUST_ACCT_RELATE_ID; --Bug 4529413
197:
198: IF ( SQL%NOTFOUND ) THEN
191: BILL_TO_FLAG = DECODE( X_BILL_TO_FLAG, NULL, BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_BILL_TO_FLAG ),
192: SHIP_TO_FLAG = DECODE( X_SHIP_TO_FLAG, NULL, SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_SHIP_TO_FLAG ),
193: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
194: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
195: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
196: WHERE CUST_ACCT_RELATE_ID = X_CUST_ACCT_RELATE_ID; --Bug 4529413
197:
198: IF ( SQL%NOTFOUND ) THEN
199: RAISE NO_DATA_FOUND;
413:
414: CURSOR c_sel_cust_acct_relate_pk IS -- Bug 4529413
415:
416: SELECT
417: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
418: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
419: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
420: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
414: CURSOR c_sel_cust_acct_relate_pk IS -- Bug 4529413
415:
416: SELECT
417: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
418: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
419: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
420: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
415:
416: SELECT
417: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
418: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
419: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
420: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
416: SELECT
417: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
418: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
419: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
420: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
417: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
418: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
419: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
420: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
418: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
419: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
420: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
419: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
420: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
420: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
421: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
422: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
423: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
424: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
432: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
425: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
432: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
433: NVL( STATUS, FND_API.G_MISS_CHAR ),
426: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
432: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
433: NVL( STATUS, FND_API.G_MISS_CHAR ),
434: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
427: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
432: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
433: NVL( STATUS, FND_API.G_MISS_CHAR ),
434: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
435: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
428: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
432: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
433: NVL( STATUS, FND_API.G_MISS_CHAR ),
434: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
435: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
436: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
429: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
432: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
433: NVL( STATUS, FND_API.G_MISS_CHAR ),
434: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
435: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
436: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
437: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
430: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
432: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
433: NVL( STATUS, FND_API.G_MISS_CHAR ),
434: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
435: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
436: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
437: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
438: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
431: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
432: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
433: NVL( STATUS, FND_API.G_MISS_CHAR ),
434: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
435: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
436: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
437: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
438: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
439: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
432: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
433: NVL( STATUS, FND_API.G_MISS_CHAR ),
434: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
435: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
436: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
437: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
438: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
439: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
440: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
433: NVL( STATUS, FND_API.G_MISS_CHAR ),
434: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
435: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
436: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
437: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
438: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
439: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
440: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
441: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
434: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
435: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
436: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
437: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
438: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
439: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
440: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
441: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
442: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
435: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
436: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
437: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
438: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
439: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
440: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
441: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
442: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
443: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489
436: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
437: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
438: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
439: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
440: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
441: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
442: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
443: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489
444: NVL( CUST_ACCT_RELATE_ID, FND_API.G_MISS_NUM) -- Bug 4529413
437: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
438: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
439: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
440: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
441: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
442: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
443: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489
444: NVL( CUST_ACCT_RELATE_ID, FND_API.G_MISS_NUM) -- Bug 4529413
445: FROM HZ_CUST_ACCT_RELATE_ALL
438: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
439: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
440: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
441: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
442: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
443: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489
444: NVL( CUST_ACCT_RELATE_ID, FND_API.G_MISS_NUM) -- Bug 4529413
445: FROM HZ_CUST_ACCT_RELATE_ALL
446: WHERE CUST_ACCT_RELATE_ID = X_CUST_ACCT_RELATE_ID;
439: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
440: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
441: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
442: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
443: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489
444: NVL( CUST_ACCT_RELATE_ID, FND_API.G_MISS_NUM) -- Bug 4529413
445: FROM HZ_CUST_ACCT_RELATE_ALL
446: WHERE CUST_ACCT_RELATE_ID = X_CUST_ACCT_RELATE_ID;
447:
440: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
441: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
442: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
443: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489
444: NVL( CUST_ACCT_RELATE_ID, FND_API.G_MISS_NUM) -- Bug 4529413
445: FROM HZ_CUST_ACCT_RELATE_ALL
446: WHERE CUST_ACCT_RELATE_ID = X_CUST_ACCT_RELATE_ID;
447:
448:
452: SELECT *
453: FROM
454: (
455: SELECT
456: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
457: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
458: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
459: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
460: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
453: FROM
454: (
455: SELECT
456: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
457: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
458: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
459: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
460: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
461: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
454: (
455: SELECT
456: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
457: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
458: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
459: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
460: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
461: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
462: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
455: SELECT
456: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
457: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
458: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
459: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
460: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
461: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
462: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
463: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
456: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
457: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
458: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
459: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
460: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
461: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
462: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
463: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
464: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
457: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
458: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
459: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
460: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
461: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
462: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
463: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
464: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
465: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
458: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
459: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
460: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
461: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
462: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
463: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
464: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
465: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
466: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
459: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
460: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
461: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
462: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
463: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
464: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
465: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
466: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
467: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
460: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
461: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
462: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
463: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
464: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
465: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
466: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
467: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
468: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
461: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
462: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
463: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
464: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
465: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
466: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
467: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
468: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
469: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
462: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
463: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
464: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
465: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
466: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
467: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
468: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
469: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
470: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
463: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
464: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
465: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
466: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
467: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
468: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
469: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
470: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
471: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
464: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
465: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
466: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
467: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
468: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
469: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
470: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
471: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
472: NVL( STATUS, FND_API.G_MISS_CHAR ),
465: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
466: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
467: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
468: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
469: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
470: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
471: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
472: NVL( STATUS, FND_API.G_MISS_CHAR ),
473: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
466: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
467: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
468: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
469: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
470: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
471: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
472: NVL( STATUS, FND_API.G_MISS_CHAR ),
473: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
474: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
467: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
468: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
469: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
470: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
471: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
472: NVL( STATUS, FND_API.G_MISS_CHAR ),
473: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
474: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
475: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
468: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
469: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
470: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
471: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
472: NVL( STATUS, FND_API.G_MISS_CHAR ),
473: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
474: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
475: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
476: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
469: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
470: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
471: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
472: NVL( STATUS, FND_API.G_MISS_CHAR ),
473: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
474: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
475: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
476: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
477: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
470: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
471: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
472: NVL( STATUS, FND_API.G_MISS_CHAR ),
473: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
474: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
475: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
476: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
477: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
478: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
471: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
472: NVL( STATUS, FND_API.G_MISS_CHAR ),
473: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
474: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
475: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
476: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
477: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
478: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
479: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
472: NVL( STATUS, FND_API.G_MISS_CHAR ),
473: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
474: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
475: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
476: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
477: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
478: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
479: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
480: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
473: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
474: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
475: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
476: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
477: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
478: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
479: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
480: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
481: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
474: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
475: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
476: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
477: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
478: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
479: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
480: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
481: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
482: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489
475: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
476: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
477: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
478: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
479: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
480: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
481: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
482: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489
483: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM) -- Bug 4529413
476: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
477: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
478: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
479: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
480: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
481: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
482: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489
483: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM) -- Bug 4529413
484: FROM HZ_CUST_ACCT_RELATE_ALL
477: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
478: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
479: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
480: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
481: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
482: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489
483: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM) -- Bug 4529413
484: FROM HZ_CUST_ACCT_RELATE_ALL
485: WHERE CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID
478: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
479: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
480: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
481: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
482: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489
483: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM) -- Bug 4529413
484: FROM HZ_CUST_ACCT_RELATE_ALL
485: WHERE CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID
486: AND RELATED_CUST_ACCOUNT_ID = X_RELATED_CUST_ACCOUNT_ID
479: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
480: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
481: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
482: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489
483: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM) -- Bug 4529413
484: FROM HZ_CUST_ACCT_RELATE_ALL
485: WHERE CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID
486: AND RELATED_CUST_ACCOUNT_ID = X_RELATED_CUST_ACCOUNT_ID
487: AND ORG_ID = NVL(X_ORG_ID, ORG_ID) -- Bug 3456489
528: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
529: FND_MESSAGE.SET_TOKEN( 'RECORD', 'cust_acct_relate_rec');
530: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CUST_ACCT_RELATE_ID ));
531: FND_MSG_PUB.ADD;
532: RAISE FND_API.G_EXC_ERROR;
533: END IF;
534:
535: CLOSE c_sel_cust_acct_relate_pk;
536:
573: FND_MESSAGE.SET_TOKEN( 'RECORD', 'cust_acct_relate_rec');
574: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CUST_ACCOUNT_ID ) ||
575: ',' || TO_CHAR( X_RELATED_CUST_ACCOUNT_ID ) );
576: FND_MSG_PUB.ADD;
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579:
580: CLOSE c_sel_cust_acct_relate;
581: END IF;
615: ) IS
616:
617: CURSOR c_sel_cust_acct_relate IS
618: SELECT
619: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
620: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
621: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
622: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
616:
617: CURSOR c_sel_cust_acct_relate IS
618: SELECT
619: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
620: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
621: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
622: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
617: CURSOR c_sel_cust_acct_relate IS
618: SELECT
619: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
620: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
621: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
622: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
618: SELECT
619: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
620: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
621: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
622: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
626: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
619: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
620: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
621: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
622: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
626: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
627: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
620: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),
621: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
622: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
626: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
627: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
628: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
621: NVL( RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR ),
622: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
626: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
627: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
628: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
629: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
622: NVL( COMMENTS, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
626: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
627: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
628: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
629: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
630: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
623: NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
626: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
627: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
628: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
629: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
630: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
631: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
624: NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
626: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
627: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
628: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
629: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
630: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
631: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
632: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
625: NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
626: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
627: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
628: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
629: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
630: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
631: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
632: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
633: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
626: NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
627: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
628: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
629: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
630: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
631: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
632: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
633: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
634: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
627: NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
628: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
629: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
630: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
631: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
632: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
633: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
634: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
635: NVL( STATUS, FND_API.G_MISS_CHAR ),
628: NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
629: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
630: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
631: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
632: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
633: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
634: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
635: NVL( STATUS, FND_API.G_MISS_CHAR ),
636: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
629: NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
630: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
631: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
632: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
633: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
634: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
635: NVL( STATUS, FND_API.G_MISS_CHAR ),
636: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
637: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
630: NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
631: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
632: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
633: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
634: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
635: NVL( STATUS, FND_API.G_MISS_CHAR ),
636: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
637: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
638: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
631: NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
632: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
633: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
634: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
635: NVL( STATUS, FND_API.G_MISS_CHAR ),
636: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
637: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
638: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
639: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
632: NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
633: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
634: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
635: NVL( STATUS, FND_API.G_MISS_CHAR ),
636: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
637: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
638: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
639: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
640: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
633: NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
634: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
635: NVL( STATUS, FND_API.G_MISS_CHAR ),
636: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
637: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
638: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
639: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
640: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
641: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
634: NVL( CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR ),
635: NVL( STATUS, FND_API.G_MISS_CHAR ),
636: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
637: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
638: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
639: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
640: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
641: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
642: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
635: NVL( STATUS, FND_API.G_MISS_CHAR ),
636: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
637: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
638: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
639: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
640: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
641: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
642: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
643: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
636: NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
637: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
638: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
639: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
640: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
641: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
642: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
643: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
644: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
637: NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
638: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
639: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
640: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
641: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
642: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
643: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
644: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
645: NVL( ORG_ID, FND_API.G_MISS_NUM),
638: NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
639: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
640: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
641: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
642: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
643: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
644: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
645: NVL( ORG_ID, FND_API.G_MISS_NUM),
646: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM)
639: NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
640: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
641: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
642: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
643: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
644: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
645: NVL( ORG_ID, FND_API.G_MISS_NUM),
646: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM)
647: FROM HZ_CUST_ACCT_RELATE_ALL
640: NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
641: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
642: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
643: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
644: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
645: NVL( ORG_ID, FND_API.G_MISS_NUM),
646: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM)
647: FROM HZ_CUST_ACCT_RELATE_ALL
648: WHERE ROWID = X_ROWID;
641: NVL( BILL_TO_FLAG, FND_API.G_MISS_CHAR ),
642: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
643: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
644: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
645: NVL( ORG_ID, FND_API.G_MISS_NUM),
646: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM)
647: FROM HZ_CUST_ACCT_RELATE_ALL
648: WHERE ROWID = X_ROWID;
649:
642: NVL( SHIP_TO_FLAG, FND_API.G_MISS_CHAR ),
643: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
644: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
645: NVL( ORG_ID, FND_API.G_MISS_NUM),
646: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM)
647: FROM HZ_CUST_ACCT_RELATE_ALL
648: WHERE ROWID = X_ROWID;
649:
650: BEGIN
683: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
684: FND_MESSAGE.SET_TOKEN( 'RECORD', 'cust_acct_relate_rec');
685: FND_MESSAGE.SET_TOKEN( 'VALUE', X_ROWID );
686: FND_MSG_PUB.ADD;
687: RAISE FND_API.G_EXC_ERROR;
688: END IF;
689:
690: CLOSE c_sel_cust_acct_relate;
691: END Select_Row;