APPS.CSD_REPAIR_ACTUAL_LINES_PKG dependencies on FND_API

Line 28: ,p_WARRANTY_CLAIM_FLAG VARCHAR2 := FND_API.G_MISS_CHAR

24: ,p_RESOURCE_ID NUMBER
25: ,p_OVERRIDE_CHARGE_FLAG VARCHAR2
26: ,p_ACTUAL_SOURCE_CODE VARCHAR2
27: ,p_ACTUAL_SOURCE_ID NUMBER
28: ,p_WARRANTY_CLAIM_FLAG VARCHAR2 := FND_API.G_MISS_CHAR
29: ,p_WARRANTY_NUMBER VARCHAR2 := FND_API.G_MISS_CHAR
30: ,p_WARRANTY_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR
31: ,p_REPLACED_ITEM_ID NUMBER := FND_API.G_MISS_NUM
32: ,p_ATTRIBUTE_CATEGORY VARCHAR2

Line 29: ,p_WARRANTY_NUMBER VARCHAR2 := FND_API.G_MISS_CHAR

25: ,p_OVERRIDE_CHARGE_FLAG VARCHAR2
26: ,p_ACTUAL_SOURCE_CODE VARCHAR2
27: ,p_ACTUAL_SOURCE_ID NUMBER
28: ,p_WARRANTY_CLAIM_FLAG VARCHAR2 := FND_API.G_MISS_CHAR
29: ,p_WARRANTY_NUMBER VARCHAR2 := FND_API.G_MISS_CHAR
30: ,p_WARRANTY_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR
31: ,p_REPLACED_ITEM_ID NUMBER := FND_API.G_MISS_NUM
32: ,p_ATTRIBUTE_CATEGORY VARCHAR2
33: ,p_ATTRIBUTE1 VARCHAR2

Line 30: ,p_WARRANTY_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR

26: ,p_ACTUAL_SOURCE_CODE VARCHAR2
27: ,p_ACTUAL_SOURCE_ID NUMBER
28: ,p_WARRANTY_CLAIM_FLAG VARCHAR2 := FND_API.G_MISS_CHAR
29: ,p_WARRANTY_NUMBER VARCHAR2 := FND_API.G_MISS_CHAR
30: ,p_WARRANTY_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR
31: ,p_REPLACED_ITEM_ID NUMBER := FND_API.G_MISS_NUM
32: ,p_ATTRIBUTE_CATEGORY VARCHAR2
33: ,p_ATTRIBUTE1 VARCHAR2
34: ,p_ATTRIBUTE2 VARCHAR2

Line 31: ,p_REPLACED_ITEM_ID NUMBER := FND_API.G_MISS_NUM

27: ,p_ACTUAL_SOURCE_ID NUMBER
28: ,p_WARRANTY_CLAIM_FLAG VARCHAR2 := FND_API.G_MISS_CHAR
29: ,p_WARRANTY_NUMBER VARCHAR2 := FND_API.G_MISS_CHAR
30: ,p_WARRANTY_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR
31: ,p_REPLACED_ITEM_ID NUMBER := FND_API.G_MISS_NUM
32: ,p_ATTRIBUTE_CATEGORY VARCHAR2
33: ,p_ATTRIBUTE1 VARCHAR2
34: ,p_ATTRIBUTE2 VARCHAR2
35: ,p_ATTRIBUTE3 VARCHAR2

Line 73: If (px_REPAIR_ACTUAL_LINE_ID IS NULL) OR (px_REPAIR_ACTUAL_LINE_ID = FND_API.G_MISS_NUM) then

69:
70: IS
71: CURSOR C2 IS SELECT CSD_REPAIR_ACTUAL_LINES_S1.nextval FROM sys.dual;
72: BEGIN
73: If (px_REPAIR_ACTUAL_LINE_ID IS NULL) OR (px_REPAIR_ACTUAL_LINE_ID = FND_API.G_MISS_NUM) then
74: OPEN C2;
75: FETCH C2 INTO px_REPAIR_ACTUAL_LINE_ID;
76: CLOSE C2;
77: End If;

Line 138: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)

134: ,LOC_SEGMENT19
135: ,LOC_SEGMENT20
136: ) VALUES (
137: px_REPAIR_ACTUAL_LINE_ID
138: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
139: ,decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATE_DETAIL_ID)
140: ,decode( p_REPAIR_ACTUAL_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ACTUAL_ID)
141: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
142: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

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

135: ,LOC_SEGMENT20
136: ) VALUES (
137: px_REPAIR_ACTUAL_LINE_ID
138: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
139: ,decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATE_DETAIL_ID)
140: ,decode( p_REPAIR_ACTUAL_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ACTUAL_ID)
141: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
142: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
143: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)

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

136: ) VALUES (
137: px_REPAIR_ACTUAL_LINE_ID
138: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
139: ,decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATE_DETAIL_ID)
140: ,decode( p_REPAIR_ACTUAL_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ACTUAL_ID)
141: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
142: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
143: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
144: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

Line 141: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)

137: px_REPAIR_ACTUAL_LINE_ID
138: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
139: ,decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATE_DETAIL_ID)
140: ,decode( p_REPAIR_ACTUAL_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ACTUAL_ID)
141: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
142: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
143: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
144: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
145: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)

Line 142: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

138: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
139: ,decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATE_DETAIL_ID)
140: ,decode( p_REPAIR_ACTUAL_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ACTUAL_ID)
141: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
142: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
143: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
144: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
145: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
146: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

Line 143: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)

139: ,decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATE_DETAIL_ID)
140: ,decode( p_REPAIR_ACTUAL_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ACTUAL_ID)
141: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
142: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
143: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
144: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
145: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
146: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
147: ,decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, p_ITEM_COST)

Line 144: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

140: ,decode( p_REPAIR_ACTUAL_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ACTUAL_ID)
141: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
142: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
143: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
144: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
145: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
146: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
147: ,decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, p_ITEM_COST)
148: ,decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, p_JUSTIFICATION_NOTES)

Line 145: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)

141: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
142: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
143: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
144: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
145: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
146: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
147: ,decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, p_ITEM_COST)
148: ,decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, p_JUSTIFICATION_NOTES)
149: ,decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID)

Line 146: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

142: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
143: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
144: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
145: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
146: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
147: ,decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, p_ITEM_COST)
148: ,decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, p_JUSTIFICATION_NOTES)
149: ,decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID)
150: ,decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CHARGE_FLAG)

Line 147: ,decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, p_ITEM_COST)

143: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
144: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
145: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
146: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
147: ,decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, p_ITEM_COST)
148: ,decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, p_JUSTIFICATION_NOTES)
149: ,decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID)
150: ,decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CHARGE_FLAG)
151: ,decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTUAL_SOURCE_CODE)

Line 148: ,decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, p_JUSTIFICATION_NOTES)

144: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
145: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
146: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
147: ,decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, p_ITEM_COST)
148: ,decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, p_JUSTIFICATION_NOTES)
149: ,decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID)
150: ,decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CHARGE_FLAG)
151: ,decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTUAL_SOURCE_CODE)
152: ,decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_ACTUAL_SOURCE_ID)

Line 149: ,decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID)

145: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
146: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
147: ,decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, p_ITEM_COST)
148: ,decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, p_JUSTIFICATION_NOTES)
149: ,decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID)
150: ,decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CHARGE_FLAG)
151: ,decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTUAL_SOURCE_CODE)
152: ,decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_ACTUAL_SOURCE_ID)
153: ,decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_CLAIM_FLAG)

Line 150: ,decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CHARGE_FLAG)

