APPS.IEX_STRATEGY_USER_ITEMS_PKG dependencies on FND_API

Line 51: If (px_STRATEGY_USER_ITEM_ID IS NULL) OR (px_STRATEGY_USER_ITEM_ID = FND_API.G_MISS_NUM) then

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

Line 89: ,decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_ID)

85: , resource_id
86: , custom_workflow_type
87: ) VALUES (
88: px_STRATEGY_USER_ITEM_ID
89: ,decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_ID)
90: ,decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_TEMP_ID)
91: ,decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_ORDER)
92: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
93: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

Line 90: ,decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_TEMP_ID)

86: , custom_workflow_type
87: ) VALUES (
88: px_STRATEGY_USER_ITEM_ID
89: ,decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_ID)
90: ,decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_TEMP_ID)
91: ,decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_ORDER)
92: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
93: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
94: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)

Line 91: ,decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_ORDER)

87: ) VALUES (
88: px_STRATEGY_USER_ITEM_ID
89: ,decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_ID)
90: ,decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_TEMP_ID)
91: ,decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_ORDER)
92: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
93: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
94: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
95: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

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

88: px_STRATEGY_USER_ITEM_ID
89: ,decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_ID)
90: ,decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_TEMP_ID)
91: ,decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_ORDER)
92: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
93: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
94: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
95: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
96: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)

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

89: ,decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_ID)
90: ,decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_TEMP_ID)
91: ,decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_ORDER)
92: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
93: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
94: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
95: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
96: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
97: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)

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

90: ,decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_TEMP_ID)
91: ,decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_ORDER)
92: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
93: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
94: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
95: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
96: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
97: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
98: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)

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

91: ,decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, p_WORK_ITEM_ORDER)
92: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
93: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
94: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
95: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
96: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
97: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
98: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
99: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)

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

92: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
93: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
94: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
95: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
96: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
97: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
98: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
99: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
100: ,decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_TEMPLATE_ID)

Line 97: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)

93: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
94: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
95: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
96: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
97: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
98: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
99: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
100: ,decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_TEMPLATE_ID)
101: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)

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

94: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
95: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
96: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
97: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
98: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
99: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
100: ,decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_TEMPLATE_ID)
101: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
102: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)

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

95: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
96: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
97: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
98: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
99: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
100: ,decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_TEMPLATE_ID)
101: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
102: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
103: ,decode( p_OPERATION, FND_API.G_MISS_CHAR, NULL, p_OPERATION)

Line 100: ,decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_TEMPLATE_ID)

96: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
97: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
98: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
99: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
100: ,decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_TEMPLATE_ID)
101: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
102: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
103: ,decode( p_OPERATION, FND_API.G_MISS_CHAR, NULL, p_OPERATION)
104: ,DECODE( p_pre_execution_wait, FND_API.G_MISS_CHAR, NULL, p_pre_execution_wait)

Line 101: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)

97: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
98: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
99: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
100: ,decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_TEMPLATE_ID)
101: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
102: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
103: ,decode( p_OPERATION, FND_API.G_MISS_CHAR, NULL, p_OPERATION)
104: ,DECODE( p_pre_execution_wait, FND_API.G_MISS_CHAR, NULL, p_pre_execution_wait)
105: ,DECODE( p_post_execution_wait, FND_API.G_MISS_CHAR, NULL, p_post_execution_wait)

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

98: ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
99: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
100: ,decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_TEMPLATE_ID)
101: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
102: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
103: ,decode( p_OPERATION, FND_API.G_MISS_CHAR, NULL, p_OPERATION)
104: ,DECODE( p_pre_execution_wait, FND_API.G_MISS_CHAR, NULL, p_pre_execution_wait)
105: ,DECODE( p_post_execution_wait, FND_API.G_MISS_CHAR, NULL, p_post_execution_wait)
106: ,DECODE( p_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_pre_execution_time_uom)

Line 103: ,decode( p_OPERATION, FND_API.G_MISS_CHAR, NULL, p_OPERATION)

99: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
100: ,decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_TEMPLATE_ID)
101: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
102: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
103: ,decode( p_OPERATION, FND_API.G_MISS_CHAR, NULL, p_OPERATION)
104: ,DECODE( p_pre_execution_wait, FND_API.G_MISS_CHAR, NULL, p_pre_execution_wait)
105: ,DECODE( p_post_execution_wait, FND_API.G_MISS_CHAR, NULL, p_post_execution_wait)
106: ,DECODE( p_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_pre_execution_time_uom)
107: ,DECODE( p_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_execution_time_uom)

Line 104: ,DECODE( p_pre_execution_wait, FND_API.G_MISS_CHAR, NULL, p_pre_execution_wait)

100: ,decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, p_STRATEGY_TEMPLATE_ID)
101: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
102: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
103: ,decode( p_OPERATION, FND_API.G_MISS_CHAR, NULL, p_OPERATION)
104: ,DECODE( p_pre_execution_wait, FND_API.G_MISS_CHAR, NULL, p_pre_execution_wait)
105: ,DECODE( p_post_execution_wait, FND_API.G_MISS_CHAR, NULL, p_post_execution_wait)
106: ,DECODE( p_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_pre_execution_time_uom)
107: ,DECODE( p_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_execution_time_uom)
108: ,DECODE( p_xdo_template_id, FND_API.G_MISS_NUM, NULL, p_xdo_template_id)

Line 105: ,DECODE( p_post_execution_wait, FND_API.G_MISS_CHAR, NULL, p_post_execution_wait)

