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_TRX_REPO_EXTRACT_PKG dependencies on JAI_TRX_REPO_EXTRACT_PKG

Line 1: package body jai_trx_repo_extract_pkg as

1: package body jai_trx_repo_extract_pkg as
2: /* $Header: jai_trx_repo_ext.plb 120.19.12010000.2 2008/08/05 07:21:10 nprashar ship $ */
3: /*------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY
5: ------------------------------------------------------------------------------------------------------------

Line 67: lv_object_name jai_cmn_debug_contexts.log_context%type default 'JAI_TRX_REPO_EXTRACT_PKG';

63:
64: /*----------------------------------------- PRIVATE MEMBERS DECLRATION -------------------------------------*/
65:
66: /** Package level variables used in debug package*/
67: lv_object_name jai_cmn_debug_contexts.log_context%type default 'JAI_TRX_REPO_EXTRACT_PKG';
68: lv_member_name jai_cmn_debug_contexts.log_context%type;
69: lv_context jai_cmn_debug_contexts.log_context%type;
70:
71: --

Line 298: jai_trx_repo_extract_pkg.derrive_doc_from_ref

294: ||',r_repo_recs.source='||r_repo_recs.source );
295:
296: if r_repo_recs.source in ('AP','AR') then
297:
298: jai_trx_repo_extract_pkg.derrive_doc_from_ref
299: ( p_reference_source => r_repo_recs.source
300: , p_reference_invoice_id => r_repo_recs.invoice_id
301: , p_reference_item_line_id => r_repo_recs.item_line_id
302: , p_trx_repo_extract_rec => lr_trx_repo_extract

Line 509: jai_trx_repo_extract_pkg.get_document_details

505:
506: if r_docs.transaction_source = 'ORDER MANAGEMENT' then
507:
508: -- Only line_id it self is primary key for oe_order_lines_all so only line_id will do the job
509: jai_trx_repo_extract_pkg.get_document_details
510: ( p_document_id => ''
511: , p_document_line_id => r_docs.document_line_id
512: , p_document_source => r_docs.transaction_source
513: , p_called_from => 'JAINRPRW'

Line 525: jai_trx_repo_extract_pkg.get_document_details

521: end if;
522: /*added by csahoo for bug#6457710,start*/
523: elsif r_docs.transaction_source = 'PROJECTS' then
524:
525: jai_trx_repo_extract_pkg.get_document_details
526: ( p_document_id => r_docs.document_id
527: , p_document_line_id => r_docs.document_line_id
528: , p_document_source => r_docs.transaction_source
529: , p_called_from => 'JAINRPRW'

Line 542: jai_trx_repo_extract_pkg.get_document_details

538: /*bug#6457710,end*/
539:
540: elsif r_docs.transaction_source = 'RECEIVABLES' then
541:
542: jai_trx_repo_extract_pkg.get_document_details
543: ( p_document_id => r_docs.document_id
544: , p_document_line_id => r_docs.document_line_id
545: , p_document_source => r_docs.transaction_source
546: , p_called_from => 'JAINRPRW'

Line 558: jai_trx_repo_extract_pkg.get_document_details

554: end if;
555:
556: elsif r_docs.transaction_source = 'PURCHASING' then
557:
558: jai_trx_repo_extract_pkg.get_document_details
559: ( p_document_id => r_docs.document_id
560: , p_document_line_id => r_docs.document_line_id
561: , p_document_source => r_docs.transaction_source
562: , p_called_from => 'JAINRPRW'

Line 571: jai_trx_repo_extract_pkg.get_document_details

567:
568: --Elsif added for Bug#6843479
569: elsif r_docs.transaction_source = 'RECEIVING' then
570:
571: jai_trx_repo_extract_pkg.get_document_details
572: ( p_document_id => r_docs.document_id
573: , p_document_line_id => r_docs.document_line_id
574: , p_document_source => r_docs.transaction_source
575: , p_called_from => 'JAINRPRW'

Line 584: jai_trx_repo_extract_pkg.get_document_details

580:
581: --Till Here Bug#6843479
582: --Elsif added for Bug#6977917 on 2008/04/08
583: elsif r_docs.transaction_source = jai_constants.G_AP_STANDALONE_INVOICE then
584: jai_trx_repo_extract_pkg.get_document_details
585: ( p_document_id => r_docs.document_id
586: , p_document_line_id => r_docs.document_line_id
587: , p_document_source => r_docs.transaction_source
588: , p_called_from => 'JAINRPRW'

Line 1686: jai_trx_repo_extract_pkg.derrive_doc_from_ref

1682:
1683: p_process_flag := jai_constants.SUCCESSFUL;
1684: ELSE
1685:
1686: jai_trx_repo_extract_pkg.derrive_doc_from_ref
1687: ( p_reference_source => lr_refs_rec.source
1688: , p_reference_invoice_id => lr_refs_rec.invoice_id
1689: , p_reference_item_line_id => lr_refs_rec.item_line_id
1690: , p_trx_repo_extract_rec => p_trx_repo_extract_rec

Line 1703: jai_trx_repo_extract_pkg.get_document_details

1699: if p_process_flag <> jai_constants.SUCCESSFUL then
1700: return;
1701: end if;
1702:
1703: jai_trx_repo_extract_pkg.get_document_details
1704: ( p_document_id => ln_doc_id
1705: , p_document_line_id => ln_doc_line_id
1706: , p_document_source => lv_trx_src
1707: , p_process_message => p_process_message

Line 2175: jai_trx_repo_extract_pkg.get_doc_from_reference

2171: lv_process_flag varchar2 (2);
2172: lv_process_message varchar2 (2000);
2173:
2174: begin
2175: jai_trx_repo_extract_pkg.get_doc_from_reference
2176: ( p_reference_id => p_reference_id
2177: , p_organization_id => lv_organization_id
2178: , p_location_id => lv_location_id
2179: , p_service_type_code => lv_service_type_code

Line 2296: end jai_trx_repo_extract_pkg;

2292:
2293:
2294:
2295:
2296: end jai_trx_repo_extract_pkg;