146: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
147: ,decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, p_ITEM_COST)
148: ,decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, p_JUSTIFICATION_NOTES)
149: ,decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID)
150: ,decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CHARGE_FLAG)
151: ,decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTUAL_SOURCE_CODE)
152: ,decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_ACTUAL_SOURCE_ID)
153: ,decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_CLAIM_FLAG)
154: ,decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_NUMBER)

Line 151: ,decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTUAL_SOURCE_CODE)

147: ,decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, p_ITEM_COST)
148: ,decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, p_JUSTIFICATION_NOTES)
149: ,decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID)
150: ,decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CHARGE_FLAG)
151: ,decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTUAL_SOURCE_CODE)
152: ,decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_ACTUAL_SOURCE_ID)
153: ,decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_CLAIM_FLAG)
154: ,decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_NUMBER)
155: ,decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_STATUS_CODE)

Line 152: ,decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_ACTUAL_SOURCE_ID)

148: ,decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, p_JUSTIFICATION_NOTES)
149: ,decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID)
150: ,decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CHARGE_FLAG)
151: ,decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTUAL_SOURCE_CODE)
152: ,decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_ACTUAL_SOURCE_ID)
153: ,decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_CLAIM_FLAG)
154: ,decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_NUMBER)
155: ,decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_STATUS_CODE)
156: ,decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_REPLACED_ITEM_ID)

Line 153: ,decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_CLAIM_FLAG)

149: ,decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID)
150: ,decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CHARGE_FLAG)
151: ,decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTUAL_SOURCE_CODE)
152: ,decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_ACTUAL_SOURCE_ID)
153: ,decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_CLAIM_FLAG)
154: ,decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_NUMBER)
155: ,decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_STATUS_CODE)
156: ,decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_REPLACED_ITEM_ID)
157: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)

Line 154: ,decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_NUMBER)

150: ,decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CHARGE_FLAG)
151: ,decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTUAL_SOURCE_CODE)
152: ,decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_ACTUAL_SOURCE_ID)
153: ,decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_CLAIM_FLAG)
154: ,decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_NUMBER)
155: ,decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_STATUS_CODE)
156: ,decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_REPLACED_ITEM_ID)
157: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
158: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)

Line 155: ,decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_STATUS_CODE)

151: ,decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_ACTUAL_SOURCE_CODE)
152: ,decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_ACTUAL_SOURCE_ID)
153: ,decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_CLAIM_FLAG)
154: ,decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_NUMBER)
155: ,decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_STATUS_CODE)
156: ,decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_REPLACED_ITEM_ID)
157: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
158: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
159: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)

Line 156: ,decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_REPLACED_ITEM_ID)

152: ,decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_ACTUAL_SOURCE_ID)
153: ,decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_CLAIM_FLAG)
154: ,decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_NUMBER)
155: ,decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_STATUS_CODE)
156: ,decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_REPLACED_ITEM_ID)
157: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
158: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
159: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
160: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)

Line 157: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)

153: ,decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_CLAIM_FLAG)
154: ,decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_NUMBER)
155: ,decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_STATUS_CODE)
156: ,decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_REPLACED_ITEM_ID)
157: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
158: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
159: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
160: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
161: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)

Line 158: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)

154: ,decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_NUMBER)
155: ,decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_STATUS_CODE)
156: ,decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_REPLACED_ITEM_ID)
157: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
158: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
159: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
160: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
161: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
162: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)

Line 159: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)

155: ,decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_WARRANTY_STATUS_CODE)
156: ,decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_REPLACED_ITEM_ID)
157: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
158: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
159: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
160: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
161: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
162: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
163: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)

Line 160: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)

156: ,decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_REPLACED_ITEM_ID)
157: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
158: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
159: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
160: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
161: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
162: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
163: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
164: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)

Line 161: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)

157: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
158: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
159: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
160: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
161: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
162: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
163: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
164: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
165: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)

Line 162: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)

158: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
159: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
160: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
161: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
162: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
163: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
164: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
165: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
166: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)

Line 163: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)

159: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
160: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
161: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
162: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
163: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
164: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
165: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
166: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
167: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)

Line 164: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)

160: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
161: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
162: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
163: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
164: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
165: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
166: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
167: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
168: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)

Line 165: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)

161: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
162: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
163: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
164: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
165: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
166: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
167: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
168: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
169: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)

Line 166: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)

162: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
163: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
164: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
165: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
166: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
167: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
168: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
169: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
170: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)

Line 167: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)

163: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
164: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
165: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
166: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
167: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
168: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
169: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
170: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
171: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)

Line 168: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)

164: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
165: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
166: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
167: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
168: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
169: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
170: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
171: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
172: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)

Line 169: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)

165: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
166: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
167: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
168: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
169: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
170: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
171: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
172: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
173: ,decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_LOCATOR_ID)

Line 170: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)

166: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
167: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
168: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
169: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
170: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
171: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
172: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
173: ,decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_LOCATOR_ID)
174: ,decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT1)

Line 171: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)

167: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
168: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
169: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
170: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
171: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
172: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
173: ,decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_LOCATOR_ID)
174: ,decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT1)
175: ,decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT2)

Line 172: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)

168: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
169: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
170: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
171: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
172: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
173: ,decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_LOCATOR_ID)
174: ,decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT1)
175: ,decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT2)
176: ,decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT3)

Line 173: ,decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_LOCATOR_ID)

169: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
170: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
171: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
172: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
173: ,decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_LOCATOR_ID)
174: ,decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT1)
175: ,decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT2)
176: ,decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT3)
177: ,decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT4)

Line 174: ,decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT1)

170: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
171: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
172: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
173: ,decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_LOCATOR_ID)
174: ,decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT1)
175: ,decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT2)
176: ,decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT3)
177: ,decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT4)
178: ,decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT5)

Line 175: ,decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT2)

171: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
172: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
173: ,decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_LOCATOR_ID)
174: ,decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT1)
175: ,decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT2)
176: ,decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT3)
177: ,decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT4)
178: ,decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT5)
179: ,decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT6)

Line 176: ,decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT3)

172: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
173: ,decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_LOCATOR_ID)
174: ,decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT1)
175: ,decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT2)
176: ,decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT3)
177: ,decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT4)
178: ,decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT5)
179: ,decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT6)
180: ,decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT7)

Line 177: ,decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT4)

173: ,decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_LOCATOR_ID)
174: ,decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT1)
175: ,decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT2)
176: ,decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT3)
177: ,decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT4)
178: ,decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT5)
179: ,decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT6)
180: ,decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT7)
181: ,decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT8)

Line 178: ,decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT5)

174: ,decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT1)
175: ,decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT2)
176: ,decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT3)
177: ,decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT4)
178: ,decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT5)
179: ,decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT6)
180: ,decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT7)
181: ,decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT8)
182: ,decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT9)

Line 179: ,decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT6)

175: ,decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT2)
176: ,decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT3)
177: ,decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT4)
178: ,decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT5)
179: ,decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT6)
180: ,decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT7)
181: ,decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT8)
182: ,decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT9)
183: ,decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT10)

Line 180: ,decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT7)

176: ,decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT3)
177: ,decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT4)
178: ,decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT5)
179: ,decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT6)
180: ,decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT7)
181: ,decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT8)
182: ,decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT9)
183: ,decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT10)
184: ,decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT11)

Line 181: ,decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT8)

177: ,decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT4)
178: ,decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT5)
179: ,decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT6)
180: ,decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT7)
181: ,decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT8)
182: ,decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT9)
183: ,decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT10)
184: ,decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT11)
185: ,decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT12)

Line 182: ,decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT9)