101: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
102: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
103: ,decode( p_OPERATION, FND_API.G_MISS_CHAR, NULL, p_OPERATION)
104: ,DECODE( p_pre_execution_wait, FND_API.G_MISS_CHAR, NULL, p_pre_execution_wait)
105: ,DECODE( p_post_execution_wait, FND_API.G_MISS_CHAR, NULL, p_post_execution_wait)
106: ,DECODE( p_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_pre_execution_time_uom)
107: ,DECODE( p_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_execution_time_uom)
108: ,DECODE( p_xdo_template_id, FND_API.G_MISS_NUM, NULL, p_xdo_template_id)
109: ,DECODE( p_optional_yn, FND_API.G_MISS_CHAR, NULL, p_optional_yn)

Line 106: ,DECODE( p_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_pre_execution_time_uom)

102: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
103: ,decode( p_OPERATION, FND_API.G_MISS_CHAR, NULL, p_OPERATION)
104: ,DECODE( p_pre_execution_wait, FND_API.G_MISS_CHAR, NULL, p_pre_execution_wait)
105: ,DECODE( p_post_execution_wait, FND_API.G_MISS_CHAR, NULL, p_post_execution_wait)
106: ,DECODE( p_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_pre_execution_time_uom)
107: ,DECODE( p_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_execution_time_uom)
108: ,DECODE( p_xdo_template_id, FND_API.G_MISS_NUM, NULL, p_xdo_template_id)
109: ,DECODE( p_optional_yn, FND_API.G_MISS_CHAR, NULL, p_optional_yn)
110: ,DECODE( p_optional_wait_time, FND_API.G_MISS_NUM, NULL, p_optional_wait_time)

Line 107: ,DECODE( p_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_execution_time_uom)

103: ,decode( p_OPERATION, FND_API.G_MISS_CHAR, NULL, p_OPERATION)
104: ,DECODE( p_pre_execution_wait, FND_API.G_MISS_CHAR, NULL, p_pre_execution_wait)
105: ,DECODE( p_post_execution_wait, FND_API.G_MISS_CHAR, NULL, p_post_execution_wait)
106: ,DECODE( p_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_pre_execution_time_uom)
107: ,DECODE( p_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_execution_time_uom)
108: ,DECODE( p_xdo_template_id, FND_API.G_MISS_NUM, NULL, p_xdo_template_id)
109: ,DECODE( p_optional_yn, FND_API.G_MISS_CHAR, NULL, p_optional_yn)
110: ,DECODE( p_optional_wait_time, FND_API.G_MISS_NUM, NULL, p_optional_wait_time)
111: ,DECODE( p_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_optional_wait_time_uom)

Line 108: ,DECODE( p_xdo_template_id, FND_API.G_MISS_NUM, NULL, p_xdo_template_id)

104: ,DECODE( p_pre_execution_wait, FND_API.G_MISS_CHAR, NULL, p_pre_execution_wait)
105: ,DECODE( p_post_execution_wait, FND_API.G_MISS_CHAR, NULL, p_post_execution_wait)
106: ,DECODE( p_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_pre_execution_time_uom)
107: ,DECODE( p_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_execution_time_uom)
108: ,DECODE( p_xdo_template_id, FND_API.G_MISS_NUM, NULL, p_xdo_template_id)
109: ,DECODE( p_optional_yn, FND_API.G_MISS_CHAR, NULL, p_optional_yn)
110: ,DECODE( p_optional_wait_time, FND_API.G_MISS_NUM, NULL, p_optional_wait_time)
111: ,DECODE( p_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_optional_wait_time_uom)
112: ,DECODE( p_notify_yn, FND_API.G_MISS_CHAR, NULL, p_notify_yn)

Line 109: ,DECODE( p_optional_yn, FND_API.G_MISS_CHAR, NULL, p_optional_yn)

105: ,DECODE( p_post_execution_wait, FND_API.G_MISS_CHAR, NULL, p_post_execution_wait)
106: ,DECODE( p_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_pre_execution_time_uom)
107: ,DECODE( p_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_execution_time_uom)
108: ,DECODE( p_xdo_template_id, FND_API.G_MISS_NUM, NULL, p_xdo_template_id)
109: ,DECODE( p_optional_yn, FND_API.G_MISS_CHAR, NULL, p_optional_yn)
110: ,DECODE( p_optional_wait_time, FND_API.G_MISS_NUM, NULL, p_optional_wait_time)
111: ,DECODE( p_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_optional_wait_time_uom)
112: ,DECODE( p_notify_yn, FND_API.G_MISS_CHAR, NULL, p_notify_yn)
113: ,DECODE( p_escalate_yn, FND_API.G_MISS_CHAR, NULL, p_escalate_yn)

Line 110: ,DECODE( p_optional_wait_time, FND_API.G_MISS_NUM, NULL, p_optional_wait_time)

106: ,DECODE( p_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_pre_execution_time_uom)
107: ,DECODE( p_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_execution_time_uom)
108: ,DECODE( p_xdo_template_id, FND_API.G_MISS_NUM, NULL, p_xdo_template_id)
109: ,DECODE( p_optional_yn, FND_API.G_MISS_CHAR, NULL, p_optional_yn)
110: ,DECODE( p_optional_wait_time, FND_API.G_MISS_NUM, NULL, p_optional_wait_time)
111: ,DECODE( p_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_optional_wait_time_uom)
112: ,DECODE( p_notify_yn, FND_API.G_MISS_CHAR, NULL, p_notify_yn)
113: ,DECODE( p_escalate_yn, FND_API.G_MISS_CHAR, NULL, p_escalate_yn)
114: ,DECODE( p_escalate_wait_time, FND_API.G_MISS_NUM, NULL, p_escalate_wait_time)

