eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_WRITEOFF_OBJECTS_PKG dependencies on FND_API

Line 103: ,decode( x_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, x_CONTRACT_ID)

99: ) VALUES (
100: x_WRITEOFF_OBJECT_ID
101: ,x_WRITEOFF_ID
102: ,x_OBJECT_VERSION_NUMBER
103: ,decode( x_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, x_CONTRACT_ID)
104: ,decode( x_CONS_INVOICE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_ID)
105: ,decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_LINE_ID)
106: ,x_TRANSACTION_ID
107: ,x_ADJUSTMENT_AMOUNT

Line 104: ,decode( x_CONS_INVOICE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_ID)

100: x_WRITEOFF_OBJECT_ID
101: ,x_WRITEOFF_ID
102: ,x_OBJECT_VERSION_NUMBER
103: ,decode( x_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, x_CONTRACT_ID)
104: ,decode( x_CONS_INVOICE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_ID)
105: ,decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_LINE_ID)
106: ,x_TRANSACTION_ID
107: ,x_ADJUSTMENT_AMOUNT
108: ,x_ADJUSTMENT_REASON_CODE

Line 105: ,decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_LINE_ID)

101: ,x_WRITEOFF_ID
102: ,x_OBJECT_VERSION_NUMBER
103: ,decode( x_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, x_CONTRACT_ID)
104: ,decode( x_CONS_INVOICE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_ID)
105: ,decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_LINE_ID)
106: ,x_TRANSACTION_ID
107: ,x_ADJUSTMENT_AMOUNT
108: ,x_ADJUSTMENT_REASON_CODE
109: ,decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM, NULL,

Line 109: ,decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM, NULL,

105: ,decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_LINE_ID)
106: ,x_TRANSACTION_ID
107: ,x_ADJUSTMENT_AMOUNT
108: ,x_ADJUSTMENT_REASON_CODE
109: ,decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM, NULL,
110: x_RECEVIABLES_ADJUSTMENT_ID),
111: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),

Line 111: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),

107: ,x_ADJUSTMENT_AMOUNT
108: ,x_ADJUSTMENT_REASON_CODE
109: ,decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM, NULL,
110: x_RECEVIABLES_ADJUSTMENT_ID),
111: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),

Line 112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),

108: ,x_ADJUSTMENT_REASON_CODE
109: ,decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM, NULL,
110: x_RECEVIABLES_ADJUSTMENT_ID),
111: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),

Line 113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),

109: ,decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM, NULL,
110: x_RECEVIABLES_ADJUSTMENT_ID),
111: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),

Line 114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),

110: x_RECEVIABLES_ADJUSTMENT_ID),
111: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),

Line 115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),

111: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),

Line 116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),

112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),

Line 117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),

113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),

Line 118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),

114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),

Line 119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),

115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),

Line 120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),

116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),

Line 121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),

117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),

Line 122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),

118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),

Line 123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),

119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),

Line 124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),

120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),

Line 125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),

121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),

Line 126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),

122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)

Line 127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),

123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)
131: ,x_CREATED_BY

Line 128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),

124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)
131: ,x_CREATED_BY
132: ,x_CREATION_DATE

Line 129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),

125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)
131: ,x_CREATED_BY
132: ,x_CREATION_DATE
133: ,x_LAST_UPDATED_BY

Line 130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)

126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)
131: ,x_CREATED_BY
132: ,x_CREATION_DATE
133: ,x_LAST_UPDATED_BY
134: ,x_LAST_UPDATE_DATE

Line 135: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)

131: ,x_CREATED_BY
132: ,x_CREATION_DATE
133: ,x_LAST_UPDATED_BY
134: ,x_LAST_UPDATE_DATE
135: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
136: ,decode( x_writeoff_status, FND_API.G_MISS_CHAR, NULL, x_writeoff_status)
137: ,decode( x_writeoff_type_id, FND_API.G_MISS_NUM, NULL, x_writeoff_type_id)
138: ,decode( x_writeoff_type, FND_API.G_MISS_CHAR, NULL, x_writeoff_type)
139: ,decode( x_customer_trx_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_id)

