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

APPS.CSD_REPAIR_ESTIMATE_PKG dependencies on FND_API

Line 53: If (px_REPAIR_ESTIMATE_ID IS NULL) OR (px_REPAIR_ESTIMATE_ID = FND_API.G_MISS_NUM) then

49:
50: IS
51: CURSOR C2 IS SELECT CSD_REPAIR_ESTIMATE_S1.nextval FROM sys.dual;
52: BEGIN
53: If (px_REPAIR_ESTIMATE_ID IS NULL) OR (px_REPAIR_ESTIMATE_ID = FND_API.G_MISS_NUM) then
54: OPEN C2;
55: FETCH C2 INTO px_REPAIR_ESTIMATE_ID;
56: CLOSE C2;
57: End If;

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

90: ,ESTIMATE_FREEZE_FLAG
91: ,ESTIMATE_REASON_CODE
92: ) VALUES (
93: px_REPAIR_ESTIMATE_ID
94: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
95: ,decode( p_ESTIMATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_STATUS)
96: ,decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ESTIMATE_DATE)
97: ,decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, NULL, p_WORK_SUMMARY)
98: ,decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_PO_NUMBER)

Line 95: ,decode( p_ESTIMATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_STATUS)

91: ,ESTIMATE_REASON_CODE
92: ) VALUES (
93: px_REPAIR_ESTIMATE_ID
94: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
95: ,decode( p_ESTIMATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_STATUS)
96: ,decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ESTIMATE_DATE)
97: ,decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, NULL, p_WORK_SUMMARY)
98: ,decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_PO_NUMBER)
99: ,decode( p_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_LEAD_TIME)

Line 96: ,decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ESTIMATE_DATE)

92: ) VALUES (
93: px_REPAIR_ESTIMATE_ID
94: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
95: ,decode( p_ESTIMATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_STATUS)
96: ,decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ESTIMATE_DATE)
97: ,decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, NULL, p_WORK_SUMMARY)
98: ,decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_PO_NUMBER)
99: ,decode( p_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_LEAD_TIME)
100: ,decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_LEAD_TIME_UOM)

Line 97: ,decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, NULL, p_WORK_SUMMARY)

93: px_REPAIR_ESTIMATE_ID
94: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
95: ,decode( p_ESTIMATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_STATUS)
96: ,decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ESTIMATE_DATE)
97: ,decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, NULL, p_WORK_SUMMARY)
98: ,decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_PO_NUMBER)
99: ,decode( p_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_LEAD_TIME)
100: ,decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_LEAD_TIME_UOM)
101: ,decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NULL, p_NOT_TO_EXCEED)

Line 98: ,decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_PO_NUMBER)

94: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
95: ,decode( p_ESTIMATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_STATUS)
96: ,decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ESTIMATE_DATE)
97: ,decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, NULL, p_WORK_SUMMARY)
98: ,decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_PO_NUMBER)
99: ,decode( p_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_LEAD_TIME)
100: ,decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_LEAD_TIME_UOM)
101: ,decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NULL, p_NOT_TO_EXCEED)
102: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)

Line 99: ,decode( p_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_LEAD_TIME)

95: ,decode( p_ESTIMATE_STATUS, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_STATUS)
96: ,decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ESTIMATE_DATE)
97: ,decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, NULL, p_WORK_SUMMARY)
98: ,decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_PO_NUMBER)
99: ,decode( p_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_LEAD_TIME)
100: ,decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_LEAD_TIME_UOM)
101: ,decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NULL, p_NOT_TO_EXCEED)
102: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
103: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

Line 100: ,decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_LEAD_TIME_UOM)

96: ,decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ESTIMATE_DATE)
97: ,decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, NULL, p_WORK_SUMMARY)
98: ,decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_PO_NUMBER)
99: ,decode( p_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_LEAD_TIME)
100: ,decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_LEAD_TIME_UOM)
101: ,decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NULL, p_NOT_TO_EXCEED)
102: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
103: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
104: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

