APPS.IGF_AP_TODO_GRPS_PRC_PKG dependencies on IGF_AP_TD_ITEM_INST_PKG

Line 32: | igf_ap_td_item_inst_pkg.insert_row

28: | all parameters made optional now |
29: | bkkumar 04-jun-2003 Bug #2858504
30: | Added legacy_record_flag
31: | in the table handler calls for
32: | igf_ap_td_item_inst_pkg.insert_row
33: | rasingh 09-Jan-2003 Bug 2738442, Message IGF_AP_INVALID_QUERY |
34: | added |
35: | brajendr 19-OCT-2002 Bug # 2632359 |
36: | Modified the Log file contents with |

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 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,