eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_NSC_PKG dependencies on STANDARD

Line 189: p_std_rep_flag IN VARCHAR2, -- Standard report flag

185: p_comment IN VARCHAR2, -- Runtime Comments
186: p_school_id IN VARCHAR2, -- School code
187: p_branch_id IN VARCHAR2, -- Branch code
188: p_cal_inst_id IN VARCHAR2, -- Calendar instance concatenated ID
189: p_std_rep_flag IN VARCHAR2, -- Standard report flag
190: p_non_std_rpt_type IN VARCHAR2, --Non standard report type like GRADUATE
191: p_prev_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Previous snapshot Id (if any)
192: p_dirpath IN VARCHAR2, -- Output directory name
193: p_file_name IN VARCHAR2, -- Output file name

Line 190: p_non_std_rpt_type IN VARCHAR2, --Non standard report type like GRADUATE

186: p_school_id IN VARCHAR2, -- School code
187: p_branch_id IN VARCHAR2, -- Branch code
188: p_cal_inst_id IN VARCHAR2, -- Calendar instance concatenated ID
189: p_std_rep_flag IN VARCHAR2, -- Standard report flag
190: p_non_std_rpt_type IN VARCHAR2, --Non standard report type like GRADUATE
191: p_prev_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Previous snapshot Id (if any)
192: p_dirpath IN VARCHAR2, -- Output directory name
193: p_file_name IN VARCHAR2, -- Output file name
194: p_debug_mode IN VARCHAR2

Line 222: p_std_rep_flag IN VARCHAR2, -- Standard report flag

218: p_comment IN VARCHAR2, -- Runtime Comments
219: p_school_id IN VARCHAR2, -- School code
220: p_branch_id IN VARCHAR2, -- Branch code
221: p_cal_inst_id IN VARCHAR2, -- Calendar instance concatenated ID
222: p_std_rep_flag IN VARCHAR2, -- Standard report flag
223: p_non_std_rpt_type IN VARCHAR2, --Non standard report type like GRADUATE
224: p_prev_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Previous snapshot Id (if any)
225: p_dirpath IN VARCHAR2, -- Output directory name
226: p_file_name IN VARCHAR2, -- Output file name

Line 223: p_non_std_rpt_type IN VARCHAR2, --Non standard report type like GRADUATE

219: p_school_id IN VARCHAR2, -- School code
220: p_branch_id IN VARCHAR2, -- Branch code
221: p_cal_inst_id IN VARCHAR2, -- Calendar instance concatenated ID
222: p_std_rep_flag IN VARCHAR2, -- Standard report flag
223: p_non_std_rpt_type IN VARCHAR2, --Non standard report type like GRADUATE
224: p_prev_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Previous snapshot Id (if any)
225: p_dirpath IN VARCHAR2, -- Output directory name
226: p_file_name IN VARCHAR2, -- Output file name
227: p_debug_mode IN VARCHAR2

Line 476: -- Standard Start of API savepoint

472: WHERE doc_inst_id = p_inst_id;
473: l_rowid rowid;
474: BEGIN
475:
476: -- Standard Start of API savepoint
477: g_debug_mode := TRUE;
478:
479: BEGIN
480: IF (g_debug_mode) THEN

Line 902: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string

898: Who When What
899: (reverse chronological order - newest change first)
900: ckasu 17-JAN-2006 Added igs_ge_gen_003.set_org_id(NULL) as a part of bug#4958173.
901: ***************************************************************/
902: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
903: retcode OUT NOCOPY NUMBER , -- Request standard return status
904: p_comment IN VARCHAR2, -- Runtime comments
905: p_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Snapshot Id to create a file
906: p_dirpath IN VARCHAR2 , -- Output directory name

Line 903: retcode OUT NOCOPY NUMBER , -- Request standard return status

899: (reverse chronological order - newest change first)
900: ckasu 17-JAN-2006 Added igs_ge_gen_003.set_org_id(NULL) as a part of bug#4958173.
901: ***************************************************************/
902: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
903: retcode OUT NOCOPY NUMBER , -- Request standard return status
904: p_comment IN VARCHAR2, -- Runtime comments
905: p_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Snapshot Id to create a file
906: p_dirpath IN VARCHAR2 , -- Output directory name
907: p_file_name IN VARCHAR2 , -- Output file name

Line 971: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string

967: Who When What
968: (reverse chronological order - newest change first)
969: ckasu 17-JAN-2006 Added igs_ge_gen_003.set_org_id(NULL) as a part of bug#4958173.
970: ***************************************************************/
971: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
972: retcode OUT NOCOPY NUMBER , -- Request standard return status
973: p_comment IN VARCHAR2, -- Runtime Comments
974: p_school_id IN VARCHAR2, -- School code
975: p_branch_id IN VARCHAR2, -- Branch code

Line 972: retcode OUT NOCOPY NUMBER , -- Request standard return status

