APPS.IGF_GR_GEN_XML dependencies on IGF_AW_DB_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 1094: igf_aw_db_cod_dtls_pkg.add_row( x_rowid => lv_rowid,

1090: rec.disb_conf_flag := 'false';
1091: ELSIF rec.disb_conf_flag = 'N' THEN
1092: rec.disb_conf_flag := 'true';
1093: END IF;
1094: igf_aw_db_cod_dtls_pkg.add_row( x_rowid => lv_rowid,
1095: x_award_id => rec.award_id,
1096: x_document_id_txt => gv_document_id_txt,
1097: x_disb_num => rec.disb_num,
1098: x_disb_seq_num => rec.disb_seq_num,

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 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 1826: FROM IGF_AW_DB_COD_DTLS disb

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
1826: FROM IGF_AW_DB_COD_DTLS disb
1827: WHERE disb.document_id_txt = cp_document_id_txt;
1828:
1829: CURSOR cur_rfms_orig ( cp_origination_id VARCHAR2) IS
1830: SELECT rfms.*