Line 111: ,DECODE( p_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_optional_wait_time_uom)

107: ,DECODE( p_execution_time_uom, FND_API.G_MISS_CHAR, NULL, p_execution_time_uom)
108: ,DECODE( p_xdo_template_id, FND_API.G_MISS_NUM, NULL, p_xdo_template_id)
109: ,DECODE( p_optional_yn, FND_API.G_MISS_CHAR, NULL, p_optional_yn)
110: ,DECODE( p_optional_wait_time, FND_API.G_MISS_NUM, NULL, p_optional_wait_time)
111: ,DECODE( p_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_optional_wait_time_uom)
112: ,DECODE( p_notify_yn, FND_API.G_MISS_CHAR, NULL, p_notify_yn)
113: ,DECODE( p_escalate_yn, FND_API.G_MISS_CHAR, NULL, p_escalate_yn)
114: ,DECODE( p_escalate_wait_time, FND_API.G_MISS_NUM, NULL, p_escalate_wait_time)
115: ,DECODE( p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_escalate_wait_time_uom)

Line 112: ,DECODE( p_notify_yn, FND_API.G_MISS_CHAR, NULL, p_notify_yn)

108: ,DECODE( p_xdo_template_id, FND_API.G_MISS_NUM, NULL, p_xdo_template_id)
109: ,DECODE( p_optional_yn, FND_API.G_MISS_CHAR, NULL, p_optional_yn)
110: ,DECODE( p_optional_wait_time, FND_API.G_MISS_NUM, NULL, p_optional_wait_time)
111: ,DECODE( p_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_optional_wait_time_uom)
112: ,DECODE( p_notify_yn, FND_API.G_MISS_CHAR, NULL, p_notify_yn)
113: ,DECODE( p_escalate_yn, FND_API.G_MISS_CHAR, NULL, p_escalate_yn)
114: ,DECODE( p_escalate_wait_time, FND_API.G_MISS_NUM, NULL, p_escalate_wait_time)
115: ,DECODE( p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_escalate_wait_time_uom)
116: ,DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id)

Line 113: ,DECODE( p_escalate_yn, FND_API.G_MISS_CHAR, NULL, p_escalate_yn)

109: ,DECODE( p_optional_yn, FND_API.G_MISS_CHAR, NULL, p_optional_yn)
110: ,DECODE( p_optional_wait_time, FND_API.G_MISS_NUM, NULL, p_optional_wait_time)
111: ,DECODE( p_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_optional_wait_time_uom)
112: ,DECODE( p_notify_yn, FND_API.G_MISS_CHAR, NULL, p_notify_yn)
113: ,DECODE( p_escalate_yn, FND_API.G_MISS_CHAR, NULL, p_escalate_yn)
114: ,DECODE( p_escalate_wait_time, FND_API.G_MISS_NUM, NULL, p_escalate_wait_time)
115: ,DECODE( p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_escalate_wait_time_uom)
116: ,DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id)
117: ,DECODE( p_custom_workflow_type, FND_API.G_MISS_CHAR, NULL, p_custom_workflow_type));

Line 114: ,DECODE( p_escalate_wait_time, FND_API.G_MISS_NUM, NULL, p_escalate_wait_time)

110: ,DECODE( p_optional_wait_time, FND_API.G_MISS_NUM, NULL, p_optional_wait_time)
111: ,DECODE( p_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_optional_wait_time_uom)
112: ,DECODE( p_notify_yn, FND_API.G_MISS_CHAR, NULL, p_notify_yn)
113: ,DECODE( p_escalate_yn, FND_API.G_MISS_CHAR, NULL, p_escalate_yn)
114: ,DECODE( p_escalate_wait_time, FND_API.G_MISS_NUM, NULL, p_escalate_wait_time)
115: ,DECODE( p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_escalate_wait_time_uom)
116: ,DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id)
117: ,DECODE( p_custom_workflow_type, FND_API.G_MISS_CHAR, NULL, p_custom_workflow_type));
118: End Insert_Row;

Line 115: ,DECODE( p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_escalate_wait_time_uom)

111: ,DECODE( p_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_optional_wait_time_uom)
112: ,DECODE( p_notify_yn, FND_API.G_MISS_CHAR, NULL, p_notify_yn)
113: ,DECODE( p_escalate_yn, FND_API.G_MISS_CHAR, NULL, p_escalate_yn)
114: ,DECODE( p_escalate_wait_time, FND_API.G_MISS_NUM, NULL, p_escalate_wait_time)
115: ,DECODE( p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_escalate_wait_time_uom)
116: ,DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id)
117: ,DECODE( p_custom_workflow_type, FND_API.G_MISS_CHAR, NULL, p_custom_workflow_type));
118: End Insert_Row;
119:

Line 116: ,DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id)

112: ,DECODE( p_notify_yn, FND_API.G_MISS_CHAR, NULL, p_notify_yn)
113: ,DECODE( p_escalate_yn, FND_API.G_MISS_CHAR, NULL, p_escalate_yn)
114: ,DECODE( p_escalate_wait_time, FND_API.G_MISS_NUM, NULL, p_escalate_wait_time)
115: ,DECODE( p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_escalate_wait_time_uom)
116: ,DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id)
117: ,DECODE( p_custom_workflow_type, FND_API.G_MISS_CHAR, NULL, p_custom_workflow_type));
118: End Insert_Row;
119:
120: PROCEDURE Update_Row(

Line 117: ,DECODE( p_custom_workflow_type, FND_API.G_MISS_CHAR, NULL, p_custom_workflow_type));