Line 136: ,decode( x_writeoff_status, FND_API.G_MISS_CHAR, NULL, x_writeoff_status)

132: ,x_CREATION_DATE
133: ,x_LAST_UPDATED_BY
134: ,x_LAST_UPDATE_DATE
135: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
136: ,decode( x_writeoff_status, FND_API.G_MISS_CHAR, NULL, x_writeoff_status)
137: ,decode( x_writeoff_type_id, FND_API.G_MISS_NUM, NULL, x_writeoff_type_id)
138: ,decode( x_writeoff_type, FND_API.G_MISS_CHAR, NULL, x_writeoff_type)
139: ,decode( x_customer_trx_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_id)
140: ,decode( x_customer_trx_line_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_line_id)

Line 137: ,decode( x_writeoff_type_id, FND_API.G_MISS_NUM, NULL, x_writeoff_type_id)

133: ,x_LAST_UPDATED_BY
134: ,x_LAST_UPDATE_DATE
135: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
136: ,decode( x_writeoff_status, FND_API.G_MISS_CHAR, NULL, x_writeoff_status)
137: ,decode( x_writeoff_type_id, FND_API.G_MISS_NUM, NULL, x_writeoff_type_id)
138: ,decode( x_writeoff_type, FND_API.G_MISS_CHAR, NULL, x_writeoff_type)
139: ,decode( x_customer_trx_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_id)
140: ,decode( x_customer_trx_line_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_line_id)
141: );

Line 138: ,decode( x_writeoff_type, FND_API.G_MISS_CHAR, NULL, x_writeoff_type)

134: ,x_LAST_UPDATE_DATE
135: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
136: ,decode( x_writeoff_status, FND_API.G_MISS_CHAR, NULL, x_writeoff_status)
137: ,decode( x_writeoff_type_id, FND_API.G_MISS_NUM, NULL, x_writeoff_type_id)
138: ,decode( x_writeoff_type, FND_API.G_MISS_CHAR, NULL, x_writeoff_type)
139: ,decode( x_customer_trx_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_id)
140: ,decode( x_customer_trx_line_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_line_id)
141: );
142:

Line 139: ,decode( x_customer_trx_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_id)

135: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
136: ,decode( x_writeoff_status, FND_API.G_MISS_CHAR, NULL, x_writeoff_status)
137: ,decode( x_writeoff_type_id, FND_API.G_MISS_NUM, NULL, x_writeoff_type_id)
138: ,decode( x_writeoff_type, FND_API.G_MISS_CHAR, NULL, x_writeoff_type)
139: ,decode( x_customer_trx_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_id)
140: ,decode( x_customer_trx_line_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_line_id)
141: );
142:
143: OPEN C;

Line 140: ,decode( x_customer_trx_line_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_line_id)

136: ,decode( x_writeoff_status, FND_API.G_MISS_CHAR, NULL, x_writeoff_status)
137: ,decode( x_writeoff_type_id, FND_API.G_MISS_NUM, NULL, x_writeoff_type_id)
138: ,decode( x_writeoff_type, FND_API.G_MISS_CHAR, NULL, x_writeoff_type)
139: ,decode( x_customer_trx_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_id)
140: ,decode( x_customer_trx_line_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_line_id)
141: );
142:
143: OPEN C;
144: FETCH C INTO x_rowid;

Line 198: WRITEOFF_ID = decode( x_WRITEOFF_ID, FND_API.G_MISS_NUM, NULL,

194: x_customer_trx_line_id in number)
195: IS
196: BEGIN
197: UPDATE IEX_WRITEOFF_OBJECTS SET
198: WRITEOFF_ID = decode( x_WRITEOFF_ID, FND_API.G_MISS_NUM, NULL,
199: NULL, WRITEOFF_ID, x_WRITEOFF_ID)
200: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,NULL,
201: NULL,OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)
202:

