APPS.WMS_TASK_ACTION_PVT dependencies on WMS_SAVED_QUERIES

Line 1001: from wms_saved_queries

997: DEBUG( 'Inside DELETE_TEMP_QUERY');
998:
999: BEGIN
1000: delete
1001: from wms_saved_queries
1002: where query_name = p_query_name
1003: and query_type = 'TEMP_TASK_PLANNING';
1004:
1005: DEBUG( 'Temporary query records cleaned. Records deleted = ' || sql%rowcount );

Line 1046: from wms_saved_queries

1042: DEBUG( 'Inside DELETE_TEMP_ACTION');
1043:
1044: BEGIN
1045: delete
1046: from wms_saved_queries
1047: where query_name = p_action_name
1048: and query_type = 'TEMP_TASK_ACTION';
1049:
1050: DEBUG( 'Temporary action records cleaned. Records deleted = ' || sql%rowcount );

Line 1344: from wms_saved_queries

1340: --ltrim(rtrim(field_value)) field_value,
1341: field_value,
1342: organization_id,
1343: query_type
1344: from wms_saved_queries
1345: where query_name = p_query_name
1346: and (query_type = 'TASK_PLANNING' or query_type = 'TEMP_TASK_PLANNING')
1347: FOR UPDATE NOWAIT;
1348:

Line 1353: from wms_saved_queries

1349: CURSOR c_saved_actions ( p_action_name varchar2 ) IS
1350: select field_name,
1351: field_value,
1352: query_type
1353: from wms_saved_queries
1354: where query_name = p_action_name
1355: and (query_type = 'TASK_ACTION' or query_type = 'TEMP_TASK_ACTION')
1356: FOR UPDATE NOWAIT;
1357:

Line 1360: from wms_saved_queries

1356: FOR UPDATE NOWAIT;
1357:
1358: CURSOR c_query_type ( p_action_name varchar2 ) IS
1359: select distinct query_type
1360: from wms_saved_queries
1361: where query_name = p_action_name;
1362:
1363: rec_saved_queries c_saved_queries%rowtype;
1364: rec_saved_actions c_saved_actions%rowtype;