APPS.IGF_GR_GEN_XML dependencies on IGF_GR_COD_DTLS

Line 12: 7. insert_into_cod_tables() (IGF_GR_COD_DTLS and IGF_AW_DB_COD_DTLS)

8: 3. Process RFMS records based on input criteria.
9: 4. process_rfms_record()
10: 5. General validations
11: 6. XML Validations
12: 7. insert_into_cod_tables() (IGF_GR_COD_DTLS and IGF_AW_DB_COD_DTLS)
13: 8. submit_xml_event()
14: 9. XML Gateway Standard to create xml
15: 10. store_xml()
16: 11. This will insert xml file into IGF_SL_COD_DOC_DTLS

Line 930: -- Cursor to get ssn, last_name, dob from IGF_GR_COD_DTLS table

926: FROM IGF_AW_DB_CHG_DTLS dbchgdtls
927: WHERE dbchgdtls.award_id = cp_award_id;
928: rec_disb_chg_dtls cur_disb_chg_dtls%ROWTYPE;
929:
930: -- Cursor to get ssn, last_name, dob from IGF_GR_COD_DTLS table
931: CURSOR cur_get_chg_data ( cp_origination_id igf_gr_cod_dtls.origination_id%TYPE) IS
932: SELECT s_ssn, s_last_name, s_date_of_birth
933: FROM IGF_GR_COD_DTLS
934: WHERE origination_id = cp_origination_id;

Line 931: CURSOR cur_get_chg_data ( cp_origination_id igf_gr_cod_dtls.origination_id%TYPE) IS

927: WHERE dbchgdtls.award_id = cp_award_id;
928: rec_disb_chg_dtls cur_disb_chg_dtls%ROWTYPE;
929:
930: -- Cursor to get ssn, last_name, dob from IGF_GR_COD_DTLS table
931: CURSOR cur_get_chg_data ( cp_origination_id igf_gr_cod_dtls.origination_id%TYPE) IS
932: SELECT s_ssn, s_last_name, s_date_of_birth
933: FROM IGF_GR_COD_DTLS
934: WHERE origination_id = cp_origination_id;
935: rec_get_chg_data cur_get_chg_data%ROWTYPE;

Line 933: FROM IGF_GR_COD_DTLS

929:
930: -- Cursor to get ssn, last_name, dob from IGF_GR_COD_DTLS table
931: CURSOR cur_get_chg_data ( cp_origination_id igf_gr_cod_dtls.origination_id%TYPE) IS
932: SELECT s_ssn, s_last_name, s_date_of_birth
933: FROM IGF_GR_COD_DTLS
934: WHERE origination_id = cp_origination_id;
935: rec_get_chg_data cur_get_chg_data%ROWTYPE;
936:
937: -- Cursor to get disbursement data.

Line 1029: igf_gr_cod_dtls_pkg.add_row(

1025: IF l_s_phone = 'N/A' then
1026: l_s_phone := NULL;
1027: END IF;
1028:
1029: igf_gr_cod_dtls_pkg.add_row(
1030: x_rowid => lv_rowid,
1031: x_origination_id => p_rfms_rec.origination_id,
1032: x_award_id => p_rfms_rec.award_id,
1033: x_document_id_txt => gv_document_id_txt,

Line 1193: -- 3. insert data into IGF_GR_COD_DTLS and IGF_AW_DB_COD_DTLS tables.

1189: gv_document_id_txt := TO_CHAR(TRUNC(SYSDATE),'YYYY-MM-DD')||'T'||TO_CHAR(SYSDATE,'HH:MM:SS') || '.00' || LPAD(p_source_entity_id, 8, '0');
1190: END IF;
1191: -- 1. validate general validations
1192: -- 2. validate xml boundary validations
1193: -- 3. insert data into IGF_GR_COD_DTLS and IGF_AW_DB_COD_DTLS tables.
1194:
1195: fnd_message.set_name('IGF','IGF_GR_PROCESS_STUD');
1196: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
1197: fnd_message.set_token('ORIG_ID',p_rfms_rec.origination_id);

Line 1447: FROM IGF_GR_COD_DTLS

1443: ***************************************************************/
1444:
1445: CURSOR cur_cod_dtls ( cp_document_id VARCHAR2) IS
1446: SELECT document_id_txt
1447: FROM IGF_GR_COD_DTLS
1448: WHERE document_id_txt = cp_document_id;
1449: cod_dtls_rec cur_cod_dtls%ROWTYPE;
1450:
1451: CURSOR cur_full_resp_code ( cp_cal_type VARCHAR2, cp_sequence_number NUMBER, cp_source_entity_id VARCHAR2) IS

Line 1483: -- 5. Insert valid pell records into IGF_GR_COD_DTLS, and disb records into IGF_AW_DB_COD_DTLS

1479: -- 1. Print parameters
1480: -- 2. Validate parameters
1481: -- 3. Find PELL records to be processed
1482: -- 4. Validate Pell records
1483: -- 5. Insert valid pell records into IGF_GR_COD_DTLS, and disb records into IGF_AW_DB_COD_DTLS
1484: -- 6. Raise Business Event
1485: --
1486: igf_aw_gen.set_org_id(NULL);
1487: retcode := 0;

Line 1821: FROM IGF_GR_COD_DTLS coddtls

1817: ***************************************************************/
1818:
1819: CURSOR cur_cod_orig ( cp_document_id_txt VARCHAR2) IS
1820: SELECT coddtls.origination_id
1821: FROM IGF_GR_COD_DTLS coddtls
1822: WHERE coddtls.document_id_txt = cp_document_id_txt;
1823:
1824: CURSOR cur_cod_disb ( cp_document_id_txt VARCHAR2) IS
1825: SELECT disb.award_id, disb.disb_num, disb.disb_seq_num