113: ,DECODE( p_escalate_yn, FND_API.G_MISS_CHAR, NULL, p_escalate_yn)
114: ,DECODE( p_escalate_wait_time, FND_API.G_MISS_NUM, NULL, p_escalate_wait_time)
115: ,DECODE( p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, p_escalate_wait_time_uom)
116: ,DECODE( p_resource_id, FND_API.G_MISS_NUM, NULL, p_resource_id)
117: ,DECODE( p_custom_workflow_type, FND_API.G_MISS_CHAR, NULL, p_custom_workflow_type));
118: End Insert_Row;
119:
120: PROCEDURE Update_Row(
121: p_STRATEGY_USER_ITEM_ID NUMBER

Line 156: STRATEGY_ID = decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, p_STRATEGY_ID)

152: IS
153: BEGIN
154: Update IEX_STRATEGY_USER_ITEMS
155: SET
156: STRATEGY_ID = decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, p_STRATEGY_ID)
157: ,WORK_ITEM_TEMP_ID = decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMP_ID, p_WORK_ITEM_TEMP_ID)
158: ,WORK_ITEM_ORDER = decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, p_WORK_ITEM_ORDER)
159: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
160: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

Line 157: ,WORK_ITEM_TEMP_ID = decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMP_ID, p_WORK_ITEM_TEMP_ID)

153: BEGIN
154: Update IEX_STRATEGY_USER_ITEMS
155: SET
156: STRATEGY_ID = decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, p_STRATEGY_ID)
157: ,WORK_ITEM_TEMP_ID = decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMP_ID, p_WORK_ITEM_TEMP_ID)
158: ,WORK_ITEM_ORDER = decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, p_WORK_ITEM_ORDER)
159: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
160: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
161: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

Line 158: ,WORK_ITEM_ORDER = decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, p_WORK_ITEM_ORDER)

154: Update IEX_STRATEGY_USER_ITEMS
155: SET
156: STRATEGY_ID = decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, p_STRATEGY_ID)
157: ,WORK_ITEM_TEMP_ID = decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMP_ID, p_WORK_ITEM_TEMP_ID)
158: ,WORK_ITEM_ORDER = decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, p_WORK_ITEM_ORDER)
159: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
160: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
161: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
162: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)

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

155: SET
156: STRATEGY_ID = decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, p_STRATEGY_ID)
157: ,WORK_ITEM_TEMP_ID = decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMP_ID, p_WORK_ITEM_TEMP_ID)
158: ,WORK_ITEM_ORDER = decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, p_WORK_ITEM_ORDER)
159: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
160: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
161: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
162: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
163: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)

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

156: STRATEGY_ID = decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, p_STRATEGY_ID)
157: ,WORK_ITEM_TEMP_ID = decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMP_ID, p_WORK_ITEM_TEMP_ID)
158: ,WORK_ITEM_ORDER = decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, p_WORK_ITEM_ORDER)
159: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
160: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
161: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
162: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
163: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
164: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)

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

157: ,WORK_ITEM_TEMP_ID = decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMP_ID, p_WORK_ITEM_TEMP_ID)
158: ,WORK_ITEM_ORDER = decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, p_WORK_ITEM_ORDER)
159: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
160: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
161: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
162: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
163: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
164: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
165: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

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

158: ,WORK_ITEM_ORDER = decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, p_WORK_ITEM_ORDER)
159: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
160: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
161: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
162: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
163: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
164: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
165: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
166: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)

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

159: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
160: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
161: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
162: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
163: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
164: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
165: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
166: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
167: ,STRATEGY_TEMPLATE_ID = decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, STRATEGY_TEMPLATE_ID, p_STRATEGY_TEMPLATE_ID)

Line 164: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)

160: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
161: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
162: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
163: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
164: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
165: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
166: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
167: ,STRATEGY_TEMPLATE_ID = decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, STRATEGY_TEMPLATE_ID, p_STRATEGY_TEMPLATE_ID)
168: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)

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

161: -- ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
162: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
163: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
164: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
165: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
166: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
167: ,STRATEGY_TEMPLATE_ID = decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, STRATEGY_TEMPLATE_ID, p_STRATEGY_TEMPLATE_ID)
168: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
169: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)

Line 166: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)

162: -- ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
163: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
164: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
165: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
166: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
167: ,STRATEGY_TEMPLATE_ID = decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, STRATEGY_TEMPLATE_ID, p_STRATEGY_TEMPLATE_ID)
168: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
169: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
170: ,OPERATION = decode( p_OPERATION, FND_API.G_MISS_CHAR, OPERATION, p_OPERATION)

Line 167: ,STRATEGY_TEMPLATE_ID = decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, STRATEGY_TEMPLATE_ID, p_STRATEGY_TEMPLATE_ID)

163: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
164: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
165: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
166: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
167: ,STRATEGY_TEMPLATE_ID = decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, STRATEGY_TEMPLATE_ID, p_STRATEGY_TEMPLATE_ID)
168: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
169: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
170: ,OPERATION = decode( p_OPERATION, FND_API.G_MISS_CHAR, OPERATION, p_OPERATION)
171: ,pre_execution_wait = DECODE(p_pre_execution_wait, FND_API.G_MISS_CHAR, pre_execution_wait, p_pre_execution_wait)

Line 168: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)

