APPS.WMS_TASK_MGMT_PUB dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 1092: FROM Mtl_Cycle_Count_Entries mcce

1088: IF (l_task_exists = 0 ) THEN
1089: --Checkif it is a cycle count task
1090: SELECT count(1)
1091: INTO l_task_exists
1092: FROM Mtl_Cycle_Count_Entries mcce
1093: WHERE mcce.cycle_count_entry_id = p_transaction_number
1094: AND mcce.entry_status_code IN( 1 , 3) ;
1095: l_task_type := 3 ; --cycle count.
1096: END IF ;

Line 1932: FROM mtl_cycle_count_entries mcce

1928: EXCEPTION
1929: WHEN NO_DATA_FOUND THEN
1930: SELECT count(1)
1931: INTO l_task_exists
1932: FROM mtl_cycle_count_entries mcce
1933: WHERE mcce.cycle_count_entry_id = p_transaction_temp_id
1934: AND mcce.entry_status_code IN( 1 , 3) ;
1935: IF g_debug = 1 THEN
1936: IF l_task_exists > 0 THEN

Line 4995: FROM mtl_cycle_count_entries

4991: l_cc_entry_id := p_task_rec.transaction_number ;
4992: SAVEPOINT delcyc;
4993: SELECT cycle_count_header_id
4994: INTO l_cyc_header_id
4995: FROM mtl_cycle_count_entries
4996: WHERE cycle_count_entry_id = l_cc_entry_id ;
4997: UPDATE mtl_cycle_count_entries
4998: SET entry_status_code = 4
4999: WHERE cycle_count_entry_id = l_cc_entry_id ;

Line 4997: UPDATE mtl_cycle_count_entries

4993: SELECT cycle_count_header_id
4994: INTO l_cyc_header_id
4995: FROM mtl_cycle_count_entries
4996: WHERE cycle_count_entry_id = l_cc_entry_id ;
4997: UPDATE mtl_cycle_count_entries
4998: SET entry_status_code = 4
4999: WHERE cycle_count_entry_id = l_cc_entry_id ;
5000: IF l_debug =1 THEN
5001: debug_print('delete_cc_tasks: In Delete Cycle Count Tasks');

Line 5149: FROM mtl_cycle_count_entries

5145: END IF;
5146: IF (l_task_exists = 0 ) THEN
5147: SELECT count(cycle_count_entry_id)
5148: INTO l_task_exists
5149: FROM mtl_cycle_count_entries
5150: WHERE cycle_count_entry_id = l_ret_task_table(i).transaction_number ;
5151: SELECT 1
5152: INTO l_lock_cyc_rec
5153: FROM mtl_cycle_count_entries

Line 5153: FROM mtl_cycle_count_entries

5149: FROM mtl_cycle_count_entries
5150: WHERE cycle_count_entry_id = l_ret_task_table(i).transaction_number ;
5151: SELECT 1
5152: INTO l_lock_cyc_rec
5153: FROM mtl_cycle_count_entries
5154: WHERE cycle_count_entry_id = l_ret_task_table(i).transaction_number FOR UPDATE NOWAIT;
5155: l_task_type := 3;
5156: IF l_task_exists = 1 THEN
5157: IF l_debug = 1 THEN

Line 5296: l_mcce_rec mtl_cycle_count_entries%ROWTYPE;

5292: )
5293: IS
5294:
5295: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
5296: l_mcce_rec mtl_cycle_count_entries%ROWTYPE;
5297: l_query_tab query_tab_type;
5298:
5299:
5300: l_organization_id NUMBER := NULL;

Line 5597: FROM mtl_cycle_count_entries

5593: WHEN NO_DATA_FOUND THEN
5594: BEGIN
5595: SELECT *
5596: INTO l_mcce_rec
5597: FROM mtl_cycle_count_entries
5598: WHERE cycle_count_entry_id = p_transaction_number;
5599:
5600: BEGIN
5601: SELECT cycle_count_header_name

Line 7315: FROM mtl_cycle_count_entries

7311: --Cursor to lock the mcce record before updation.
7312: Cursor c_lock_mcce (p_transaction_number NUMBER)
7313: IS
7314: SELECT '1'
7315: FROM mtl_cycle_count_entries
7316: WHERE cycle_count_entry_id = p_transaction_number FOR UPDATE NOWAIT;
7317: p_return_sts VARCHAR2(30);
7318: P_msg_count NUMBER;
7319: l_msg_count NUMBER;

Line 7738: UPDATE mtl_cycle_count_entries

7734: END IF;
7735:
7736: IF (l_mcce_transaction_num_table.COUNT > 0) THEN
7737: FORALL i in 1..l_mcce_transaction_num_table.COUNT
7738: UPDATE mtl_cycle_count_entries
7739: SET task_priority = l_mcce_priority_table(i) ,
7740: standard_operation_id = l_mcce_usertask_type_id_table(i)
7741: WHERE cycle_count_entry_id = l_mcce_transaction_num_table(i);
7742: END IF;