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.IGF_AW_ROLLOVER dependencies on IGF_AP_TD_ITEM_MST

Line 29: p_todo_item OUT NOCOPY igf_ap_td_item_mst_all.item_code%TYPE

25: p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
26: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
27: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
28: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
29: p_todo_item OUT NOCOPY igf_ap_td_item_mst_all.item_code%TYPE
30: )
31: RETURN BOOLEAN IS
32: --------------------------------------------------------------------------------
33: -- Created by : ridas, Oracle India

Line 45: FROM igf_ap_td_item_mst_all mst,

41: --Cursor to fetch the todo details attached to the fund id
42: CURSOR c_get_fund_todo ( cp_ref_fund_id igf_aw_fund_excl_all.fund_id%TYPE
43: ) IS
44: SELECT DISTINCT mst.*
45: FROM igf_ap_td_item_mst_all mst,
46: igf_aw_fund_td_map_all map
47: WHERE map.fund_id = cp_ref_fund_id
48: AND map.item_sequence_number = mst.todo_number;
49:

Line 59: igf_ap_td_item_mst_all tdm

55: ) IS
56: SELECT tdm.item_code,
57: tdm.career_item
58: FROM igf_aw_fund_td_map_all ftodo,
59: igf_ap_td_item_mst_all tdm
60: WHERE tdm.todo_number = ftodo.item_sequence_number
61: AND ftodo.fund_id = cp_ref_fund_id;
62:
63: l_fund_td c_fund_td%ROWTYPE;

Line 67: CURSOR c_get_cr_td_number( cp_item_code igf_ap_td_item_mst_all.item_code%TYPE

63: l_fund_td c_fund_td%ROWTYPE;
64:
65:
66: --Cursor to fetch the todo number of a career item code
67: CURSOR c_get_cr_td_number( cp_item_code igf_ap_td_item_mst_all.item_code%TYPE
68: ) IS
69: SELECT todo_number
70: FROM igf_ap_td_item_mst_all
71: WHERE ci_cal_type IS NULL

Line 70: FROM igf_ap_td_item_mst_all

66: --Cursor to fetch the todo number of a career item code
67: CURSOR c_get_cr_td_number( cp_item_code igf_ap_td_item_mst_all.item_code%TYPE
68: ) IS
69: SELECT todo_number
70: FROM igf_ap_td_item_mst_all
71: WHERE ci_cal_type IS NULL
72: AND ci_sequence_number IS NULL
73: AND item_code = cp_item_code
74: AND NVL(career_item,'N') = 'Y';

Line 80: cp_item_code igf_ap_td_item_mst_all.item_code%TYPE

76:
77: --Cursor to fetch the todo number of an item code for the To Award Year
78: CURSOR c_get_td_number( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
79: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
80: cp_item_code igf_ap_td_item_mst_all.item_code%TYPE
81: ) IS
82: SELECT todo_number
83: FROM igf_ap_td_item_mst_all
84: WHERE item_code = cp_item_code

Line 83: FROM igf_ap_td_item_mst_all

79: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
80: cp_item_code igf_ap_td_item_mst_all.item_code%TYPE
81: ) IS
82: SELECT todo_number
83: FROM igf_ap_td_item_mst_all
84: WHERE item_code = cp_item_code
85: AND ci_cal_type = cp_to_cal_type
86: AND ci_sequence_number = cp_to_sequence_number
87: AND NVL(career_item,'N') = 'N';

Line 91: l_todo_number igf_ap_td_item_mst.todo_number%TYPE;

87: AND NVL(career_item,'N') = 'N';
88:
89:
90: l_rowid VARCHAR2(25);
91: l_todo_number igf_ap_td_item_mst.todo_number%TYPE;
92: l_ftodo_id igf_aw_fund_td_map.ftodo_id%TYPE;
93: l_item_sequence_number igf_aw_fund_td_map_all.item_sequence_number%TYPE;
94: l_todo_item igf_ap_td_item_mst_all.item_code%TYPE := NULL;
95: lv_return_flg VARCHAR2(1);

