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

APPS.IEX_STRATEGY_WORK_ITEMS_PKG dependencies on FND_API

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

96: VALUES (
97: x_WORK_ITEM_ID
98: ,x_STRATEGY_ID
99: ,x_RESOURCE_ID
100: ,decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, x_STATUS_CODE)
101: ,decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)
102: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
103: ,decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
104: ,decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL, x_CREATED_BY)

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

97: x_WORK_ITEM_ID
98: ,x_STRATEGY_ID
99: ,x_RESOURCE_ID
100: ,decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, x_STATUS_CODE)
101: ,decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)
102: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
103: ,decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
104: ,decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL, x_CREATED_BY)
105: ,decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID)

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

98: ,x_STRATEGY_ID
99: ,x_RESOURCE_ID
100: ,decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, x_STATUS_CODE)
101: ,decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)
102: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
103: ,decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
104: ,decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL, x_CREATED_BY)
105: ,decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID)
106: ,decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER)

Line 103: ,decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)

99: ,x_RESOURCE_ID
100: ,decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, x_STATUS_CODE)
101: ,decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)
102: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
103: ,decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
104: ,decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL, x_CREATED_BY)
105: ,decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID)
106: ,decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER)
107: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID)

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

100: ,decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, x_STATUS_CODE)
101: ,decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)
102: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
103: ,decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
104: ,decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL, x_CREATED_BY)
105: ,decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID)
106: ,decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER)
107: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID)
108: ,decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)

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

101: ,decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)
102: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
103: ,decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
104: ,decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL, x_CREATED_BY)
105: ,decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID)
106: ,decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER)
107: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID)
108: ,decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)
109: ,decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_TEMPLATE_ID)

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

102: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
103: ,decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
104: ,decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL, x_CREATED_BY)
105: ,decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID)
106: ,decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER)
107: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID)
108: ,decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)
109: ,decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_TEMPLATE_ID)
110: ,decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID)

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

103: ,decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
104: ,decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL, x_CREATED_BY)
105: ,decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID)
106: ,decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER)
107: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID)
108: ,decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)
109: ,decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_TEMPLATE_ID)
110: ,decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID)
111: ,decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), x_PROGRAM_UPDATE_DATE)

Line 108: ,decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)

104: ,decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL, x_CREATED_BY)
105: ,decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID)
106: ,decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER)
107: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID)
108: ,decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)
109: ,decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_TEMPLATE_ID)
110: ,decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID)
111: ,decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), x_PROGRAM_UPDATE_DATE)
112: ,decode( x_execute_start, FND_API.G_MISS_DATE, to_date(null), x_execute_start)

Line 109: ,decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_TEMPLATE_ID)

105: ,decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID)
106: ,decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER)
107: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID)
108: ,decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)
109: ,decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_TEMPLATE_ID)
110: ,decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID)
111: ,decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), x_PROGRAM_UPDATE_DATE)
112: ,decode( x_execute_start, FND_API.G_MISS_DATE, to_date(null), x_execute_start)
113: ,decode( x_execute_end, FND_API.G_MISS_DATE, to_date(null), x_execute_end)

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

106: ,decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER)
107: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID)
108: ,decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)
109: ,decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_TEMPLATE_ID)
110: ,decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID)
111: ,decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), x_PROGRAM_UPDATE_DATE)
112: ,decode( x_execute_start, FND_API.G_MISS_DATE, to_date(null), x_execute_start)
113: ,decode( x_execute_end, FND_API.G_MISS_DATE, to_date(null), x_execute_end)
114: ,decode( x_schedule_start, FND_API.G_MISS_DATE, to_date(null), x_schedule_start )

Line 111: ,decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), x_PROGRAM_UPDATE_DATE)

107: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID)
108: ,decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)
109: ,decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_TEMPLATE_ID)
110: ,decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID)
111: ,decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), x_PROGRAM_UPDATE_DATE)
112: ,decode( x_execute_start, FND_API.G_MISS_DATE, to_date(null), x_execute_start)
113: ,decode( x_execute_end, FND_API.G_MISS_DATE, to_date(null), x_execute_end)
114: ,decode( x_schedule_start, FND_API.G_MISS_DATE, to_date(null), x_schedule_start )
115: ,decode( x_schedule_end , FND_API.G_MISS_DATE, to_date(null), x_schedule_end)