Line 200: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,NULL,

196: BEGIN
197: UPDATE IEX_WRITEOFF_OBJECTS SET
198: WRITEOFF_ID = decode( x_WRITEOFF_ID, FND_API.G_MISS_NUM, NULL,
199: NULL, WRITEOFF_ID, x_WRITEOFF_ID)
200: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,NULL,
201: NULL,OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)
202:
203: ,CONTRACT_ID = decode( x_CONTRACT_ID, FND_API.G_MISS_NUM, NULL,
204: NULL, CONTRACT_ID, x_CONTRACT_ID)

Line 203: ,CONTRACT_ID = decode( x_CONTRACT_ID, FND_API.G_MISS_NUM, NULL,

199: NULL, WRITEOFF_ID, x_WRITEOFF_ID)
200: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,NULL,
201: NULL,OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)
202:
203: ,CONTRACT_ID = decode( x_CONTRACT_ID, FND_API.G_MISS_NUM, NULL,
204: NULL, CONTRACT_ID, x_CONTRACT_ID)
205:
206: ,CONS_INVOICE_ID = decode( x_CONS_INVOICE_ID, FND_API.G_MISS_NUM,NULL,
207: NULL,CONS_INVOICE_ID, x_CONS_INVOICE_ID)

Line 206: ,CONS_INVOICE_ID = decode( x_CONS_INVOICE_ID, FND_API.G_MISS_NUM,NULL,

202:
203: ,CONTRACT_ID = decode( x_CONTRACT_ID, FND_API.G_MISS_NUM, NULL,
204: NULL, CONTRACT_ID, x_CONTRACT_ID)
205:
206: ,CONS_INVOICE_ID = decode( x_CONS_INVOICE_ID, FND_API.G_MISS_NUM,NULL,
207: NULL,CONS_INVOICE_ID, x_CONS_INVOICE_ID)
208:
209: ,CONS_INVOICE_LINE_ID = decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM,NULL,
210: NULL,CONS_INVOICE_LINE_ID,x_CONS_INVOICE_LINE_ID)

Line 209: ,CONS_INVOICE_LINE_ID = decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM,NULL,

205:
206: ,CONS_INVOICE_ID = decode( x_CONS_INVOICE_ID, FND_API.G_MISS_NUM,NULL,
207: NULL,CONS_INVOICE_ID, x_CONS_INVOICE_ID)
208:
209: ,CONS_INVOICE_LINE_ID = decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM,NULL,
210: NULL,CONS_INVOICE_LINE_ID,x_CONS_INVOICE_LINE_ID)
211:
212: ,TRANSACTION_ID = decode( x_TRANSACTION_ID, FND_API.G_MISS_NUM,NULL,
213: NULL,TRANSACTION_ID, x_TRANSACTION_ID)

Line 212: ,TRANSACTION_ID = decode( x_TRANSACTION_ID, FND_API.G_MISS_NUM,NULL,

208:
209: ,CONS_INVOICE_LINE_ID = decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM,NULL,
210: NULL,CONS_INVOICE_LINE_ID,x_CONS_INVOICE_LINE_ID)
211:
212: ,TRANSACTION_ID = decode( x_TRANSACTION_ID, FND_API.G_MISS_NUM,NULL,
213: NULL,TRANSACTION_ID, x_TRANSACTION_ID)
214:
215: ,ADJUSTMENT_AMOUNT = decode( x_ADJUSTMENT_AMOUNT, FND_API.G_MISS_NUM,NULL,
216: NULL,ADJUSTMENT_AMOUNT, x_ADJUSTMENT_AMOUNT)

