APPS.WMS_TASK_ACTION_PVT dependencies on WMS_SAVED_QUERIES

Line 976: from wms_saved_queries

972: DEBUG( 'Inside DELETE_TEMP_QUERY');
973:
974: BEGIN
975: delete
976: from wms_saved_queries
977: where query_name = p_query_name
978: and query_type = 'TEMP_TASK_PLANNING';
979:
980: DEBUG( 'Temporary query records cleaned. Records deleted = ' || sql%rowcount );

Line 1021: from wms_saved_queries

1017: DEBUG( 'Inside DELETE_TEMP_ACTION');
1018:
1019: BEGIN
1020: delete
1021: from wms_saved_queries
1022: where query_name = p_action_name
1023: and query_type = 'TEMP_TASK_ACTION';
1024:
1025: DEBUG( 'Temporary action records cleaned. Records deleted = ' || sql%rowcount );

Line 1319: from wms_saved_queries

1315: --ltrim(rtrim(field_value)) field_value,
1316: field_value,
1317: organization_id,
1318: query_type
1319: from wms_saved_queries
1320: where query_name = p_query_name
1321: and (query_type = 'TASK_PLANNING' or query_type = 'TEMP_TASK_PLANNING')
1322: FOR UPDATE NOWAIT;
1323:

Line 1328: from wms_saved_queries

1324: CURSOR c_saved_actions ( p_action_name varchar2 ) IS
1325: select field_name,
1326: field_value,
1327: query_type
1328: from wms_saved_queries
1329: where query_name = p_action_name
1330: and (query_type = 'TASK_ACTION' or query_type = 'TEMP_TASK_ACTION')
1331: FOR UPDATE NOWAIT;
1332:

Line 1335: from wms_saved_queries

1331: FOR UPDATE NOWAIT;
1332:
1333: CURSOR c_query_type ( p_action_name varchar2 ) IS
1334: select distinct query_type
1335: from wms_saved_queries
1336: where query_name = p_action_name;
1337:
1338: rec_saved_queries c_saved_queries%rowtype;
1339: rec_saved_actions c_saved_actions%rowtype;