164: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
165: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
166: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
167: ,STRATEGY_TEMPLATE_ID = decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, STRATEGY_TEMPLATE_ID, p_STRATEGY_TEMPLATE_ID)
168: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
169: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
170: ,OPERATION = decode( p_OPERATION, FND_API.G_MISS_CHAR, OPERATION, p_OPERATION)
171: ,pre_execution_wait = DECODE(p_pre_execution_wait, FND_API.G_MISS_CHAR, pre_execution_wait, p_pre_execution_wait)
172: ,post_execution_wait = DECODE(p_post_execution_wait, FND_API.G_MISS_CHAR, post_execution_wait, p_post_execution_wait)

Line 169: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)

165: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
166: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
167: ,STRATEGY_TEMPLATE_ID = decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, STRATEGY_TEMPLATE_ID, p_STRATEGY_TEMPLATE_ID)
168: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
169: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
170: ,OPERATION = decode( p_OPERATION, FND_API.G_MISS_CHAR, OPERATION, p_OPERATION)
171: ,pre_execution_wait = DECODE(p_pre_execution_wait, FND_API.G_MISS_CHAR, pre_execution_wait, p_pre_execution_wait)
172: ,post_execution_wait = DECODE(p_post_execution_wait, FND_API.G_MISS_CHAR, post_execution_wait, p_post_execution_wait)
173: ,pre_execution_time_uom = DECODE(p_pre_execution_time_uom, FND_API.G_MISS_CHAR, pre_execution_time_uom, p_pre_execution_time_uom)

Line 170: ,OPERATION = decode( p_OPERATION, FND_API.G_MISS_CHAR, OPERATION, p_OPERATION)

166: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
167: ,STRATEGY_TEMPLATE_ID = decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, STRATEGY_TEMPLATE_ID, p_STRATEGY_TEMPLATE_ID)
168: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
169: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
170: ,OPERATION = decode( p_OPERATION, FND_API.G_MISS_CHAR, OPERATION, p_OPERATION)
171: ,pre_execution_wait = DECODE(p_pre_execution_wait, FND_API.G_MISS_CHAR, pre_execution_wait, p_pre_execution_wait)
172: ,post_execution_wait = DECODE(p_post_execution_wait, FND_API.G_MISS_CHAR, post_execution_wait, p_post_execution_wait)
173: ,pre_execution_time_uom = DECODE(p_pre_execution_time_uom, FND_API.G_MISS_CHAR, pre_execution_time_uom, p_pre_execution_time_uom)
174: ,execution_time_uom = DECODE(p_execution_time_uom, FND_API.G_MISS_CHAR, execution_time_uom, p_execution_time_uom)

Line 171: ,pre_execution_wait = DECODE(p_pre_execution_wait, FND_API.G_MISS_CHAR, pre_execution_wait, p_pre_execution_wait)

167: ,STRATEGY_TEMPLATE_ID = decode( p_STRATEGY_TEMPLATE_ID, FND_API.G_MISS_NUM, STRATEGY_TEMPLATE_ID, p_STRATEGY_TEMPLATE_ID)
168: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
169: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
170: ,OPERATION = decode( p_OPERATION, FND_API.G_MISS_CHAR, OPERATION, p_OPERATION)
171: ,pre_execution_wait = DECODE(p_pre_execution_wait, FND_API.G_MISS_CHAR, pre_execution_wait, p_pre_execution_wait)
172: ,post_execution_wait = DECODE(p_post_execution_wait, FND_API.G_MISS_CHAR, post_execution_wait, p_post_execution_wait)
173: ,pre_execution_time_uom = DECODE(p_pre_execution_time_uom, FND_API.G_MISS_CHAR, pre_execution_time_uom, p_pre_execution_time_uom)
174: ,execution_time_uom = DECODE(p_execution_time_uom, FND_API.G_MISS_CHAR, execution_time_uom, p_execution_time_uom)
175: ,xdo_temp_id = DECODE(p_xdo_template_id, FND_API.G_MISS_CHAR, xdo_temp_id, p_xdo_template_id)

Line 172: ,post_execution_wait = DECODE(p_post_execution_wait, FND_API.G_MISS_CHAR, post_execution_wait, p_post_execution_wait)

168: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
169: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
170: ,OPERATION = decode( p_OPERATION, FND_API.G_MISS_CHAR, OPERATION, p_OPERATION)
171: ,pre_execution_wait = DECODE(p_pre_execution_wait, FND_API.G_MISS_CHAR, pre_execution_wait, p_pre_execution_wait)
172: ,post_execution_wait = DECODE(p_post_execution_wait, FND_API.G_MISS_CHAR, post_execution_wait, p_post_execution_wait)
173: ,pre_execution_time_uom = DECODE(p_pre_execution_time_uom, FND_API.G_MISS_CHAR, pre_execution_time_uom, p_pre_execution_time_uom)
174: ,execution_time_uom = DECODE(p_execution_time_uom, FND_API.G_MISS_CHAR, execution_time_uom, p_execution_time_uom)
175: ,xdo_temp_id = DECODE(p_xdo_template_id, FND_API.G_MISS_CHAR, xdo_temp_id, p_xdo_template_id)
176: ,optional_yn = DECODE(p_optional_yn, FND_API.G_MISS_CHAR, optional_yn, p_optional_yn)

Line 173: ,pre_execution_time_uom = DECODE(p_pre_execution_time_uom, FND_API.G_MISS_CHAR, pre_execution_time_uom, p_pre_execution_time_uom)