Line 215: ,ADJUSTMENT_AMOUNT = decode( x_ADJUSTMENT_AMOUNT, FND_API.G_MISS_NUM,NULL,

211:
212: ,TRANSACTION_ID = decode( x_TRANSACTION_ID, FND_API.G_MISS_NUM,NULL,
213: NULL,TRANSACTION_ID, x_TRANSACTION_ID)
214:
215: ,ADJUSTMENT_AMOUNT = decode( x_ADJUSTMENT_AMOUNT, FND_API.G_MISS_NUM,NULL,
216: NULL,ADJUSTMENT_AMOUNT, x_ADJUSTMENT_AMOUNT)
217:
218: ,ADJUSTMENT_REASON_CODE = decode( x_ADJUSTMENT_REASON_CODE, FND_API.G_MISS_CHAR,NULL,
219: NULL,ADJUSTMENT_REASON_CODE, x_ADJUSTMENT_REASON_CODE)

Line 218: ,ADJUSTMENT_REASON_CODE = decode( x_ADJUSTMENT_REASON_CODE, FND_API.G_MISS_CHAR,NULL,

214:
215: ,ADJUSTMENT_AMOUNT = decode( x_ADJUSTMENT_AMOUNT, FND_API.G_MISS_NUM,NULL,
216: NULL,ADJUSTMENT_AMOUNT, x_ADJUSTMENT_AMOUNT)
217:
218: ,ADJUSTMENT_REASON_CODE = decode( x_ADJUSTMENT_REASON_CODE, FND_API.G_MISS_CHAR,NULL,
219: NULL,ADJUSTMENT_REASON_CODE, x_ADJUSTMENT_REASON_CODE)
220:
221: ,RECEVIABLES_ADJUSTMENT_ID = decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM,NULL,
222: NULL,RECEVIABLES_ADJUSTMENT_ID, x_RECEVIABLES_ADJUSTMENT_ID)

Line 221: ,RECEVIABLES_ADJUSTMENT_ID = decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM,NULL,

217:
218: ,ADJUSTMENT_REASON_CODE = decode( x_ADJUSTMENT_REASON_CODE, FND_API.G_MISS_CHAR,NULL,
219: NULL,ADJUSTMENT_REASON_CODE, x_ADJUSTMENT_REASON_CODE)
220:
221: ,RECEVIABLES_ADJUSTMENT_ID = decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM,NULL,
222: NULL,RECEVIABLES_ADJUSTMENT_ID, x_RECEVIABLES_ADJUSTMENT_ID)
223:
224: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,NULL, NULL,REQUEST_ID, x_REQUEST_ID)
225: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,

Line 224: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,NULL, NULL,REQUEST_ID, x_REQUEST_ID)

220:
221: ,RECEVIABLES_ADJUSTMENT_ID = decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM,NULL,
222: NULL,RECEVIABLES_ADJUSTMENT_ID, x_RECEVIABLES_ADJUSTMENT_ID)
223:
224: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,NULL, NULL,REQUEST_ID, x_REQUEST_ID)
225: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,
226: NULL,PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID),
227: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,NULL,
228: NULL,PROGRAM_ID, x_PROGRAM_ID),

Line 225: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,

221: ,RECEVIABLES_ADJUSTMENT_ID = decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM,NULL,
222: NULL,RECEVIABLES_ADJUSTMENT_ID, x_RECEVIABLES_ADJUSTMENT_ID)
223:
224: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,NULL, NULL,REQUEST_ID, x_REQUEST_ID)
225: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,
226: NULL,PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID),
227: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,NULL,
228: NULL,PROGRAM_ID, x_PROGRAM_ID),
229: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,

Line 227: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,NULL,

223:
224: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,NULL, NULL,REQUEST_ID, x_REQUEST_ID)
225: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,
226: NULL,PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID),
227: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,NULL,
228: NULL,PROGRAM_ID, x_PROGRAM_ID),
229: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
230: NULL,PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE),
231: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,NULL,

Line 229: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,

