eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_TCS_REP_PKG dependencies on JAI_RGM_ITEM_GEN_DOCS

Line 1478: || IF yes punch/reset to null, the customer_trx_id into jai_rgm_item_gen_docs.generated_doc_id based on the

1474: );*/
1475: CLOSE cur_chk_tcs_applicable ;
1476: /*
1477: ||Check whether the invoice has been created due to the secondary creation
1478: || IF yes punch/reset to null, the customer_trx_id into jai_rgm_item_gen_docs.generated_doc_id based on the
1479: ||complete flag
1480: */
1481: /*commented by csahoo for bug# 6401388
1482: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,

Line 5072: jai_rgm_item_gen_docs jrigd,

5068: SELECT
5069: jrigd.rowid ,
5070: jrigd.generated_doc_id
5071: FROM
5072: jai_rgm_item_gen_docs jrigd,
5073: jai_rgm_refs_all jrra
5074: WHERE
5075: jrigd.generated_doc_trx_number = p_trx_number
5076: AND jrra.transaction_id = jrigd.transaction_id

Line 5081: ln_generated_doc_id JAI_RGM_ITEM_GEN_DOCS.GENERATED_DOC_ID%TYPE ;

5077: AND jrra.org_id = p_org_id
5078: FOR UPDATE OF jrigd.generated_doc_id NOWAIT;
5079:
5080: lv_rowid ROWID ;
5081: ln_generated_doc_id JAI_RGM_ITEM_GEN_DOCS.GENERATED_DOC_ID%TYPE ;
5082: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
5083: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
5084:
5085: BEGIN

Line 5113: || UPDATE THE TABLE JAI_RGM_ITEM_GEN_DOCS

5109: ln_user_id := fnd_global.user_id ;
5110: ln_login_id := fnd_global.login_id ;
5111:
5112: /*################################################################################################################
5113: || UPDATE THE TABLE JAI_RGM_ITEM_GEN_DOCS
5114: ################################################################################################################*/
5115:
5116: OPEN cur_upd_gen_docs ;
5117: FETCH cur_upd_gen_docs INTO lv_rowid, ln_generated_doc_id;

Line 5154: pv_log_msg => 'valid transaction record found in table jai_rgm_item_gen_docs. Updating the table jai_rgm_item_gen_docs with ' ||fnd_global.local_chr(10)

5150: END IF;
5151:
5152: /*commented by csahoo for bug# 6401388
5153: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5154: pv_log_msg => 'valid transaction record found in table jai_rgm_item_gen_docs. Updating the table jai_rgm_item_gen_docs with ' ||fnd_global.local_chr(10)
5155: ||', generated_doc_id -> '||ln_generated_doc_id
5156: );*/
5157: UPDATE jai_rgm_item_gen_docs
5158: SET

Line 5157: UPDATE jai_rgm_item_gen_docs

5153: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5154: pv_log_msg => 'valid transaction record found in table jai_rgm_item_gen_docs. Updating the table jai_rgm_item_gen_docs with ' ||fnd_global.local_chr(10)
5155: ||', generated_doc_id -> '||ln_generated_doc_id
5156: );*/
5157: UPDATE jai_rgm_item_gen_docs
5158: SET
5159: generated_doc_id = ln_generated_doc_id ,
5160: last_updated_by = ln_user_id ,
5161: last_update_date = sysdate ,

Line 5764: pv_log_msg => 'Inserting values into jai_rgm_item_gen_docs :- ' ||fnd_global.local_chr(10)

5760:
5761:
5762: /*commented by csahoo for bug# 6401388
5763: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5764: pv_log_msg => 'Inserting values into jai_rgm_item_gen_docs :- ' ||fnd_global.local_chr(10)
5765: ||', transaction_id -> '||p_rgm_ref.transaction_id ||fnd_global.local_chr(10)
5766: ||', source_document_id -> '||p_rgm_ref.source_document_id ||fnd_global.local_chr(10)
5767: ||', source_document_type -> '||p_rgm_ref.source_document_type ||fnd_global.local_chr(10)
5768: ||', item_classification -> '||p_rgm_ref.item_classification ||fnd_global.local_chr(10)

Line 5776: || INSERT INTO JAI_RGM_ITEM_GEN_DOCS TABLE

5772: ||', generated_doc_amt -> '||ln_amount
5773: );*/
5774:
5775: /*################################################################################################################
5776: || INSERT INTO JAI_RGM_ITEM_GEN_DOCS TABLE
5777: ################################################################################################################*/
5778:
5779: INSERT INTO jai_rgm_item_gen_docs ( transaction_id ,
5780: source_document_id ,

Line 5779: INSERT INTO jai_rgm_item_gen_docs ( transaction_id ,

5775: /*################################################################################################################
5776: || INSERT INTO JAI_RGM_ITEM_GEN_DOCS TABLE
5777: ################################################################################################################*/
5778:
5779: INSERT INTO jai_rgm_item_gen_docs ( transaction_id ,
5780: source_document_id ,
5781: source_document_type ,
5782: item_classification ,
5783: generated_doc_trx_number ,

Line 5810: pv_log_msg => 'Data successfully inserted into jai_rgm_item_gen_docs'

5806: );
5807:
5808: /*commented by csahoo for bug# 6401388
5809: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5810: pv_log_msg => 'Data successfully inserted into jai_rgm_item_gen_docs'
5811: );
5812:
5813:
5814: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/