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 982: || IF yes punch/reset to null, the customer_trx_id into jai_rgm_item_gen_docs.generated_doc_id based on the

978: );*/
979: CLOSE cur_chk_tcs_applicable ;
980: /*
981: ||Check whether the invoice has been created due to the secondary creation
982: || IF yes punch/reset to null, the customer_trx_id into jai_rgm_item_gen_docs.generated_doc_id based on the
983: ||complete flag
984: */
985: /*commented by csahoo for bug# 6401388
986: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,

Line 4501: jai_rgm_item_gen_docs jrigd,

4497: SELECT
4498: jrigd.rowid ,
4499: jrigd.generated_doc_id
4500: FROM
4501: jai_rgm_item_gen_docs jrigd,
4502: jai_rgm_refs_all jrra
4503: WHERE
4504: jrigd.generated_doc_trx_number = p_trx_number
4505: AND jrra.transaction_id = jrigd.transaction_id

Line 4510: ln_generated_doc_id JAI_RGM_ITEM_GEN_DOCS.GENERATED_DOC_ID%TYPE ;

4506: AND jrra.org_id = p_org_id
4507: FOR UPDATE OF jrigd.generated_doc_id NOWAIT;
4508:
4509: lv_rowid ROWID ;
4510: ln_generated_doc_id JAI_RGM_ITEM_GEN_DOCS.GENERATED_DOC_ID%TYPE ;
4511: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4512: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4513:
4514: BEGIN

Line 4542: || UPDATE THE TABLE JAI_RGM_ITEM_GEN_DOCS

4538: ln_user_id := fnd_global.user_id ;
4539: ln_login_id := fnd_global.login_id ;
4540:
4541: /*################################################################################################################
4542: || UPDATE THE TABLE JAI_RGM_ITEM_GEN_DOCS
4543: ################################################################################################################*/
4544:
4545: OPEN cur_upd_gen_docs ;
4546: FETCH cur_upd_gen_docs INTO lv_rowid, ln_generated_doc_id;

Line 4583: 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)

4579: END IF;
4580:
4581: /*commented by csahoo for bug# 6401388
4582: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4583: 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)
4584: ||', generated_doc_id -> '||ln_generated_doc_id
4585: );*/
4586: UPDATE jai_rgm_item_gen_docs
4587: SET

Line 4586: UPDATE jai_rgm_item_gen_docs

4582: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4583: 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)
4584: ||', generated_doc_id -> '||ln_generated_doc_id
4585: );*/
4586: UPDATE jai_rgm_item_gen_docs
4587: SET
4588: generated_doc_id = ln_generated_doc_id ,
4589: last_updated_by = ln_user_id ,
4590: last_update_date = sysdate ,

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

5148:
5149:
5150: /*commented by csahoo for bug# 6401388
5151: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5152: pv_log_msg => 'Inserting values into jai_rgm_item_gen_docs :- ' ||fnd_global.local_chr(10)
5153: ||', transaction_id -> '||p_rgm_ref.transaction_id ||fnd_global.local_chr(10)
5154: ||', source_document_id -> '||p_rgm_ref.source_document_id ||fnd_global.local_chr(10)
5155: ||', source_document_type -> '||p_rgm_ref.source_document_type ||fnd_global.local_chr(10)
5156: ||', item_classification -> '||p_rgm_ref.item_classification ||fnd_global.local_chr(10)

Line 5164: || INSERT INTO JAI_RGM_ITEM_GEN_DOCS TABLE

5160: ||', generated_doc_amt -> '||ln_amount
5161: );*/
5162:
5163: /*################################################################################################################
5164: || INSERT INTO JAI_RGM_ITEM_GEN_DOCS TABLE
5165: ################################################################################################################*/
5166:
5167: INSERT INTO jai_rgm_item_gen_docs ( transaction_id ,
5168: source_document_id ,

Line 5167: INSERT INTO jai_rgm_item_gen_docs ( transaction_id ,

5163: /*################################################################################################################
5164: || INSERT INTO JAI_RGM_ITEM_GEN_DOCS TABLE
5165: ################################################################################################################*/
5166:
5167: INSERT INTO jai_rgm_item_gen_docs ( transaction_id ,
5168: source_document_id ,
5169: source_document_type ,
5170: item_classification ,
5171: generated_doc_trx_number ,

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

5194: );
5195:
5196: /*commented by csahoo for bug# 6401388
5197: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5198: pv_log_msg => 'Data successfully inserted into jai_rgm_item_gen_docs'
5199: );
5200:
5201:
5202: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/