APPS.IGS_PS_GEN_003 dependencies on IGS_PS_OFR_OPT

Line 52: gv_cd_and_vn_passed IGS_PS_OFR_OPT.coo_id%TYPE;

48: lv_param_values VARCHAR2(1080);
49: BEGIN
50: DECLARE
51:
52: gv_cd_and_vn_passed IGS_PS_OFR_OPT.coo_id%TYPE;
53: gv_coo_id_passed IGS_PS_OFR_OPT%ROWTYPE;
54: -- this is used when the course_cd and version_number
55: -- are passed
56: CURSOR gc_cd_and_vn_passed IS

Line 53: gv_coo_id_passed IGS_PS_OFR_OPT%ROWTYPE;

49: BEGIN
50: DECLARE
51:
52: gv_cd_and_vn_passed IGS_PS_OFR_OPT.coo_id%TYPE;
53: gv_coo_id_passed IGS_PS_OFR_OPT%ROWTYPE;
54: -- this is used when the course_cd and version_number
55: -- are passed
56: CURSOR gc_cd_and_vn_passed IS
57: SELECT coo_id

Line 58: FROM IGS_PS_OFR_OPT

54: -- this is used when the course_cd and version_number
55: -- are passed
56: CURSOR gc_cd_and_vn_passed IS
57: SELECT coo_id
58: FROM IGS_PS_OFR_OPT
59: WHERE course_cd = p_course_cd AND
60: version_number = p_version_number AND
61: cal_type = p_cal_type AND
62: location_cd = p_location_cd AND

Line 69: FROM IGS_PS_OFR_OPT

65: delete_flag = 'N';
66: -- this is used when the coo_id is passed
67: CURSOR gc_coo_id_passed IS
68: SELECT *
69: FROM IGS_PS_OFR_OPT
70: WHERE coo_id = p_coo_id
71: AND delete_flag = 'N';
72: BEGIN
73: -- if only the course_cd was enetered