178: ,decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT5)
179: ,decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT6)
180: ,decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT7)
181: ,decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT8)
182: ,decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT9)
183: ,decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT10)
184: ,decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT11)
185: ,decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT12)
186: ,decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT13)

Line 183: ,decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT10)

179: ,decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT6)
180: ,decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT7)
181: ,decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT8)
182: ,decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT9)
183: ,decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT10)
184: ,decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT11)
185: ,decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT12)
186: ,decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT13)
187: ,decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT14)

Line 184: ,decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT11)

180: ,decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT7)
181: ,decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT8)
182: ,decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT9)
183: ,decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT10)
184: ,decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT11)
185: ,decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT12)
186: ,decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT13)
187: ,decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT14)
188: ,decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT15)

Line 185: ,decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT12)

181: ,decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT8)
182: ,decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT9)
183: ,decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT10)
184: ,decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT11)
185: ,decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT12)
186: ,decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT13)
187: ,decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT14)
188: ,decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT15)
189: ,decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT16)

Line 186: ,decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT13)

182: ,decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT9)
183: ,decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT10)
184: ,decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT11)
185: ,decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT12)
186: ,decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT13)
187: ,decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT14)
188: ,decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT15)
189: ,decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT16)
190: ,decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT17)

Line 187: ,decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT14)

183: ,decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT10)
184: ,decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT11)
185: ,decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT12)
186: ,decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT13)
187: ,decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT14)
188: ,decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT15)
189: ,decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT16)
190: ,decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT17)
191: ,decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT18)

Line 188: ,decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT15)

184: ,decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT11)
185: ,decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT12)
186: ,decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT13)
187: ,decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT14)
188: ,decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT15)
189: ,decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT16)
190: ,decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT17)
191: ,decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT18)
192: ,decode( p_LOC_SEGMENT19, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT19)

Line 189: ,decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT16)

185: ,decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT12)
186: ,decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT13)
187: ,decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT14)
188: ,decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT15)
189: ,decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT16)
190: ,decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT17)
191: ,decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT18)
192: ,decode( p_LOC_SEGMENT19, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT19)
193: ,decode( p_LOC_SEGMENT20, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT20));

Line 190: ,decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT17)

186: ,decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT13)
187: ,decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT14)
188: ,decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT15)
189: ,decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT16)
190: ,decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT17)
191: ,decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT18)
192: ,decode( p_LOC_SEGMENT19, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT19)
193: ,decode( p_LOC_SEGMENT20, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT20));
194: End Insert_Row;

Line 191: ,decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT18)

187: ,decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT14)
188: ,decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT15)
189: ,decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT16)
190: ,decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT17)
191: ,decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT18)
192: ,decode( p_LOC_SEGMENT19, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT19)
193: ,decode( p_LOC_SEGMENT20, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT20));
194: End Insert_Row;
195:

Line 192: ,decode( p_LOC_SEGMENT19, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT19)

188: ,decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT15)
189: ,decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT16)
190: ,decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT17)
191: ,decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT18)
192: ,decode( p_LOC_SEGMENT19, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT19)
193: ,decode( p_LOC_SEGMENT20, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT20));
194: End Insert_Row;
195:
196: PROCEDURE Update_Row(

Line 193: ,decode( p_LOC_SEGMENT20, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT20));

189: ,decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT16)
190: ,decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT17)
191: ,decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT18)
192: ,decode( p_LOC_SEGMENT19, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT19)
193: ,decode( p_LOC_SEGMENT20, FND_API.G_MISS_CHAR, NULL, p_LOC_SEGMENT20));
194: End Insert_Row;
195:
196: PROCEDURE Update_Row(
197: p_REPAIR_ACTUAL_LINE_ID NUMBER

Line 213: ,p_WARRANTY_CLAIM_FLAG VARCHAR2 := FND_API.G_MISS_CHAR

209: ,p_RESOURCE_ID NUMBER
210: ,p_OVERRIDE_CHARGE_FLAG VARCHAR2
211: ,p_ACTUAL_SOURCE_CODE VARCHAR2
212: ,p_ACTUAL_SOURCE_ID NUMBER
213: ,p_WARRANTY_CLAIM_FLAG VARCHAR2 := FND_API.G_MISS_CHAR
214: ,p_WARRANTY_NUMBER VARCHAR2 := FND_API.G_MISS_CHAR
215: ,p_WARRANTY_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR
216: ,p_REPLACED_ITEM_ID NUMBER := FND_API.G_MISS_NUM
217: ,p_ATTRIBUTE_CATEGORY VARCHAR2

Line 214: ,p_WARRANTY_NUMBER VARCHAR2 := FND_API.G_MISS_CHAR

210: ,p_OVERRIDE_CHARGE_FLAG VARCHAR2
211: ,p_ACTUAL_SOURCE_CODE VARCHAR2
212: ,p_ACTUAL_SOURCE_ID NUMBER
213: ,p_WARRANTY_CLAIM_FLAG VARCHAR2 := FND_API.G_MISS_CHAR
214: ,p_WARRANTY_NUMBER VARCHAR2 := FND_API.G_MISS_CHAR
215: ,p_WARRANTY_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR
216: ,p_REPLACED_ITEM_ID NUMBER := FND_API.G_MISS_NUM
217: ,p_ATTRIBUTE_CATEGORY VARCHAR2
218: ,p_ATTRIBUTE1 VARCHAR2

Line 215: ,p_WARRANTY_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR

211: ,p_ACTUAL_SOURCE_CODE VARCHAR2
212: ,p_ACTUAL_SOURCE_ID NUMBER
213: ,p_WARRANTY_CLAIM_FLAG VARCHAR2 := FND_API.G_MISS_CHAR
214: ,p_WARRANTY_NUMBER VARCHAR2 := FND_API.G_MISS_CHAR
215: ,p_WARRANTY_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR
216: ,p_REPLACED_ITEM_ID NUMBER := FND_API.G_MISS_NUM
217: ,p_ATTRIBUTE_CATEGORY VARCHAR2
218: ,p_ATTRIBUTE1 VARCHAR2
219: ,p_ATTRIBUTE2 VARCHAR2

Line 216: ,p_REPLACED_ITEM_ID NUMBER := FND_API.G_MISS_NUM

212: ,p_ACTUAL_SOURCE_ID NUMBER
213: ,p_WARRANTY_CLAIM_FLAG VARCHAR2 := FND_API.G_MISS_CHAR
214: ,p_WARRANTY_NUMBER VARCHAR2 := FND_API.G_MISS_CHAR
215: ,p_WARRANTY_STATUS_CODE VARCHAR2 := FND_API.G_MISS_CHAR
216: ,p_REPLACED_ITEM_ID NUMBER := FND_API.G_MISS_NUM
217: ,p_ATTRIBUTE_CATEGORY VARCHAR2
218: ,p_ATTRIBUTE1 VARCHAR2
219: ,p_ATTRIBUTE2 VARCHAR2
220: ,p_ATTRIBUTE3 VARCHAR2

Line 259: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

255: IS
256: BEGIN
257: Update CSD_REPAIR_ACTUAL_LINES
258: SET
259: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
260: ,ESTIMATE_DETAIL_ID = decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, NULL, ESTIMATE_DETAIL_ID, p_ESTIMATE_DETAIL_ID)
261: ,REPAIR_ACTUAL_ID = decode( p_REPAIR_ACTUAL_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ACTUAL_ID, p_REPAIR_ACTUAL_ID)
262: ,REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
263: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)

Line 260: ,ESTIMATE_DETAIL_ID = decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, NULL, ESTIMATE_DETAIL_ID, p_ESTIMATE_DETAIL_ID)