Line 101: ,decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NULL, p_NOT_TO_EXCEED)

97: ,decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, NULL, p_WORK_SUMMARY)
98: ,decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_PO_NUMBER)
99: ,decode( p_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_LEAD_TIME)
100: ,decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_LEAD_TIME_UOM)
101: ,decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NULL, p_NOT_TO_EXCEED)
102: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
103: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
104: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
105: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)

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

98: ,decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_PO_NUMBER)
99: ,decode( p_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_LEAD_TIME)
100: ,decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_LEAD_TIME_UOM)
101: ,decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NULL, p_NOT_TO_EXCEED)
102: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
103: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
104: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
105: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
106: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

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

99: ,decode( p_LEAD_TIME, FND_API.G_MISS_NUM, NULL, p_LEAD_TIME)
100: ,decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_LEAD_TIME_UOM)
101: ,decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NULL, p_NOT_TO_EXCEED)
102: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
103: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
104: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
105: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
106: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)

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

100: ,decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_LEAD_TIME_UOM)
101: ,decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NULL, p_NOT_TO_EXCEED)
102: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
103: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
104: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
105: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
106: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
108: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)

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

101: ,decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NULL, p_NOT_TO_EXCEED)
102: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
103: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
104: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
105: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
106: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
108: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
109: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)

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

102: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
103: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
104: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
105: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
106: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
108: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
109: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
110: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)

Line 107: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)

103: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
104: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
105: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
106: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
108: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
109: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
110: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
111: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)

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

104: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
105: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
106: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
108: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
109: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
110: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
111: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
112: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)

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

105: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
106: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
108: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
109: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
110: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
111: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
112: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
113: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)

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

106: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
107: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
108: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
109: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
110: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
111: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
112: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
113: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
114: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)

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

107: ,decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT)
108: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
109: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
110: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
111: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
112: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
113: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
114: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
115: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)

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

108: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
109: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
110: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
111: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
112: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
113: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
114: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
115: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
116: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)

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

109: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
110: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
111: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
112: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
113: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
114: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
115: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
116: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
117: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)

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

110: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
111: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
112: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
113: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
114: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
115: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
116: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
117: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
118: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)

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

111: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
112: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
113: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
114: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
115: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
116: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
117: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
118: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
119: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)

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

112: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
113: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
114: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
115: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
116: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
117: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
118: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
119: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
120: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)

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

113: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
114: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
115: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
116: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
117: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
118: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
119: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
120: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
121: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)

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

114: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
115: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
116: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
117: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
118: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
119: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
120: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
121: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
122: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)

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

115: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
116: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
117: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
118: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
119: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
120: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
121: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
122: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
123: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)

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

116: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
117: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
118: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
119: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
120: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
121: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
122: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
123: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
124: ,decode( p_ESTIMATE_FREEZE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_FREEZE_FLAG)

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

117: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
118: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
119: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
120: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
121: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
122: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
123: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
124: ,decode( p_ESTIMATE_FREEZE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_FREEZE_FLAG)
125: ,decode( p_ESTIMATE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_REASON_CODE));

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

118: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
119: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
120: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
121: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
122: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
123: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
124: ,decode( p_ESTIMATE_FREEZE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_FREEZE_FLAG)
125: ,decode( p_ESTIMATE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_REASON_CODE));
126: End Insert_Row;

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

119: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
120: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
121: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
122: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
123: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
124: ,decode( p_ESTIMATE_FREEZE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_FREEZE_FLAG)
125: ,decode( p_ESTIMATE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_REASON_CODE));
126: End Insert_Row;
127:

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

