APPS.IGF_AW_COA_UPDATE dependencies on IGS_PE_STD_TODO

Line 27: c_person_id igs_pe_std_todo_ref.person_id%TYPE,

23: --Cursor to fetch persons from todo ref table
24: CURSOR c_person_ref(
25: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
26: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
27: c_person_id igs_pe_std_todo_ref.person_id%TYPE,
28: c_s_student_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,
29: c_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE
30: ) IS
31: SELECT tref.rowid row_id,

Line 28: c_s_student_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,

24: CURSOR c_person_ref(
25: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
26: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
27: c_person_id igs_pe_std_todo_ref.person_id%TYPE,
28: c_s_student_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,
29: c_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE
30: ) IS
31: SELECT tref.rowid row_id,
32: tref.*

Line 29: c_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE

25: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
26: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
27: c_person_id igs_pe_std_todo_ref.person_id%TYPE,
28: c_s_student_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,
29: c_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE
30: ) IS
31: SELECT tref.rowid row_id,
32: tref.*
33: FROM igs_pe_std_todo_ref tref

Line 33: FROM igs_pe_std_todo_ref tref

29: c_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE
30: ) IS
31: SELECT tref.rowid row_id,
32: tref.*
33: FROM igs_pe_std_todo_ref tref
34: WHERE tref.person_id = c_person_id
35: AND tref.s_student_todo_type = c_s_student_todo_type
36: AND tref.sequence_number = c_sequence_number
37: AND tref.cal_type = c_ci_cal_type

Line 45: c_person_id igs_pe_std_todo.person_id%TYPE,

41:
42:
43: --Cursor to fetch persons from todo table
44: CURSOR c_person_todo(
45: c_person_id igs_pe_std_todo.person_id%TYPE,
46: c_s_student_todo_type igs_pe_std_todo.s_student_todo_type%TYPE,
47: c_sequence_number igs_pe_std_todo.sequence_number%TYPE
48: ) IS
49: SELECT todo.rowid row_id,

Line 46: c_s_student_todo_type igs_pe_std_todo.s_student_todo_type%TYPE,

42:
43: --Cursor to fetch persons from todo table
44: CURSOR c_person_todo(
45: c_person_id igs_pe_std_todo.person_id%TYPE,
46: c_s_student_todo_type igs_pe_std_todo.s_student_todo_type%TYPE,
47: c_sequence_number igs_pe_std_todo.sequence_number%TYPE
48: ) IS
49: SELECT todo.rowid row_id,
50: todo.*

Line 47: c_sequence_number igs_pe_std_todo.sequence_number%TYPE

43: --Cursor to fetch persons from todo table
44: CURSOR c_person_todo(
45: c_person_id igs_pe_std_todo.person_id%TYPE,
46: c_s_student_todo_type igs_pe_std_todo.s_student_todo_type%TYPE,
47: c_sequence_number igs_pe_std_todo.sequence_number%TYPE
48: ) IS
49: SELECT todo.rowid row_id,
50: todo.*
51: FROM igs_pe_std_todo todo

Line 51: FROM igs_pe_std_todo todo

47: c_sequence_number igs_pe_std_todo.sequence_number%TYPE
48: ) IS
49: SELECT todo.rowid row_id,
50: todo.*
51: FROM igs_pe_std_todo todo
52: WHERE todo.person_id = c_person_id
53: AND todo.s_student_todo_type = c_s_student_todo_type
54: AND todo.sequence_number = c_sequence_number
55: AND todo.logical_delete_dt IS NULL

Line 60: FROM igs_pe_std_todo_ref tref

56: AND NOT EXISTS
57: (SELECT tref.person_id,
58: tref.s_student_todo_type,
59: tref.sequence_number
60: FROM igs_pe_std_todo_ref tref
61: WHERE tref.person_id = todo.person_id
62: AND tref.s_student_todo_type = todo.s_student_todo_type
63: AND tref.sequence_number = todo.sequence_number
64: AND tref.s_student_todo_type = 'IGF_COA_COMP'

Line 80: FROM igs_pe_std_todo todo,

76: ) IS
77: SELECT distinct todo.person_id,
78: todo.s_student_todo_type,
79: todo.sequence_number
80: FROM igs_pe_std_todo todo,
81: igs_pe_std_todo_ref tref
82: WHERE todo.person_id = c_person_id
83: AND tref.person_id = todo.person_id
84: AND tref.s_student_todo_type = todo.s_student_todo_type