256: BEGIN
257: Update CSD_REPAIR_ACTUAL_LINES
258: SET
259: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
260: ,ESTIMATE_DETAIL_ID = decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, NULL, ESTIMATE_DETAIL_ID, p_ESTIMATE_DETAIL_ID)
261: ,REPAIR_ACTUAL_ID = decode( p_REPAIR_ACTUAL_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ACTUAL_ID, p_REPAIR_ACTUAL_ID)
262: ,REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
263: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
264: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)

Line 261: ,REPAIR_ACTUAL_ID = decode( p_REPAIR_ACTUAL_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ACTUAL_ID, p_REPAIR_ACTUAL_ID)

257: Update CSD_REPAIR_ACTUAL_LINES
258: SET
259: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
260: ,ESTIMATE_DETAIL_ID = decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, NULL, ESTIMATE_DETAIL_ID, p_ESTIMATE_DETAIL_ID)
261: ,REPAIR_ACTUAL_ID = decode( p_REPAIR_ACTUAL_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ACTUAL_ID, p_REPAIR_ACTUAL_ID)
262: ,REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
263: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
264: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
265: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

Line 262: ,REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)

258: SET
259: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
260: ,ESTIMATE_DETAIL_ID = decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, NULL, ESTIMATE_DETAIL_ID, p_ESTIMATE_DETAIL_ID)
261: ,REPAIR_ACTUAL_ID = decode( p_REPAIR_ACTUAL_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ACTUAL_ID, p_REPAIR_ACTUAL_ID)
262: ,REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
263: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
264: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
265: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
266: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)

Line 263: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)

259: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
260: ,ESTIMATE_DETAIL_ID = decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, NULL, ESTIMATE_DETAIL_ID, p_ESTIMATE_DETAIL_ID)
261: ,REPAIR_ACTUAL_ID = decode( p_REPAIR_ACTUAL_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ACTUAL_ID, p_REPAIR_ACTUAL_ID)
262: ,REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
263: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
264: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
265: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
266: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
267: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

Line 264: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)

260: ,ESTIMATE_DETAIL_ID = decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, NULL, ESTIMATE_DETAIL_ID, p_ESTIMATE_DETAIL_ID)
261: ,REPAIR_ACTUAL_ID = decode( p_REPAIR_ACTUAL_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ACTUAL_ID, p_REPAIR_ACTUAL_ID)
262: ,REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
263: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
264: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
265: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
266: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
267: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
268: ,ITEM_COST = decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, NULL, ITEM_COST, p_ITEM_COST)

Line 265: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

261: ,REPAIR_ACTUAL_ID = decode( p_REPAIR_ACTUAL_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_ACTUAL_ID, p_REPAIR_ACTUAL_ID)
262: ,REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
263: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
264: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
265: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
266: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
267: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
268: ,ITEM_COST = decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, NULL, ITEM_COST, p_ITEM_COST)
269: ,JUSTIFICATION_NOTES = decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, NULL, JUSTIFICATION_NOTES, p_JUSTIFICATION_NOTES)

Line 266: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)

262: ,REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
263: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
264: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
265: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
266: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
267: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
268: ,ITEM_COST = decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, NULL, ITEM_COST, p_ITEM_COST)
269: ,JUSTIFICATION_NOTES = decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, NULL, JUSTIFICATION_NOTES, p_JUSTIFICATION_NOTES)
270: ,RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_ID, p_RESOURCE_ID)

Line 267: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

263: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
264: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
265: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
266: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
267: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
268: ,ITEM_COST = decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, NULL, ITEM_COST, p_ITEM_COST)
269: ,JUSTIFICATION_NOTES = decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, NULL, JUSTIFICATION_NOTES, p_JUSTIFICATION_NOTES)
270: ,RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_ID, p_RESOURCE_ID)
271: ,OVERRIDE_CHARGE_FLAG = decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, OVERRIDE_CHARGE_FLAG, p_OVERRIDE_CHARGE_FLAG)

Line 268: ,ITEM_COST = decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, NULL, ITEM_COST, p_ITEM_COST)

264: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
265: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
266: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
267: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
268: ,ITEM_COST = decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, NULL, ITEM_COST, p_ITEM_COST)
269: ,JUSTIFICATION_NOTES = decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, NULL, JUSTIFICATION_NOTES, p_JUSTIFICATION_NOTES)
270: ,RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_ID, p_RESOURCE_ID)
271: ,OVERRIDE_CHARGE_FLAG = decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, OVERRIDE_CHARGE_FLAG, p_OVERRIDE_CHARGE_FLAG)
272: ,ACTUAL_SOURCE_CODE = decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, NULL, ACTUAL_SOURCE_CODE, p_ACTUAL_SOURCE_CODE)

Line 269: ,JUSTIFICATION_NOTES = decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, NULL, JUSTIFICATION_NOTES, p_JUSTIFICATION_NOTES)

265: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
266: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
267: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
268: ,ITEM_COST = decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, NULL, ITEM_COST, p_ITEM_COST)
269: ,JUSTIFICATION_NOTES = decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, NULL, JUSTIFICATION_NOTES, p_JUSTIFICATION_NOTES)
270: ,RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_ID, p_RESOURCE_ID)
271: ,OVERRIDE_CHARGE_FLAG = decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, OVERRIDE_CHARGE_FLAG, p_OVERRIDE_CHARGE_FLAG)
272: ,ACTUAL_SOURCE_CODE = decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, NULL, ACTUAL_SOURCE_CODE, p_ACTUAL_SOURCE_CODE)
273: ,ACTUAL_SOURCE_ID = decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, ACTUAL_SOURCE_ID, p_ACTUAL_SOURCE_ID)

Line 270: ,RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_ID, p_RESOURCE_ID)

266: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
267: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
268: ,ITEM_COST = decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, NULL, ITEM_COST, p_ITEM_COST)
269: ,JUSTIFICATION_NOTES = decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, NULL, JUSTIFICATION_NOTES, p_JUSTIFICATION_NOTES)
270: ,RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_ID, p_RESOURCE_ID)
271: ,OVERRIDE_CHARGE_FLAG = decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, OVERRIDE_CHARGE_FLAG, p_OVERRIDE_CHARGE_FLAG)
272: ,ACTUAL_SOURCE_CODE = decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, NULL, ACTUAL_SOURCE_CODE, p_ACTUAL_SOURCE_CODE)
273: ,ACTUAL_SOURCE_ID = decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, ACTUAL_SOURCE_ID, p_ACTUAL_SOURCE_ID)
274: ,WARRANTY_CLAIM_FLAG = decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_CLAIM_FLAG, p_WARRANTY_CLAIM_FLAG)

Line 271: ,OVERRIDE_CHARGE_FLAG = decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, OVERRIDE_CHARGE_FLAG, p_OVERRIDE_CHARGE_FLAG)

267: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
268: ,ITEM_COST = decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, NULL, ITEM_COST, p_ITEM_COST)
269: ,JUSTIFICATION_NOTES = decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, NULL, JUSTIFICATION_NOTES, p_JUSTIFICATION_NOTES)
270: ,RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_ID, p_RESOURCE_ID)
271: ,OVERRIDE_CHARGE_FLAG = decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, OVERRIDE_CHARGE_FLAG, p_OVERRIDE_CHARGE_FLAG)
272: ,ACTUAL_SOURCE_CODE = decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, NULL, ACTUAL_SOURCE_CODE, p_ACTUAL_SOURCE_CODE)
273: ,ACTUAL_SOURCE_ID = decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, ACTUAL_SOURCE_ID, p_ACTUAL_SOURCE_ID)
274: ,WARRANTY_CLAIM_FLAG = decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_CLAIM_FLAG, p_WARRANTY_CLAIM_FLAG)
275: ,WARRANTY_NUMBER = decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_NUMBER, p_WARRANTY_NUMBER)