Line 112: ,decode( x_execute_start, FND_API.G_MISS_DATE, to_date(null), x_execute_start)

108: ,decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)
109: ,decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_TEMPLATE_ID)
110: ,decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID)
111: ,decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), x_PROGRAM_UPDATE_DATE)
112: ,decode( x_execute_start, FND_API.G_MISS_DATE, to_date(null), x_execute_start)
113: ,decode( x_execute_end, FND_API.G_MISS_DATE, to_date(null), x_execute_end)
114: ,decode( x_schedule_start, FND_API.G_MISS_DATE, to_date(null), x_schedule_start )
115: ,decode( x_schedule_end , FND_API.G_MISS_DATE, to_date(null), x_schedule_end)
116: ,decode( x_strategy_temp_id, FND_API.G_MISS_NUM, NULL, x_strategy_temp_id)

Line 113: ,decode( x_execute_end, FND_API.G_MISS_DATE, to_date(null), x_execute_end)

109: ,decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_TEMPLATE_ID)
110: ,decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID)
111: ,decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), x_PROGRAM_UPDATE_DATE)
112: ,decode( x_execute_start, FND_API.G_MISS_DATE, to_date(null), x_execute_start)
113: ,decode( x_execute_end, FND_API.G_MISS_DATE, to_date(null), x_execute_end)
114: ,decode( x_schedule_start, FND_API.G_MISS_DATE, to_date(null), x_schedule_start )
115: ,decode( x_schedule_end , FND_API.G_MISS_DATE, to_date(null), x_schedule_end)
116: ,decode( x_strategy_temp_id, FND_API.G_MISS_NUM, NULL, x_strategy_temp_id)
117: ,decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_ORDER)

Line 114: ,decode( x_schedule_start, FND_API.G_MISS_DATE, to_date(null), x_schedule_start )

110: ,decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID)
111: ,decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), x_PROGRAM_UPDATE_DATE)
112: ,decode( x_execute_start, FND_API.G_MISS_DATE, to_date(null), x_execute_start)
113: ,decode( x_execute_end, FND_API.G_MISS_DATE, to_date(null), x_execute_end)
114: ,decode( x_schedule_start, FND_API.G_MISS_DATE, to_date(null), x_schedule_start )
115: ,decode( x_schedule_end , FND_API.G_MISS_DATE, to_date(null), x_schedule_end)
116: ,decode( x_strategy_temp_id, FND_API.G_MISS_NUM, NULL, x_strategy_temp_id)
117: ,decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_ORDER)
118: ,decode( x_escalated_yn, FND_API.G_MISS_CHAR, NULL, x_escalated_yn)

Line 115: ,decode( x_schedule_end , FND_API.G_MISS_DATE, to_date(null), x_schedule_end)

111: ,decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), x_PROGRAM_UPDATE_DATE)
112: ,decode( x_execute_start, FND_API.G_MISS_DATE, to_date(null), x_execute_start)
113: ,decode( x_execute_end, FND_API.G_MISS_DATE, to_date(null), x_execute_end)
114: ,decode( x_schedule_start, FND_API.G_MISS_DATE, to_date(null), x_schedule_start )
115: ,decode( x_schedule_end , FND_API.G_MISS_DATE, to_date(null), x_schedule_end)
116: ,decode( x_strategy_temp_id, FND_API.G_MISS_NUM, NULL, x_strategy_temp_id)
117: ,decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_ORDER)
118: ,decode( x_escalated_yn, FND_API.G_MISS_CHAR, NULL, x_escalated_yn)
119: ,decode( x_pre_execution_wait, FND_API.G_MISS_NUM, NULL, x_pre_execution_wait)

Line 116: ,decode( x_strategy_temp_id, FND_API.G_MISS_NUM, NULL, x_strategy_temp_id)

112: ,decode( x_execute_start, FND_API.G_MISS_DATE, to_date(null), x_execute_start)
113: ,decode( x_execute_end, FND_API.G_MISS_DATE, to_date(null), x_execute_end)
114: ,decode( x_schedule_start, FND_API.G_MISS_DATE, to_date(null), x_schedule_start )
115: ,decode( x_schedule_end , FND_API.G_MISS_DATE, to_date(null), x_schedule_end)
116: ,decode( x_strategy_temp_id, FND_API.G_MISS_NUM, NULL, x_strategy_temp_id)
117: ,decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_ORDER)
118: ,decode( x_escalated_yn, FND_API.G_MISS_CHAR, NULL, x_escalated_yn)
119: ,decode( x_pre_execution_wait, FND_API.G_MISS_NUM, NULL, x_pre_execution_wait)
120: ,decode( x_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_pre_execution_time_uom)

