DBA Data[Home] [Help]

APPS.IGS_AD_IMP_015 dependencies on IGS_AD_GEN_016

Line 72: g_person_qual_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'PERSON_QUAL');

68: NULL,NULL,NULL,NULL,NULL,
69: TO_CHAR(l_request_id));
70: END IF;
71:
72: g_person_qual_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'PERSON_QUAL');
73: IF g_person_qual_inc AND p_legacy_ind = 'N' THEN
74: g_person_qual_inc := FALSE;
75: END IF;
76: g_person_recruit_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'PERSON_RECRUITMENT_DETAILS');

Line 76: g_person_recruit_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'PERSON_RECRUITMENT_DETAILS');

72: g_person_qual_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'PERSON_QUAL');
73: IF g_person_qual_inc AND p_legacy_ind = 'N' THEN
74: g_person_qual_inc := FALSE;
75: END IF;
76: g_person_recruit_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'PERSON_RECRUITMENT_DETAILS');
77:
78: g_test_result_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'TEST_RESULTS');
79: g_transcript_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'TRANSCRIPT_DETAILS');
80:

Line 78: g_test_result_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'TEST_RESULTS');

74: g_person_qual_inc := FALSE;
75: END IF;
76: g_person_recruit_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'PERSON_RECRUITMENT_DETAILS');
77:
78: g_test_result_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'TEST_RESULTS');
79: g_transcript_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'TRANSCRIPT_DETAILS');
80:
81: g_application_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICATION');
82: g_applicant_oth_inst_appl_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_OTHERINSTS_APPLIED');

Line 79: g_transcript_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'TRANSCRIPT_DETAILS');

75: END IF;
76: g_person_recruit_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'PERSON_RECRUITMENT_DETAILS');
77:
78: g_test_result_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'TEST_RESULTS');
79: g_transcript_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'TRANSCRIPT_DETAILS');
80:
81: g_application_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICATION');
82: g_applicant_oth_inst_appl_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_OTHERINSTS_APPLIED');
83: g_applicant_acad_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_ACADEMIC_INTERESTS');

Line 81: g_application_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICATION');

77:
78: g_test_result_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'TEST_RESULTS');
79: g_transcript_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'TRANSCRIPT_DETAILS');
80:
81: g_application_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICATION');
82: g_applicant_oth_inst_appl_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_OTHERINSTS_APPLIED');
83: g_applicant_acad_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_ACADEMIC_INTERESTS');
84: g_applicant_appl_intent_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_INTENT');
85: g_applicant_spl_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_INTERESTS');

Line 82: g_applicant_oth_inst_appl_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_OTHERINSTS_APPLIED');

78: g_test_result_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'TEST_RESULTS');
79: g_transcript_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'TRANSCRIPT_DETAILS');
80:
81: g_application_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICATION');
82: g_applicant_oth_inst_appl_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_OTHERINSTS_APPLIED');
83: g_applicant_acad_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_ACADEMIC_INTERESTS');
84: g_applicant_appl_intent_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_INTENT');
85: g_applicant_spl_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_INTERESTS');
86: g_applicant_spl_tal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_TALENTS');

Line 83: g_applicant_acad_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_ACADEMIC_INTERESTS');

79: g_transcript_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'TRANSCRIPT_DETAILS');
80:
81: g_application_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICATION');
82: g_applicant_oth_inst_appl_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_OTHERINSTS_APPLIED');
83: g_applicant_acad_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_ACADEMIC_INTERESTS');
84: g_applicant_appl_intent_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_INTENT');
85: g_applicant_spl_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_INTERESTS');
86: g_applicant_spl_tal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_TALENTS');
87: g_applicant_per_stat_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_PERSONAL_STATEMENTS');

Line 84: g_applicant_appl_intent_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_INTENT');

