APPS.IEX_STRY_UTL_PUB dependencies on IEX_DLN_UWQ_SUMMARY

Line 1191: UPDATE IEX_DLN_UWQ_SUMMARY

1187:
1188: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1189: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing party level strategy uwq summary ************');
1190: END IF;
1191: UPDATE IEX_DLN_UWQ_SUMMARY
1192: SET WORK_ITEM_ID = null,
1193: SCHEDULE_START = null,
1194: SCHEDULE_END = null,
1195: WORK_TYPE = null,

Line 1214: UPDATE IEX_DLN_UWQ_SUMMARY

1210: ELSIF p_object_type = 'IEX_ACCOUNT' THEN
1211: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1212: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing account level strategy uwq summary ************');
1213: END IF;
1214: UPDATE IEX_DLN_UWQ_SUMMARY
1215: SET WORK_ITEM_ID = null,
1216: SCHEDULE_START = null,
1217: SCHEDULE_END = null,
1218: WORK_TYPE = null,

Line 1237: UPDATE IEX_DLN_UWQ_SUMMARY

1233: ELSIF p_object_type = 'IEX_BILLTO' THEN
1234: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1235: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing billto level strategy uwq summary ************');
1236: END IF;
1237: UPDATE IEX_DLN_UWQ_SUMMARY
1238: SET WORK_ITEM_ID = null,
1239: SCHEDULE_START = null,
1240: SCHEDULE_END = null,
1241: WORK_TYPE = null,

Line 1354: update iex_dln_uwq_summary

1350: IF l_jtf_object_type = 'PARTY' THEN
1351: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1352: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.REFRESH_UWQ_STR_SUMM: Updating party level strategy uwq summary ************');
1353: END IF;
1354: update iex_dln_uwq_summary
1355: set work_item_id = l_work_item_id,
1356: schedule_start = l_schedule_start,
1357: schedule_end = l_schedule_end,
1358: work_type = l_work_type,

Line 1377: update iex_dln_uwq_summary

1373: ELSIF l_jtf_object_type = 'IEX_ACCOUNT' THEN
1374: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1375: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.REFRESH_UWQ_STR_SUMM: Updating account level strategy uwq summary ************');
1376: END IF;
1377: update iex_dln_uwq_summary
1378: set work_item_id = l_work_item_id,
1379: schedule_start = l_schedule_start,
1380: schedule_end = l_schedule_end,
1381: work_type = l_work_type,

Line 1400: update iex_dln_uwq_summary

1396: ELSIF l_jtf_object_type = 'IEX_BILLTO' THEN
1397: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1398: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.REFRESH_UWQ_STR_SUMM: Updating billto level strategy uwq summary ************');
1399: END IF;
1400: update iex_dln_uwq_summary
1401: set work_item_id = l_work_item_id,
1402: schedule_start = l_schedule_start,
1403: schedule_end = l_schedule_end,
1404: work_type = l_work_type,