Line 117: ,decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_ORDER)

113: ,decode( x_execute_end, FND_API.G_MISS_DATE, to_date(null), x_execute_end)
114: ,decode( x_schedule_start, FND_API.G_MISS_DATE, to_date(null), x_schedule_start )
115: ,decode( x_schedule_end , FND_API.G_MISS_DATE, to_date(null), x_schedule_end)
116: ,decode( x_strategy_temp_id, FND_API.G_MISS_NUM, NULL, x_strategy_temp_id)
117: ,decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_ORDER)
118: ,decode( x_escalated_yn, FND_API.G_MISS_CHAR, NULL, x_escalated_yn)
119: ,decode( x_pre_execution_wait, FND_API.G_MISS_NUM, NULL, x_pre_execution_wait)
120: ,decode( x_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_pre_execution_time_uom)
121: ,decode( x_post_execution_wait, FND_API.G_MISS_NUM, NULL, x_post_execution_wait)

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

114: ,decode( x_schedule_start, FND_API.G_MISS_DATE, to_date(null), x_schedule_start )
115: ,decode( x_schedule_end , FND_API.G_MISS_DATE, to_date(null), x_schedule_end)
116: ,decode( x_strategy_temp_id, FND_API.G_MISS_NUM, NULL, x_strategy_temp_id)
117: ,decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_ORDER)
118: ,decode( x_escalated_yn, FND_API.G_MISS_CHAR, NULL, x_escalated_yn)
119: ,decode( x_pre_execution_wait, FND_API.G_MISS_NUM, NULL, x_pre_execution_wait)
120: ,decode( x_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_pre_execution_time_uom)
121: ,decode( x_post_execution_wait, FND_API.G_MISS_NUM, NULL, x_post_execution_wait)
122: ,decode( x_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_execution_time_uom)

Line 119: ,decode( x_pre_execution_wait, FND_API.G_MISS_NUM, NULL, x_pre_execution_wait)

115: ,decode( x_schedule_end , FND_API.G_MISS_DATE, to_date(null), x_schedule_end)
116: ,decode( x_strategy_temp_id, FND_API.G_MISS_NUM, NULL, x_strategy_temp_id)
117: ,decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_ORDER)
118: ,decode( x_escalated_yn, FND_API.G_MISS_CHAR, NULL, x_escalated_yn)
119: ,decode( x_pre_execution_wait, FND_API.G_MISS_NUM, NULL, x_pre_execution_wait)
120: ,decode( x_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_pre_execution_time_uom)
121: ,decode( x_post_execution_wait, FND_API.G_MISS_NUM, NULL, x_post_execution_wait)
122: ,decode( x_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_execution_time_uom)
123: ,decode( x_xdo_temp_id, FND_API.G_MISS_NUM, NULL, x_xdo_temp_id)

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

116: ,decode( x_strategy_temp_id, FND_API.G_MISS_NUM, NULL, x_strategy_temp_id)
117: ,decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_ORDER)
118: ,decode( x_escalated_yn, FND_API.G_MISS_CHAR, NULL, x_escalated_yn)
119: ,decode( x_pre_execution_wait, FND_API.G_MISS_NUM, NULL, x_pre_execution_wait)
120: ,decode( x_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_pre_execution_time_uom)
121: ,decode( x_post_execution_wait, FND_API.G_MISS_NUM, NULL, x_post_execution_wait)
122: ,decode( x_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_execution_time_uom)
123: ,decode( x_xdo_temp_id, FND_API.G_MISS_NUM, NULL, x_xdo_temp_id)
124: ,decode( x_optional_yn, FND_API.G_MISS_CHAR, NULL, x_optional_yn)

Line 121: ,decode( x_post_execution_wait, FND_API.G_MISS_NUM, NULL, x_post_execution_wait)

117: ,decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_ORDER)
118: ,decode( x_escalated_yn, FND_API.G_MISS_CHAR, NULL, x_escalated_yn)
119: ,decode( x_pre_execution_wait, FND_API.G_MISS_NUM, NULL, x_pre_execution_wait)
120: ,decode( x_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_pre_execution_time_uom)
121: ,decode( x_post_execution_wait, FND_API.G_MISS_NUM, NULL, x_post_execution_wait)
122: ,decode( x_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_execution_time_uom)
123: ,decode( x_xdo_temp_id, FND_API.G_MISS_NUM, NULL, x_xdo_temp_id)
124: ,decode( x_optional_yn, FND_API.G_MISS_CHAR, NULL, x_optional_yn)
125: ,decode( x_optional_wait_time, FND_API.G_MISS_NUM, NULL, x_optional_wait_time)

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