Line 272: ,ACTUAL_SOURCE_CODE = decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, NULL, ACTUAL_SOURCE_CODE, p_ACTUAL_SOURCE_CODE)

268: ,ITEM_COST = decode( p_ITEM_COST, FND_API.G_MISS_NUM, NULL, NULL, ITEM_COST, p_ITEM_COST)
269: ,JUSTIFICATION_NOTES = decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, NULL, JUSTIFICATION_NOTES, p_JUSTIFICATION_NOTES)
270: ,RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_ID, p_RESOURCE_ID)
271: ,OVERRIDE_CHARGE_FLAG = decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, OVERRIDE_CHARGE_FLAG, p_OVERRIDE_CHARGE_FLAG)
272: ,ACTUAL_SOURCE_CODE = decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, NULL, ACTUAL_SOURCE_CODE, p_ACTUAL_SOURCE_CODE)
273: ,ACTUAL_SOURCE_ID = decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, ACTUAL_SOURCE_ID, p_ACTUAL_SOURCE_ID)
274: ,WARRANTY_CLAIM_FLAG = decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_CLAIM_FLAG, p_WARRANTY_CLAIM_FLAG)
275: ,WARRANTY_NUMBER = decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_NUMBER, p_WARRANTY_NUMBER)
276: ,WARRANTY_STATUS_CODE = decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_STATUS_CODE, p_WARRANTY_STATUS_CODE)

Line 273: ,ACTUAL_SOURCE_ID = decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, ACTUAL_SOURCE_ID, p_ACTUAL_SOURCE_ID)

269: ,JUSTIFICATION_NOTES = decode( p_JUSTIFICATION_NOTES, FND_API.G_MISS_CHAR, NULL, NULL, JUSTIFICATION_NOTES, p_JUSTIFICATION_NOTES)
270: ,RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_ID, p_RESOURCE_ID)
271: ,OVERRIDE_CHARGE_FLAG = decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, OVERRIDE_CHARGE_FLAG, p_OVERRIDE_CHARGE_FLAG)
272: ,ACTUAL_SOURCE_CODE = decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, NULL, ACTUAL_SOURCE_CODE, p_ACTUAL_SOURCE_CODE)
273: ,ACTUAL_SOURCE_ID = decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, ACTUAL_SOURCE_ID, p_ACTUAL_SOURCE_ID)
274: ,WARRANTY_CLAIM_FLAG = decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_CLAIM_FLAG, p_WARRANTY_CLAIM_FLAG)
275: ,WARRANTY_NUMBER = decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_NUMBER, p_WARRANTY_NUMBER)
276: ,WARRANTY_STATUS_CODE = decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_STATUS_CODE, p_WARRANTY_STATUS_CODE)
277: ,REPLACED_ITEM_ID = decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, REPLACED_ITEM_ID, p_REPLACED_ITEM_ID)

Line 274: ,WARRANTY_CLAIM_FLAG = decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_CLAIM_FLAG, p_WARRANTY_CLAIM_FLAG)

270: ,RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_ID, p_RESOURCE_ID)
271: ,OVERRIDE_CHARGE_FLAG = decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, OVERRIDE_CHARGE_FLAG, p_OVERRIDE_CHARGE_FLAG)
272: ,ACTUAL_SOURCE_CODE = decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, NULL, ACTUAL_SOURCE_CODE, p_ACTUAL_SOURCE_CODE)
273: ,ACTUAL_SOURCE_ID = decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, ACTUAL_SOURCE_ID, p_ACTUAL_SOURCE_ID)
274: ,WARRANTY_CLAIM_FLAG = decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_CLAIM_FLAG, p_WARRANTY_CLAIM_FLAG)
275: ,WARRANTY_NUMBER = decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_NUMBER, p_WARRANTY_NUMBER)
276: ,WARRANTY_STATUS_CODE = decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_STATUS_CODE, p_WARRANTY_STATUS_CODE)
277: ,REPLACED_ITEM_ID = decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, REPLACED_ITEM_ID, p_REPLACED_ITEM_ID)
278: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)

Line 275: ,WARRANTY_NUMBER = decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_NUMBER, p_WARRANTY_NUMBER)

271: ,OVERRIDE_CHARGE_FLAG = decode( p_OVERRIDE_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, OVERRIDE_CHARGE_FLAG, p_OVERRIDE_CHARGE_FLAG)
272: ,ACTUAL_SOURCE_CODE = decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, NULL, ACTUAL_SOURCE_CODE, p_ACTUAL_SOURCE_CODE)
273: ,ACTUAL_SOURCE_ID = decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, ACTUAL_SOURCE_ID, p_ACTUAL_SOURCE_ID)
274: ,WARRANTY_CLAIM_FLAG = decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_CLAIM_FLAG, p_WARRANTY_CLAIM_FLAG)
275: ,WARRANTY_NUMBER = decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_NUMBER, p_WARRANTY_NUMBER)
276: ,WARRANTY_STATUS_CODE = decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_STATUS_CODE, p_WARRANTY_STATUS_CODE)
277: ,REPLACED_ITEM_ID = decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, REPLACED_ITEM_ID, p_REPLACED_ITEM_ID)
278: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
279: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)

Line 276: ,WARRANTY_STATUS_CODE = decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_STATUS_CODE, p_WARRANTY_STATUS_CODE)

272: ,ACTUAL_SOURCE_CODE = decode( p_ACTUAL_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, NULL, ACTUAL_SOURCE_CODE, p_ACTUAL_SOURCE_CODE)
273: ,ACTUAL_SOURCE_ID = decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, ACTUAL_SOURCE_ID, p_ACTUAL_SOURCE_ID)
274: ,WARRANTY_CLAIM_FLAG = decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_CLAIM_FLAG, p_WARRANTY_CLAIM_FLAG)
275: ,WARRANTY_NUMBER = decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_NUMBER, p_WARRANTY_NUMBER)
276: ,WARRANTY_STATUS_CODE = decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_STATUS_CODE, p_WARRANTY_STATUS_CODE)
277: ,REPLACED_ITEM_ID = decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, REPLACED_ITEM_ID, p_REPLACED_ITEM_ID)
278: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
279: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
280: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)

Line 277: ,REPLACED_ITEM_ID = decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, REPLACED_ITEM_ID, p_REPLACED_ITEM_ID)

273: ,ACTUAL_SOURCE_ID = decode( p_ACTUAL_SOURCE_ID, FND_API.G_MISS_NUM, NULL, NULL, ACTUAL_SOURCE_ID, p_ACTUAL_SOURCE_ID)
274: ,WARRANTY_CLAIM_FLAG = decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_CLAIM_FLAG, p_WARRANTY_CLAIM_FLAG)
275: ,WARRANTY_NUMBER = decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_NUMBER, p_WARRANTY_NUMBER)
276: ,WARRANTY_STATUS_CODE = decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_STATUS_CODE, p_WARRANTY_STATUS_CODE)
277: ,REPLACED_ITEM_ID = decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, REPLACED_ITEM_ID, p_REPLACED_ITEM_ID)
278: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
279: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
280: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
281: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)

Line 278: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)

274: ,WARRANTY_CLAIM_FLAG = decode( p_WARRANTY_CLAIM_FLAG, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_CLAIM_FLAG, p_WARRANTY_CLAIM_FLAG)
275: ,WARRANTY_NUMBER = decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_NUMBER, p_WARRANTY_NUMBER)
276: ,WARRANTY_STATUS_CODE = decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_STATUS_CODE, p_WARRANTY_STATUS_CODE)
277: ,REPLACED_ITEM_ID = decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, REPLACED_ITEM_ID, p_REPLACED_ITEM_ID)
278: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
279: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
280: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
281: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
282: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)