120: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
121: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
122: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
123: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
124: ,decode( p_ESTIMATE_FREEZE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_FREEZE_FLAG)
125: ,decode( p_ESTIMATE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_REASON_CODE));
126: End Insert_Row;
127:
128: PROCEDURE Update_Row(

Line 125: ,decode( p_ESTIMATE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_REASON_CODE));

121: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
122: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
123: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
124: ,decode( p_ESTIMATE_FREEZE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_FREEZE_FLAG)
125: ,decode( p_ESTIMATE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_ESTIMATE_REASON_CODE));
126: End Insert_Row;
127:
128: PROCEDURE Update_Row(
129: p_REPAIR_ESTIMATE_ID NUMBER

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

163: IS
164: BEGIN
165: Update CSD_REPAIR_ESTIMATE
166: SET
167: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
168: ,ESTIMATE_STATUS = decode( p_ESTIMATE_STATUS, FND_API.G_MISS_CHAR, ESTIMATE_STATUS, p_ESTIMATE_STATUS)
169: ,ESTIMATE_DATE = decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, ESTIMATE_DATE, p_ESTIMATE_DATE)
170: ,WORK_SUMMARY = decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, WORK_SUMMARY, p_WORK_SUMMARY)
171: ,PO_NUMBER = decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, PO_NUMBER, p_PO_NUMBER)

Line 168: ,ESTIMATE_STATUS = decode( p_ESTIMATE_STATUS, FND_API.G_MISS_CHAR, ESTIMATE_STATUS, p_ESTIMATE_STATUS)

164: BEGIN
165: Update CSD_REPAIR_ESTIMATE
166: SET
167: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
168: ,ESTIMATE_STATUS = decode( p_ESTIMATE_STATUS, FND_API.G_MISS_CHAR, ESTIMATE_STATUS, p_ESTIMATE_STATUS)
169: ,ESTIMATE_DATE = decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, ESTIMATE_DATE, p_ESTIMATE_DATE)
170: ,WORK_SUMMARY = decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, WORK_SUMMARY, p_WORK_SUMMARY)
171: ,PO_NUMBER = decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, PO_NUMBER, p_PO_NUMBER)
172: ,LEAD_TIME = decode( p_LEAD_TIME, FND_API.G_MISS_NUM, LEAD_TIME, p_LEAD_TIME)

Line 169: ,ESTIMATE_DATE = decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, ESTIMATE_DATE, p_ESTIMATE_DATE)

165: Update CSD_REPAIR_ESTIMATE
166: SET
167: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
168: ,ESTIMATE_STATUS = decode( p_ESTIMATE_STATUS, FND_API.G_MISS_CHAR, ESTIMATE_STATUS, p_ESTIMATE_STATUS)
169: ,ESTIMATE_DATE = decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, ESTIMATE_DATE, p_ESTIMATE_DATE)
170: ,WORK_SUMMARY = decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, WORK_SUMMARY, p_WORK_SUMMARY)
171: ,PO_NUMBER = decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, PO_NUMBER, p_PO_NUMBER)
172: ,LEAD_TIME = decode( p_LEAD_TIME, FND_API.G_MISS_NUM, LEAD_TIME, p_LEAD_TIME)
173: ,LEAD_TIME_UOM = decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, LEAD_TIME_UOM, p_LEAD_TIME_UOM)

Line 170: ,WORK_SUMMARY = decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, WORK_SUMMARY, p_WORK_SUMMARY)

166: SET
167: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
168: ,ESTIMATE_STATUS = decode( p_ESTIMATE_STATUS, FND_API.G_MISS_CHAR, ESTIMATE_STATUS, p_ESTIMATE_STATUS)
169: ,ESTIMATE_DATE = decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, ESTIMATE_DATE, p_ESTIMATE_DATE)
170: ,WORK_SUMMARY = decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, WORK_SUMMARY, p_WORK_SUMMARY)
171: ,PO_NUMBER = decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, PO_NUMBER, p_PO_NUMBER)
172: ,LEAD_TIME = decode( p_LEAD_TIME, FND_API.G_MISS_NUM, LEAD_TIME, p_LEAD_TIME)
173: ,LEAD_TIME_UOM = decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, LEAD_TIME_UOM, p_LEAD_TIME_UOM)
174: ,NOT_TO_EXCEED = decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NOT_TO_EXCEED, p_NOT_TO_EXCEED)