118: ,decode( x_escalated_yn, FND_API.G_MISS_CHAR, NULL, x_escalated_yn)
119: ,decode( x_pre_execution_wait, FND_API.G_MISS_NUM, NULL, x_pre_execution_wait)
120: ,decode( x_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_pre_execution_time_uom)
121: ,decode( x_post_execution_wait, FND_API.G_MISS_NUM, NULL, x_post_execution_wait)
122: ,decode( x_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_execution_time_uom)
123: ,decode( x_xdo_temp_id, FND_API.G_MISS_NUM, NULL, x_xdo_temp_id)
124: ,decode( x_optional_yn, FND_API.G_MISS_CHAR, NULL, x_optional_yn)
125: ,decode( x_optional_wait_time, FND_API.G_MISS_NUM, NULL, x_optional_wait_time)
126: ,decode( x_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_optional_wait_time_uom)

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

119: ,decode( x_pre_execution_wait, FND_API.G_MISS_NUM, NULL, x_pre_execution_wait)
120: ,decode( x_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_pre_execution_time_uom)
121: ,decode( x_post_execution_wait, FND_API.G_MISS_NUM, NULL, x_post_execution_wait)
122: ,decode( x_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_execution_time_uom)
123: ,decode( x_xdo_temp_id, FND_API.G_MISS_NUM, NULL, x_xdo_temp_id)
124: ,decode( x_optional_yn, FND_API.G_MISS_CHAR, NULL, x_optional_yn)
125: ,decode( x_optional_wait_time, FND_API.G_MISS_NUM, NULL, x_optional_wait_time)
126: ,decode( x_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_optional_wait_time_uom)
127: ,decode( x_notify_yn, FND_API.G_MISS_CHAR, NULL, x_notify_yn)

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

120: ,decode( x_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_pre_execution_time_uom)
121: ,decode( x_post_execution_wait, FND_API.G_MISS_NUM, NULL, x_post_execution_wait)
122: ,decode( x_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_execution_time_uom)
123: ,decode( x_xdo_temp_id, FND_API.G_MISS_NUM, NULL, x_xdo_temp_id)
124: ,decode( x_optional_yn, FND_API.G_MISS_CHAR, NULL, x_optional_yn)
125: ,decode( x_optional_wait_time, FND_API.G_MISS_NUM, NULL, x_optional_wait_time)
126: ,decode( x_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_optional_wait_time_uom)
127: ,decode( x_notify_yn, FND_API.G_MISS_CHAR, NULL, x_notify_yn)
128: ,decode( x_escalate_yn, FND_API.G_MISS_CHAR, NULL, x_escalate_yn)

Line 125: ,decode( x_optional_wait_time, FND_API.G_MISS_NUM, NULL, x_optional_wait_time)

121: ,decode( x_post_execution_wait, FND_API.G_MISS_NUM, NULL, x_post_execution_wait)
122: ,decode( x_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_execution_time_uom)
123: ,decode( x_xdo_temp_id, FND_API.G_MISS_NUM, NULL, x_xdo_temp_id)
124: ,decode( x_optional_yn, FND_API.G_MISS_CHAR, NULL, x_optional_yn)
125: ,decode( x_optional_wait_time, FND_API.G_MISS_NUM, NULL, x_optional_wait_time)
126: ,decode( x_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_optional_wait_time_uom)
127: ,decode( x_notify_yn, FND_API.G_MISS_CHAR, NULL, x_notify_yn)
128: ,decode( x_escalate_yn, FND_API.G_MISS_CHAR, NULL, x_escalate_yn)
129: ,decode( x_escalate_wait_time, FND_API.G_MISS_NUM, NULL, x_escalate_wait_time)

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

122: ,decode( x_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_execution_time_uom)
123: ,decode( x_xdo_temp_id, FND_API.G_MISS_NUM, NULL, x_xdo_temp_id)
124: ,decode( x_optional_yn, FND_API.G_MISS_CHAR, NULL, x_optional_yn)
125: ,decode( x_optional_wait_time, FND_API.G_MISS_NUM, NULL, x_optional_wait_time)
126: ,decode( x_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_optional_wait_time_uom)
127: ,decode( x_notify_yn, FND_API.G_MISS_CHAR, NULL, x_notify_yn)
128: ,decode( x_escalate_yn, FND_API.G_MISS_CHAR, NULL, x_escalate_yn)
129: ,decode( x_escalate_wait_time, FND_API.G_MISS_NUM, NULL, x_escalate_wait_time)
130: ,decode( x_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_escalate_wait_time_uom)

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