80:
81: g_application_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICATION');
82: g_applicant_oth_inst_appl_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_OTHERINSTS_APPLIED');
83: g_applicant_acad_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_ACADEMIC_INTERESTS');
84: g_applicant_appl_intent_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_INTENT');
85: g_applicant_spl_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_INTERESTS');
86: g_applicant_spl_tal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_TALENTS');
87: g_applicant_per_stat_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_PERSONAL_STATEMENTS');
88: g_applicant_fee_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_FEE_DTLS');

Line 85: g_applicant_spl_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_INTERESTS');

81: g_application_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICATION');
82: g_applicant_oth_inst_appl_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_OTHERINSTS_APPLIED');
83: g_applicant_acad_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_ACADEMIC_INTERESTS');
84: g_applicant_appl_intent_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_INTENT');
85: g_applicant_spl_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_INTERESTS');
86: g_applicant_spl_tal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_TALENTS');
87: g_applicant_per_stat_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_PERSONAL_STATEMENTS');
88: g_applicant_fee_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_FEE_DTLS');
89: g_applicant_notes_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_NOTES');

Line 86: g_applicant_spl_tal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_TALENTS');

82: g_applicant_oth_inst_appl_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_OTHERINSTS_APPLIED');
83: g_applicant_acad_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_ACADEMIC_INTERESTS');
84: g_applicant_appl_intent_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_INTENT');
85: g_applicant_spl_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_INTERESTS');
86: g_applicant_spl_tal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_TALENTS');
87: g_applicant_per_stat_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_PERSONAL_STATEMENTS');
88: g_applicant_fee_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_FEE_DTLS');
89: g_applicant_notes_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_NOTES');
90: g_applicant_des_unit_sets_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_UNITSETS_APPLIED');

Line 87: g_applicant_per_stat_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_PERSONAL_STATEMENTS');

83: g_applicant_acad_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_ACADEMIC_INTERESTS');
84: g_applicant_appl_intent_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_INTENT');
85: g_applicant_spl_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_INTERESTS');
86: g_applicant_spl_tal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_TALENTS');
87: g_applicant_per_stat_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_PERSONAL_STATEMENTS');
88: g_applicant_fee_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_FEE_DTLS');
89: g_applicant_notes_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_NOTES');
90: g_applicant_des_unit_sets_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_UNITSETS_APPLIED');
91: g_applicant_edu_goal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_EDU_GOALS' );

Line 88: g_applicant_fee_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_FEE_DTLS');

84: g_applicant_appl_intent_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_INTENT');
85: g_applicant_spl_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_INTERESTS');
86: g_applicant_spl_tal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_TALENTS');
87: g_applicant_per_stat_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_PERSONAL_STATEMENTS');
88: g_applicant_fee_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_FEE_DTLS');
89: g_applicant_notes_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_NOTES');
90: g_applicant_des_unit_sets_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_UNITSETS_APPLIED');
91: g_applicant_edu_goal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_EDU_GOALS' );
92: g_applicant_hist_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_HISTORY');

Line 89: g_applicant_notes_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_NOTES');

85: g_applicant_spl_int_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_INTERESTS');
86: g_applicant_spl_tal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_TALENTS');
87: g_applicant_per_stat_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_PERSONAL_STATEMENTS');
88: g_applicant_fee_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_FEE_DTLS');
89: g_applicant_notes_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_NOTES');
90: g_applicant_des_unit_sets_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_UNITSETS_APPLIED');
91: g_applicant_edu_goal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_EDU_GOALS' );
92: g_applicant_hist_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_HISTORY');
93: IF g_applicant_hist_inc AND p_legacy_ind = 'N' THEN

Line 90: g_applicant_des_unit_sets_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_UNITSETS_APPLIED');