Line 279: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)

275: ,WARRANTY_NUMBER = decode( p_WARRANTY_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_NUMBER, p_WARRANTY_NUMBER)
276: ,WARRANTY_STATUS_CODE = decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_STATUS_CODE, p_WARRANTY_STATUS_CODE)
277: ,REPLACED_ITEM_ID = decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, REPLACED_ITEM_ID, p_REPLACED_ITEM_ID)
278: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
279: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
280: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
281: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
282: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
283: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)

Line 280: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)

276: ,WARRANTY_STATUS_CODE = decode( p_WARRANTY_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, WARRANTY_STATUS_CODE, p_WARRANTY_STATUS_CODE)
277: ,REPLACED_ITEM_ID = decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, REPLACED_ITEM_ID, p_REPLACED_ITEM_ID)
278: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
279: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
280: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
281: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
282: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
283: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
284: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)

Line 281: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)

277: ,REPLACED_ITEM_ID = decode( p_REPLACED_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, REPLACED_ITEM_ID, p_REPLACED_ITEM_ID)
278: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
279: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
280: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
281: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
282: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
283: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
284: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
285: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)

Line 282: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)

278: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
279: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
280: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
281: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
282: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
283: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
284: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
285: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
286: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)

Line 283: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)

279: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
280: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
281: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
282: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
283: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
284: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
285: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
286: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
287: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)

Line 284: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)

280: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
281: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
282: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
283: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
284: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
285: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
286: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
287: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
288: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)

Line 285: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)

281: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
282: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
283: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
284: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
285: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
286: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
287: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
288: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
289: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)

Line 286: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)

282: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
283: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
284: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
285: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
286: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
287: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
288: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
289: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
290: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)

Line 287: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)

283: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
284: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
285: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
286: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
287: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
288: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
289: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
290: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
291: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)

Line 288: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)

284: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
285: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
286: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
287: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
288: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
289: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
290: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
291: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
292: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)

Line 289: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)

285: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
286: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
287: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
288: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
289: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
290: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
291: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
292: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
293: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)

Line 290: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)

286: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
287: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
288: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
289: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
290: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
291: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
292: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
293: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
294: ,LOCATOR_ID = decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, NULL, LOCATOR_ID, p_LOCATOR_ID)

Line 291: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)

287: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
288: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
289: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
290: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
291: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
292: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
293: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
294: ,LOCATOR_ID = decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, NULL, LOCATOR_ID, p_LOCATOR_ID)
295: ,LOC_SEGMENT1 = decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT1, p_LOC_SEGMENT1)

Line 292: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)

288: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
289: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
290: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
291: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
292: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
293: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
294: ,LOCATOR_ID = decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, NULL, LOCATOR_ID, p_LOCATOR_ID)
295: ,LOC_SEGMENT1 = decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT1, p_LOC_SEGMENT1)
296: ,LOC_SEGMENT2 = decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT2, p_LOC_SEGMENT2)

Line 293: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)

289: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
290: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
291: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
292: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
293: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
294: ,LOCATOR_ID = decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, NULL, LOCATOR_ID, p_LOCATOR_ID)
295: ,LOC_SEGMENT1 = decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT1, p_LOC_SEGMENT1)
296: ,LOC_SEGMENT2 = decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT2, p_LOC_SEGMENT2)
297: ,LOC_SEGMENT3 = decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT3, p_LOC_SEGMENT3)

Line 294: ,LOCATOR_ID = decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, NULL, LOCATOR_ID, p_LOCATOR_ID)

290: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
291: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
292: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
293: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
294: ,LOCATOR_ID = decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, NULL, LOCATOR_ID, p_LOCATOR_ID)
295: ,LOC_SEGMENT1 = decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT1, p_LOC_SEGMENT1)
296: ,LOC_SEGMENT2 = decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT2, p_LOC_SEGMENT2)
297: ,LOC_SEGMENT3 = decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT3, p_LOC_SEGMENT3)
298: ,LOC_SEGMENT4 = decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT4, p_LOC_SEGMENT4)

Line 295: ,LOC_SEGMENT1 = decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT1, p_LOC_SEGMENT1)

291: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
292: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
293: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
294: ,LOCATOR_ID = decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, NULL, LOCATOR_ID, p_LOCATOR_ID)
295: ,LOC_SEGMENT1 = decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT1, p_LOC_SEGMENT1)
296: ,LOC_SEGMENT2 = decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT2, p_LOC_SEGMENT2)
297: ,LOC_SEGMENT3 = decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT3, p_LOC_SEGMENT3)
298: ,LOC_SEGMENT4 = decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT4, p_LOC_SEGMENT4)
299: ,LOC_SEGMENT5 = decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT5, p_LOC_SEGMENT5)

Line 296: ,LOC_SEGMENT2 = decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT2, p_LOC_SEGMENT2)

292: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
293: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
294: ,LOCATOR_ID = decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, NULL, LOCATOR_ID, p_LOCATOR_ID)
295: ,LOC_SEGMENT1 = decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT1, p_LOC_SEGMENT1)
296: ,LOC_SEGMENT2 = decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT2, p_LOC_SEGMENT2)
297: ,LOC_SEGMENT3 = decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT3, p_LOC_SEGMENT3)
298: ,LOC_SEGMENT4 = decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT4, p_LOC_SEGMENT4)
299: ,LOC_SEGMENT5 = decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT5, p_LOC_SEGMENT5)
300: ,LOC_SEGMENT6 = decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT6, p_LOC_SEGMENT6)

Line 297: ,LOC_SEGMENT3 = decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT3, p_LOC_SEGMENT3)

293: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
294: ,LOCATOR_ID = decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, NULL, LOCATOR_ID, p_LOCATOR_ID)
295: ,LOC_SEGMENT1 = decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT1, p_LOC_SEGMENT1)
296: ,LOC_SEGMENT2 = decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT2, p_LOC_SEGMENT2)
297: ,LOC_SEGMENT3 = decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT3, p_LOC_SEGMENT3)
298: ,LOC_SEGMENT4 = decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT4, p_LOC_SEGMENT4)
299: ,LOC_SEGMENT5 = decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT5, p_LOC_SEGMENT5)
300: ,LOC_SEGMENT6 = decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT6, p_LOC_SEGMENT6)
301: ,LOC_SEGMENT7 = decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT7, p_LOC_SEGMENT7)

Line 298: ,LOC_SEGMENT4 = decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT4, p_LOC_SEGMENT4)

294: ,LOCATOR_ID = decode( p_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, NULL, LOCATOR_ID, p_LOCATOR_ID)
295: ,LOC_SEGMENT1 = decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT1, p_LOC_SEGMENT1)
296: ,LOC_SEGMENT2 = decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT2, p_LOC_SEGMENT2)
297: ,LOC_SEGMENT3 = decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT3, p_LOC_SEGMENT3)
298: ,LOC_SEGMENT4 = decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT4, p_LOC_SEGMENT4)
299: ,LOC_SEGMENT5 = decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT5, p_LOC_SEGMENT5)
300: ,LOC_SEGMENT6 = decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT6, p_LOC_SEGMENT6)
301: ,LOC_SEGMENT7 = decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT7, p_LOC_SEGMENT7)
302: ,LOC_SEGMENT8 = decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT8, p_LOC_SEGMENT8)

Line 299: ,LOC_SEGMENT5 = decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT5, p_LOC_SEGMENT5)

