[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT sca_course_cd, research_topic
FROM igs_re_candidature
WHERE person_id = p_person_id
AND sequence_number = p_seq_num;
SELECT title, thesis_topic
FROM igs_re_thesis
WHERE person_id = p_person_id
AND ca_sequence_number=p_ca_seq_num
AND sequence_number=p_seq_num;
SELECT person_id
FROM igs_re_sprvsr
WHERE ca_person_id = p_ca_person_id
AND ca_sequence_number = p_ca_sequence_number ;
SELECT person_id
FROM igs_re_ths_pnl_mbr
WHERE ca_person_id = p_personid
AND ca_sequence_number= p_ca_sequence_number
AND the_sequence_number= p_the_sequence_number
AND creation_dt= p_creation_dt ;
SELECT igs_re_retopc_s.NEXTVAL
FROM dual;
SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
FROM dual;
SELECT FND_GLOBAL.USER_ID user_id
FROM dual;
WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.restop.update',
p_event_key => 'RESTOPUPDATE'||ln_seq_val,
p_parameters => l_parameter_list_t);
l_parameter_list_t.delete;
p_deleted IN VARCHAR2
) IS
------------------------------------------------------------------------------------------------
-- Created by : Deepankar Dey, Oracle India (in)
-- Date created: 30-04-2003
--
-- Purpose:Bug # 2829275 . UK Correspondence.The TBH needs to be modified to invoke the thesis event is raised
-- when there is a change in thesis attributes.
--
--
--
-- Known limitations/enhancements and/or remarks:
--
-- Change History:
-- Who When What
--
-------------------------------------------------------------------------------------------------
l_event_t wf_event_t;
SELECT igs_re_thesis_s.NEXTVAL
FROM dual;
SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
FROM dual;
SELECT FND_GLOBAL.USER_ID user_id
FROM dual;
SELECT sca_course_cd
FROM igs_re_candidature
WHERE person_id = p_personid
AND sequence_number = p_ca_seq_num;
wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);
WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.thesis.update',
p_event_key => 'THESISUPDATE'||ln_seq_val,
p_parameters => l_parameter_list_t);
l_parameter_list_t.delete;
SELECT igs_re_sprvsn_s.NEXTVAL
FROM dual;
SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
FROM dual;
SELECT FND_GLOBAL.USER_ID user_id
FROM dual;
SELECT sca_course_cd
FROM igs_re_candidature
WHERE person_id = p_personid
AND sequence_number = p_ca_seq_num;
SELECT
start_dt
FROM igs_re_sprvsr
WHERE
ca_person_id = p_personid
AND ca_sequence_number = p_ca_seq_num
AND person_id = p_rep_person_id
AND sequence_number = p_rep_seq_num ;
WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.sprvsn.update',
p_event_key => 'SPRVSNUPDATE'||ln_seq_val,
p_parameters => l_parameter_list_t);
l_parameter_list_t.delete;
SELECT igs_en_ovrsub_s.NEXTVAL
FROM dual;
SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
FROM dual;
SELECT FND_GLOBAL.USER_ID user_id
FROM dual;
l_parameter_list_t.delete;
SELECT user_name
FROM fnd_user
WHERE person_party_id = cp_person_id
AND ( end_date IS NULL OR end_date > SYSDATE );
SELECT user_name
FROM fnd_user
WHERE user_id = cp_person_id
AND ( end_date IS NULL OR end_date > SYSDATE );
SELECT count(1)
FROM WF_LOCAL_USER_ROLES
WHERE USER_NAME = cp_user_name
AND ROLE_NAME = cp_role_name
AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
AND ROLE_ORIG_SYSTEM_ID = 0;
SELECT full_name
FROM igs_pe_person_base_v
WHERE person_id = cp_person_id;
l_delete VARCHAR2(10);
SELECT user_name
FROM fnd_user
WHERE person_party_id = cp_person_id
AND ( end_date IS NULL OR end_date > SYSDATE );
SELECT user_name
FROM fnd_user
WHERE user_id = cp_person_id
AND ( end_date IS NULL OR end_date > SYSDATE );
SELECT count(1)
FROM WF_LOCAL_USER_ROLES
WHERE USER_NAME = cp_user_name
AND ROLE_NAME = cp_role_name
AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
AND ROLE_ORIG_SYSTEM_ID = 0;
SELECT full_name
FROM igs_pe_person_base_v
WHERE person_id = cp_person_id;
SELECT message_text
FROM fnd_new_messages
WHERE message_name = cp_message_name;
l_delete := Wf_Engine.GetItemAttrText(itemtype,itemkey,'P_DELETED');
IF (l_delete = 'Y') THEN
resultout := 'COMPLETE:Y' ;
ELSIF (l_delete = 'N' or l_delete IS NULL ) THEN
resultout := 'COMPLETE:N' ;
SELECT user_name
FROM fnd_user
WHERE person_party_id = cp_person_id
AND ( end_date IS NULL OR end_date > SYSDATE );
SELECT user_name
FROM fnd_user
WHERE user_id = cp_person_id
AND ( end_date IS NULL OR end_date > SYSDATE );
SELECT count(1)
FROM WF_LOCAL_USER_ROLES
WHERE USER_NAME = cp_user_name
AND ROLE_NAME = cp_role_name
AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
AND ROLE_ORIG_SYSTEM_ID = 0;
SELECT full_name
FROM igs_pe_person_base_v
WHERE person_id = cp_person_id;
SELECT message_text
FROM fnd_new_messages
WHERE message_name = cp_message_name;
SELECT user_name
FROM fnd_user
WHERE person_party_id = cp_person_id
AND ( end_date IS NULL OR end_date > SYSDATE );
SELECT user_name
FROM fnd_user
WHERE user_id = cp_person_id
AND ( end_date IS NULL OR end_date > SYSDATE );
SELECT count(1)
FROM WF_LOCAL_USER_ROLES
WHERE USER_NAME = cp_user_name
AND ROLE_NAME = cp_role_name
AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
AND ROLE_ORIG_SYSTEM_ID = 0;
SELECT full_name
FROM igs_pe_person_base_v
WHERE person_id = cp_person_id;
SELECT message_text
FROM fnd_new_messages
WHERE message_name = cp_message_name;
p_deleted IN VARCHAR2
) AS
------------------------------------------------------------------------------------------------
-- Created by : Deepankar Dey, Oracle India (in)
-- Date created: 05-Sept-2003
--
-- Purpose: The changes are done as per the Enrollments Notifications TD Bug # 3052429
-- The procedure raises the milestone event.
--
--
-- Known limitations/enhancements and/or remarks:
--
-- Change History:
-- Who When What
--
-------------------------------------------------------------------------------------------------
l_event_t wf_event_t;
SELECT igs_re_milstn_s.NEXTVAL
FROM dual;
SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
FROM dual;
SELECT FND_GLOBAL.USER_ID user_id
FROM dual;
SELECT course_cd , version_number, attendance_type
FROM igs_en_stdnt_ps_att
WHERE person_id = p_person_id
AND course_cd = p_course_cd ;
SELECT 1
FROM igs_re_dflt_ms_set
WHERE
course_cd = p_course_cd AND
version_number = p_version_number AND
attendance_type = p_attendance_type ;
wf_event.AddParameterToList (p_name => 'P_DELETED', p_Value => p_deleted, p_ParameterList => l_parameter_list_t);
l_parameter_list_t.delete;
SELECT igs_re_exmsub_s.NEXTVAL
FROM dual;
SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
FROM dual;
SELECT FND_GLOBAL.USER_ID user_id
FROM dual;
SELECT course_attempt_status
FROM igs_en_stdnt_ps_att
WHERE person_id = p_person_id
AND course_cd = p_course_cd ;
l_parameter_list_t.delete;
SELECT igs_re_resupd_s.NEXTVAL
FROM dual;
SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
FROM dual;
SELECT FND_GLOBAL.USER_ID user_id
FROM dual;
l_parameter_list_t.delete;
SELECT igs_re_regcfm_s.NEXTVAL
FROM dual;
SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
FROM dual;
SELECT FND_GLOBAL.USER_ID user_id
FROM dual;
SELECT research_topic,sequence_number
FROM igs_re_candidature
WHERE person_id = p_personid
AND sca_course_cd = p_programcd ;
SELECT course_type
FROM igs_ps_ver
WHERE course_cd=p_programcd ;
l_parameter_list_t.delete;
SELECT igs_re_milnot_s.NEXTVAL
FROM dual;
SELECT FND_PROFILE.VALUE('IGS_WF_ENABLE') value
FROM dual;
SELECT FND_GLOBAL.USER_ID user_id
FROM dual;
SELECT spa.person_id, spa.course_cd, re.sequence_number, spa.attendance_type, re.research_topic
FROM igs_en_stdnt_ps_att spa, igs_re_candidature re
WHERE spa.person_id = re.person_id
AND spa.course_cd = re.sca_course_cd
AND spa.course_attempt_status NOT IN ('LAPSED','DISCONTIN');
SELECT a.due_dt, NVL(ovrd_ntfctn_imminent_days, b.NTFCTN_IMMINENT_DAYS) ovrd_ntfctn_imminent_days,
nvl(ovrd_ntfctn_reminder_days, b.NTFCTN_REMINDER_DAYS) ovrd_ntfctn_reminder_days,
nvl(ovrd_ntfctn_re_reminder_days, b.NTFCTN_RE_REMINDER_DAYS) ovrd_ntfctn_re_reminder_days, a.milestone_status, a.milestone_type
FROM igs_pr_milestone a,
igs_pr_milestone_typ b
WHERE a.person_id = p_person_id
AND a.ca_sequence_number = p_seq_num
AND a.milestone_status <> 'ACHIEVED'
AND TRUNC(a.due_dt) >= TRUNC(SYSDATE)
AND a.milestone_type = b.milestone_type ;
l_parameter_list_t.delete;
SELECT user_name
FROM fnd_user
WHERE person_party_id = cp_person_id
AND ( end_date IS NULL OR end_date > SYSDATE );
SELECT user_name
FROM fnd_user
WHERE user_id = cp_person_id
AND ( end_date IS NULL OR end_date > SYSDATE );
SELECT count(1)
FROM WF_LOCAL_USER_ROLES
WHERE USER_NAME = cp_user_name
AND ROLE_NAME = cp_role_name
AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
AND ROLE_ORIG_SYSTEM_ID = 0;
SELECT full_name
FROM igs_pe_person_base_v
WHERE person_id = cp_person_id;
SELECT message_text
FROM fnd_new_messages
WHERE message_name = cp_message_name;
SELECT full_name , person_number
FROM igs_pe_person_base_v
WHERE person_id = cp_person_id;
SELECT meaning
FROM igs_lookups_view
WHERE lookup_type = 'VS_EN_COURSE_ATMPT_STATUS'
AND lookup_code = l_lookup_code ;
SELECT full_name , person_number
FROM igs_pe_person_base_v
WHERE person_id = cp_person_id;