DBA Data[Home] [Help]

APPS.HZ_CUST_ACCT_RELATE_PKG dependencies on FND_API

Line 79: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),

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,

Line 80: DECODE( X_RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_RELATED_CUST_ACCOUNT_ID ),

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,

Line 86: DECODE( X_RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),

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 ),

Line 87: DECODE( X_COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),

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 ),

Line 88: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

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 ),

Line 89: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

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 ),

Line 90: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

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 ),

Line 91: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

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 ),

Line 92: DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

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 ),

Line 93: DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

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 ),

Line 94: DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

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 ),

Line 95: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

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,

Line 96: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

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,

Line 97: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

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,

Line 98: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

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,

Line 103: DECODE( X_CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),

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 ),

Line 104: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

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 ),

Line 105: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

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 ),

Line 106: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

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 ),

Line 107: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

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 ),

Line 108: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

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 ),

Line 109: DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

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 ),

Line 110: DECODE( X_BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_BILL_TO_FLAG ),

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 ),

Line 111: DECODE( X_SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y', X_SHIP_TO_FLAG ),

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

Line 112: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

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

Line 113: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

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: )

Line 114: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

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

Line 115: DECODE( X_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID ), -- Bug 3456489

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

Line 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

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

Line 160: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),

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,

Line 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 ),

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,

Line 167: RELATIONSHIP_TYPE = DECODE( X_RELATIONSHIP_TYPE, NULL, RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, X_RELATIONSHIP_TYPE ),

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 ),

Line 168: COMMENTS = DECODE( X_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),

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 ),

Line 169: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

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 ),

Line 170: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

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 ),

Line 171: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

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 ),

Line 172: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

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 ),

Line 173: ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),

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 ),

Line 174: ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),

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 ),

Line 175: ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),

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 ),

Line 176: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),

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,

Line 177: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),

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,

Line 178: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),

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,

Line 179: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),

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,

Line 184: CUSTOMER_RECIPROCAL_FLAG = DECODE( X_CUSTOMER_RECIPROCAL_FLAG, NULL, CUSTOMER_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, 'N', X_CUSTOMER_RECIPROCAL_FLAG ),

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 ),

Line 185: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),

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 ),

Line 186: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

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 ),

Line 187: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

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 ),

Line 188: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

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 ),

Line 189: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),

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 ),

Line 190: ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),

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 ),

Line 191: BILL_TO_FLAG = DECODE( X_BILL_TO_FLAG, NULL, BILL_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_BILL_TO_FLAG ),

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 )

Line 192: SHIP_TO_FLAG = DECODE( X_SHIP_TO_FLAG, NULL, SHIP_TO_FLAG, FND_API.G_MISS_CHAR, 'Y', X_SHIP_TO_FLAG ),

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

Line 193: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

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:

Line 194: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

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

Line 195: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )

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;

Line 417: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),

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 ),

Line 418: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),

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 ),

Line 419: NVL( RELATIONSHIP_TYPE, 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 ),

Line 420: NVL( COMMENTS, 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 ),

Line 421: NVL( ATTRIBUTE_CATEGORY, 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 ),

Line 422: NVL( ATTRIBUTE1, 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 ),

Line 423: NVL( ATTRIBUTE2, 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 ),

Line 424: NVL( ATTRIBUTE3, 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 ),

Line 425: NVL( ATTRIBUTE4, 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 ),

Line 426: NVL( ATTRIBUTE5, 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 ),

Line 427: NVL( ATTRIBUTE6, 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 ),

Line 428: NVL( ATTRIBUTE7, 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 ),

Line 429: NVL( ATTRIBUTE8, 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 ),

Line 430: NVL( ATTRIBUTE9, 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 ),

Line 431: NVL( ATTRIBUTE10, 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 ),

Line 432: NVL( CUSTOMER_RECIPROCAL_FLAG, 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 ),

Line 433: NVL( STATUS, 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 ),

Line 434: NVL( ATTRIBUTE11, 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 ),

Line 435: NVL( ATTRIBUTE12, 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 ),

Line 436: NVL( ATTRIBUTE13, 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 ),

Line 437: NVL( ATTRIBUTE14, 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 ),

Line 438: NVL( ATTRIBUTE15, 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 ),

Line 439: NVL( BILL_TO_FLAG, 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 ),
443: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489