Line 171: ,PO_NUMBER = decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, PO_NUMBER, p_PO_NUMBER)

167: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
168: ,ESTIMATE_STATUS = decode( p_ESTIMATE_STATUS, FND_API.G_MISS_CHAR, ESTIMATE_STATUS, p_ESTIMATE_STATUS)
169: ,ESTIMATE_DATE = decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, ESTIMATE_DATE, p_ESTIMATE_DATE)
170: ,WORK_SUMMARY = decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, WORK_SUMMARY, p_WORK_SUMMARY)
171: ,PO_NUMBER = decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, PO_NUMBER, p_PO_NUMBER)
172: ,LEAD_TIME = decode( p_LEAD_TIME, FND_API.G_MISS_NUM, LEAD_TIME, p_LEAD_TIME)
173: ,LEAD_TIME_UOM = decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, LEAD_TIME_UOM, p_LEAD_TIME_UOM)
174: ,NOT_TO_EXCEED = decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NOT_TO_EXCEED, p_NOT_TO_EXCEED)
175: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

Line 172: ,LEAD_TIME = decode( p_LEAD_TIME, FND_API.G_MISS_NUM, LEAD_TIME, p_LEAD_TIME)

168: ,ESTIMATE_STATUS = decode( p_ESTIMATE_STATUS, FND_API.G_MISS_CHAR, ESTIMATE_STATUS, p_ESTIMATE_STATUS)
169: ,ESTIMATE_DATE = decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, ESTIMATE_DATE, p_ESTIMATE_DATE)
170: ,WORK_SUMMARY = decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, WORK_SUMMARY, p_WORK_SUMMARY)
171: ,PO_NUMBER = decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, PO_NUMBER, p_PO_NUMBER)
172: ,LEAD_TIME = decode( p_LEAD_TIME, FND_API.G_MISS_NUM, LEAD_TIME, p_LEAD_TIME)
173: ,LEAD_TIME_UOM = decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, LEAD_TIME_UOM, p_LEAD_TIME_UOM)
174: ,NOT_TO_EXCEED = decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NOT_TO_EXCEED, p_NOT_TO_EXCEED)
175: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
176: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)

Line 173: ,LEAD_TIME_UOM = decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, LEAD_TIME_UOM, p_LEAD_TIME_UOM)

169: ,ESTIMATE_DATE = decode( p_ESTIMATE_DATE, FND_API.G_MISS_DATE, ESTIMATE_DATE, p_ESTIMATE_DATE)
170: ,WORK_SUMMARY = decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, WORK_SUMMARY, p_WORK_SUMMARY)
171: ,PO_NUMBER = decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, PO_NUMBER, p_PO_NUMBER)
172: ,LEAD_TIME = decode( p_LEAD_TIME, FND_API.G_MISS_NUM, LEAD_TIME, p_LEAD_TIME)
173: ,LEAD_TIME_UOM = decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, LEAD_TIME_UOM, p_LEAD_TIME_UOM)
174: ,NOT_TO_EXCEED = decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NOT_TO_EXCEED, p_NOT_TO_EXCEED)
175: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
176: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
177: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

Line 174: ,NOT_TO_EXCEED = decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NOT_TO_EXCEED, p_NOT_TO_EXCEED)

