APPS.IGF_AP_INST_APP dependencies on IGF_AP_APPL_STATUS_ALL

Line 6: p_application_code igf_ap_appl_status_all.application_code%TYPE,

2: /* $Header: IGFAP50B.pls 120.0 2005/09/09 17:14:44 appldev noship $ */
3:
4:
5: PROCEDURE update_ToDo_status(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
6: p_application_code igf_ap_appl_status_all.application_code%TYPE,
7: x_return_status OUT NOCOPY VARCHAR2)
8: IS
9: ------------------------------------------------------------------
10: --Created by : upinjark, Oracle India

Line 24: cp_application_code igf_ap_appl_status_all.application_code%TYPE)

20: -------------------------------------------------------------------
21:
22: --Cursor to fetch to do item
23: CURSOR c_td_item (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
24: cp_application_code igf_ap_appl_status_all.application_code%TYPE)
25: IS
26: SELECT tdmst.todo_number
27: FROM igf_ap_td_item_inst_all tdinst, igf_ap_td_item_mst_all tdmst, Igf_ap_fa_base_rec_all baseRec
28: WHERE tdmst.system_todo_type_code = 'INSTAPP'

Line 75: p_application_code igf_ap_appl_status_all.application_code%TYPE,

71:
72: END update_ToDo_status;
73:
74: PROCEDURE update_ToDo (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
75: p_application_code igf_ap_appl_status_all.application_code%TYPE,
76: p_status IN igf_ap_td_item_inst_all.status%TYPE,
77: x_return_status OUT NOCOPY VARCHAR2)
78: IS
79: ------------------------------------------------------------------

Line 94: cp_application_code igf_ap_appl_status_all.application_code%TYPE)

90: -------------------------------------------------------------------
91:
92: --Cursor to fetch to do item
93: CURSOR c_td_item (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
94: cp_application_code igf_ap_appl_status_all.application_code%TYPE)
95: IS
96: SELECT tdmst.todo_number
97: FROM igf_ap_td_item_inst_all tdinst, igf_ap_td_item_mst_all tdmst, Igf_ap_fa_base_rec_all baseRec
98: WHERE tdmst.system_todo_type_code = 'INSTAPP'

Line 147: p_application_code igf_ap_appl_status_all.application_code%TYPE,

143:
144:
145:
146: PROCEDURE update_app_status(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
147: p_application_code igf_ap_appl_status_all.application_code%TYPE,
148: p_application_status_code igf_ap_appl_status_all.application_status_code%TYPE,
149: x_return_status OUT NOCOPY VARCHAR2)
150: IS
151: ------------------------------------------------------------------

Line 148: p_application_status_code igf_ap_appl_status_all.application_status_code%TYPE,

144:
145:
146: PROCEDURE update_app_status(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
147: p_application_code igf_ap_appl_status_all.application_code%TYPE,
148: p_application_status_code igf_ap_appl_status_all.application_status_code%TYPE,
149: x_return_status OUT NOCOPY VARCHAR2)
150: IS
151: ------------------------------------------------------------------
152: --Created by : upinjark, Oracle India

Line 166: cp_application_code igf_ap_appl_status_all.application_code%TYPE

162: -------------------------------------------------------------------
163:
164: -- cursor to get the row from application status table
165: CURSOR c_appl_status (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
166: cp_application_code igf_ap_appl_status_all.application_code%TYPE
167: ) IS
168: SELECT rowid
169: FROM IGF_AP_APPL_STATUS_ALL aps
170: WHERE BASE_ID = cp_base_id

Line 169: FROM IGF_AP_APPL_STATUS_ALL aps

165: CURSOR c_appl_status (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
166: cp_application_code igf_ap_appl_status_all.application_code%TYPE
167: ) IS
168: SELECT rowid
169: FROM IGF_AP_APPL_STATUS_ALL aps
170: WHERE BASE_ID = cp_base_id
171: AND APPLICATION_CODE = cp_application_code;
172:
173: l_appl_status c_appl_status%ROWTYPE;

Line 179: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_inst_app.update_app_status.debug','calling igf_ap_appl_status_all_pkg.update_row');

175: BEGIN
176: x_return_status := 'F';
177:
178: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
179: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_inst_app.update_app_status.debug','calling igf_ap_appl_status_all_pkg.update_row');
180: END IF;
181:
182:
183: OPEN c_appl_status(p_base_id, p_application_code);

Line 559: p_application_code igf_ap_appl_status_all.application_code%TYPE,

555: END update_Ant_Data_a_Term;
556:
557:
558: PROCEDURE raise_event_on_IA_submit (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
559: p_application_code igf_ap_appl_status_all.application_code%TYPE,
560: x_return_status OUT NOCOPY VARCHAR2)
561: IS
562: ------------------------------------------------------------------
563: --Created by : upinjark, Oracle India