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_AP_VER_GRPS_PRC_PKG dependencies on IGF_AP_INST_VER_ITEM

Line 10: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,

6: PROCEDURE log_input_params( p_awd_cal_type IN igs_ca_inst.cal_type%TYPE ,
7: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE ,
8: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
9: p_prs_grp_id IN VARCHAR2 ,
10: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
11: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
12: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
13: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
14: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 63: cp_isir_field igf_ap_inst_ver_item.isir_map_col%TYPE,

59:
60: -- Get Verification Item Descrition
61: CURSOR c_get_verif_item (cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
62: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ,
63: cp_isir_field igf_ap_inst_ver_item.isir_map_col%TYPE,
64: cp_lkup_type VARCHAR2 ) IS
65: SELECT lkup.meaning meaning
66: FROM igf_ap_batch_aw_map map,
67: Igf_fc_sar_cd_mst sar ,

Line 321: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE

317: END log_input_params ;
318:
319:
320: FUNCTION dup_ver_item ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
321: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE
322: ) RETURN BOOLEAN AS
323:
324: /*
325: || Created By : masehgal

Line 334: -- cursor to select existing record from igf_ap_inst_ver_item for a particular base_id and isir_map_col

330: || Who When What
331: || (reverse chronological order - newest change first)
332: */
333:
334: -- cursor to select existing record from igf_ap_inst_ver_item for a particular base_id and isir_map_col
335: CURSOR c_ver_item_exists ( cp_base_id igf_ap_inst_ver_item.base_id%TYPE ,
336: cp_isir_field igf_ap_inst_ver_item.isir_map_col%TYPE
337: ) IS
338: SELECT 1

Line 335: CURSOR c_ver_item_exists ( cp_base_id igf_ap_inst_ver_item.base_id%TYPE ,

331: || (reverse chronological order - newest change first)
332: */
333:
334: -- cursor to select existing record from igf_ap_inst_ver_item for a particular base_id and isir_map_col
335: CURSOR c_ver_item_exists ( cp_base_id igf_ap_inst_ver_item.base_id%TYPE ,
336: cp_isir_field igf_ap_inst_ver_item.isir_map_col%TYPE
337: ) IS
338: SELECT 1
339: FROM igf_ap_inst_ver_item

Line 336: cp_isir_field igf_ap_inst_ver_item.isir_map_col%TYPE

332: */
333:
334: -- cursor to select existing record from igf_ap_inst_ver_item for a particular base_id and isir_map_col
335: CURSOR c_ver_item_exists ( cp_base_id igf_ap_inst_ver_item.base_id%TYPE ,
336: cp_isir_field igf_ap_inst_ver_item.isir_map_col%TYPE
337: ) IS
338: SELECT 1
339: FROM igf_ap_inst_ver_item
340: WHERE base_id = cp_base_id

Line 339: FROM igf_ap_inst_ver_item

335: CURSOR c_ver_item_exists ( cp_base_id igf_ap_inst_ver_item.base_id%TYPE ,
336: cp_isir_field igf_ap_inst_ver_item.isir_map_col%TYPE
337: ) IS
338: SELECT 1
339: FROM igf_ap_inst_ver_item
340: WHERE base_id = cp_base_id
341: AND isir_map_col = cp_isir_field ;
342:
343: ver_item_exists_rec c_ver_item_exists%ROWTYPE ;

Line 373: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,

369: FUNCTION add_ver_item(
370: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
371: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE ,
372: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE ,
373: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
374: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
375: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
376: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
377: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 398: || igf_ap_inst_ver_item_pkg.insert_row

394: || Known limitations, enhancements or remarks :
395: || Change History :
396: || Who When What
397: || rasahoo 17-Oct-2003 #3085558 FA121 Added parameter use_blank_flag in
398: || igf_ap_inst_ver_item_pkg.insert_row
399: || masehgal 21-May-2003 #2885882 FACR113 SAR Updates
400: || Changed cursors for SAR Number updates
401: || masehgal 22-Oct-2002 Added message to show duplicate ver item rather
402: || than eding the process as an error

Line 410: lv_isir_field igf_ap_inst_ver_item.isir_map_col%TYPE,

406: lv_rowid ROWID := NULL ;
407: lv_meaning igf_lookups_view.meaning%TYPE;
408: l_isir_map_col igf_fc_sar_cd_mst.sar_field_number%TYPE;
409: CURSOR cur_isir_desc (cp_base_id igf_ap_fa_base_rec.base_id%TYPE ,
410: lv_isir_field igf_ap_inst_ver_item.isir_map_col%TYPE,
411: cp_lkup_type VARCHAR2 ) IS
412: SELECT sar.sar_field_number isir_map_col, lkup.meaning meaning
413: FROM igf_ap_batch_aw_map map,
414: igf_ap_fa_base_rec_all fabase,

Line 442: -- Insert in IGF_AP_INST_VER_ITEM Table

438: -- check for dup_ver_item
439: IF NOT (dup_ver_item ( p_base_id => p_base_id ,
440: p_isir_field => l_isir_map_col ) ) THEN
441:
442: -- Insert in IGF_AP_INST_VER_ITEM Table
443: igf_ap_inst_ver_item_pkg.insert_row
444: (
445: X_ROWID => lv_rowid ,
446: X_BASE_ID => p_base_id ,

Line 443: igf_ap_inst_ver_item_pkg.insert_row

439: IF NOT (dup_ver_item ( p_base_id => p_base_id ,
440: p_isir_field => l_isir_map_col ) ) THEN
441:
442: -- Insert in IGF_AP_INST_VER_ITEM Table
443: igf_ap_inst_ver_item_pkg.insert_row
444: (
445: X_ROWID => lv_rowid ,
446: X_BASE_ID => p_base_id ,
447: X_UDF_VERN_ITEM_SEQ_NUM => NULL ,

Line 534: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE,

530: retcode OUT NOCOPY NUMBER,
531: p_awd_yr IN VARCHAR2,
532: p_prs_grp_id IN igs_pe_prsid_grp_mem.group_id%TYPE,
533: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
534: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE,
535: p_item_1 IN igf_ap_td_item_mst_all.todo_number%TYPE,
536: p_item_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
537: p_item_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
538: p_item_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,