170: ,WORK_SUMMARY = decode( p_WORK_SUMMARY, FND_API.G_MISS_CHAR, WORK_SUMMARY, p_WORK_SUMMARY)
171: ,PO_NUMBER = decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, PO_NUMBER, p_PO_NUMBER)
172: ,LEAD_TIME = decode( p_LEAD_TIME, FND_API.G_MISS_NUM, LEAD_TIME, p_LEAD_TIME)
173: ,LEAD_TIME_UOM = decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, LEAD_TIME_UOM, p_LEAD_TIME_UOM)
174: ,NOT_TO_EXCEED = decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NOT_TO_EXCEED, p_NOT_TO_EXCEED)
175: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
176: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
177: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
178: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)

Line 175: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

171: ,PO_NUMBER = decode( p_PO_NUMBER, FND_API.G_MISS_CHAR, PO_NUMBER, p_PO_NUMBER)
172: ,LEAD_TIME = decode( p_LEAD_TIME, FND_API.G_MISS_NUM, LEAD_TIME, p_LEAD_TIME)
173: ,LEAD_TIME_UOM = decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, LEAD_TIME_UOM, p_LEAD_TIME_UOM)
174: ,NOT_TO_EXCEED = decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NOT_TO_EXCEED, p_NOT_TO_EXCEED)
175: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
176: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
177: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
178: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
179: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

Line 176: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)

172: ,LEAD_TIME = decode( p_LEAD_TIME, FND_API.G_MISS_NUM, LEAD_TIME, p_LEAD_TIME)
173: ,LEAD_TIME_UOM = decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, LEAD_TIME_UOM, p_LEAD_TIME_UOM)
174: ,NOT_TO_EXCEED = decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NOT_TO_EXCEED, p_NOT_TO_EXCEED)
175: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
176: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
177: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
178: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
179: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
180: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT)

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

173: ,LEAD_TIME_UOM = decode( p_LEAD_TIME_UOM, FND_API.G_MISS_CHAR, LEAD_TIME_UOM, p_LEAD_TIME_UOM)
174: ,NOT_TO_EXCEED = decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NOT_TO_EXCEED, p_NOT_TO_EXCEED)
175: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
176: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
177: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
178: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
179: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
180: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT)
181: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)

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

174: ,NOT_TO_EXCEED = decode( p_NOT_TO_EXCEED, FND_API.G_MISS_NUM, NOT_TO_EXCEED, p_NOT_TO_EXCEED)
175: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
176: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
177: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
178: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
179: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
180: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT)
181: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
182: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)

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

175: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
176: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
177: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
178: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
179: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
180: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT)
181: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
182: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
183: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)

Line 180: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT)

176: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
177: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
178: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
179: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
180: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT)
181: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
182: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
183: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
184: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)

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

177: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
178: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
179: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
180: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT)
181: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
182: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
183: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
184: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
185: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)

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

178: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
179: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
180: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT)
181: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
182: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
183: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
184: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
185: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
186: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)

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

179: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
180: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT)
181: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
182: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
183: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
184: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
185: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
186: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
187: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)

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

180: ,CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT)
181: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
182: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
183: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
184: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
185: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
186: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
187: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
188: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)

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

181: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
182: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
183: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
184: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
185: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
186: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
187: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
188: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
189: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)

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

182: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
183: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
184: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
185: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
186: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
187: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
188: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
189: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
190: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)

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

183: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
184: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
185: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
186: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
187: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
188: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
189: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
190: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
191: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)

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

184: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
185: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
186: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
187: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
188: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
189: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
190: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
191: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
192: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)

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

185: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
186: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
187: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
188: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
189: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
190: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
191: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
192: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
193: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)

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

186: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
187: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
188: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
189: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
190: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
191: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
192: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
193: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
194: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)

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

187: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
188: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
189: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
190: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
191: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
192: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
193: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
194: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
195: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)

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

188: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
189: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
190: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
191: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
192: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
193: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
194: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
195: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
196: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

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

189: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
190: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
191: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
192: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
193: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
194: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
195: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
196: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
197: ,ESTIMATE_FREEZE_FLAG = decode( p_ESTIMATE_FREEZE_FLAG, FND_API.G_MISS_CHAR, ESTIMATE_FREEZE_FLAG, p_ESTIMATE_FREEZE_FLAG)

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