169: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
170: ,OPERATION = decode( p_OPERATION, FND_API.G_MISS_CHAR, OPERATION, p_OPERATION)
171: ,pre_execution_wait = DECODE(p_pre_execution_wait, FND_API.G_MISS_CHAR, pre_execution_wait, p_pre_execution_wait)
172: ,post_execution_wait = DECODE(p_post_execution_wait, FND_API.G_MISS_CHAR, post_execution_wait, p_post_execution_wait)
173: ,pre_execution_time_uom = DECODE(p_pre_execution_time_uom, FND_API.G_MISS_CHAR, pre_execution_time_uom, p_pre_execution_time_uom)
174: ,execution_time_uom = DECODE(p_execution_time_uom, FND_API.G_MISS_CHAR, execution_time_uom, p_execution_time_uom)
175: ,xdo_temp_id = DECODE(p_xdo_template_id, FND_API.G_MISS_CHAR, xdo_temp_id, p_xdo_template_id)
176: ,optional_yn = DECODE(p_optional_yn, FND_API.G_MISS_CHAR, optional_yn, p_optional_yn)
177: ,optional_wait_time = DECODE(p_optional_wait_time, FND_API.G_MISS_CHAR, optional_wait_time, p_optional_wait_time)

Line 174: ,execution_time_uom = DECODE(p_execution_time_uom, FND_API.G_MISS_CHAR, execution_time_uom, p_execution_time_uom)

170: ,OPERATION = decode( p_OPERATION, FND_API.G_MISS_CHAR, OPERATION, p_OPERATION)
171: ,pre_execution_wait = DECODE(p_pre_execution_wait, FND_API.G_MISS_CHAR, pre_execution_wait, p_pre_execution_wait)
172: ,post_execution_wait = DECODE(p_post_execution_wait, FND_API.G_MISS_CHAR, post_execution_wait, p_post_execution_wait)
173: ,pre_execution_time_uom = DECODE(p_pre_execution_time_uom, FND_API.G_MISS_CHAR, pre_execution_time_uom, p_pre_execution_time_uom)
174: ,execution_time_uom = DECODE(p_execution_time_uom, FND_API.G_MISS_CHAR, execution_time_uom, p_execution_time_uom)
175: ,xdo_temp_id = DECODE(p_xdo_template_id, FND_API.G_MISS_CHAR, xdo_temp_id, p_xdo_template_id)
176: ,optional_yn = DECODE(p_optional_yn, FND_API.G_MISS_CHAR, optional_yn, p_optional_yn)
177: ,optional_wait_time = DECODE(p_optional_wait_time, FND_API.G_MISS_CHAR, optional_wait_time, p_optional_wait_time)
178: ,optional_wait_time_uom = DECODE(p_optional_wait_time_uom, FND_API.G_MISS_CHAR, optional_wait_time_uom, p_optional_wait_time_uom)

Line 175: ,xdo_temp_id = DECODE(p_xdo_template_id, FND_API.G_MISS_CHAR, xdo_temp_id, p_xdo_template_id)

171: ,pre_execution_wait = DECODE(p_pre_execution_wait, FND_API.G_MISS_CHAR, pre_execution_wait, p_pre_execution_wait)
172: ,post_execution_wait = DECODE(p_post_execution_wait, FND_API.G_MISS_CHAR, post_execution_wait, p_post_execution_wait)
173: ,pre_execution_time_uom = DECODE(p_pre_execution_time_uom, FND_API.G_MISS_CHAR, pre_execution_time_uom, p_pre_execution_time_uom)
174: ,execution_time_uom = DECODE(p_execution_time_uom, FND_API.G_MISS_CHAR, execution_time_uom, p_execution_time_uom)
175: ,xdo_temp_id = DECODE(p_xdo_template_id, FND_API.G_MISS_CHAR, xdo_temp_id, p_xdo_template_id)
176: ,optional_yn = DECODE(p_optional_yn, FND_API.G_MISS_CHAR, optional_yn, p_optional_yn)
177: ,optional_wait_time = DECODE(p_optional_wait_time, FND_API.G_MISS_CHAR, optional_wait_time, p_optional_wait_time)
178: ,optional_wait_time_uom = DECODE(p_optional_wait_time_uom, FND_API.G_MISS_CHAR, optional_wait_time_uom, p_optional_wait_time_uom)
179: ,notify_yn = DECODE(p_notify_yn, FND_API.G_MISS_CHAR, notify_yn, p_notify_yn)

Line 176: ,optional_yn = DECODE(p_optional_yn, FND_API.G_MISS_CHAR, optional_yn, p_optional_yn)

172: ,post_execution_wait = DECODE(p_post_execution_wait, FND_API.G_MISS_CHAR, post_execution_wait, p_post_execution_wait)
173: ,pre_execution_time_uom = DECODE(p_pre_execution_time_uom, FND_API.G_MISS_CHAR, pre_execution_time_uom, p_pre_execution_time_uom)
174: ,execution_time_uom = DECODE(p_execution_time_uom, FND_API.G_MISS_CHAR, execution_time_uom, p_execution_time_uom)
175: ,xdo_temp_id = DECODE(p_xdo_template_id, FND_API.G_MISS_CHAR, xdo_temp_id, p_xdo_template_id)
176: ,optional_yn = DECODE(p_optional_yn, FND_API.G_MISS_CHAR, optional_yn, p_optional_yn)
177: ,optional_wait_time = DECODE(p_optional_wait_time, FND_API.G_MISS_CHAR, optional_wait_time, p_optional_wait_time)
178: ,optional_wait_time_uom = DECODE(p_optional_wait_time_uom, FND_API.G_MISS_CHAR, optional_wait_time_uom, p_optional_wait_time_uom)
179: ,notify_yn = DECODE(p_notify_yn, FND_API.G_MISS_CHAR, notify_yn, p_notify_yn)
180: ,escalate_yn = DECODE(p_escalate_yn, FND_API.G_MISS_CHAR, escalate_yn, p_escalate_yn)