295: ,LOC_SEGMENT1 = decode( p_LOC_SEGMENT1, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT1, p_LOC_SEGMENT1)
296: ,LOC_SEGMENT2 = decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT2, p_LOC_SEGMENT2)
297: ,LOC_SEGMENT3 = decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT3, p_LOC_SEGMENT3)
298: ,LOC_SEGMENT4 = decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT4, p_LOC_SEGMENT4)
299: ,LOC_SEGMENT5 = decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT5, p_LOC_SEGMENT5)
300: ,LOC_SEGMENT6 = decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT6, p_LOC_SEGMENT6)
301: ,LOC_SEGMENT7 = decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT7, p_LOC_SEGMENT7)
302: ,LOC_SEGMENT8 = decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT8, p_LOC_SEGMENT8)
303: ,LOC_SEGMENT9 = decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT9, p_LOC_SEGMENT9)

Line 300: ,LOC_SEGMENT6 = decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT6, p_LOC_SEGMENT6)

296: ,LOC_SEGMENT2 = decode( p_LOC_SEGMENT2, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT2, p_LOC_SEGMENT2)
297: ,LOC_SEGMENT3 = decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT3, p_LOC_SEGMENT3)
298: ,LOC_SEGMENT4 = decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT4, p_LOC_SEGMENT4)
299: ,LOC_SEGMENT5 = decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT5, p_LOC_SEGMENT5)
300: ,LOC_SEGMENT6 = decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT6, p_LOC_SEGMENT6)
301: ,LOC_SEGMENT7 = decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT7, p_LOC_SEGMENT7)
302: ,LOC_SEGMENT8 = decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT8, p_LOC_SEGMENT8)
303: ,LOC_SEGMENT9 = decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT9, p_LOC_SEGMENT9)
304: ,LOC_SEGMENT10 = decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT10, p_LOC_SEGMENT10)

Line 301: ,LOC_SEGMENT7 = decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT7, p_LOC_SEGMENT7)

297: ,LOC_SEGMENT3 = decode( p_LOC_SEGMENT3, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT3, p_LOC_SEGMENT3)
298: ,LOC_SEGMENT4 = decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT4, p_LOC_SEGMENT4)
299: ,LOC_SEGMENT5 = decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT5, p_LOC_SEGMENT5)
300: ,LOC_SEGMENT6 = decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT6, p_LOC_SEGMENT6)
301: ,LOC_SEGMENT7 = decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT7, p_LOC_SEGMENT7)
302: ,LOC_SEGMENT8 = decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT8, p_LOC_SEGMENT8)
303: ,LOC_SEGMENT9 = decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT9, p_LOC_SEGMENT9)
304: ,LOC_SEGMENT10 = decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT10, p_LOC_SEGMENT10)
305: ,LOC_SEGMENT11 = decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT11, p_LOC_SEGMENT11)

Line 302: ,LOC_SEGMENT8 = decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT8, p_LOC_SEGMENT8)

298: ,LOC_SEGMENT4 = decode( p_LOC_SEGMENT4, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT4, p_LOC_SEGMENT4)
299: ,LOC_SEGMENT5 = decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT5, p_LOC_SEGMENT5)
300: ,LOC_SEGMENT6 = decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT6, p_LOC_SEGMENT6)
301: ,LOC_SEGMENT7 = decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT7, p_LOC_SEGMENT7)
302: ,LOC_SEGMENT8 = decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT8, p_LOC_SEGMENT8)
303: ,LOC_SEGMENT9 = decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT9, p_LOC_SEGMENT9)
304: ,LOC_SEGMENT10 = decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT10, p_LOC_SEGMENT10)
305: ,LOC_SEGMENT11 = decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT11, p_LOC_SEGMENT11)
306: ,LOC_SEGMENT12 = decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT12, p_LOC_SEGMENT12)

Line 303: ,LOC_SEGMENT9 = decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT9, p_LOC_SEGMENT9)

299: ,LOC_SEGMENT5 = decode( p_LOC_SEGMENT5, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT5, p_LOC_SEGMENT5)
300: ,LOC_SEGMENT6 = decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT6, p_LOC_SEGMENT6)
301: ,LOC_SEGMENT7 = decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT7, p_LOC_SEGMENT7)
302: ,LOC_SEGMENT8 = decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT8, p_LOC_SEGMENT8)
303: ,LOC_SEGMENT9 = decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT9, p_LOC_SEGMENT9)
304: ,LOC_SEGMENT10 = decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT10, p_LOC_SEGMENT10)
305: ,LOC_SEGMENT11 = decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT11, p_LOC_SEGMENT11)
306: ,LOC_SEGMENT12 = decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT12, p_LOC_SEGMENT12)
307: ,LOC_SEGMENT13 = decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT13, p_LOC_SEGMENT13)

Line 304: ,LOC_SEGMENT10 = decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT10, p_LOC_SEGMENT10)

300: ,LOC_SEGMENT6 = decode( p_LOC_SEGMENT6, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT6, p_LOC_SEGMENT6)
301: ,LOC_SEGMENT7 = decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT7, p_LOC_SEGMENT7)
302: ,LOC_SEGMENT8 = decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT8, p_LOC_SEGMENT8)
303: ,LOC_SEGMENT9 = decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT9, p_LOC_SEGMENT9)
304: ,LOC_SEGMENT10 = decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT10, p_LOC_SEGMENT10)
305: ,LOC_SEGMENT11 = decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT11, p_LOC_SEGMENT11)
306: ,LOC_SEGMENT12 = decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT12, p_LOC_SEGMENT12)
307: ,LOC_SEGMENT13 = decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT13, p_LOC_SEGMENT13)
308: ,LOC_SEGMENT14 = decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT14, p_LOC_SEGMENT14)

Line 305: ,LOC_SEGMENT11 = decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT11, p_LOC_SEGMENT11)

301: ,LOC_SEGMENT7 = decode( p_LOC_SEGMENT7, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT7, p_LOC_SEGMENT7)
302: ,LOC_SEGMENT8 = decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT8, p_LOC_SEGMENT8)
303: ,LOC_SEGMENT9 = decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT9, p_LOC_SEGMENT9)
304: ,LOC_SEGMENT10 = decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT10, p_LOC_SEGMENT10)
305: ,LOC_SEGMENT11 = decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT11, p_LOC_SEGMENT11)
306: ,LOC_SEGMENT12 = decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT12, p_LOC_SEGMENT12)
307: ,LOC_SEGMENT13 = decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT13, p_LOC_SEGMENT13)
308: ,LOC_SEGMENT14 = decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT14, p_LOC_SEGMENT14)
309: ,LOC_SEGMENT15 = decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT15, p_LOC_SEGMENT15)

Line 306: ,LOC_SEGMENT12 = decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT12, p_LOC_SEGMENT12)

302: ,LOC_SEGMENT8 = decode( p_LOC_SEGMENT8, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT8, p_LOC_SEGMENT8)
303: ,LOC_SEGMENT9 = decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT9, p_LOC_SEGMENT9)
304: ,LOC_SEGMENT10 = decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT10, p_LOC_SEGMENT10)
305: ,LOC_SEGMENT11 = decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT11, p_LOC_SEGMENT11)
306: ,LOC_SEGMENT12 = decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT12, p_LOC_SEGMENT12)
307: ,LOC_SEGMENT13 = decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT13, p_LOC_SEGMENT13)
308: ,LOC_SEGMENT14 = decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT14, p_LOC_SEGMENT14)
309: ,LOC_SEGMENT15 = decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT15, p_LOC_SEGMENT15)
310: ,LOC_SEGMENT16 = decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT16, p_LOC_SEGMENT16)

Line 307: ,LOC_SEGMENT13 = decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT13, p_LOC_SEGMENT13)