190: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
191: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
192: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
193: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
194: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
195: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
196: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
197: ,ESTIMATE_FREEZE_FLAG = decode( p_ESTIMATE_FREEZE_FLAG, FND_API.G_MISS_CHAR, ESTIMATE_FREEZE_FLAG, p_ESTIMATE_FREEZE_FLAG)
198: ,ESTIMATE_REASON_CODE = decode( p_ESTIMATE_REASON_CODE, FND_API.G_MISS_CHAR, ESTIMATE_REASON_CODE, p_ESTIMATE_REASON_CODE)

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

191: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
192: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
193: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
194: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
195: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
196: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
197: ,ESTIMATE_FREEZE_FLAG = decode( p_ESTIMATE_FREEZE_FLAG, FND_API.G_MISS_CHAR, ESTIMATE_FREEZE_FLAG, p_ESTIMATE_FREEZE_FLAG)
198: ,ESTIMATE_REASON_CODE = decode( p_ESTIMATE_REASON_CODE, FND_API.G_MISS_CHAR, ESTIMATE_REASON_CODE, p_ESTIMATE_REASON_CODE)
199: where REPAIR_ESTIMATE_ID = p_REPAIR_ESTIMATE_ID;

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

192: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
193: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
194: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
195: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
196: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
197: ,ESTIMATE_FREEZE_FLAG = decode( p_ESTIMATE_FREEZE_FLAG, FND_API.G_MISS_CHAR, ESTIMATE_FREEZE_FLAG, p_ESTIMATE_FREEZE_FLAG)
198: ,ESTIMATE_REASON_CODE = decode( p_ESTIMATE_REASON_CODE, FND_API.G_MISS_CHAR, ESTIMATE_REASON_CODE, p_ESTIMATE_REASON_CODE)
199: where REPAIR_ESTIMATE_ID = p_REPAIR_ESTIMATE_ID;
200:

Line 197: ,ESTIMATE_FREEZE_FLAG = decode( p_ESTIMATE_FREEZE_FLAG, FND_API.G_MISS_CHAR, ESTIMATE_FREEZE_FLAG, p_ESTIMATE_FREEZE_FLAG)

193: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
194: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
195: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
196: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
197: ,ESTIMATE_FREEZE_FLAG = decode( p_ESTIMATE_FREEZE_FLAG, FND_API.G_MISS_CHAR, ESTIMATE_FREEZE_FLAG, p_ESTIMATE_FREEZE_FLAG)
198: ,ESTIMATE_REASON_CODE = decode( p_ESTIMATE_REASON_CODE, FND_API.G_MISS_CHAR, ESTIMATE_REASON_CODE, p_ESTIMATE_REASON_CODE)
199: where REPAIR_ESTIMATE_ID = p_REPAIR_ESTIMATE_ID;
200:
201: If (SQL%NOTFOUND) then

Line 198: ,ESTIMATE_REASON_CODE = decode( p_ESTIMATE_REASON_CODE, FND_API.G_MISS_CHAR, ESTIMATE_REASON_CODE, p_ESTIMATE_REASON_CODE)

194: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
195: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
196: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
197: ,ESTIMATE_FREEZE_FLAG = decode( p_ESTIMATE_FREEZE_FLAG, FND_API.G_MISS_CHAR, ESTIMATE_FREEZE_FLAG, p_ESTIMATE_FREEZE_FLAG)
198: ,ESTIMATE_REASON_CODE = decode( p_ESTIMATE_REASON_CODE, FND_API.G_MISS_CHAR, ESTIMATE_REASON_CODE, p_ESTIMATE_REASON_CODE)
199: where REPAIR_ESTIMATE_ID = p_REPAIR_ESTIMATE_ID;
200:
201: If (SQL%NOTFOUND) then
202: RAISE NO_DATA_FOUND;