86: g_applicant_spl_tal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_SPECIAL_TALENTS');
87: g_applicant_per_stat_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_PERSONAL_STATEMENTS');
88: g_applicant_fee_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_FEE_DTLS');
89: g_applicant_notes_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_NOTES');
90: g_applicant_des_unit_sets_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_UNITSETS_APPLIED');
91: g_applicant_edu_goal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_EDU_GOALS' );
92: g_applicant_hist_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_HISTORY');
93: IF g_applicant_hist_inc AND p_legacy_ind = 'N' THEN
94: g_applicant_hist_inc := FALSE;

Line 91: g_applicant_edu_goal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_EDU_GOALS' );

87: g_applicant_per_stat_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_PERSONAL_STATEMENTS');
88: g_applicant_fee_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_FEE_DTLS');
89: g_applicant_notes_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_NOTES');
90: g_applicant_des_unit_sets_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_UNITSETS_APPLIED');
91: g_applicant_edu_goal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_EDU_GOALS' );
92: g_applicant_hist_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_HISTORY');
93: IF g_applicant_hist_inc AND p_legacy_ind = 'N' THEN
94: g_applicant_hist_inc := FALSE;
95: END IF;

Line 92: g_applicant_hist_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_HISTORY');

88: g_applicant_fee_dtls_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_FEE_DTLS');
89: g_applicant_notes_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_NOTES');
90: g_applicant_des_unit_sets_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_UNITSETS_APPLIED');
91: g_applicant_edu_goal_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_EDU_GOALS' );
92: g_applicant_hist_inc := igs_ad_gen_016.chk_src_cat (p_source_type_id, 'APPLICANT_HISTORY');
93: IF g_applicant_hist_inc AND p_legacy_ind = 'N' THEN
94: g_applicant_hist_inc := FALSE;
95: END IF;
96:

Line 167: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'PERSON_QUAL', 8405);

163: -- To fetch table schema name for gather statistics
164: l_return := fnd_installation.get_app_info('IGS', l_status, l_industry, l_schema);
165:
166: IF g_person_qual_inc THEN
167: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'PERSON_QUAL', 8405);
168:
169: IF p_enable_log = 'Y' THEN
170: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
171: p_token_name => 'TYPE_NAME',

Line 199: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'PERSON_RECRUITMENT_DETAILS', 8405);

195:
196: END IF; -- g_person_qual_inc
197:
198: IF g_person_recruit_dtls_inc THEN
199: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'PERSON_RECRUITMENT_DETAILS', 8405);
200:
201: IF p_enable_log = 'Y' THEN
202: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
203: p_token_name => 'TYPE_NAME',

Line 226: p_rule => igs_ad_gen_016.find_source_cat_rule (p_source_type_id, 'PERSON_RECRUITMENT_DETAILS'));

222:
223: -- Call category entity import procedure
224: igs_ad_imp_014.prc_pe_recruitments_dtl (p_interface_run_id => p_interface_run_id,
225: p_enable_log => p_enable_log,
226: p_rule => igs_ad_gen_016.find_source_cat_rule (p_source_type_id, 'PERSON_RECRUITMENT_DETAILS'));
227:
228: END IF; -- g_person_recruit_dtls_inc
229:
230: --Dynamic Code block to be executed when IGR functionality is enabled.

Line 233: IF igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_INSTANCE') = TRUE THEN

229:
230: --Dynamic Code block to be executed when IGR functionality is enabled.
231: IF (fnd_profile.value('IGS_RECRUITING_ENABLED') IS NULL OR fnd_profile.value('IGS_RECRUITING_ENABLED') = 'N') THEN
232:
233: IF igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_INSTANCE') = TRUE THEN
234: --Log error "Inquiry Instance related information is not Processed as Oracle Student Recruiting functionality is not enabled for the user".
235: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET_STRING('IGS','IGS_AD_INQ_NOT_PRCSD'));
236: ELSE
237: OPEN c_system_source_type;

Line 262: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'TEST_RESULTS', 8405);

258:
259: END IF;
260:
261: IF g_test_result_inc THEN
262: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'TEST_RESULTS', 8405);
263:
264: IF p_enable_log = 'Y' THEN
265: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
266: p_token_name => 'TYPE_NAME',