968: (reverse chronological order - newest change first)
969: ckasu 17-JAN-2006 Added igs_ge_gen_003.set_org_id(NULL) as a part of bug#4958173.
970: ***************************************************************/
971: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
972: retcode OUT NOCOPY NUMBER , -- Request standard return status
973: p_comment IN VARCHAR2, -- Runtime Comments
974: p_school_id IN VARCHAR2, -- School code
975: p_branch_id IN VARCHAR2, -- Branch code
976: p_cal_inst_id IN VARCHAR2, -- Calendar instance concatenated ID

Line 977: p_std_rep_flag IN VARCHAR2, -- Standard report flag

973: p_comment IN VARCHAR2, -- Runtime Comments
974: p_school_id IN VARCHAR2, -- School code
975: p_branch_id IN VARCHAR2, -- Branch code
976: p_cal_inst_id IN VARCHAR2, -- Calendar instance concatenated ID
977: p_std_rep_flag IN VARCHAR2, -- Standard report flag
978: p_dummy IN VARCHAR2, /* Dummy Parameter used for validation of non_std_rpt_type Value Set, it is nowhere used in the procedure. */
979: p_non_std_rpt_typ IN VARCHAR2, -- Non Standard report type like 'GRADUATE'
980: p_prev_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Previous snapshot Id (if any)
981: p_dirpath IN VARCHAR2, -- Output directory name

Line 979: p_non_std_rpt_typ IN VARCHAR2, -- Non Standard report type like 'GRADUATE'

975: p_branch_id IN VARCHAR2, -- Branch code
976: p_cal_inst_id IN VARCHAR2, -- Calendar instance concatenated ID
977: p_std_rep_flag IN VARCHAR2, -- Standard report flag
978: p_dummy IN VARCHAR2, /* Dummy Parameter used for validation of non_std_rpt_type Value Set, it is nowhere used in the procedure. */
979: p_non_std_rpt_typ IN VARCHAR2, -- Non Standard report type like 'GRADUATE'
980: p_prev_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Previous snapshot Id (if any)
981: p_dirpath IN VARCHAR2, -- Output directory name
982: p_file_name IN VARCHAR2, -- Output file name
983: p_debug_mode IN VARCHAR2 := FND_API.G_FALSE

Line 993: -- If the parameter non standard report type is passed as null

989: p_non_std_rpt_type VARCHAR2(20);
990: BEGIN
991:
992: igs_ge_gen_003.set_org_id(NULL);
993: -- If the parameter non standard report type is passed as null
994: -- then it is assigned with a value 'Y'
995: IF p_non_std_rpt_typ IS NULL THEN
996: p_non_std_rpt_type := 'Y';
997: ELSE

Line 1047: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string

1043: Who When What
1044: (reverse chronological order - newest change first)
1045: ckasu 17-JAN-2006 Added igs_ge_gen_003.set_org_id(NULL) as a part of bug#4958173.
1046: ***************************************************************/
1047: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
1048: retcode OUT NOCOPY NUMBER , -- Request standard return status
1049: p_comment IN VARCHAR2, -- Runtime comments
1050: p_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE , -- Snapshot Id to delete
1051: p_debug_mode IN VARCHAR2 := FND_API.G_FALSE

Line 1048: retcode OUT NOCOPY NUMBER , -- Request standard return status

1044: (reverse chronological order - newest change first)
1045: ckasu 17-JAN-2006 Added igs_ge_gen_003.set_org_id(NULL) as a part of bug#4958173.
1046: ***************************************************************/
1047: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
1048: retcode OUT NOCOPY NUMBER , -- Request standard return status
1049: p_comment IN VARCHAR2, -- Runtime comments
1050: p_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE , -- Snapshot Id to delete
1051: p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
1052: )IS

Line 1913: The cursor fetches all course attemmpts if run in standard mode

1909: c_outcome_dt_rec c_outcome_dt%ROWTYPE;
1910:
1911:
1912: /* List of all course attempts for the person.
1913: The cursor fetches all course attemmpts if run in standard mode
1914: and only completed program attempts if run in non standard
1915: Also takes into account the career profile of the university*/
1916:
1917: CURSOR c_stud_courses(cp_nslc_condition VARCHAR2,cp_career_profile VARCHAR2,cp_grad_type VARCHAR2,p_s_date DATE,p_e_date DATE) IS

Line 1914: and only completed program attempts if run in non standard

1910:
1911:
1912: /* List of all course attempts for the person.
1913: The cursor fetches all course attemmpts if run in standard mode
1914: and only completed program attempts if run in non standard
1915: Also takes into account the career profile of the university*/
1916:
1917: CURSOR c_stud_courses(cp_nslc_condition VARCHAR2,cp_career_profile VARCHAR2,cp_grad_type VARCHAR2,p_s_date DATE,p_e_date DATE) IS
1918: SELECT pr.course_cd,