123: ,decode( x_xdo_temp_id, FND_API.G_MISS_NUM, NULL, x_xdo_temp_id)
124: ,decode( x_optional_yn, FND_API.G_MISS_CHAR, NULL, x_optional_yn)
125: ,decode( x_optional_wait_time, FND_API.G_MISS_NUM, NULL, x_optional_wait_time)
126: ,decode( x_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_optional_wait_time_uom)
127: ,decode( x_notify_yn, FND_API.G_MISS_CHAR, NULL, x_notify_yn)
128: ,decode( x_escalate_yn, FND_API.G_MISS_CHAR, NULL, x_escalate_yn)
129: ,decode( x_escalate_wait_time, FND_API.G_MISS_NUM, NULL, x_escalate_wait_time)
130: ,decode( x_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_escalate_wait_time_uom)
131: ,decode( x_custom_workflow_type, FND_API.G_MISS_CHAR, NULL, x_custom_workflow_type)

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

124: ,decode( x_optional_yn, FND_API.G_MISS_CHAR, NULL, x_optional_yn)
125: ,decode( x_optional_wait_time, FND_API.G_MISS_NUM, NULL, x_optional_wait_time)
126: ,decode( x_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_optional_wait_time_uom)
127: ,decode( x_notify_yn, FND_API.G_MISS_CHAR, NULL, x_notify_yn)
128: ,decode( x_escalate_yn, FND_API.G_MISS_CHAR, NULL, x_escalate_yn)
129: ,decode( x_escalate_wait_time, FND_API.G_MISS_NUM, NULL, x_escalate_wait_time)
130: ,decode( x_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_escalate_wait_time_uom)
131: ,decode( x_custom_workflow_type, FND_API.G_MISS_CHAR, NULL, x_custom_workflow_type)
132: );

Line 129: ,decode( x_escalate_wait_time, FND_API.G_MISS_NUM, NULL, x_escalate_wait_time)

125: ,decode( x_optional_wait_time, FND_API.G_MISS_NUM, NULL, x_optional_wait_time)
126: ,decode( x_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_optional_wait_time_uom)
127: ,decode( x_notify_yn, FND_API.G_MISS_CHAR, NULL, x_notify_yn)
128: ,decode( x_escalate_yn, FND_API.G_MISS_CHAR, NULL, x_escalate_yn)
129: ,decode( x_escalate_wait_time, FND_API.G_MISS_NUM, NULL, x_escalate_wait_time)
130: ,decode( x_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_escalate_wait_time_uom)
131: ,decode( x_custom_workflow_type, FND_API.G_MISS_CHAR, NULL, x_custom_workflow_type)
132: );
133: open c;

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

126: ,decode( x_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_optional_wait_time_uom)
127: ,decode( x_notify_yn, FND_API.G_MISS_CHAR, NULL, x_notify_yn)
128: ,decode( x_escalate_yn, FND_API.G_MISS_CHAR, NULL, x_escalate_yn)
129: ,decode( x_escalate_wait_time, FND_API.G_MISS_NUM, NULL, x_escalate_wait_time)
130: ,decode( x_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_escalate_wait_time_uom)
131: ,decode( x_custom_workflow_type, FND_API.G_MISS_CHAR, NULL, x_custom_workflow_type)
132: );
133: open c;
134: fetch c into X_ROWID;

Line 131: ,decode( x_custom_workflow_type, FND_API.G_MISS_CHAR, NULL, x_custom_workflow_type)

127: ,decode( x_notify_yn, FND_API.G_MISS_CHAR, NULL, x_notify_yn)
128: ,decode( x_escalate_yn, FND_API.G_MISS_CHAR, NULL, x_escalate_yn)
129: ,decode( x_escalate_wait_time, FND_API.G_MISS_NUM, NULL, x_escalate_wait_time)
130: ,decode( x_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_escalate_wait_time_uom)
131: ,decode( x_custom_workflow_type, FND_API.G_MISS_CHAR, NULL, x_custom_workflow_type)
132: );
133: open c;
134: fetch c into X_ROWID;
135: -- IF PG_DEBUG < 10 THEN

Line 181: STRATEGY_ID = decode( x_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, x_STRATEGY_ID)

177: IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.UPDATE_ROW ******** ');
178: END IF;
179: Update IEX_STRATEGY_WORK_ITEMS
180: SET
181: STRATEGY_ID = decode( x_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, x_STRATEGY_ID)
182: ,RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, x_RESOURCE_ID)
183: ,STATUS_CODE = decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, x_STATUS_CODE)
184: ,LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, x_LAST_UPDATED_BY)
185: ,LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN)