225: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,
226: NULL,PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID),
227: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,NULL,
228: NULL,PROGRAM_ID, x_PROGRAM_ID),
229: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
230: NULL,PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE),
231: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,NULL,
232: NULL,ATTRIBUTE_CATEGORY, x_ATTRIBUTE_CATEGORY),
233: ATTRIBUTE1 = decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR,NULL,

Line 231: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,NULL,

227: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,NULL,
228: NULL,PROGRAM_ID, x_PROGRAM_ID),
229: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
230: NULL,PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE),
231: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,NULL,
232: NULL,ATTRIBUTE_CATEGORY, x_ATTRIBUTE_CATEGORY),
233: ATTRIBUTE1 = decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR,NULL,
234: NULL,ATTRIBUTE1, x_ATTRIBUTE1),
235: ATTRIBUTE2 = decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR,NULL,

Line 233: ATTRIBUTE1 = decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR,NULL,

229: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
230: NULL,PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE),
231: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,NULL,
232: NULL,ATTRIBUTE_CATEGORY, x_ATTRIBUTE_CATEGORY),
233: ATTRIBUTE1 = decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR,NULL,
234: NULL,ATTRIBUTE1, x_ATTRIBUTE1),
235: ATTRIBUTE2 = decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR,NULL,
236: NULL,ATTRIBUTE2, x_ATTRIBUTE2),
237: ATTRIBUTE3 = decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,

Line 235: ATTRIBUTE2 = decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR,NULL,

231: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,NULL,
232: NULL,ATTRIBUTE_CATEGORY, x_ATTRIBUTE_CATEGORY),
233: ATTRIBUTE1 = decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR,NULL,
234: NULL,ATTRIBUTE1, x_ATTRIBUTE1),
235: ATTRIBUTE2 = decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR,NULL,
236: NULL,ATTRIBUTE2, x_ATTRIBUTE2),
237: ATTRIBUTE3 = decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
238: NULL,ATTRIBUTE3, x_ATTRIBUTE3),
239: ATTRIBUTE4 = decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR,NULL,

Line 237: ATTRIBUTE3 = decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,

233: ATTRIBUTE1 = decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR,NULL,
234: NULL,ATTRIBUTE1, x_ATTRIBUTE1),
235: ATTRIBUTE2 = decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR,NULL,
236: NULL,ATTRIBUTE2, x_ATTRIBUTE2),
237: ATTRIBUTE3 = decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
238: NULL,ATTRIBUTE3, x_ATTRIBUTE3),
239: ATTRIBUTE4 = decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR,NULL,
240: NULL,ATTRIBUTE4, x_ATTRIBUTE4),
241: ATTRIBUTE5 = decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR,NULL,

Line 239: ATTRIBUTE4 = decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR,NULL,

235: ATTRIBUTE2 = decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR,NULL,
236: NULL,ATTRIBUTE2, x_ATTRIBUTE2),
237: ATTRIBUTE3 = decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
238: NULL,ATTRIBUTE3, x_ATTRIBUTE3),
239: ATTRIBUTE4 = decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR,NULL,
240: NULL,ATTRIBUTE4, x_ATTRIBUTE4),
241: ATTRIBUTE5 = decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR,NULL,
242: NULL,ATTRIBUTE5, x_ATTRIBUTE5),
243:

Line 241: ATTRIBUTE5 = decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR,NULL,

237: ATTRIBUTE3 = decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
238: NULL,ATTRIBUTE3, x_ATTRIBUTE3),
239: ATTRIBUTE4 = decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR,NULL,
240: NULL,ATTRIBUTE4, x_ATTRIBUTE4),
241: ATTRIBUTE5 = decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR,NULL,
242: NULL,ATTRIBUTE5, x_ATTRIBUTE5),
243:
244: ATTRIBUTE6 = decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR,NULL,
245: NULL,ATTRIBUTE6, x_ATTRIBUTE6),

Line 244: ATTRIBUTE6 = decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR,NULL,

