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 1856: FROM mtl_cycle_count_entries mcce

1852: EXCEPTION
1853: WHEN NO_DATA_FOUND THEN
1854: SELECT count(1)
1855: INTO l_task_exists
1856: FROM mtl_cycle_count_entries mcce
1857: WHERE mcce.cycle_count_entry_id = p_transaction_temp_id
1858: AND mcce.entry_status_code IN( 1 , 3) ;
1859: IF g_debug = 1 THEN
1860: IF l_task_exists > 0 THEN

Line 4906: FROM mtl_cycle_count_entries

4902: l_cc_entry_id := p_task_rec.transaction_number ;
4903: SAVEPOINT delcyc;
4904: SELECT cycle_count_header_id
4905: INTO l_cyc_header_id
4906: FROM mtl_cycle_count_entries
4907: WHERE cycle_count_entry_id = l_cc_entry_id ;
4908: UPDATE mtl_cycle_count_entries
4909: SET entry_status_code = 4
4910: WHERE cycle_count_entry_id = l_cc_entry_id ;

Line 4908: UPDATE mtl_cycle_count_entries

4904: SELECT cycle_count_header_id
4905: INTO l_cyc_header_id
4906: FROM mtl_cycle_count_entries
4907: WHERE cycle_count_entry_id = l_cc_entry_id ;
4908: UPDATE mtl_cycle_count_entries
4909: SET entry_status_code = 4
4910: WHERE cycle_count_entry_id = l_cc_entry_id ;
4911: IF l_debug =1 THEN
4912: debug_print('delete_cc_tasks: In Delete Cycle Count Tasks');

Line 5060: FROM mtl_cycle_count_entries

5056: END IF;
5057: IF (l_task_exists = 0 ) THEN
5058: SELECT count(cycle_count_entry_id)
5059: INTO l_task_exists
5060: FROM mtl_cycle_count_entries
5061: WHERE cycle_count_entry_id = l_ret_task_table(i).transaction_number ;
5062: SELECT 1
5063: INTO l_lock_cyc_rec
5064: FROM mtl_cycle_count_entries

Line 5064: FROM mtl_cycle_count_entries

5060: FROM mtl_cycle_count_entries
5061: WHERE cycle_count_entry_id = l_ret_task_table(i).transaction_number ;
5062: SELECT 1
5063: INTO l_lock_cyc_rec
5064: FROM mtl_cycle_count_entries
5065: WHERE cycle_count_entry_id = l_ret_task_table(i).transaction_number FOR UPDATE NOWAIT;
5066: l_task_type := 3;
5067: IF l_task_exists = 1 THEN
5068: IF l_debug = 1 THEN

Line 5207: l_mcce_rec mtl_cycle_count_entries%ROWTYPE;

5203: )
5204: IS
5205:
5206: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
5207: l_mcce_rec mtl_cycle_count_entries%ROWTYPE;
5208: l_query_tab query_tab_type;
5209:
5210:
5211: l_organization_id NUMBER := NULL;

Line 5506: FROM mtl_cycle_count_entries

5502: WHEN NO_DATA_FOUND THEN
5503: BEGIN
5504: SELECT *
5505: INTO l_mcce_rec
5506: FROM mtl_cycle_count_entries
5507: WHERE cycle_count_entry_id = p_transaction_number;
5508:
5509: BEGIN
5510: SELECT cycle_count_header_name

Line 7216: FROM mtl_cycle_count_entries

7212: --Cursor to lock the mcce record before updation.
7213: Cursor c_lock_mcce (p_transaction_number NUMBER)
7214: IS
7215: SELECT '1'
7216: FROM mtl_cycle_count_entries
7217: WHERE cycle_count_entry_id = p_transaction_number FOR UPDATE NOWAIT;
7218: p_return_sts VARCHAR2(30);
7219: P_msg_count NUMBER;
7220: l_msg_count NUMBER;

Line 7639: UPDATE mtl_cycle_count_entries

7635: END IF;
7636:
7637: IF (l_mcce_transaction_num_table.COUNT > 0) THEN
7638: FORALL i in 1..l_mcce_transaction_num_table.COUNT
7639: UPDATE mtl_cycle_count_entries
7640: SET task_priority = l_mcce_priority_table(i) ,
7641: standard_operation_id = l_mcce_usertask_type_id_table(i)
7642: WHERE cycle_count_entry_id = l_mcce_transaction_num_table(i);
7643: END IF;