Line 311: p_rule => igs_ad_gen_016.find_source_cat_rule (p_source_type_id, 'TEST_RESULTS'));

307:
308: -- Call category entity import procedure
309: igs_ad_imp_016.prc_tst_rslts (p_interface_run_id => p_interface_run_id,
310: p_enable_log => p_enable_log,
311: p_rule => igs_ad_gen_016.find_source_cat_rule (p_source_type_id, 'TEST_RESULTS'));
312:
313: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
314:
315: IF (l_request_id IS NULL) THEN

Line 332: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'TRANSCRIPT_DETAILS', 8405);

328:
329: END IF; -- g_test_result_inc
330:
331: IF g_transcript_dtls_inc THEN
332: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'TRANSCRIPT_DETAILS', 8405);
333:
334: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
335:
336: IF (l_request_id IS NULL) THEN

Line 396: p_rule => igs_ad_gen_016.find_source_cat_rule (p_source_type_id, 'TRANSCRIPT_DETAILS'));

392:
393: -- Call category entity import procedure
394: igs_ad_imp_024.prc_trscrpt (p_interface_run_id => p_interface_run_id,
395: p_enable_log => p_enable_log,
396: p_rule => igs_ad_gen_016.find_source_cat_rule (p_source_type_id, 'TRANSCRIPT_DETAILS'));
397:
398: END IF; -- g_transcript_dtls_inc
399:
400: IF g_application_inc THEN

Line 401: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICATION', 8405);

397:
398: END IF; -- g_transcript_dtls_inc
399:
400: IF g_application_inc THEN
401: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICATION', 8405);
402:
403: IF p_enable_log = 'Y' THEN
404: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
405: p_token_name => 'TYPE_NAME',

Line 486: p_rule => igs_ad_gen_016.find_source_cat_rule (p_source_type_id, 'APPLICATION'),

482:
483: -- Call category entity import procedure
484: igs_ad_imp_004.prc_appcln (p_interface_run_id => p_interface_run_id,
485: p_enable_log => p_enable_log,
486: p_rule => igs_ad_gen_016.find_source_cat_rule (p_source_type_id, 'APPLICATION'),
487: p_legacy_ind => p_legacy_ind);
488:
489: UPDATE igs_ad_ps_appl_inst_int a
490: SET (person_id,admission_appl_number,admission_application_type)

Line 500: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_HISTORY', 8405);

496:
497: END IF; -- g_application_inc
498:
499: IF g_applicant_hist_inc THEN
500: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_HISTORY', 8405);
501:
502: IF p_enable_log = 'Y' THEN
503: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
504: p_token_name => 'TYPE_NAME',

Line 553: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_OTHERINSTS_APPLIED', 8405);

549:
550: END IF; -- g_applicant_hist_inc
551:
552: IF g_applicant_oth_inst_appl_inc THEN
553: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_OTHERINSTS_APPLIED', 8405);
554:
555: IF p_enable_log = 'Y' THEN
556: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
557: p_token_name => 'TYPE_NAME',

Line 587: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_ACADEMIC_INTERESTS', 8405);

583:
584: END IF; -- g_applicant_oth_inst_appl_inc
585:
586: IF g_applicant_acad_int_inc THEN
587: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_ACADEMIC_INTERESTS', 8405);
588:
589: IF p_enable_log = 'Y' THEN
590: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
591: p_token_name => 'TYPE_NAME',

Line 621: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_INTENT', 8405);

617:
618: END IF; -- g_applicant_acad_int_inc
619:
620: IF g_applicant_appl_intent_inc THEN
621: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_INTENT', 8405);
622:
623: IF p_enable_log = 'Y' THEN
624: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
625: p_token_name => 'TYPE_NAME',

Line 655: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_SPECIAL_INTERESTS', 8405);