303: ,LOC_SEGMENT9 = decode( p_LOC_SEGMENT9, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT9, p_LOC_SEGMENT9)
304: ,LOC_SEGMENT10 = decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT10, p_LOC_SEGMENT10)
305: ,LOC_SEGMENT11 = decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT11, p_LOC_SEGMENT11)
306: ,LOC_SEGMENT12 = decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT12, p_LOC_SEGMENT12)
307: ,LOC_SEGMENT13 = decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT13, p_LOC_SEGMENT13)
308: ,LOC_SEGMENT14 = decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT14, p_LOC_SEGMENT14)
309: ,LOC_SEGMENT15 = decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT15, p_LOC_SEGMENT15)
310: ,LOC_SEGMENT16 = decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT16, p_LOC_SEGMENT16)
311: ,LOC_SEGMENT17 = decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT17, p_LOC_SEGMENT17)

Line 308: ,LOC_SEGMENT14 = decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT14, p_LOC_SEGMENT14)

304: ,LOC_SEGMENT10 = decode( p_LOC_SEGMENT10, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT10, p_LOC_SEGMENT10)
305: ,LOC_SEGMENT11 = decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT11, p_LOC_SEGMENT11)
306: ,LOC_SEGMENT12 = decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT12, p_LOC_SEGMENT12)
307: ,LOC_SEGMENT13 = decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT13, p_LOC_SEGMENT13)
308: ,LOC_SEGMENT14 = decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT14, p_LOC_SEGMENT14)
309: ,LOC_SEGMENT15 = decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT15, p_LOC_SEGMENT15)
310: ,LOC_SEGMENT16 = decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT16, p_LOC_SEGMENT16)
311: ,LOC_SEGMENT17 = decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT17, p_LOC_SEGMENT17)
312: ,LOC_SEGMENT18 = decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT18, p_LOC_SEGMENT18)

Line 309: ,LOC_SEGMENT15 = decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT15, p_LOC_SEGMENT15)

305: ,LOC_SEGMENT11 = decode( p_LOC_SEGMENT11, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT11, p_LOC_SEGMENT11)
306: ,LOC_SEGMENT12 = decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT12, p_LOC_SEGMENT12)
307: ,LOC_SEGMENT13 = decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT13, p_LOC_SEGMENT13)
308: ,LOC_SEGMENT14 = decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT14, p_LOC_SEGMENT14)
309: ,LOC_SEGMENT15 = decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT15, p_LOC_SEGMENT15)
310: ,LOC_SEGMENT16 = decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT16, p_LOC_SEGMENT16)
311: ,LOC_SEGMENT17 = decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT17, p_LOC_SEGMENT17)
312: ,LOC_SEGMENT18 = decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT18, p_LOC_SEGMENT18)
313: ,LOC_SEGMENT19 = decode( p_LOC_SEGMENT19, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT19, p_LOC_SEGMENT19)

Line 310: ,LOC_SEGMENT16 = decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT16, p_LOC_SEGMENT16)

306: ,LOC_SEGMENT12 = decode( p_LOC_SEGMENT12, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT12, p_LOC_SEGMENT12)
307: ,LOC_SEGMENT13 = decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT13, p_LOC_SEGMENT13)
308: ,LOC_SEGMENT14 = decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT14, p_LOC_SEGMENT14)
309: ,LOC_SEGMENT15 = decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT15, p_LOC_SEGMENT15)
310: ,LOC_SEGMENT16 = decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT16, p_LOC_SEGMENT16)
311: ,LOC_SEGMENT17 = decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT17, p_LOC_SEGMENT17)
312: ,LOC_SEGMENT18 = decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT18, p_LOC_SEGMENT18)
313: ,LOC_SEGMENT19 = decode( p_LOC_SEGMENT19, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT19, p_LOC_SEGMENT19)
314: ,LOC_SEGMENT20 = decode( p_LOC_SEGMENT20, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT20, p_LOC_SEGMENT20)

Line 311: ,LOC_SEGMENT17 = decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT17, p_LOC_SEGMENT17)

307: ,LOC_SEGMENT13 = decode( p_LOC_SEGMENT13, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT13, p_LOC_SEGMENT13)
308: ,LOC_SEGMENT14 = decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT14, p_LOC_SEGMENT14)
309: ,LOC_SEGMENT15 = decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT15, p_LOC_SEGMENT15)
310: ,LOC_SEGMENT16 = decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT16, p_LOC_SEGMENT16)
311: ,LOC_SEGMENT17 = decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT17, p_LOC_SEGMENT17)
312: ,LOC_SEGMENT18 = decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT18, p_LOC_SEGMENT18)
313: ,LOC_SEGMENT19 = decode( p_LOC_SEGMENT19, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT19, p_LOC_SEGMENT19)
314: ,LOC_SEGMENT20 = decode( p_LOC_SEGMENT20, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT20, p_LOC_SEGMENT20)
315: where REPAIR_ACTUAL_LINE_ID = p_REPAIR_ACTUAL_LINE_ID;

Line 312: ,LOC_SEGMENT18 = decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT18, p_LOC_SEGMENT18)

308: ,LOC_SEGMENT14 = decode( p_LOC_SEGMENT14, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT14, p_LOC_SEGMENT14)
309: ,LOC_SEGMENT15 = decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT15, p_LOC_SEGMENT15)
310: ,LOC_SEGMENT16 = decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT16, p_LOC_SEGMENT16)
311: ,LOC_SEGMENT17 = decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT17, p_LOC_SEGMENT17)
312: ,LOC_SEGMENT18 = decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT18, p_LOC_SEGMENT18)
313: ,LOC_SEGMENT19 = decode( p_LOC_SEGMENT19, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT19, p_LOC_SEGMENT19)
314: ,LOC_SEGMENT20 = decode( p_LOC_SEGMENT20, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT20, p_LOC_SEGMENT20)
315: where REPAIR_ACTUAL_LINE_ID = p_REPAIR_ACTUAL_LINE_ID;
316:

Line 313: ,LOC_SEGMENT19 = decode( p_LOC_SEGMENT19, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT19, p_LOC_SEGMENT19)

309: ,LOC_SEGMENT15 = decode( p_LOC_SEGMENT15, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT15, p_LOC_SEGMENT15)
310: ,LOC_SEGMENT16 = decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT16, p_LOC_SEGMENT16)
311: ,LOC_SEGMENT17 = decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT17, p_LOC_SEGMENT17)
312: ,LOC_SEGMENT18 = decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT18, p_LOC_SEGMENT18)
313: ,LOC_SEGMENT19 = decode( p_LOC_SEGMENT19, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT19, p_LOC_SEGMENT19)
314: ,LOC_SEGMENT20 = decode( p_LOC_SEGMENT20, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT20, p_LOC_SEGMENT20)
315: where REPAIR_ACTUAL_LINE_ID = p_REPAIR_ACTUAL_LINE_ID;
316:
317: If (SQL%NOTFOUND) then

Line 314: ,LOC_SEGMENT20 = decode( p_LOC_SEGMENT20, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT20, p_LOC_SEGMENT20)

310: ,LOC_SEGMENT16 = decode( p_LOC_SEGMENT16, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT16, p_LOC_SEGMENT16)
311: ,LOC_SEGMENT17 = decode( p_LOC_SEGMENT17, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT17, p_LOC_SEGMENT17)
312: ,LOC_SEGMENT18 = decode( p_LOC_SEGMENT18, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT18, p_LOC_SEGMENT18)
313: ,LOC_SEGMENT19 = decode( p_LOC_SEGMENT19, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT19, p_LOC_SEGMENT19)
314: ,LOC_SEGMENT20 = decode( p_LOC_SEGMENT20, FND_API.G_MISS_CHAR, NULL, NULL, LOC_SEGMENT20, p_LOC_SEGMENT20)
315: where REPAIR_ACTUAL_LINE_ID = p_REPAIR_ACTUAL_LINE_ID;
316:
317: If (SQL%NOTFOUND) then
318: RAISE NO_DATA_FOUND;