Line 81: igs_pe_std_todo_ref tref

77: SELECT distinct todo.person_id,
78: todo.s_student_todo_type,
79: todo.sequence_number
80: FROM igs_pe_std_todo todo,
81: igs_pe_std_todo_ref tref
82: WHERE todo.person_id = c_person_id
83: AND tref.person_id = todo.person_id
84: AND tref.s_student_todo_type = todo.s_student_todo_type
85: AND tref.sequence_number = todo.sequence_number

Line 125: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.update_to_do_items.debug','Updating table igs_pe_std_todo for person id: '||l_person_dtls.person_id);

121: IF l_person_dtls.person_id IS NOT NULL THEN
122: FOR l_person_ref IN c_person_ref(p_ci_cal_type,p_ci_sequence_number,l_person_dtls.person_id,l_person_dtls.s_student_todo_type,l_person_dtls.sequence_number)
123: LOOP
124: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
125: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.update_to_do_items.debug','Updating table igs_pe_std_todo for person id: '||l_person_dtls.person_id);
126: END IF;
127:
128: igs_pe_std_todo_ref_pkg.update_row(
129: x_rowid => l_person_ref.row_id,

Line 128: igs_pe_std_todo_ref_pkg.update_row(

124: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
125: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.update_to_do_items.debug','Updating table igs_pe_std_todo for person id: '||l_person_dtls.person_id);
126: END IF;
127:
128: igs_pe_std_todo_ref_pkg.update_row(
129: x_rowid => l_person_ref.row_id,
130: x_person_id => l_person_ref.person_id,
131: x_s_student_todo_type => l_person_ref.s_student_todo_type,
132: x_sequence_number => l_person_ref.sequence_number,

Line 154: igs_pe_std_todo_pkg.update_row(

150: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.update_to_do_items.debug','c_person_todo%FOUND');
152: END IF;
153:
154: igs_pe_std_todo_pkg.update_row(
155: x_rowid => l_person_todo.row_id,
156: x_person_id => l_person_todo.person_id,
157: x_s_student_todo_type => l_person_todo.s_student_todo_type,
158: x_sequence_number => l_person_todo.sequence_number,

Line 793: FROM igs_pe_std_todo todo,

789: ) IS
790: SELECT distinct todo.person_id,
791: todo.s_student_todo_type,
792: todo.sequence_number
793: FROM igs_pe_std_todo todo,
794: igs_pe_std_todo_ref tref
795: WHERE tref.person_id = todo.person_id
796: AND tref.s_student_todo_type = todo.s_student_todo_type
797: AND tref.sequence_number = todo.sequence_number

Line 794: igs_pe_std_todo_ref tref

790: SELECT distinct todo.person_id,
791: todo.s_student_todo_type,
792: todo.sequence_number
793: FROM igs_pe_std_todo todo,
794: igs_pe_std_todo_ref tref
795: WHERE tref.person_id = todo.person_id
796: AND tref.s_student_todo_type = todo.s_student_todo_type
797: AND tref.sequence_number = todo.sequence_number
798: AND tref.cal_type = c_ci_cal_type

Line 809: c_person_id igs_pe_std_todo_ref.person_id%TYPE,

805: --Cursor to fetch persons from todo ref table
806: CURSOR c_person_ref(
807: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
808: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
809: c_person_id igs_pe_std_todo_ref.person_id%TYPE,
810: c_s_student_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,
811: c_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE
812: ) IS
813: SELECT tref.rowid row_id,

Line 810: c_s_student_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,

806: CURSOR c_person_ref(
807: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
808: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
809: c_person_id igs_pe_std_todo_ref.person_id%TYPE,
810: c_s_student_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,
811: c_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE
812: ) IS
813: SELECT tref.rowid row_id,
814: tref.*

Line 811: c_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE

807: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
808: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
809: c_person_id igs_pe_std_todo_ref.person_id%TYPE,
810: c_s_student_todo_type igs_pe_std_todo_ref.s_student_todo_type%TYPE,
811: c_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE
812: ) IS
813: SELECT tref.rowid row_id,
814: tref.*
815: FROM igs_pe_std_todo_ref tref

Line 815: FROM igs_pe_std_todo_ref tref

811: c_sequence_number igs_pe_std_todo_ref.sequence_number%TYPE
812: ) IS
813: SELECT tref.rowid row_id,
814: tref.*
815: FROM igs_pe_std_todo_ref tref
816: WHERE tref.person_id = c_person_id
817: AND tref.s_student_todo_type = c_s_student_todo_type
818: AND tref.sequence_number = c_sequence_number
819: AND tref.cal_type = c_ci_cal_type

Line 827: c_person_id igs_pe_std_todo.person_id%TYPE,

823:
824:
825: --Cursor to fetch persons from todo table
826: CURSOR c_person_todo(
827: c_person_id igs_pe_std_todo.person_id%TYPE,
828: c_s_student_todo_type igs_pe_std_todo.s_student_todo_type%TYPE,
829: c_sequence_number igs_pe_std_todo.sequence_number%TYPE
830: ) IS
831: SELECT todo.rowid row_id,

Line 828: c_s_student_todo_type igs_pe_std_todo.s_student_todo_type%TYPE,

824:
825: --Cursor to fetch persons from todo table
826: CURSOR c_person_todo(
827: c_person_id igs_pe_std_todo.person_id%TYPE,
828: c_s_student_todo_type igs_pe_std_todo.s_student_todo_type%TYPE,
829: c_sequence_number igs_pe_std_todo.sequence_number%TYPE
830: ) IS
831: SELECT todo.rowid row_id,
832: todo.*

Line 829: c_sequence_number igs_pe_std_todo.sequence_number%TYPE

825: --Cursor to fetch persons from todo table
826: CURSOR c_person_todo(
827: c_person_id igs_pe_std_todo.person_id%TYPE,
828: c_s_student_todo_type igs_pe_std_todo.s_student_todo_type%TYPE,
829: c_sequence_number igs_pe_std_todo.sequence_number%TYPE
830: ) IS
831: SELECT todo.rowid row_id,
832: todo.*
833: FROM igs_pe_std_todo todo

Line 833: FROM igs_pe_std_todo todo

829: c_sequence_number igs_pe_std_todo.sequence_number%TYPE
830: ) IS
831: SELECT todo.rowid row_id,
832: todo.*
833: FROM igs_pe_std_todo todo
834: WHERE todo.person_id = c_person_id
835: AND todo.s_student_todo_type = c_s_student_todo_type
836: AND todo.sequence_number = c_sequence_number
837: AND todo.logical_delete_dt IS NULL

Line 842: FROM igs_pe_std_todo_ref tref

838: AND NOT EXISTS
839: (SELECT tref.person_id,
840: tref.s_student_todo_type,
841: tref.sequence_number
842: FROM igs_pe_std_todo_ref tref
843: WHERE tref.person_id = todo.person_id
844: AND tref.s_student_todo_type = todo.s_student_todo_type
845: AND tref.sequence_number = todo.sequence_number
846: AND tref.s_student_todo_type = 'IGF_COA_COMP'

Line 1078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Updating table igs_pe_std_todo for person id: '||l_person_id.person_id);

1074:
1075: FOR l_person_ref IN c_person_ref(lv_ci_cal_type,ln_ci_sequence_number,l_person_id.person_id,l_person_id.s_student_todo_type,l_person_id.sequence_number)
1076: LOOP
1077: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Updating table igs_pe_std_todo for person id: '||l_person_id.person_id);
1079: END IF;
1080:
1081: igs_pe_std_todo_ref_pkg.update_row(
1082: x_rowid => l_person_ref.row_id,

Line 1081: igs_pe_std_todo_ref_pkg.update_row(

1077: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Updating table igs_pe_std_todo for person id: '||l_person_id.person_id);
1079: END IF;
1080:
1081: igs_pe_std_todo_ref_pkg.update_row(
1082: x_rowid => l_person_ref.row_id,
1083: x_person_id => l_person_ref.person_id,
1084: x_s_student_todo_type => l_person_ref.s_student_todo_type,
1085: x_sequence_number => l_person_ref.sequence_number,

Line 1107: igs_pe_std_todo_pkg.update_row(

1103: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1104: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','c_person_todo%FOUND');
1105: END IF;
1106:
1107: igs_pe_std_todo_pkg.update_row(
1108: x_rowid => l_person_todo.row_id,
1109: x_person_id => l_person_todo.person_id,
1110: x_s_student_todo_type => l_person_todo.s_student_todo_type,
1111: x_sequence_number => l_person_todo.sequence_number,