Line 182: ,RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, x_RESOURCE_ID)

178: END IF;
179: Update IEX_STRATEGY_WORK_ITEMS
180: SET
181: STRATEGY_ID = decode( x_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, x_STRATEGY_ID)
182: ,RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, x_RESOURCE_ID)
183: ,STATUS_CODE = decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, x_STATUS_CODE)
184: ,LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, x_LAST_UPDATED_BY)
185: ,LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN)
186: ,PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, x_PROGRAM_ID)

Line 183: ,STATUS_CODE = decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, x_STATUS_CODE)

179: Update IEX_STRATEGY_WORK_ITEMS
180: SET
181: STRATEGY_ID = decode( x_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, x_STRATEGY_ID)
182: ,RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, x_RESOURCE_ID)
183: ,STATUS_CODE = decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, x_STATUS_CODE)
184: ,LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, x_LAST_UPDATED_BY)
185: ,LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN)
186: ,PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, x_PROGRAM_ID)
187: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)

Line 184: ,LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, x_LAST_UPDATED_BY)

180: SET
181: STRATEGY_ID = decode( x_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, x_STRATEGY_ID)
182: ,RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, x_RESOURCE_ID)
183: ,STATUS_CODE = decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, x_STATUS_CODE)
184: ,LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, x_LAST_UPDATED_BY)
185: ,LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN)
186: ,PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, x_PROGRAM_ID)
187: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)
188: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, x_REQUEST_ID)

Line 185: ,LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN)

181: STRATEGY_ID = decode( x_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, x_STRATEGY_ID)
182: ,RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, x_RESOURCE_ID)
183: ,STATUS_CODE = decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, x_STATUS_CODE)
184: ,LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, x_LAST_UPDATED_BY)
185: ,LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN)
186: ,PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, x_PROGRAM_ID)
187: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)
188: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, x_REQUEST_ID)
189: ,LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, x_LAST_UPDATE_DATE)

Line 186: ,PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, x_PROGRAM_ID)

182: ,RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, x_RESOURCE_ID)
183: ,STATUS_CODE = decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, x_STATUS_CODE)
184: ,LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, x_LAST_UPDATED_BY)
185: ,LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN)
186: ,PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, x_PROGRAM_ID)
187: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)
188: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, x_REQUEST_ID)
189: ,LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, x_LAST_UPDATE_DATE)
190: ,WORK_ITEM_TEMPLATE_ID = decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMPLATE_ID, x_WORK_ITEM_TEMPLATE_ID)

Line 187: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)

183: ,STATUS_CODE = decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, x_STATUS_CODE)
184: ,LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, x_LAST_UPDATED_BY)
185: ,LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN)
186: ,PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, x_PROGRAM_ID)
187: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)
188: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, x_REQUEST_ID)
189: ,LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, x_LAST_UPDATE_DATE)
190: ,WORK_ITEM_TEMPLATE_ID = decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMPLATE_ID, x_WORK_ITEM_TEMPLATE_ID)
191: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID)

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

184: ,LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, x_LAST_UPDATED_BY)
185: ,LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN)
186: ,PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, x_PROGRAM_ID)
187: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)
188: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, x_REQUEST_ID)
189: ,LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, x_LAST_UPDATE_DATE)
190: ,WORK_ITEM_TEMPLATE_ID = decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMPLATE_ID, x_WORK_ITEM_TEMPLATE_ID)
191: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID)
192: ,PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE)

Line 189: ,LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, x_LAST_UPDATE_DATE)

185: ,LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN)
186: ,PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, x_PROGRAM_ID)
187: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)
188: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, x_REQUEST_ID)
189: ,LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, x_LAST_UPDATE_DATE)
190: ,WORK_ITEM_TEMPLATE_ID = decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMPLATE_ID, x_WORK_ITEM_TEMPLATE_ID)
191: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID)
192: ,PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE)
193: ,execute_start = decode( x_execute_start, FND_API.G_MISS_DATE, execute_start, x_execute_start)

Line 190: ,WORK_ITEM_TEMPLATE_ID = decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMPLATE_ID, x_WORK_ITEM_TEMPLATE_ID)

186: ,PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, x_PROGRAM_ID)
187: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)
188: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, x_REQUEST_ID)
189: ,LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, x_LAST_UPDATE_DATE)
190: ,WORK_ITEM_TEMPLATE_ID = decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMPLATE_ID, x_WORK_ITEM_TEMPLATE_ID)
191: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID)
192: ,PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE)
193: ,execute_start = decode( x_execute_start, FND_API.G_MISS_DATE, execute_start, x_execute_start)
194: ,execute_end = decode( x_execute_end, FND_API.G_MISS_DATE, execute_end, x_execute_end)