651:
652: END IF; -- g_applicant_appl_intent_inc
653:
654: IF g_applicant_spl_int_inc THEN
655: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_SPECIAL_INTERESTS', 8405);
656:
657: IF p_enable_log = 'Y' THEN
658: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
659: p_token_name => 'TYPE_NAME',

Line 689: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_SPECIAL_TALENTS', 8405);

685:
686: END IF; -- g_applicant_spl_int_inc
687:
688: IF g_applicant_spl_tal_inc THEN
689: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_SPECIAL_TALENTS', 8405);
690:
691: IF p_enable_log = 'Y' THEN
692: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
693: p_token_name => 'TYPE_NAME',

Line 723: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_PERSONAL_STATEMENTS', 8405);

719:
720: END IF; -- g_applicant_spl_tal_inc
721:
722: IF g_applicant_per_stat_inc THEN
723: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_PERSONAL_STATEMENTS', 8405);
724:
725: IF p_enable_log = 'Y' THEN
726: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
727: p_token_name => 'TYPE_NAME',

Line 756: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_FEE_DTLS', 8405);

752:
753: END IF; -- g_applicant_per_stat_inc
754:
755: IF g_applicant_fee_dtls_inc THEN
756: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_FEE_DTLS', 8405);
757:
758: IF p_enable_log = 'Y' THEN
759: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
760: p_token_name => 'TYPE_NAME',

Line 784: p_rule => igs_ad_gen_016.find_source_cat_rule (p_source_type_id, 'APPLICANT_FEE_DTLS'));

780:
781: -- Call category entity import procedure
782: igs_ad_imp_003.prc_appl_fees (p_interface_run_id => p_interface_run_id,
783: p_enable_log => p_enable_log,
784: p_rule => igs_ad_gen_016.find_source_cat_rule (p_source_type_id, 'APPLICANT_FEE_DTLS'));
785:
786: END IF; -- g_applicant_fee_dtls_inc
787:
788: IF g_applicant_notes_inc THEN

Line 789: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_NOTES', 8405);

785:
786: END IF; -- g_applicant_fee_dtls_inc
787:
788: IF g_applicant_notes_inc THEN
789: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_NOTES', 8405);
790:
791: IF p_enable_log = 'Y' THEN
792: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
793: p_token_name => 'TYPE_NAME',

Line 824: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_UNITSETS_APPLIED', 8405);

820:
821: END IF; -- g_applicant_notes_inc
822:
823: IF g_applicant_des_unit_sets_inc THEN
824: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_UNITSETS_APPLIED', 8405);
825:
826: IF p_enable_log = 'Y' THEN
827: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
828: p_token_name => 'TYPE_NAME',

Line 853: p_rule => igs_ad_gen_016.find_source_cat_rule (p_source_type_id, 'APPLICANT_UNITSETS_APPLIED'));

849: -- Call category entity import procedure
850: igs_ad_imp_010.prc_apcnt_uset_apl (p_interface_run_id => p_interface_run_id,
851: p_enable_log => p_enable_log,
852: p_category_meaning => l_meaning,
853: p_rule => igs_ad_gen_016.find_source_cat_rule (p_source_type_id, 'APPLICANT_UNITSETS_APPLIED'));
854:
855: END IF; -- g_applicant_des_unit_sets_inc
856:
857: IF g_applicant_edu_goal_inc THEN

Line 858: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_EDU_GOALS', 8405);

854:
855: END IF; -- g_applicant_des_unit_sets_inc
856:
857: IF g_applicant_edu_goal_inc THEN
858: l_meaning := igs_ad_gen_016.get_lkup_meaning ('IMP_CATEGORIES', 'APPLICANT_EDU_GOALS', 8405);
859:
860: IF p_enable_log = 'Y' THEN
861: igs_ad_imp_001.set_message (p_name => 'IGS_PE_BEG_IMP',
862: p_token_name => 'TYPE_NAME',