240: NULL,ATTRIBUTE4, x_ATTRIBUTE4),
241: ATTRIBUTE5 = decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR,NULL,
242: NULL,ATTRIBUTE5, x_ATTRIBUTE5),
243:
244: ATTRIBUTE6 = decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR,NULL,
245: NULL,ATTRIBUTE6, x_ATTRIBUTE6),
246: ATTRIBUTE7 = decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR,NULL,
247: NULL,ATTRIBUTE7, x_ATTRIBUTE7),
248: ATTRIBUTE8 = decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,

Line 246: ATTRIBUTE7 = decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR,NULL,

242: NULL,ATTRIBUTE5, x_ATTRIBUTE5),
243:
244: ATTRIBUTE6 = decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR,NULL,
245: NULL,ATTRIBUTE6, x_ATTRIBUTE6),
246: ATTRIBUTE7 = decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR,NULL,
247: NULL,ATTRIBUTE7, x_ATTRIBUTE7),
248: ATTRIBUTE8 = decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
249: NULL,ATTRIBUTE8, x_ATTRIBUTE8),
250: ATTRIBUTE9= decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR,NULL,

Line 248: ATTRIBUTE8 = decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,

244: ATTRIBUTE6 = decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR,NULL,
245: NULL,ATTRIBUTE6, x_ATTRIBUTE6),
246: ATTRIBUTE7 = decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR,NULL,
247: NULL,ATTRIBUTE7, x_ATTRIBUTE7),
248: ATTRIBUTE8 = decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
249: NULL,ATTRIBUTE8, x_ATTRIBUTE8),
250: ATTRIBUTE9= decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR,NULL,
251: NULL,ATTRIBUTE9, x_ATTRIBUTE9),
252: ATTRIBUTE10 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,

Line 250: ATTRIBUTE9= decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR,NULL,

246: ATTRIBUTE7 = decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR,NULL,
247: NULL,ATTRIBUTE7, x_ATTRIBUTE7),
248: ATTRIBUTE8 = decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
249: NULL,ATTRIBUTE8, x_ATTRIBUTE8),
250: ATTRIBUTE9= decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR,NULL,
251: NULL,ATTRIBUTE9, x_ATTRIBUTE9),
252: ATTRIBUTE10 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
253: NULL,ATTRIBUTE10, x_ATTRIBUTE10),
254:

Line 252: ATTRIBUTE10 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,

248: ATTRIBUTE8 = decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
249: NULL,ATTRIBUTE8, x_ATTRIBUTE8),
250: ATTRIBUTE9= decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR,NULL,
251: NULL,ATTRIBUTE9, x_ATTRIBUTE9),
252: ATTRIBUTE10 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
253: NULL,ATTRIBUTE10, x_ATTRIBUTE10),
254:
255: ATTRIBUTE11 = decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR,NULL,
256: NULL,ATTRIBUTE11, x_ATTRIBUTE11),

Line 255: ATTRIBUTE11 = decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR,NULL,

251: NULL,ATTRIBUTE9, x_ATTRIBUTE9),
252: ATTRIBUTE10 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
253: NULL,ATTRIBUTE10, x_ATTRIBUTE10),
254:
255: ATTRIBUTE11 = decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR,NULL,
256: NULL,ATTRIBUTE11, x_ATTRIBUTE11),
257:
258: ATTRIBUTE12 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
259: NULL,ATTRIBUTE12, x_ATTRIBUTE12),

Line 258: ATTRIBUTE12 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,

254:
255: ATTRIBUTE11 = decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR,NULL,
256: NULL,ATTRIBUTE11, x_ATTRIBUTE11),
257:
258: ATTRIBUTE12 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
259: NULL,ATTRIBUTE12, x_ATTRIBUTE12),
260:
261: ATTRIBUTE13 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
262: NULL,ATTRIBUTE13, x_ATTRIBUTE13),

