APPS.IGF_SL_DL_GEN_XML dependencies on IGF_SL_COD_DOC_DTLS

Line 18: -- --> 2.insert into igf_sl_cod_doc_dtls

14: -- --> 1.XML Gatway Standard to create xml
15: -- --> 2.store_xml() - workflow process
16: -- --> 1.check for CLOB length, proper document id,
17: -- proper submission of request if okay then
18: -- --> 2.insert into igf_sl_cod_doc_dtls
19: -- --> 3.submit concurrent job IGFSLJ19-print_xml()
20: -- --> 1. edit_clob()
21: -- --> 2. update_status(), update igf_sl_cod_doc_dtls
22: -- --> 3. print_out_xml()

Line 21: -- --> 2. update_status(), update igf_sl_cod_doc_dtls

17: -- proper submission of request if okay then
18: -- --> 2.insert into igf_sl_cod_doc_dtls
19: -- --> 3.submit concurrent job IGFSLJ19-print_xml()
20: -- --> 1. edit_clob()
21: -- --> 2. update_status(), update igf_sl_cod_doc_dtls
22: -- --> 3. print_out_xml()
23: ------------------------------------------------------------------------------------------------
24: gv_document_id_txt VARCHAR2(30);
25: gv_dl_version VARCHAR2(30);

Line 53: FROM igf_sl_cod_doc_dtls

49:
50: CURSOR cur_doc_dtls (p_document_id_txt VARCHAR2)
51: IS
52: SELECT rowid ,document_id_txt,outbound_doc
53: FROM igf_sl_cod_doc_dtls
54: WHERE document_id_txt = p_document_id_txt
55: AND doc_status = 'R'
56: FOR UPDATE OF outbound_doc;
57:

Line 1997: igf_sl_cod_doc_dtls_pkg.update_row(x_rowid => lv_rowid,

1993: --
1994: -- print xml outfile
1995: -- update clob into database
1996: print_out_xml(lc_newxmldoc);
1997: igf_sl_cod_doc_dtls_pkg.update_row(x_rowid => lv_rowid,
1998: x_document_id_txt => p_document_id_txt,
1999: x_outbound_doc => lc_newxmldoc,
2000: x_inbound_doc => NULL,
2001: x_send_date => TRUNC(SYSDATE),

Line 2081: igf_sl_cod_doc_dtls_pkg.insert_row(

2077: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' insert into doc dtls ');
2079: END IF;
2080:
2081: igf_sl_cod_doc_dtls_pkg.insert_row(
2082: x_rowid => lv_rowid,
2083: x_document_id_txt => lv_document_id_txt,
2084: x_outbound_doc => l_clob,
2085: x_inbound_doc => NULL,