[Home] [Help]
18: g_processed_assignment_list ASG_DOWNLOAD.ACCESS_LIST;
19:
20: CURSOR c_debrief_headers( b_user_name VARCHAR2, b_tranid NUMBER) is
21: SELECT *
22: FROM csm_debrief_headers_inq
23: WHERE tranid$$ = b_tranid
24: AND clid$$cs = b_user_name;
25:
26: CURSOR c_debrief_notes(p_debrief_header_id number, b_user_name varchar2, b_tranid number)
596: csm_util_pkg.log('csm_debrief_header_pkg.apply_client_changes entered','CSM_DEBRIEF_HEADER_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);
597:
598: /*** loop through debrief parts records in inqueue ***/
599: IF p_task_assignment_id IS NULL THEN
600: OPEN c_cur FOR 'SELECT * FROM csm_debrief_headers_inq inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
601: ||''' AND TASK_ASSIGNMENT_ID NOT IN ('||CSM_UTIL_PKG.get_String_fromList(g_processed_assignment_list)||')';
602: ELSE
603: g_processed_assignment_list(g_processed_assignment_list.COUNT+1):=p_task_assignment_id;
604: OPEN c_cur FOR 'SELECT * FROM csm_debrief_headers_inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
600: OPEN c_cur FOR 'SELECT * FROM csm_debrief_headers_inq inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
601: ||''' AND TASK_ASSIGNMENT_ID NOT IN ('||CSM_UTIL_PKG.get_String_fromList(g_processed_assignment_list)||')';
602: ELSE
603: g_processed_assignment_list(g_processed_assignment_list.COUNT+1):=p_task_assignment_id;
604: OPEN c_cur FOR 'SELECT * FROM csm_debrief_headers_inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
605: ||''' AND TASK_ASSIGNMENT_ID='||p_task_assignment_id;
606: END IF;
607:
608: LOOP
736: l_sequence in number)
737: IS
738: SELECT b.last_updated_by
739: FROM csf_debrief_headers b,
740: csm_debrief_headers_inq a
741: WHERE a.clid$$cs = l_user_name
742: AND tranid$$ = l_tran_id
743: AND seqno$$ = l_sequence
744: AND a.debrief_header_id = b.debrief_header_id ;