Line 440: NVL( SHIP_TO_FLAG, 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
444: NVL( CUST_ACCT_RELATE_ID, FND_API.G_MISS_NUM) -- Bug 4529413

Line 441: NVL( CREATED_BY_MODULE, 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
445: FROM HZ_CUST_ACCT_RELATE_ALL

Line 442: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),

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;

Line 443: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489

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:

Line 444: NVL( CUST_ACCT_RELATE_ID, FND_API.G_MISS_NUM) -- Bug 4529413

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:

Line 456: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),

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 ),

Line 457: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),

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 ),

Line 458: NVL( RELATIONSHIP_TYPE, 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 ),

Line 459: NVL( COMMENTS, 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 ),

Line 460: NVL( ATTRIBUTE_CATEGORY, 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 ),

Line 461: NVL( ATTRIBUTE1, 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 ),

Line 462: NVL( ATTRIBUTE2, 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 ),

Line 463: NVL( ATTRIBUTE3, 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 ),

Line 464: NVL( ATTRIBUTE4, 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 ),

Line 465: NVL( ATTRIBUTE5, 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 ),

Line 466: NVL( ATTRIBUTE6, 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 ),

Line 467: NVL( ATTRIBUTE7, 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 ),

Line 468: NVL( ATTRIBUTE8, 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 ),

Line 469: NVL( ATTRIBUTE9, 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 ),

Line 470: NVL( ATTRIBUTE10, 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 ),

Line 471: NVL( CUSTOMER_RECIPROCAL_FLAG, 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 ),

Line 472: NVL( STATUS, 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 ),

Line 473: NVL( ATTRIBUTE11, 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 ),

Line 474: NVL( ATTRIBUTE12, 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 ),

Line 475: NVL( ATTRIBUTE13, 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 ),

Line 476: NVL( ATTRIBUTE14, 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 ),

Line 477: NVL( ATTRIBUTE15, 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 ),

Line 478: NVL( BILL_TO_FLAG, 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 ),
482: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489

Line 479: NVL( SHIP_TO_FLAG, 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
483: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM) -- Bug 4529413

Line 480: NVL( CREATED_BY_MODULE, 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
484: FROM HZ_CUST_ACCT_RELATE_ALL

Line 481: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),

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

Line 482: NVL( ORG_ID, FND_API.G_MISS_NUM), -- Bug 3456489

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

Line 483: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM) -- Bug 4529413

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

Line 532: RAISE FND_API.G_EXC_ERROR;

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:

Line 577: RAISE FND_API.G_EXC_ERROR;

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;

Line 619: NVL( CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),

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 ),

Line 620: NVL( RELATED_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM ),

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 ),

Line 621: NVL( RELATIONSHIP_TYPE, 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 ),

Line 622: NVL( COMMENTS, 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 ),

Line 623: NVL( ATTRIBUTE_CATEGORY, 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 ),

Line 624: NVL( ATTRIBUTE1, 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 ),

Line 625: NVL( ATTRIBUTE2, 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 ),

Line 626: NVL( ATTRIBUTE3, 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 ),

Line 627: NVL( ATTRIBUTE4, 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 ),

Line 628: NVL( ATTRIBUTE5, 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 ),

Line 629: NVL( ATTRIBUTE6, 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 ),

Line 630: NVL( ATTRIBUTE7, 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 ),

Line 631: NVL( ATTRIBUTE8, 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 ),

Line 632: NVL( ATTRIBUTE9, 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 ),

Line 633: NVL( ATTRIBUTE10, 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 ),

Line 634: NVL( CUSTOMER_RECIPROCAL_FLAG, 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 ),

Line 635: NVL( STATUS, 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 ),

Line 636: NVL( ATTRIBUTE11, 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 ),

Line 637: NVL( ATTRIBUTE12, 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 ),

Line 638: NVL( ATTRIBUTE13, 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 ),

Line 639: NVL( ATTRIBUTE14, 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 ),

Line 640: NVL( ATTRIBUTE15, 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 ),

Line 641: NVL( BILL_TO_FLAG, 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 ),
645: NVL( ORG_ID, FND_API.G_MISS_NUM),

Line 642: NVL( SHIP_TO_FLAG, 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),
646: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM)

Line 643: NVL( CREATED_BY_MODULE, 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)
647: FROM HZ_CUST_ACCT_RELATE_ALL

Line 644: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),

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;

Line 645: NVL( ORG_ID, FND_API.G_MISS_NUM),

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:

Line 646: NVL( CUST_ACCT_RELATE_ID,FND_API.G_MISS_NUM)

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

Line 687: RAISE FND_API.G_EXC_ERROR;

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;