50:
51: IS
52: CURSOR C2 IS SELECT CSD_SO_ORCHESTRATION_S1.nextval FROM sys.dual;
53: BEGIN
54: If (px_ORCHESTRATION_ID IS NULL) OR (px_ORCHESTRATION_ID = FND_API.G_MISS_NUM) then
55: OPEN C2;
56: FETCH C2 INTO px_ORCHESTRATION_ID;
57: CLOSE C2;
58: End If;
91: ,ATTRIBUTE15
92: ,PARAMN1
93: ) VALUES (
94: px_ORCHESTRATION_ID
95: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
96: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
97: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
98: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
99: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
92: ,PARAMN1
93: ) VALUES (
94: px_ORCHESTRATION_ID
95: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
96: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
97: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
98: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
99: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
100: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
93: ) VALUES (
94: px_ORCHESTRATION_ID
95: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
96: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
97: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
98: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
99: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
100: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
101: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
94: px_ORCHESTRATION_ID
95: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
96: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
97: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
98: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
99: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
100: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
101: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
102: ,decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_HEADER_ID)
95: ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
96: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
97: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
98: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
99: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
100: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
101: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
102: ,decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_HEADER_ID)
103: ,decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_HEADER_NAME)
96: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
97: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
98: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
99: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
100: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
101: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
102: ,decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_HEADER_ID)
103: ,decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_HEADER_NAME)
104: ,decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_LINE_ID)
97: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
98: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
99: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
100: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
101: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
102: ,decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_HEADER_ID)
103: ,decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_HEADER_NAME)
104: ,decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_LINE_ID)
105: ,decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_LINE_NAME)
98: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
99: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
100: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
101: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
102: ,decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_HEADER_ID)
103: ,decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_HEADER_NAME)
104: ,decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_LINE_ID)
105: ,decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_LINE_NAME)
106: ,decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_STATUS_ID)
99: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
100: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
101: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
102: ,decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_HEADER_ID)
103: ,decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_HEADER_NAME)
104: ,decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_LINE_ID)
105: ,decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_LINE_NAME)
106: ,decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_STATUS_ID)
107: ,decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE)
100: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
101: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
102: ,decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_HEADER_ID)
103: ,decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_HEADER_NAME)
104: ,decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_LINE_ID)
105: ,decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_LINE_NAME)
106: ,decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_STATUS_ID)
107: ,decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE)
108: ,decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_PREV_STATUS_ID)
101: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
102: ,decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_HEADER_ID)
103: ,decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_HEADER_NAME)
104: ,decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_LINE_ID)
105: ,decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_LINE_NAME)
106: ,decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_STATUS_ID)
107: ,decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE)
108: ,decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_PREV_STATUS_ID)
109: ,decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PREV_STATUS_CODE)
102: ,decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_HEADER_ID)
103: ,decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_HEADER_NAME)
104: ,decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_LINE_ID)
105: ,decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_LINE_NAME)
106: ,decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_STATUS_ID)
107: ,decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE)
108: ,decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_PREV_STATUS_ID)
109: ,decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PREV_STATUS_CODE)
110: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
103: ,decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_HEADER_NAME)
104: ,decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_LINE_ID)
105: ,decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_LINE_NAME)
106: ,decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_STATUS_ID)
107: ,decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE)
108: ,decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_PREV_STATUS_ID)
109: ,decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PREV_STATUS_CODE)
110: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
111: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
104: ,decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_LINE_ID)
105: ,decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_LINE_NAME)
106: ,decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_STATUS_ID)
107: ,decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE)
108: ,decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_PREV_STATUS_ID)
109: ,decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PREV_STATUS_CODE)
110: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
111: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
112: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
105: ,decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_LINE_NAME)
106: ,decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_STATUS_ID)
107: ,decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE)
108: ,decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_PREV_STATUS_ID)
109: ,decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PREV_STATUS_CODE)
110: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
111: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
112: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
113: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
106: ,decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_STATUS_ID)
107: ,decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE)
108: ,decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_PREV_STATUS_ID)
109: ,decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PREV_STATUS_CODE)
110: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
111: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
112: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
113: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
114: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
107: ,decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE)
108: ,decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_PREV_STATUS_ID)
109: ,decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PREV_STATUS_CODE)
110: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
111: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
112: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
113: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
114: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
115: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
108: ,decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_PREV_STATUS_ID)
109: ,decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PREV_STATUS_CODE)
110: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
111: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
112: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
113: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
114: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
115: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
116: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
109: ,decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PREV_STATUS_CODE)
110: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
111: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
112: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
113: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
114: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
115: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
116: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
117: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
110: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
111: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
112: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
113: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
114: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
115: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
116: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
117: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
118: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
111: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
112: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
113: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
114: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
115: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
116: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
117: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
118: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
119: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
112: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
113: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
114: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
115: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
116: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
117: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
118: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
119: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
120: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
113: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
114: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
115: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
116: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
117: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
118: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
119: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
120: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
121: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
114: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
115: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
116: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
117: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
118: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
119: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
120: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
121: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
122: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
115: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
116: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
117: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
118: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
119: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
120: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
121: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
122: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
123: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
116: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
117: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
118: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
119: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
120: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
121: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
122: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
123: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
124: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
117: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
118: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
119: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
120: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
121: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
122: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
123: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
124: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
125: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
118: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
119: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
120: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
121: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
122: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
123: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
124: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
125: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
126: ,decode( p_PARAMN1, FND_API.G_MISS_NUM, NULL, p_PARAMN1)
119: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
120: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
121: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
122: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
123: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
124: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
125: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
126: ,decode( p_PARAMN1, FND_API.G_MISS_NUM, NULL, p_PARAMN1)
127: );
120: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
121: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
122: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
123: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
124: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
125: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
126: ,decode( p_PARAMN1, FND_API.G_MISS_NUM, NULL, p_PARAMN1)
127: );
128: End Insert_Row;
121: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
122: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
123: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
124: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
125: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
126: ,decode( p_PARAMN1, FND_API.G_MISS_NUM, NULL, p_PARAMN1)
127: );
128: End Insert_Row;
129:
122: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
123: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
124: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
125: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
126: ,decode( p_PARAMN1, FND_API.G_MISS_NUM, NULL, p_PARAMN1)
127: );
128: End Insert_Row;
129:
130:
171: IS
172: BEGIN
173: Update CSD_SO_ORCHESTRATION
174: SET
175: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
176: ,OBJECT_VERSION_NUMBER = decode( P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, P_OBJECT_VERSION_NUMBER)
177: ,CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
178: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
179: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
172: BEGIN
173: Update CSD_SO_ORCHESTRATION
174: SET
175: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
176: ,OBJECT_VERSION_NUMBER = decode( P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, P_OBJECT_VERSION_NUMBER)
177: ,CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
178: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
179: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
180: ,LAST_UPDATE_DATE = decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, P_LAST_UPDATE_DATE)
173: Update CSD_SO_ORCHESTRATION
174: SET
175: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
176: ,OBJECT_VERSION_NUMBER = decode( P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, P_OBJECT_VERSION_NUMBER)
177: ,CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
178: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
179: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
180: ,LAST_UPDATE_DATE = decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, P_LAST_UPDATE_DATE)
181: ,LAST_UPDATE_LOGIN = decode( P_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, P_LAST_UPDATE_LOGIN)
174: SET
175: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
176: ,OBJECT_VERSION_NUMBER = decode( P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, P_OBJECT_VERSION_NUMBER)
177: ,CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
178: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
179: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
180: ,LAST_UPDATE_DATE = decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, P_LAST_UPDATE_DATE)
181: ,LAST_UPDATE_LOGIN = decode( P_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, P_LAST_UPDATE_LOGIN)
182: ,DOCUMENT_HEADER_ID = decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_HEADER_ID, p_DOCUMENT_HEADER_ID)
175: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
176: ,OBJECT_VERSION_NUMBER = decode( P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, P_OBJECT_VERSION_NUMBER)
177: ,CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
178: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
179: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
180: ,LAST_UPDATE_DATE = decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, P_LAST_UPDATE_DATE)
181: ,LAST_UPDATE_LOGIN = decode( P_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, P_LAST_UPDATE_LOGIN)
182: ,DOCUMENT_HEADER_ID = decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_HEADER_ID, p_DOCUMENT_HEADER_ID)
183: ,DOCUMENT_HEADER_NAME = decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_HEADER_NAME, p_DOCUMENT_HEADER_NAME)
176: ,OBJECT_VERSION_NUMBER = decode( P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, P_OBJECT_VERSION_NUMBER)
177: ,CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
178: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
179: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
180: ,LAST_UPDATE_DATE = decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, P_LAST_UPDATE_DATE)
181: ,LAST_UPDATE_LOGIN = decode( P_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, P_LAST_UPDATE_LOGIN)
182: ,DOCUMENT_HEADER_ID = decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_HEADER_ID, p_DOCUMENT_HEADER_ID)
183: ,DOCUMENT_HEADER_NAME = decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_HEADER_NAME, p_DOCUMENT_HEADER_NAME)
184: ,DOCUMENT_LINE_ID = decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_LINE_ID, p_DOCUMENT_LINE_ID)
177: ,CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
178: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
179: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
180: ,LAST_UPDATE_DATE = decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, P_LAST_UPDATE_DATE)
181: ,LAST_UPDATE_LOGIN = decode( P_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, P_LAST_UPDATE_LOGIN)
182: ,DOCUMENT_HEADER_ID = decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_HEADER_ID, p_DOCUMENT_HEADER_ID)
183: ,DOCUMENT_HEADER_NAME = decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_HEADER_NAME, p_DOCUMENT_HEADER_NAME)
184: ,DOCUMENT_LINE_ID = decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_LINE_ID, p_DOCUMENT_LINE_ID)
185: ,DOCUMENT_LINE_NAME = decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_LINE_NAME, p_DOCUMENT_LINE_NAME)
178: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
179: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
180: ,LAST_UPDATE_DATE = decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, P_LAST_UPDATE_DATE)
181: ,LAST_UPDATE_LOGIN = decode( P_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, P_LAST_UPDATE_LOGIN)
182: ,DOCUMENT_HEADER_ID = decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_HEADER_ID, p_DOCUMENT_HEADER_ID)
183: ,DOCUMENT_HEADER_NAME = decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_HEADER_NAME, p_DOCUMENT_HEADER_NAME)
184: ,DOCUMENT_LINE_ID = decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_LINE_ID, p_DOCUMENT_LINE_ID)
185: ,DOCUMENT_LINE_NAME = decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_LINE_NAME, p_DOCUMENT_LINE_NAME)
186: ,STATUS_ID = decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, STATUS_ID, p_STATUS_ID)
179: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
180: ,LAST_UPDATE_DATE = decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, P_LAST_UPDATE_DATE)
181: ,LAST_UPDATE_LOGIN = decode( P_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, P_LAST_UPDATE_LOGIN)
182: ,DOCUMENT_HEADER_ID = decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_HEADER_ID, p_DOCUMENT_HEADER_ID)
183: ,DOCUMENT_HEADER_NAME = decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_HEADER_NAME, p_DOCUMENT_HEADER_NAME)
184: ,DOCUMENT_LINE_ID = decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_LINE_ID, p_DOCUMENT_LINE_ID)
185: ,DOCUMENT_LINE_NAME = decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_LINE_NAME, p_DOCUMENT_LINE_NAME)
186: ,STATUS_ID = decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, STATUS_ID, p_STATUS_ID)
187: ,STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, STATUS_CODE, p_STATUS_CODE)
180: ,LAST_UPDATE_DATE = decode( P_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, P_LAST_UPDATE_DATE)
181: ,LAST_UPDATE_LOGIN = decode( P_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, P_LAST_UPDATE_LOGIN)
182: ,DOCUMENT_HEADER_ID = decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_HEADER_ID, p_DOCUMENT_HEADER_ID)
183: ,DOCUMENT_HEADER_NAME = decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_HEADER_NAME, p_DOCUMENT_HEADER_NAME)
184: ,DOCUMENT_LINE_ID = decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_LINE_ID, p_DOCUMENT_LINE_ID)
185: ,DOCUMENT_LINE_NAME = decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_LINE_NAME, p_DOCUMENT_LINE_NAME)
186: ,STATUS_ID = decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, STATUS_ID, p_STATUS_ID)
187: ,STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, STATUS_CODE, p_STATUS_CODE)
188: ,PREV_STATUS_ID = decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, PREV_STATUS_ID, p_PREV_STATUS_ID)
181: ,LAST_UPDATE_LOGIN = decode( P_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, P_LAST_UPDATE_LOGIN)
182: ,DOCUMENT_HEADER_ID = decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_HEADER_ID, p_DOCUMENT_HEADER_ID)
183: ,DOCUMENT_HEADER_NAME = decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_HEADER_NAME, p_DOCUMENT_HEADER_NAME)
184: ,DOCUMENT_LINE_ID = decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_LINE_ID, p_DOCUMENT_LINE_ID)
185: ,DOCUMENT_LINE_NAME = decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_LINE_NAME, p_DOCUMENT_LINE_NAME)
186: ,STATUS_ID = decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, STATUS_ID, p_STATUS_ID)
187: ,STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, STATUS_CODE, p_STATUS_CODE)
188: ,PREV_STATUS_ID = decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, PREV_STATUS_ID, p_PREV_STATUS_ID)
189: ,PREV_STATUS_CODE = decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, PREV_STATUS_CODE, p_PREV_STATUS_CODE)
182: ,DOCUMENT_HEADER_ID = decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_HEADER_ID, p_DOCUMENT_HEADER_ID)
183: ,DOCUMENT_HEADER_NAME = decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_HEADER_NAME, p_DOCUMENT_HEADER_NAME)
184: ,DOCUMENT_LINE_ID = decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_LINE_ID, p_DOCUMENT_LINE_ID)
185: ,DOCUMENT_LINE_NAME = decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_LINE_NAME, p_DOCUMENT_LINE_NAME)
186: ,STATUS_ID = decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, STATUS_ID, p_STATUS_ID)
187: ,STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, STATUS_CODE, p_STATUS_CODE)
188: ,PREV_STATUS_ID = decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, PREV_STATUS_ID, p_PREV_STATUS_ID)
189: ,PREV_STATUS_CODE = decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, PREV_STATUS_CODE, p_PREV_STATUS_CODE)
190: ,ATTRIBUTE_CATEGORY = decode( P_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY)
183: ,DOCUMENT_HEADER_NAME = decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_HEADER_NAME, p_DOCUMENT_HEADER_NAME)
184: ,DOCUMENT_LINE_ID = decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_LINE_ID, p_DOCUMENT_LINE_ID)
185: ,DOCUMENT_LINE_NAME = decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_LINE_NAME, p_DOCUMENT_LINE_NAME)
186: ,STATUS_ID = decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, STATUS_ID, p_STATUS_ID)
187: ,STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, STATUS_CODE, p_STATUS_CODE)
188: ,PREV_STATUS_ID = decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, PREV_STATUS_ID, p_PREV_STATUS_ID)
189: ,PREV_STATUS_CODE = decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, PREV_STATUS_CODE, p_PREV_STATUS_CODE)
190: ,ATTRIBUTE_CATEGORY = decode( P_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY)
191: ,ATTRIBUTE1 = decode( P_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, P_ATTRIBUTE1)
184: ,DOCUMENT_LINE_ID = decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_LINE_ID, p_DOCUMENT_LINE_ID)
185: ,DOCUMENT_LINE_NAME = decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_LINE_NAME, p_DOCUMENT_LINE_NAME)
186: ,STATUS_ID = decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, STATUS_ID, p_STATUS_ID)
187: ,STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, STATUS_CODE, p_STATUS_CODE)
188: ,PREV_STATUS_ID = decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, PREV_STATUS_ID, p_PREV_STATUS_ID)
189: ,PREV_STATUS_CODE = decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, PREV_STATUS_CODE, p_PREV_STATUS_CODE)
190: ,ATTRIBUTE_CATEGORY = decode( P_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY)
191: ,ATTRIBUTE1 = decode( P_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, P_ATTRIBUTE1)
192: ,ATTRIBUTE2 = decode( P_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, P_ATTRIBUTE2)
185: ,DOCUMENT_LINE_NAME = decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_LINE_NAME, p_DOCUMENT_LINE_NAME)
186: ,STATUS_ID = decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, STATUS_ID, p_STATUS_ID)
187: ,STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, STATUS_CODE, p_STATUS_CODE)
188: ,PREV_STATUS_ID = decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, PREV_STATUS_ID, p_PREV_STATUS_ID)
189: ,PREV_STATUS_CODE = decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, PREV_STATUS_CODE, p_PREV_STATUS_CODE)
190: ,ATTRIBUTE_CATEGORY = decode( P_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY)
191: ,ATTRIBUTE1 = decode( P_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, P_ATTRIBUTE1)
192: ,ATTRIBUTE2 = decode( P_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, P_ATTRIBUTE2)
193: ,ATTRIBUTE3 = decode( P_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, P_ATTRIBUTE3)
186: ,STATUS_ID = decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, STATUS_ID, p_STATUS_ID)
187: ,STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, STATUS_CODE, p_STATUS_CODE)
188: ,PREV_STATUS_ID = decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, PREV_STATUS_ID, p_PREV_STATUS_ID)
189: ,PREV_STATUS_CODE = decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, PREV_STATUS_CODE, p_PREV_STATUS_CODE)
190: ,ATTRIBUTE_CATEGORY = decode( P_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY)
191: ,ATTRIBUTE1 = decode( P_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, P_ATTRIBUTE1)
192: ,ATTRIBUTE2 = decode( P_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, P_ATTRIBUTE2)
193: ,ATTRIBUTE3 = decode( P_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, P_ATTRIBUTE3)
194: ,ATTRIBUTE4 = decode( P_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, P_ATTRIBUTE4)
187: ,STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, STATUS_CODE, p_STATUS_CODE)
188: ,PREV_STATUS_ID = decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, PREV_STATUS_ID, p_PREV_STATUS_ID)
189: ,PREV_STATUS_CODE = decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, PREV_STATUS_CODE, p_PREV_STATUS_CODE)
190: ,ATTRIBUTE_CATEGORY = decode( P_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY)
191: ,ATTRIBUTE1 = decode( P_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, P_ATTRIBUTE1)
192: ,ATTRIBUTE2 = decode( P_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, P_ATTRIBUTE2)
193: ,ATTRIBUTE3 = decode( P_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, P_ATTRIBUTE3)
194: ,ATTRIBUTE4 = decode( P_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, P_ATTRIBUTE4)
195: ,ATTRIBUTE5 = decode( P_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, P_ATTRIBUTE5)
188: ,PREV_STATUS_ID = decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, PREV_STATUS_ID, p_PREV_STATUS_ID)
189: ,PREV_STATUS_CODE = decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, PREV_STATUS_CODE, p_PREV_STATUS_CODE)
190: ,ATTRIBUTE_CATEGORY = decode( P_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY)
191: ,ATTRIBUTE1 = decode( P_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, P_ATTRIBUTE1)
192: ,ATTRIBUTE2 = decode( P_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, P_ATTRIBUTE2)
193: ,ATTRIBUTE3 = decode( P_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, P_ATTRIBUTE3)
194: ,ATTRIBUTE4 = decode( P_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, P_ATTRIBUTE4)
195: ,ATTRIBUTE5 = decode( P_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, P_ATTRIBUTE5)
196: ,ATTRIBUTE6 = decode( P_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, P_ATTRIBUTE6)
189: ,PREV_STATUS_CODE = decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, PREV_STATUS_CODE, p_PREV_STATUS_CODE)
190: ,ATTRIBUTE_CATEGORY = decode( P_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY)
191: ,ATTRIBUTE1 = decode( P_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, P_ATTRIBUTE1)
192: ,ATTRIBUTE2 = decode( P_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, P_ATTRIBUTE2)
193: ,ATTRIBUTE3 = decode( P_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, P_ATTRIBUTE3)
194: ,ATTRIBUTE4 = decode( P_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, P_ATTRIBUTE4)
195: ,ATTRIBUTE5 = decode( P_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, P_ATTRIBUTE5)
196: ,ATTRIBUTE6 = decode( P_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, P_ATTRIBUTE6)
197: ,ATTRIBUTE7 = decode( P_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, P_ATTRIBUTE7)
190: ,ATTRIBUTE_CATEGORY = decode( P_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY)
191: ,ATTRIBUTE1 = decode( P_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, P_ATTRIBUTE1)
192: ,ATTRIBUTE2 = decode( P_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, P_ATTRIBUTE2)
193: ,ATTRIBUTE3 = decode( P_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, P_ATTRIBUTE3)
194: ,ATTRIBUTE4 = decode( P_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, P_ATTRIBUTE4)
195: ,ATTRIBUTE5 = decode( P_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, P_ATTRIBUTE5)
196: ,ATTRIBUTE6 = decode( P_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, P_ATTRIBUTE6)
197: ,ATTRIBUTE7 = decode( P_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, P_ATTRIBUTE7)
198: ,ATTRIBUTE8 = decode( P_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, P_ATTRIBUTE8)
191: ,ATTRIBUTE1 = decode( P_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, P_ATTRIBUTE1)
192: ,ATTRIBUTE2 = decode( P_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, P_ATTRIBUTE2)
193: ,ATTRIBUTE3 = decode( P_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, P_ATTRIBUTE3)
194: ,ATTRIBUTE4 = decode( P_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, P_ATTRIBUTE4)
195: ,ATTRIBUTE5 = decode( P_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, P_ATTRIBUTE5)
196: ,ATTRIBUTE6 = decode( P_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, P_ATTRIBUTE6)
197: ,ATTRIBUTE7 = decode( P_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, P_ATTRIBUTE7)
198: ,ATTRIBUTE8 = decode( P_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, P_ATTRIBUTE8)
199: ,ATTRIBUTE9 = decode( P_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, P_ATTRIBUTE9)
192: ,ATTRIBUTE2 = decode( P_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, P_ATTRIBUTE2)
193: ,ATTRIBUTE3 = decode( P_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, P_ATTRIBUTE3)
194: ,ATTRIBUTE4 = decode( P_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, P_ATTRIBUTE4)
195: ,ATTRIBUTE5 = decode( P_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, P_ATTRIBUTE5)
196: ,ATTRIBUTE6 = decode( P_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, P_ATTRIBUTE6)
197: ,ATTRIBUTE7 = decode( P_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, P_ATTRIBUTE7)
198: ,ATTRIBUTE8 = decode( P_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, P_ATTRIBUTE8)
199: ,ATTRIBUTE9 = decode( P_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, P_ATTRIBUTE9)
200: ,ATTRIBUTE10 = decode( P_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, P_ATTRIBUTE10)
193: ,ATTRIBUTE3 = decode( P_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, P_ATTRIBUTE3)
194: ,ATTRIBUTE4 = decode( P_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, P_ATTRIBUTE4)
195: ,ATTRIBUTE5 = decode( P_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, P_ATTRIBUTE5)
196: ,ATTRIBUTE6 = decode( P_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, P_ATTRIBUTE6)
197: ,ATTRIBUTE7 = decode( P_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, P_ATTRIBUTE7)
198: ,ATTRIBUTE8 = decode( P_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, P_ATTRIBUTE8)
199: ,ATTRIBUTE9 = decode( P_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, P_ATTRIBUTE9)
200: ,ATTRIBUTE10 = decode( P_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, P_ATTRIBUTE10)
201: ,ATTRIBUTE11 = decode( P_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, P_ATTRIBUTE11)
194: ,ATTRIBUTE4 = decode( P_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, P_ATTRIBUTE4)
195: ,ATTRIBUTE5 = decode( P_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, P_ATTRIBUTE5)
196: ,ATTRIBUTE6 = decode( P_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, P_ATTRIBUTE6)
197: ,ATTRIBUTE7 = decode( P_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, P_ATTRIBUTE7)
198: ,ATTRIBUTE8 = decode( P_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, P_ATTRIBUTE8)
199: ,ATTRIBUTE9 = decode( P_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, P_ATTRIBUTE9)
200: ,ATTRIBUTE10 = decode( P_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, P_ATTRIBUTE10)
201: ,ATTRIBUTE11 = decode( P_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, P_ATTRIBUTE11)
202: ,ATTRIBUTE12 = decode( P_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, P_ATTRIBUTE12)
195: ,ATTRIBUTE5 = decode( P_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, P_ATTRIBUTE5)
196: ,ATTRIBUTE6 = decode( P_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, P_ATTRIBUTE6)
197: ,ATTRIBUTE7 = decode( P_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, P_ATTRIBUTE7)
198: ,ATTRIBUTE8 = decode( P_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, P_ATTRIBUTE8)
199: ,ATTRIBUTE9 = decode( P_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, P_ATTRIBUTE9)
200: ,ATTRIBUTE10 = decode( P_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, P_ATTRIBUTE10)
201: ,ATTRIBUTE11 = decode( P_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, P_ATTRIBUTE11)
202: ,ATTRIBUTE12 = decode( P_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, P_ATTRIBUTE12)
203: ,ATTRIBUTE13 = decode( P_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, P_ATTRIBUTE13)
196: ,ATTRIBUTE6 = decode( P_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, P_ATTRIBUTE6)
197: ,ATTRIBUTE7 = decode( P_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, P_ATTRIBUTE7)
198: ,ATTRIBUTE8 = decode( P_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, P_ATTRIBUTE8)
199: ,ATTRIBUTE9 = decode( P_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, P_ATTRIBUTE9)
200: ,ATTRIBUTE10 = decode( P_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, P_ATTRIBUTE10)
201: ,ATTRIBUTE11 = decode( P_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, P_ATTRIBUTE11)
202: ,ATTRIBUTE12 = decode( P_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, P_ATTRIBUTE12)
203: ,ATTRIBUTE13 = decode( P_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, P_ATTRIBUTE13)
204: ,ATTRIBUTE14 = decode( P_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, P_ATTRIBUTE14)
197: ,ATTRIBUTE7 = decode( P_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, P_ATTRIBUTE7)
198: ,ATTRIBUTE8 = decode( P_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, P_ATTRIBUTE8)
199: ,ATTRIBUTE9 = decode( P_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, P_ATTRIBUTE9)
200: ,ATTRIBUTE10 = decode( P_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, P_ATTRIBUTE10)
201: ,ATTRIBUTE11 = decode( P_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, P_ATTRIBUTE11)
202: ,ATTRIBUTE12 = decode( P_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, P_ATTRIBUTE12)
203: ,ATTRIBUTE13 = decode( P_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, P_ATTRIBUTE13)
204: ,ATTRIBUTE14 = decode( P_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, P_ATTRIBUTE14)
205: ,ATTRIBUTE15 = decode( P_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, P_ATTRIBUTE15)
198: ,ATTRIBUTE8 = decode( P_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, P_ATTRIBUTE8)
199: ,ATTRIBUTE9 = decode( P_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, P_ATTRIBUTE9)
200: ,ATTRIBUTE10 = decode( P_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, P_ATTRIBUTE10)
201: ,ATTRIBUTE11 = decode( P_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, P_ATTRIBUTE11)
202: ,ATTRIBUTE12 = decode( P_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, P_ATTRIBUTE12)
203: ,ATTRIBUTE13 = decode( P_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, P_ATTRIBUTE13)
204: ,ATTRIBUTE14 = decode( P_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, P_ATTRIBUTE14)
205: ,ATTRIBUTE15 = decode( P_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, P_ATTRIBUTE15)
206: ,PARAMN1 = decode( P_PARAMN1, FND_API.G_MISS_NUM, NULL, NULL, PARAMN1, P_PARAMN1)
199: ,ATTRIBUTE9 = decode( P_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, P_ATTRIBUTE9)
200: ,ATTRIBUTE10 = decode( P_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, P_ATTRIBUTE10)
201: ,ATTRIBUTE11 = decode( P_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, P_ATTRIBUTE11)
202: ,ATTRIBUTE12 = decode( P_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, P_ATTRIBUTE12)
203: ,ATTRIBUTE13 = decode( P_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, P_ATTRIBUTE13)
204: ,ATTRIBUTE14 = decode( P_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, P_ATTRIBUTE14)
205: ,ATTRIBUTE15 = decode( P_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, P_ATTRIBUTE15)
206: ,PARAMN1 = decode( P_PARAMN1, FND_API.G_MISS_NUM, NULL, NULL, PARAMN1, P_PARAMN1)
207:
200: ,ATTRIBUTE10 = decode( P_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, P_ATTRIBUTE10)
201: ,ATTRIBUTE11 = decode( P_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, P_ATTRIBUTE11)
202: ,ATTRIBUTE12 = decode( P_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, P_ATTRIBUTE12)
203: ,ATTRIBUTE13 = decode( P_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, P_ATTRIBUTE13)
204: ,ATTRIBUTE14 = decode( P_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, P_ATTRIBUTE14)
205: ,ATTRIBUTE15 = decode( P_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, P_ATTRIBUTE15)
206: ,PARAMN1 = decode( P_PARAMN1, FND_API.G_MISS_NUM, NULL, NULL, PARAMN1, P_PARAMN1)
207:
208: where ORCHESTRATION_ID = p_ORCHESTRATION_ID;
201: ,ATTRIBUTE11 = decode( P_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, P_ATTRIBUTE11)
202: ,ATTRIBUTE12 = decode( P_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, P_ATTRIBUTE12)
203: ,ATTRIBUTE13 = decode( P_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, P_ATTRIBUTE13)
204: ,ATTRIBUTE14 = decode( P_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, P_ATTRIBUTE14)
205: ,ATTRIBUTE15 = decode( P_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, P_ATTRIBUTE15)
206: ,PARAMN1 = decode( P_PARAMN1, FND_API.G_MISS_NUM, NULL, NULL, PARAMN1, P_PARAMN1)
207:
208: where ORCHESTRATION_ID = p_ORCHESTRATION_ID;
209:
202: ,ATTRIBUTE12 = decode( P_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, P_ATTRIBUTE12)
203: ,ATTRIBUTE13 = decode( P_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, P_ATTRIBUTE13)
204: ,ATTRIBUTE14 = decode( P_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, P_ATTRIBUTE14)
205: ,ATTRIBUTE15 = decode( P_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, P_ATTRIBUTE15)
206: ,PARAMN1 = decode( P_PARAMN1, FND_API.G_MISS_NUM, NULL, NULL, PARAMN1, P_PARAMN1)
207:
208: where ORCHESTRATION_ID = p_ORCHESTRATION_ID;
209:
210: If (SQL%NOTFOUND) then