Line 177: ,optional_wait_time = DECODE(p_optional_wait_time, FND_API.G_MISS_CHAR, optional_wait_time, p_optional_wait_time)

173: ,pre_execution_time_uom = DECODE(p_pre_execution_time_uom, FND_API.G_MISS_CHAR, pre_execution_time_uom, p_pre_execution_time_uom)
174: ,execution_time_uom = DECODE(p_execution_time_uom, FND_API.G_MISS_CHAR, execution_time_uom, p_execution_time_uom)
175: ,xdo_temp_id = DECODE(p_xdo_template_id, FND_API.G_MISS_CHAR, xdo_temp_id, p_xdo_template_id)
176: ,optional_yn = DECODE(p_optional_yn, FND_API.G_MISS_CHAR, optional_yn, p_optional_yn)
177: ,optional_wait_time = DECODE(p_optional_wait_time, FND_API.G_MISS_CHAR, optional_wait_time, p_optional_wait_time)
178: ,optional_wait_time_uom = DECODE(p_optional_wait_time_uom, FND_API.G_MISS_CHAR, optional_wait_time_uom, p_optional_wait_time_uom)
179: ,notify_yn = DECODE(p_notify_yn, FND_API.G_MISS_CHAR, notify_yn, p_notify_yn)
180: ,escalate_yn = DECODE(p_escalate_yn, FND_API.G_MISS_CHAR, escalate_yn, p_escalate_yn)
181: ,escalate_wait_time = DECODE(p_escalate_wait_time, FND_API.G_MISS_NUM, escalate_wait_time, p_escalate_wait_time)

Line 178: ,optional_wait_time_uom = DECODE(p_optional_wait_time_uom, FND_API.G_MISS_CHAR, optional_wait_time_uom, p_optional_wait_time_uom)

174: ,execution_time_uom = DECODE(p_execution_time_uom, FND_API.G_MISS_CHAR, execution_time_uom, p_execution_time_uom)
175: ,xdo_temp_id = DECODE(p_xdo_template_id, FND_API.G_MISS_CHAR, xdo_temp_id, p_xdo_template_id)
176: ,optional_yn = DECODE(p_optional_yn, FND_API.G_MISS_CHAR, optional_yn, p_optional_yn)
177: ,optional_wait_time = DECODE(p_optional_wait_time, FND_API.G_MISS_CHAR, optional_wait_time, p_optional_wait_time)
178: ,optional_wait_time_uom = DECODE(p_optional_wait_time_uom, FND_API.G_MISS_CHAR, optional_wait_time_uom, p_optional_wait_time_uom)
179: ,notify_yn = DECODE(p_notify_yn, FND_API.G_MISS_CHAR, notify_yn, p_notify_yn)
180: ,escalate_yn = DECODE(p_escalate_yn, FND_API.G_MISS_CHAR, escalate_yn, p_escalate_yn)
181: ,escalate_wait_time = DECODE(p_escalate_wait_time, FND_API.G_MISS_NUM, escalate_wait_time, p_escalate_wait_time)
182: ,escalate_wait_time_uom = DECODE(p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, escalate_wait_time_uom, p_escalate_wait_time_uom)

Line 179: ,notify_yn = DECODE(p_notify_yn, FND_API.G_MISS_CHAR, notify_yn, p_notify_yn)

175: ,xdo_temp_id = DECODE(p_xdo_template_id, FND_API.G_MISS_CHAR, xdo_temp_id, p_xdo_template_id)
176: ,optional_yn = DECODE(p_optional_yn, FND_API.G_MISS_CHAR, optional_yn, p_optional_yn)
177: ,optional_wait_time = DECODE(p_optional_wait_time, FND_API.G_MISS_CHAR, optional_wait_time, p_optional_wait_time)
178: ,optional_wait_time_uom = DECODE(p_optional_wait_time_uom, FND_API.G_MISS_CHAR, optional_wait_time_uom, p_optional_wait_time_uom)
179: ,notify_yn = DECODE(p_notify_yn, FND_API.G_MISS_CHAR, notify_yn, p_notify_yn)
180: ,escalate_yn = DECODE(p_escalate_yn, FND_API.G_MISS_CHAR, escalate_yn, p_escalate_yn)
181: ,escalate_wait_time = DECODE(p_escalate_wait_time, FND_API.G_MISS_NUM, escalate_wait_time, p_escalate_wait_time)
182: ,escalate_wait_time_uom = DECODE(p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, escalate_wait_time_uom, p_escalate_wait_time_uom)
183: ,resource_id = DECODE(p_resource_id, FND_API.G_MISS_CHAR, resource_id, p_resource_id)

Line 180: ,escalate_yn = DECODE(p_escalate_yn, FND_API.G_MISS_CHAR, escalate_yn, p_escalate_yn)

176: ,optional_yn = DECODE(p_optional_yn, FND_API.G_MISS_CHAR, optional_yn, p_optional_yn)
177: ,optional_wait_time = DECODE(p_optional_wait_time, FND_API.G_MISS_CHAR, optional_wait_time, p_optional_wait_time)
178: ,optional_wait_time_uom = DECODE(p_optional_wait_time_uom, FND_API.G_MISS_CHAR, optional_wait_time_uom, p_optional_wait_time_uom)
179: ,notify_yn = DECODE(p_notify_yn, FND_API.G_MISS_CHAR, notify_yn, p_notify_yn)
180: ,escalate_yn = DECODE(p_escalate_yn, FND_API.G_MISS_CHAR, escalate_yn, p_escalate_yn)
181: ,escalate_wait_time = DECODE(p_escalate_wait_time, FND_API.G_MISS_NUM, escalate_wait_time, p_escalate_wait_time)
182: ,escalate_wait_time_uom = DECODE(p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, escalate_wait_time_uom, p_escalate_wait_time_uom)
183: ,resource_id = DECODE(p_resource_id, FND_API.G_MISS_CHAR, resource_id, p_resource_id)
184: ,custom_workflow_type = DECODE(p_custom_workflow_type, FND_API.G_MISS_CHAR, custom_workflow_type, p_custom_workflow_type)