Line 94: l_todo_item igf_ap_td_item_mst_all.item_code%TYPE := NULL;

90: l_rowid VARCHAR2(25);
91: l_todo_number igf_ap_td_item_mst.todo_number%TYPE;
92: l_ftodo_id igf_aw_fund_td_map.ftodo_id%TYPE;
93: l_item_sequence_number igf_aw_fund_td_map_all.item_sequence_number%TYPE;
94: l_todo_item igf_ap_td_item_mst_all.item_code%TYPE := NULL;
95: lv_return_flg VARCHAR2(1);
96:
97: BEGIN
98:

Line 111: igf_ap_td_item_mst_pkg.insert_row(

107: l_rowid := NULL;
108: l_todo_number := NULL;
109:
110: BEGIN
111: igf_ap_td_item_mst_pkg.insert_row(
112: x_rowid => l_rowid,
113: x_todo_number => l_todo_number,
114: x_item_code => l_get_fund_todo.item_code,
115: x_ci_cal_type => p_to_cal_type,

Line 773: l_todo_item igf_ap_td_item_mst_all.item_code%TYPE;

769: E_SKIP_FUND EXCEPTION;
770: l_pay_program igf_aw_fund_prg_all.course_cd%TYPE;
771: l_pay_unit igf_aw_fund_unit_all.unit_cd%TYPE;
772: l_fee_class igf_aw_fund_feeclas_all.fee_class%TYPE;
773: l_todo_item igf_ap_td_item_mst_all.item_code%TYPE;
774: l_inclusive_fund igf_aw_fund_mast_all.fund_code%TYPE;
775: l_exclusive_fund igf_aw_fund_mast_all.fund_code%TYPE;
776: l_discontinued_flg VARCHAR2(1) := 'N';
777:

Line 2106: FROM igf_ap_td_item_mst_all todo

2102: CURSOR c_todo_item_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2103: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
2104: ) IS
2105: SELECT todo.*
2106: FROM igf_ap_td_item_mst_all todo
2107: WHERE todo.ci_cal_type = cp_frm_cal_type
2108: AND todo.ci_sequence_number = cp_frm_sequence_number
2109: ORDER BY todo.item_code;
2110:

Line 2114: cp_item_code igf_ap_td_item_mst_all.item_code%TYPE

2110:
2111: -- Check whether the todo item already got rolled over or not
2112: CURSOR c_todo_exists(cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
2113: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2114: cp_item_code igf_ap_td_item_mst_all.item_code%TYPE
2115: ) IS
2116: SELECT 'X' exist
2117: FROM igf_ap_td_item_mst_all todo
2118: WHERE todo.ci_cal_type = cp_to_cal_type

Line 2117: FROM igf_ap_td_item_mst_all todo

2113: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2114: cp_item_code igf_ap_td_item_mst_all.item_code%TYPE
2115: ) IS
2116: SELECT 'X' exist
2117: FROM igf_ap_td_item_mst_all todo
2118: WHERE todo.ci_cal_type = cp_to_cal_type
2119: AND todo.ci_sequence_number = cp_to_sequence_number
2120: AND todo.item_code = cp_item_code;
2121:

Line 2127: l_todo_number igf_ap_td_item_mst_all.todo_number%TYPE;

2123:
2124: l_to_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
2125: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2126: l_rowid VARCHAR2(25):= NULL;
2127: l_todo_number igf_ap_td_item_mst_all.todo_number%TYPE;
2128: E_SKIP_TODO EXCEPTION;
2129: lv_return_flg VARCHAR2(1);
2130:
2131: BEGIN

Line 2174: igf_ap_td_item_mst_pkg.insert_row (

2170:
2171: l_rowid := NULL;
2172: l_todo_number := NULL;
2173: --insert into the To Do Items table
2174: igf_ap_td_item_mst_pkg.insert_row (
2175: x_rowid => l_rowid,
2176: x_todo_number => l_todo_number,
2177: x_item_code => l_todo_item_setup.item_code,
2178: x_ci_cal_type => p_to_cal_type,