APPS.IEX_STRY_UTL_PUB dependencies on IEX_DLN_UWQ_SUMMARY

Line 1185: UPDATE IEX_DLN_UWQ_SUMMARY

1181:
1182: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1183: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing party level strategy uwq summary ************');
1184: END IF;
1185: UPDATE IEX_DLN_UWQ_SUMMARY
1186: SET WORK_ITEM_ID = null,
1187: SCHEDULE_START = null,
1188: SCHEDULE_END = null,
1189: WORK_TYPE = null,

Line 1207: UPDATE IEX_DLN_UWQ_SUMMARY

1203: ELSIF p_object_type = 'IEX_ACCOUNT' THEN
1204: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1205: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing account level strategy uwq summary ************');
1206: END IF;
1207: UPDATE IEX_DLN_UWQ_SUMMARY
1208: SET WORK_ITEM_ID = null,
1209: SCHEDULE_START = null,
1210: SCHEDULE_END = null,
1211: WORK_TYPE = null,

Line 1229: UPDATE IEX_DLN_UWQ_SUMMARY

1225: ELSIF p_object_type = 'IEX_BILLTO' THEN
1226: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1227: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing billto level strategy uwq summary ************');
1228: END IF;
1229: UPDATE IEX_DLN_UWQ_SUMMARY
1230: SET WORK_ITEM_ID = null,
1231: SCHEDULE_START = null,
1232: SCHEDULE_END = null,
1233: WORK_TYPE = null,

Line 1341: update iex_dln_uwq_summary

1337: IF l_jtf_object_type = 'PARTY' THEN
1338: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1339: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.REFRESH_UWQ_STR_SUMM: Updating party level strategy uwq summary ************');
1340: END IF;
1341: update iex_dln_uwq_summary
1342: set work_item_id = l_work_item_id,
1343: schedule_start = l_schedule_start,
1344: schedule_end = l_schedule_end,
1345: work_type = l_work_type,

Line 1363: update iex_dln_uwq_summary

1359: ELSIF l_jtf_object_type = 'IEX_ACCOUNT' THEN
1360: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1361: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.REFRESH_UWQ_STR_SUMM: Updating account level strategy uwq summary ************');
1362: END IF;
1363: update iex_dln_uwq_summary
1364: set work_item_id = l_work_item_id,
1365: schedule_start = l_schedule_start,
1366: schedule_end = l_schedule_end,
1367: work_type = l_work_type,

Line 1385: update iex_dln_uwq_summary

1381: ELSIF l_jtf_object_type = 'IEX_BILLTO' THEN
1382: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1383: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.REFRESH_UWQ_STR_SUMM: Updating billto level strategy uwq summary ************');
1384: END IF;
1385: update iex_dln_uwq_summary
1386: set work_item_id = l_work_item_id,
1387: schedule_start = l_schedule_start,
1388: schedule_end = l_schedule_end,
1389: work_type = l_work_type,