Line 181: ,escalate_wait_time = DECODE(p_escalate_wait_time, FND_API.G_MISS_NUM, escalate_wait_time, p_escalate_wait_time)

177: ,optional_wait_time = DECODE(p_optional_wait_time, FND_API.G_MISS_CHAR, optional_wait_time, p_optional_wait_time)
178: ,optional_wait_time_uom = DECODE(p_optional_wait_time_uom, FND_API.G_MISS_CHAR, optional_wait_time_uom, p_optional_wait_time_uom)
179: ,notify_yn = DECODE(p_notify_yn, FND_API.G_MISS_CHAR, notify_yn, p_notify_yn)
180: ,escalate_yn = DECODE(p_escalate_yn, FND_API.G_MISS_CHAR, escalate_yn, p_escalate_yn)
181: ,escalate_wait_time = DECODE(p_escalate_wait_time, FND_API.G_MISS_NUM, escalate_wait_time, p_escalate_wait_time)
182: ,escalate_wait_time_uom = DECODE(p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, escalate_wait_time_uom, p_escalate_wait_time_uom)
183: ,resource_id = DECODE(p_resource_id, FND_API.G_MISS_CHAR, resource_id, p_resource_id)
184: ,custom_workflow_type = DECODE(p_custom_workflow_type, FND_API.G_MISS_CHAR, custom_workflow_type, p_custom_workflow_type)
185: where STRATEGY_USER_ITEM_ID = p_STRATEGY_USER_ITEM_ID;

Line 182: ,escalate_wait_time_uom = DECODE(p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, escalate_wait_time_uom, p_escalate_wait_time_uom)

178: ,optional_wait_time_uom = DECODE(p_optional_wait_time_uom, FND_API.G_MISS_CHAR, optional_wait_time_uom, p_optional_wait_time_uom)
179: ,notify_yn = DECODE(p_notify_yn, FND_API.G_MISS_CHAR, notify_yn, p_notify_yn)
180: ,escalate_yn = DECODE(p_escalate_yn, FND_API.G_MISS_CHAR, escalate_yn, p_escalate_yn)
181: ,escalate_wait_time = DECODE(p_escalate_wait_time, FND_API.G_MISS_NUM, escalate_wait_time, p_escalate_wait_time)
182: ,escalate_wait_time_uom = DECODE(p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, escalate_wait_time_uom, p_escalate_wait_time_uom)
183: ,resource_id = DECODE(p_resource_id, FND_API.G_MISS_CHAR, resource_id, p_resource_id)
184: ,custom_workflow_type = DECODE(p_custom_workflow_type, FND_API.G_MISS_CHAR, custom_workflow_type, p_custom_workflow_type)
185: where STRATEGY_USER_ITEM_ID = p_STRATEGY_USER_ITEM_ID;
186:

Line 183: ,resource_id = DECODE(p_resource_id, FND_API.G_MISS_CHAR, resource_id, p_resource_id)

179: ,notify_yn = DECODE(p_notify_yn, FND_API.G_MISS_CHAR, notify_yn, p_notify_yn)
180: ,escalate_yn = DECODE(p_escalate_yn, FND_API.G_MISS_CHAR, escalate_yn, p_escalate_yn)
181: ,escalate_wait_time = DECODE(p_escalate_wait_time, FND_API.G_MISS_NUM, escalate_wait_time, p_escalate_wait_time)
182: ,escalate_wait_time_uom = DECODE(p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, escalate_wait_time_uom, p_escalate_wait_time_uom)
183: ,resource_id = DECODE(p_resource_id, FND_API.G_MISS_CHAR, resource_id, p_resource_id)
184: ,custom_workflow_type = DECODE(p_custom_workflow_type, FND_API.G_MISS_CHAR, custom_workflow_type, p_custom_workflow_type)
185: where STRATEGY_USER_ITEM_ID = p_STRATEGY_USER_ITEM_ID;
186:
187: If (SQL%NOTFOUND) then

Line 184: ,custom_workflow_type = DECODE(p_custom_workflow_type, FND_API.G_MISS_CHAR, custom_workflow_type, p_custom_workflow_type)

180: ,escalate_yn = DECODE(p_escalate_yn, FND_API.G_MISS_CHAR, escalate_yn, p_escalate_yn)
181: ,escalate_wait_time = DECODE(p_escalate_wait_time, FND_API.G_MISS_NUM, escalate_wait_time, p_escalate_wait_time)
182: ,escalate_wait_time_uom = DECODE(p_escalate_wait_time_uom, FND_API.G_MISS_CHAR, escalate_wait_time_uom, p_escalate_wait_time_uom)
183: ,resource_id = DECODE(p_resource_id, FND_API.G_MISS_CHAR, resource_id, p_resource_id)
184: ,custom_workflow_type = DECODE(p_custom_workflow_type, FND_API.G_MISS_CHAR, custom_workflow_type, p_custom_workflow_type)
185: where STRATEGY_USER_ITEM_ID = p_STRATEGY_USER_ITEM_ID;
186:
187: If (SQL%NOTFOUND) then
188: RAISE NO_DATA_FOUND;