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_TODO_GRPS_PRC_PKG dependencies on IGF_AP_TD_ITEM_INST

Line 32: | igf_ap_td_item_inst_pkg.insert_row

Line 45: | igf_ap_td_item_inst_pkg.insert_row |

41: | Modified the Messages IGF_AP_NO_BASEID |
42: | bkkumar 04-jun-2003 Bug #2858504 |
43: | Added legacy_record_flag |
44: | in the table handler calls for |
45: | igf_ap_td_item_inst_pkg.insert_row |
46: | gvarapra 13-sep-2004 Added the validation to auto update the |
47: | To Do Item status that are attached to the |
48: | system to do type of ISIR or PROFILE. |
49: *=======================================================================*/

Line 420: p_status IN igf_ap_td_item_inst_all.status%TYPE,

416: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
417: p_todo_number IN igf_ap_td_item_mst_all.todo_number%TYPE,
418: p_item_cnt IN NUMBER,
419: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
420: p_status IN igf_ap_td_item_inst_all.status%TYPE,
421: p_upd_mode IN VARCHAR2
422: ) AS
423: /*
424: || Created By : brajendr

Line 452: igf_ap_td_item_inst inst,

448: cp_todo_number igf_ap_td_item_mst.todo_number%TYPE
449: ) IS
450: SELECT 1 value, fab.base_id base_id
451: FROM igf_ap_fa_base_rec fab,
452: igf_ap_td_item_inst inst,
453: igf_ap_td_item_mst mst
454: WHERE fab.person_id = cp_person_id
455: AND mst.todo_number = cp_todo_number
456: AND mst.career_item = 'Y'

Line 463: cp_item_sequence_number igf_ap_td_item_inst_all.item_sequence_number%TYPE

459:
460: --FA 140 - To Avoid skipping of items if already present. Need to update
461: CURSOR c_to_do_item (
462: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
463: cp_item_sequence_number igf_ap_td_item_inst_all.item_sequence_number%TYPE
464: ) IS
465: SELECT item_inst.ROWID row_id, item_inst.*
466: FROM igf_ap_td_item_inst_all item_inst
467: WHERE base_id = cp_base_id

Line 466: FROM igf_ap_td_item_inst_all item_inst

462: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
463: cp_item_sequence_number igf_ap_td_item_inst_all.item_sequence_number%TYPE
464: ) IS
465: SELECT item_inst.ROWID row_id, item_inst.*
466: FROM igf_ap_td_item_inst_all item_inst
467: WHERE base_id = cp_base_id
468: AND item_sequence_number = cp_item_sequence_number;
469:
470: CURSOR c_check_preflender(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS

Line 482: l_status igf_ap_td_item_inst_all.status%TYPE := 'REQ';

478: lc_item_details c_item_details%ROWTYPE;
479: lc_chk_career_exists c_chk_career_exists%ROWTYPE;
480: lv_rowid ROWID;
481: lb_item_present BOOLEAN := FALSE;
482: l_status igf_ap_td_item_inst_all.status%TYPE := 'REQ';
483:
484: lc_check_preflender c_check_preflender%ROWTYPE;
485: lc_to_do_item c_to_do_item%ROWTYPE;
486: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

Line 601: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','calling igf_ap_td_item_inst_pkg.update_row with base_id/item_seq_number:'||lc_to_do_item.base_id||'/'||lc_to_do_item.item_sequence_number);

597: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_upd_mode:'||p_todo_number||' and lc_to_do_item.status:'||lc_to_do_item.status);
598: END IF;
599: IF p_upd_mode = 'UPD' OR (p_upd_mode = 'NO_UPD_IF_COMP' AND lc_to_do_item.status <> 'COM') THEN
600: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
601: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','calling igf_ap_td_item_inst_pkg.update_row with base_id/item_seq_number:'||lc_to_do_item.base_id||'/'||lc_to_do_item.item_sequence_number);
602: END IF;
603: igf_ap_td_item_inst_pkg.update_row (
604: x_mode => 'R',
605: x_rowid => lc_to_do_item.row_id,

Line 603: igf_ap_td_item_inst_pkg.update_row (

599: IF p_upd_mode = 'UPD' OR (p_upd_mode = 'NO_UPD_IF_COMP' AND lc_to_do_item.status <> 'COM') THEN
600: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
601: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','calling igf_ap_td_item_inst_pkg.update_row with base_id/item_seq_number:'||lc_to_do_item.base_id||'/'||lc_to_do_item.item_sequence_number);
602: END IF;
603: igf_ap_td_item_inst_pkg.update_row (
604: x_mode => 'R',
605: x_rowid => lc_to_do_item.row_id,
606: x_base_id => lc_to_do_item.base_id,
607: x_item_sequence_number => lc_to_do_item.item_sequence_number,

Line 629: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','calling igf_ap_td_item_inst_pkg.insert_row with base_id/item_seq_number:'||l_base_id||'/'||p_todo_number);

625: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
626: END IF;
627: ELSIF lb_item_present = FALSE THEN
628: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
629: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','calling igf_ap_td_item_inst_pkg.insert_row with base_id/item_seq_number:'||l_base_id||'/'||p_todo_number);
630: END IF;
631: igf_ap_td_item_inst_pkg.insert_row (
632: x_mode => 'R',
633: x_rowid => lv_rowid,

Line 631: igf_ap_td_item_inst_pkg.insert_row (

627: ELSIF lb_item_present = FALSE THEN
628: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
629: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','calling igf_ap_td_item_inst_pkg.insert_row with base_id/item_seq_number:'||l_base_id||'/'||p_todo_number);
630: END IF;
631: igf_ap_td_item_inst_pkg.insert_row (
632: x_mode => 'R',
633: x_rowid => lv_rowid,
634: x_base_id => l_base_id,
635: x_item_sequence_number => p_todo_number,

Line 672: p_status_1 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

668: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE,
669: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE,
670: p_upd_mode IN VARCHAR2,
671: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE,
672: p_status_1 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
673: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
674: p_status_2 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
675: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
676: p_status_3 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

Line 674: p_status_2 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

670: p_upd_mode IN VARCHAR2,
671: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE,
672: p_status_1 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
673: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
674: p_status_2 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
675: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
676: p_status_3 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
677: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
678: p_status_4 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

Line 676: p_status_3 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

672: p_status_1 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
673: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
674: p_status_2 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
675: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
676: p_status_3 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
677: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
678: p_status_4 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
679: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
680: p_status_5 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

Line 678: p_status_4 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

674: p_status_2 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
675: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
676: p_status_3 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
677: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
678: p_status_4 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
679: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
680: p_status_5 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
681: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
682: p_status_6 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

Line 680: p_status_5 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

676: p_status_3 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
677: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
678: p_status_4 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
679: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
680: p_status_5 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
681: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
682: p_status_6 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
683: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
684: p_status_7 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

Line 682: p_status_6 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

678: p_status_4 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
679: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
680: p_status_5 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
681: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
682: p_status_6 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
683: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
684: p_status_7 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
685: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
686: p_status_8 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

Line 684: p_status_7 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

680: p_status_5 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
681: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
682: p_status_6 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
683: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
684: p_status_7 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
685: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
686: p_status_8 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
687: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
688: p_status_9 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

Line 686: p_status_8 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

682: p_status_6 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
683: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
684: p_status_7 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
685: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
686: p_status_8 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
687: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
688: p_status_9 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
689: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
690: p_status_10 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

Line 688: p_status_9 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

684: p_status_7 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
685: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
686: p_status_8 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
687: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
688: p_status_9 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
689: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
690: p_status_10 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
691: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
692: p_status_11 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

Line 690: p_status_10 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

686: p_status_8 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
687: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
688: p_status_9 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
689: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
690: p_status_10 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
691: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
692: p_status_11 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
693: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
694: p_status_12 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

Line 692: p_status_11 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

688: p_status_9 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
689: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
690: p_status_10 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
691: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
692: p_status_11 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
693: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
694: p_status_12 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
695: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,
696: p_status_13 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

Line 694: p_status_12 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

690: p_status_10 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
691: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
692: p_status_11 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
693: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
694: p_status_12 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
695: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,
696: p_status_13 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
697: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,
698: p_status_14 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

Line 696: p_status_13 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

692: p_status_11 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
693: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
694: p_status_12 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
695: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,
696: p_status_13 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
697: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,
698: p_status_14 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
699: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE,
700: p_status_15 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

Line 698: p_status_14 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

694: p_status_12 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
695: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,
696: p_status_13 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
697: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,
698: p_status_14 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
699: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE,
700: p_status_15 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
701: p_calling_from IN VARCHAR2
702: ) RETURN BOOLEAN AS

Line 700: p_status_15 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

696: p_status_13 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
697: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,
698: p_status_14 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
699: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE,
700: p_status_15 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
701: p_calling_from IN VARCHAR2
702: ) RETURN BOOLEAN AS
703: /*
704: || Created By : brajendr