Line 191: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID)

187: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)
188: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, x_REQUEST_ID)
189: ,LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, x_LAST_UPDATE_DATE)
190: ,WORK_ITEM_TEMPLATE_ID = decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMPLATE_ID, x_WORK_ITEM_TEMPLATE_ID)
191: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID)
192: ,PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE)
193: ,execute_start = decode( x_execute_start, FND_API.G_MISS_DATE, execute_start, x_execute_start)
194: ,execute_end = decode( x_execute_end, FND_API.G_MISS_DATE, execute_end, x_execute_end)
195: ,schedule_start =decode( x_schedule_start, FND_API.G_MISS_DATE, schedule_start, x_schedule_start)

Line 192: ,PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE)

188: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, x_REQUEST_ID)
189: ,LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, x_LAST_UPDATE_DATE)
190: ,WORK_ITEM_TEMPLATE_ID = decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMPLATE_ID, x_WORK_ITEM_TEMPLATE_ID)
191: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID)
192: ,PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE)
193: ,execute_start = decode( x_execute_start, FND_API.G_MISS_DATE, execute_start, x_execute_start)
194: ,execute_end = decode( x_execute_end, FND_API.G_MISS_DATE, execute_end, x_execute_end)
195: ,schedule_start =decode( x_schedule_start, FND_API.G_MISS_DATE, schedule_start, x_schedule_start)
196: ,schedule_end =decode( x_schedule_end, FND_API.G_MISS_DATE, schedule_end, x_schedule_end)

Line 193: ,execute_start = decode( x_execute_start, FND_API.G_MISS_DATE, execute_start, x_execute_start)

189: ,LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, x_LAST_UPDATE_DATE)
190: ,WORK_ITEM_TEMPLATE_ID = decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMPLATE_ID, x_WORK_ITEM_TEMPLATE_ID)
191: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID)
192: ,PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE)
193: ,execute_start = decode( x_execute_start, FND_API.G_MISS_DATE, execute_start, x_execute_start)
194: ,execute_end = decode( x_execute_end, FND_API.G_MISS_DATE, execute_end, x_execute_end)
195: ,schedule_start =decode( x_schedule_start, FND_API.G_MISS_DATE, schedule_start, x_schedule_start)
196: ,schedule_end =decode( x_schedule_end, FND_API.G_MISS_DATE, schedule_end, x_schedule_end)
197: ,strategy_temp_id = decode( x_strategy_temp_id , FND_API.G_MISS_NUM, strategy_temp_id , x_strategy_temp_id )

Line 194: ,execute_end = decode( x_execute_end, FND_API.G_MISS_DATE, execute_end, x_execute_end)

190: ,WORK_ITEM_TEMPLATE_ID = decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMPLATE_ID, x_WORK_ITEM_TEMPLATE_ID)
191: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID)
192: ,PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE)
193: ,execute_start = decode( x_execute_start, FND_API.G_MISS_DATE, execute_start, x_execute_start)
194: ,execute_end = decode( x_execute_end, FND_API.G_MISS_DATE, execute_end, x_execute_end)
195: ,schedule_start =decode( x_schedule_start, FND_API.G_MISS_DATE, schedule_start, x_schedule_start)
196: ,schedule_end =decode( x_schedule_end, FND_API.G_MISS_DATE, schedule_end, x_schedule_end)
197: ,strategy_temp_id = decode( x_strategy_temp_id , FND_API.G_MISS_NUM, strategy_temp_id , x_strategy_temp_id )
198: ,WORK_ITEM_ORDER = decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, x_WORK_ITEM_ORDER)

Line 195: ,schedule_start =decode( x_schedule_start, FND_API.G_MISS_DATE, schedule_start, x_schedule_start)

191: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID)
192: ,PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE)
193: ,execute_start = decode( x_execute_start, FND_API.G_MISS_DATE, execute_start, x_execute_start)
194: ,execute_end = decode( x_execute_end, FND_API.G_MISS_DATE, execute_end, x_execute_end)
195: ,schedule_start =decode( x_schedule_start, FND_API.G_MISS_DATE, schedule_start, x_schedule_start)
196: ,schedule_end =decode( x_schedule_end, FND_API.G_MISS_DATE, schedule_end, x_schedule_end)
197: ,strategy_temp_id = decode( x_strategy_temp_id , FND_API.G_MISS_NUM, strategy_temp_id , x_strategy_temp_id )
198: ,WORK_ITEM_ORDER = decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, x_WORK_ITEM_ORDER)
199: ,escalated_yn = decode( x_escalated_yn, FND_API.G_MISS_CHAR, escalated_yn, x_escalated_yn)