Line 261: ATTRIBUTE13 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,

257:
258: ATTRIBUTE12 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
259: NULL,ATTRIBUTE12, x_ATTRIBUTE12),
260:
261: ATTRIBUTE13 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
262: NULL,ATTRIBUTE13, x_ATTRIBUTE13),
263: ATTRIBUTE14 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
264: NULL,ATTRIBUTE14, x_ATTRIBUTE14),
265: ATTRIBUTE15 = decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL,

Line 263: ATTRIBUTE14 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,

259: NULL,ATTRIBUTE12, x_ATTRIBUTE12),
260:
261: ATTRIBUTE13 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
262: NULL,ATTRIBUTE13, x_ATTRIBUTE13),
263: ATTRIBUTE14 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
264: NULL,ATTRIBUTE14, x_ATTRIBUTE14),
265: ATTRIBUTE15 = decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL,
266: NULL,ATTRIBUTE15, x_ATTRIBUTE15),
267:

Line 265: ATTRIBUTE15 = decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL,

261: ATTRIBUTE13 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
262: NULL,ATTRIBUTE13, x_ATTRIBUTE13),
263: ATTRIBUTE14 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
264: NULL,ATTRIBUTE14, x_ATTRIBUTE14),
265: ATTRIBUTE15 = decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL,
266: NULL,ATTRIBUTE15, x_ATTRIBUTE15),
267:
268: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,
269: NULL,LAST_UPDATED_BY, x_LAST_UPDATED_BY),

Line 268: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,

264: NULL,ATTRIBUTE14, x_ATTRIBUTE14),
265: ATTRIBUTE15 = decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL,
266: NULL,ATTRIBUTE15, x_ATTRIBUTE15),
267:
268: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,
269: NULL,LAST_UPDATED_BY, x_LAST_UPDATED_BY),
270: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
271: NULL,LAST_UPDATE_DATE, x_LAST_UPDATE_DATE),
272: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,

Line 270: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,

