APPS.IGS_RE_WORKFLOW dependencies on IGS_RE_THESIS

Line 27: p_ca_seq_num igs_re_thesis.ca_sequence_number%TYPE,

23: WHERE person_id = p_person_id
24: AND sequence_number = p_seq_num;
25:
26: CURSOR c_thesis ( p_person_id igs_pe_person.person_id%TYPE,
27: p_ca_seq_num igs_re_thesis.ca_sequence_number%TYPE,
28: p_seq_num igs_re_thesis.sequence_number%TYPE) IS
29: SELECT title, thesis_topic
30: FROM igs_re_thesis
31: WHERE person_id = p_person_id

Line 28: p_seq_num igs_re_thesis.sequence_number%TYPE) IS

24: AND sequence_number = p_seq_num;
25:
26: CURSOR c_thesis ( p_person_id igs_pe_person.person_id%TYPE,
27: p_ca_seq_num igs_re_thesis.ca_sequence_number%TYPE,
28: p_seq_num igs_re_thesis.sequence_number%TYPE) IS
29: SELECT title, thesis_topic
30: FROM igs_re_thesis
31: WHERE person_id = p_person_id
32: AND ca_sequence_number=p_ca_seq_num

Line 30: FROM igs_re_thesis

26: CURSOR c_thesis ( p_person_id igs_pe_person.person_id%TYPE,
27: p_ca_seq_num igs_re_thesis.ca_sequence_number%TYPE,
28: p_seq_num igs_re_thesis.sequence_number%TYPE) IS
29: SELECT title, thesis_topic
30: FROM igs_re_thesis
31: WHERE person_id = p_person_id
32: AND ca_sequence_number=p_ca_seq_num
33: AND sequence_number=p_seq_num;
34:

Line 273: SELECT igs_re_thesis_s.NEXTVAL

269:
270: -- Gets a unique sequence number
271:
272: CURSOR c_seq_num IS
273: SELECT igs_re_thesis_s.NEXTVAL
274: FROM dual;
275:
276:
277: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment

Line 352: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.thesis.update',

348: wf_event.AddParameterToList (p_name => 'P_ADMIN', p_Value => l_cur_user_id.user_id, p_ParameterList => l_parameter_list_t);
349:
350: -- Raise the Event
351:
352: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.thesis.update',
353: p_event_key => 'THESISUPDATE'||ln_seq_val,
354: p_parameters => l_parameter_list_t);
355:
356: --

Line 1874: l_the_topic igs_re_thesis.thesis_topic%TYPE;

1870: l_cur_prof_value cur_prof_value%ROWTYPE;
1871: l_cur_user_id cur_user_id%ROWTYPE;
1872: l_cur_prog_stat cur_prog_stat%ROWTYPE;
1873: l_panel_member VARCHAR2(32000);
1874: l_the_topic igs_re_thesis.thesis_topic%TYPE;
1875: l_title igs_re_thesis.title%TYPE;
1876: l_supervisor VARCHAR2(32000);
1877:
1878:

Line 1875: l_title igs_re_thesis.title%TYPE;

1871: l_cur_user_id cur_user_id%ROWTYPE;
1872: l_cur_prog_stat cur_prog_stat%ROWTYPE;
1873: l_panel_member VARCHAR2(32000);
1874: l_the_topic igs_re_thesis.thesis_topic%TYPE;
1875: l_title igs_re_thesis.title%TYPE;
1876: l_supervisor VARCHAR2(32000);
1877:
1878:
1879: BEGIN

Line 1956: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.thesis.examsub',

1952:
1953:
1954: -- Raise the Event
1955:
1956: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.thesis.examsub',
1957: p_event_key => 'THESISEXAMEVENT'||ln_seq_val,
1958: p_parameters => l_parameter_list_t);
1959:
1960: --

Line 2025: l_the_topic igs_re_thesis.thesis_topic%TYPE;

2021:
2022: l_cur_prof_value cur_prof_value%ROWTYPE;
2023: l_cur_user_id cur_user_id%ROWTYPE;
2024: l_panel_member VARCHAR2(32000);
2025: l_the_topic igs_re_thesis.thesis_topic%TYPE;
2026: l_title igs_re_thesis.title%TYPE;
2027: l_supervisor VARCHAR2(32000);
2028:
2029:

Line 2026: l_title igs_re_thesis.title%TYPE;

2022: l_cur_prof_value cur_prof_value%ROWTYPE;
2023: l_cur_user_id cur_user_id%ROWTYPE;
2024: l_panel_member VARCHAR2(32000);
2025: l_the_topic igs_re_thesis.thesis_topic%TYPE;
2026: l_title igs_re_thesis.title%TYPE;
2027: l_supervisor VARCHAR2(32000);
2028:
2029:
2030: BEGIN

Line 2104: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.thesis.resultupd',

2100:
2101: -- Raise the Event
2102:
2103:
2104: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.re.thesis.resultupd',
2105: p_event_key => 'THESISRESULTEVENT'||ln_seq_val,
2106: p_parameters => l_parameter_list_t);
2107:
2108: --