Line 196: ,schedule_end =decode( x_schedule_end, FND_API.G_MISS_DATE, schedule_end, x_schedule_end)

192: ,PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE)
193: ,execute_start = decode( x_execute_start, FND_API.G_MISS_DATE, execute_start, x_execute_start)
194: ,execute_end = decode( x_execute_end, FND_API.G_MISS_DATE, execute_end, x_execute_end)
195: ,schedule_start =decode( x_schedule_start, FND_API.G_MISS_DATE, schedule_start, x_schedule_start)
196: ,schedule_end =decode( x_schedule_end, FND_API.G_MISS_DATE, schedule_end, x_schedule_end)
197: ,strategy_temp_id = decode( x_strategy_temp_id , FND_API.G_MISS_NUM, strategy_temp_id , x_strategy_temp_id )
198: ,WORK_ITEM_ORDER = decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, x_WORK_ITEM_ORDER)
199: ,escalated_yn = decode( x_escalated_yn, FND_API.G_MISS_CHAR, escalated_yn, x_escalated_yn)
200: where WORK_ITEM_ID = x_WORK_ITEM_ID;

Line 197: ,strategy_temp_id = decode( x_strategy_temp_id , FND_API.G_MISS_NUM, strategy_temp_id , x_strategy_temp_id )

193: ,execute_start = decode( x_execute_start, FND_API.G_MISS_DATE, execute_start, x_execute_start)
194: ,execute_end = decode( x_execute_end, FND_API.G_MISS_DATE, execute_end, x_execute_end)
195: ,schedule_start =decode( x_schedule_start, FND_API.G_MISS_DATE, schedule_start, x_schedule_start)
196: ,schedule_end =decode( x_schedule_end, FND_API.G_MISS_DATE, schedule_end, x_schedule_end)
197: ,strategy_temp_id = decode( x_strategy_temp_id , FND_API.G_MISS_NUM, strategy_temp_id , x_strategy_temp_id )
198: ,WORK_ITEM_ORDER = decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, x_WORK_ITEM_ORDER)
199: ,escalated_yn = decode( x_escalated_yn, FND_API.G_MISS_CHAR, escalated_yn, x_escalated_yn)
200: where WORK_ITEM_ID = x_WORK_ITEM_ID;
201:

Line 198: ,WORK_ITEM_ORDER = decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, x_WORK_ITEM_ORDER)

194: ,execute_end = decode( x_execute_end, FND_API.G_MISS_DATE, execute_end, x_execute_end)
195: ,schedule_start =decode( x_schedule_start, FND_API.G_MISS_DATE, schedule_start, x_schedule_start)
196: ,schedule_end =decode( x_schedule_end, FND_API.G_MISS_DATE, schedule_end, x_schedule_end)
197: ,strategy_temp_id = decode( x_strategy_temp_id , FND_API.G_MISS_NUM, strategy_temp_id , x_strategy_temp_id )
198: ,WORK_ITEM_ORDER = decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, x_WORK_ITEM_ORDER)
199: ,escalated_yn = decode( x_escalated_yn, FND_API.G_MISS_CHAR, escalated_yn, x_escalated_yn)
200: where WORK_ITEM_ID = x_WORK_ITEM_ID;
201:
202: If (SQL%NOTFOUND) then

Line 199: ,escalated_yn = decode( x_escalated_yn, FND_API.G_MISS_CHAR, escalated_yn, x_escalated_yn)

195: ,schedule_start =decode( x_schedule_start, FND_API.G_MISS_DATE, schedule_start, x_schedule_start)
196: ,schedule_end =decode( x_schedule_end, FND_API.G_MISS_DATE, schedule_end, x_schedule_end)
197: ,strategy_temp_id = decode( x_strategy_temp_id , FND_API.G_MISS_NUM, strategy_temp_id , x_strategy_temp_id )
198: ,WORK_ITEM_ORDER = decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, x_WORK_ITEM_ORDER)
199: ,escalated_yn = decode( x_escalated_yn, FND_API.G_MISS_CHAR, escalated_yn, x_escalated_yn)
200: where WORK_ITEM_ID = x_WORK_ITEM_ID;
201:
202: If (SQL%NOTFOUND) then
203: RAISE NO_DATA_FOUND;