266: NULL,ATTRIBUTE15, x_ATTRIBUTE15),
267:
268: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,
269: NULL,LAST_UPDATED_BY, x_LAST_UPDATED_BY),
270: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
271: NULL,LAST_UPDATE_DATE, x_LAST_UPDATE_DATE),
272: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,
273: NULL,LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN),
274: WRITEOFF_STATUS = decode( x_WRITEOFF_STATUS, FND_API.G_MISS_CHAR,NULL,

Line 272: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,

268: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,
269: NULL,LAST_UPDATED_BY, x_LAST_UPDATED_BY),
270: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
271: NULL,LAST_UPDATE_DATE, x_LAST_UPDATE_DATE),
272: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,
273: NULL,LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN),
274: WRITEOFF_STATUS = decode( x_WRITEOFF_STATUS, FND_API.G_MISS_CHAR,NULL,
275: NULL,WRITEOFF_STATUS, x_WRITEOFF_STATUS),
276: WRITEOFF_TYPE_ID = decode( x_WRITEOFF_TYPE_ID, FND_API.G_MISS_NUM,NULL,

Line 274: WRITEOFF_STATUS = decode( x_WRITEOFF_STATUS, FND_API.G_MISS_CHAR,NULL,

270: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
271: NULL,LAST_UPDATE_DATE, x_LAST_UPDATE_DATE),
272: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,
273: NULL,LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN),
274: WRITEOFF_STATUS = decode( x_WRITEOFF_STATUS, FND_API.G_MISS_CHAR,NULL,
275: NULL,WRITEOFF_STATUS, x_WRITEOFF_STATUS),
276: WRITEOFF_TYPE_ID = decode( x_WRITEOFF_TYPE_ID, FND_API.G_MISS_NUM,NULL,
277: NULL,WRITEOFF_TYPE_ID, X_WRITEOFF_TYPE_ID),
278: WRITEOFF_TYPE = decode( x_WRITEOFF_TYPE, FND_API.G_MISS_CHAR,NULL,

Line 276: WRITEOFF_TYPE_ID = decode( x_WRITEOFF_TYPE_ID, FND_API.G_MISS_NUM,NULL,

272: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,
273: NULL,LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN),
274: WRITEOFF_STATUS = decode( x_WRITEOFF_STATUS, FND_API.G_MISS_CHAR,NULL,
275: NULL,WRITEOFF_STATUS, x_WRITEOFF_STATUS),
276: WRITEOFF_TYPE_ID = decode( x_WRITEOFF_TYPE_ID, FND_API.G_MISS_NUM,NULL,
277: NULL,WRITEOFF_TYPE_ID, X_WRITEOFF_TYPE_ID),
278: WRITEOFF_TYPE = decode( x_WRITEOFF_TYPE, FND_API.G_MISS_CHAR,NULL,
279: NULL,WRITEOFF_TYPE, x_WRITEOFF_TYPE),
280: customer_trx_id = decode( x_customer_trx_id, FND_API.G_MISS_NUM,NULL,

Line 278: WRITEOFF_TYPE = decode( x_WRITEOFF_TYPE, FND_API.G_MISS_CHAR,NULL,

274: WRITEOFF_STATUS = decode( x_WRITEOFF_STATUS, FND_API.G_MISS_CHAR,NULL,
275: NULL,WRITEOFF_STATUS, x_WRITEOFF_STATUS),
276: WRITEOFF_TYPE_ID = decode( x_WRITEOFF_TYPE_ID, FND_API.G_MISS_NUM,NULL,
277: NULL,WRITEOFF_TYPE_ID, X_WRITEOFF_TYPE_ID),
278: WRITEOFF_TYPE = decode( x_WRITEOFF_TYPE, FND_API.G_MISS_CHAR,NULL,
279: NULL,WRITEOFF_TYPE, x_WRITEOFF_TYPE),
280: customer_trx_id = decode( x_customer_trx_id, FND_API.G_MISS_NUM,NULL,
281: NULL, customer_trx_id, x_customer_trx_id),
282: customer_trx_line_id = decode( x_customer_trx_line_id, FND_API.G_MISS_NUM,NULL,

Line 280: customer_trx_id = decode( x_customer_trx_id, FND_API.G_MISS_NUM,NULL,

276: WRITEOFF_TYPE_ID = decode( x_WRITEOFF_TYPE_ID, FND_API.G_MISS_NUM,NULL,
277: NULL,WRITEOFF_TYPE_ID, X_WRITEOFF_TYPE_ID),
278: WRITEOFF_TYPE = decode( x_WRITEOFF_TYPE, FND_API.G_MISS_CHAR,NULL,
279: NULL,WRITEOFF_TYPE, x_WRITEOFF_TYPE),
280: customer_trx_id = decode( x_customer_trx_id, FND_API.G_MISS_NUM,NULL,
281: NULL, customer_trx_id, x_customer_trx_id),
282: customer_trx_line_id = decode( x_customer_trx_line_id, FND_API.G_MISS_NUM,NULL,
283: NULL, customer_trx_line_id, x_customer_trx_line_id)
284:

Line 282: customer_trx_line_id = decode( x_customer_trx_line_id, FND_API.G_MISS_NUM,NULL,

278: WRITEOFF_TYPE = decode( x_WRITEOFF_TYPE, FND_API.G_MISS_CHAR,NULL,
279: NULL,WRITEOFF_TYPE, x_WRITEOFF_TYPE),
280: customer_trx_id = decode( x_customer_trx_id, FND_API.G_MISS_NUM,NULL,
281: NULL, customer_trx_id, x_customer_trx_id),
282: customer_trx_line_id = decode( x_customer_trx_line_id, FND_API.G_MISS_NUM,NULL,
283: NULL, customer_trx_line_id, x_customer_trx_line_id)
284:
285: WHERE writeoff_object_id = x_WRITEOFF_OBJECT_ID;
286: