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.70.12020000.6 2013/01/30 16:00:06 nkodakan ship $ */
3: /*------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY
5: ------------------------------------------------------------------------------------------------------------

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

185:
186: /*----------------------------------------- PRIVATE MEMBERS DECLRATION -------------------------------------*/
187:
188: /** Package level variables used in debug package*/
189: lv_object_name jai_cmn_debug_contexts.log_context%type default 'JAI_TRX_REPO_EXTRACT_PKG';
190: lv_member_name jai_cmn_debug_contexts.log_context%type;
191: lv_context jai_cmn_debug_contexts.log_context%type;
192:
193: --

Line 765: jai_trx_repo_extract_pkg.derrive_doc_from_ref

761:
762: -----------------------------------------------
763: --Add by Wenqiong for Advanced Receipt end
764:
765: jai_trx_repo_extract_pkg.derrive_doc_from_ref
766: ( p_reference_source => r_repo_recs.source
767: , p_source_trx_type => r_repo_recs.source_trx_type
768: , p_reference_invoice_id => ln_refer_invoice_id --Changed by Wenqiong for advanced receipt
769: , p_reference_item_line_id => ln_refer_item_line_id--Changed by Wenqiong for advanced receipt

Line 1074: jai_trx_repo_extract_pkg.get_document_details

1070: lr_trx_repo_extract := null;
1071: if r_docs.transaction_source = 'ORDER MANAGEMENT' then
1072:
1073: -- Only line_id it self is primary key for oe_order_lines_all so only line_id will do the job
1074: jai_trx_repo_extract_pkg.get_document_details
1075: ( p_document_id => ''
1076: , p_document_line_id => r_docs.document_line_id
1077: , p_document_source => r_docs.transaction_source
1078: , p_called_from => 'JAINRPRW'

Line 1090: jai_trx_repo_extract_pkg.get_document_details

1086: end if;
1087: /*added by csahoo for bug#6457710,start*/
1088: elsif r_docs.transaction_source = 'PROJECTS' then
1089:
1090: jai_trx_repo_extract_pkg.get_document_details
1091: ( p_document_id => r_docs.document_id
1092: , p_document_line_id => r_docs.document_line_id
1093: , p_document_source => r_docs.transaction_source
1094: , p_called_from => 'JAINRPRW'

Line 1110: jai_trx_repo_extract_pkg.get_document_details

1106: --elsif r_docs.transaction_source = 'RECEIVABLES' THEN
1107: elsif r_docs.transaction_source IN ('RECEIVABLES', 'AR_REVERSAL', 'AR_CLAIM') THEN --Changed by Xiao for POT Phase III, reg bug#12895841.
1108: --Added by Chong.Lei for POT code port end
1109:
1110: jai_trx_repo_extract_pkg.get_document_details
1111: ( p_document_id => r_docs.document_id
1112: , p_document_line_id => r_docs.document_line_id
1113: , p_document_source => r_docs.transaction_source
1114: , p_called_from => 'JAINRPRW'

Line 1128: jai_trx_repo_extract_pkg.get_document_details

1124: end if;
1125:
1126: /* elsif r_docs.transaction_source = 'PURCHASING' then
1127:
1128: jai_trx_repo_extract_pkg.get_document_details
1129: ( p_document_id => r_docs.document_id
1130: , p_document_line_id => r_docs.document_line_id
1131: , p_document_source => r_docs.transaction_source
1132: , p_called_from => 'JAINRPRW'

Line 1141: jai_trx_repo_extract_pkg.get_document_details

1137:
1138: --Elsif added for Bug#6841116
1139: elsif r_docs.transaction_source = 'RECEIVING' then
1140:
1141: jai_trx_repo_extract_pkg.get_document_details
1142: ( p_document_id => r_docs.document_id
1143: , p_document_line_id => r_docs.document_line_id
1144: , p_document_source => r_docs.transaction_source
1145: , p_called_from => 'JAINRPRW'

Line 1161: jai_trx_repo_extract_pkg.get_document_details

1157:
1158: --Added by Qiong for bug#13405553 begin
1159: ------------------------------------------
1160: if r_docs.transaction_source = 'AP_CLAIM' then
1161: jai_trx_repo_extract_pkg.get_document_details
1162: ( p_document_id => r_docs.document_id
1163: , p_document_line_id => r_docs.document_line_id
1164: , p_document_source => r_docs.transaction_source
1165: , p_called_from => 'JAINRPRW'

Line 1175: jai_trx_repo_extract_pkg.get_document_details

1171: ------------------------------------------
1172: --Added by Qiong for bug#13405553 begin
1173: else
1174:
1175: jai_trx_repo_extract_pkg.get_document_details
1176: ( p_document_id => r_docs.document_id
1177: , p_document_line_id => r_docs.document_line_id
1178: , p_document_source => r_docs.transaction_source
1179: , p_called_from => 'JAINRPRW'

Line 3084: jai_trx_repo_extract_pkg.derrive_doc_from_ref

3080: --------------------------------------------------------
3081: IF lr_refs_rec.source = 'AR' AND p_source_trx_type in (jai_constants.trx_type_adv_app,jai_constants.trx_type_adv_unapp)
3082: THEN
3083:
3084: jai_trx_repo_extract_pkg.derrive_doc_from_ref
3085: ( p_reference_source => lr_refs_rec.source
3086: , p_source_trx_type => p_source_trx_type
3087: , p_reference_invoice_id => p_application_id
3088: , p_reference_item_line_id => lr_refs_rec.item_line_id

Line 3096: jai_trx_repo_extract_pkg.derrive_doc_from_ref

3092: ) ;
3093: ELSE
3094: -------------------------------------------------------
3095: --Add by Qiong for Advanced Receipts bug#13361952 End
3096: jai_trx_repo_extract_pkg.derrive_doc_from_ref
3097: ( p_reference_source => lr_refs_rec.source
3098: , p_reference_invoice_id => lr_refs_rec.invoice_id
3099: , p_reference_item_line_id => lr_refs_rec.item_line_id
3100: , p_trx_repo_extract_rec => p_trx_repo_extract_rec

Line 3124: jai_trx_repo_extract_pkg.get_document_details

3120:
3121: if p_process_flag <> jai_constants.SUCCESSFUL then
3122: return;
3123: end if;
3124: jai_trx_repo_extract_pkg.get_document_details
3125: ( p_document_id => ln_doc_id
3126: , p_document_line_id => ln_doc_line_id
3127: , p_document_source => lv_trx_src
3128: , p_source_trx_type => p_source_trx_type

Line 3581: jai_trx_repo_extract_pkg.get_doc_from_reference

3577: lv_process_flag varchar2 (2);
3578: lv_process_message varchar2 (2000);
3579:
3580: begin
3581: jai_trx_repo_extract_pkg.get_doc_from_reference
3582: ( p_reference_id => p_reference_id
3583: , p_organization_id => lv_organization_id
3584: , p_location_id => lv_location_id
3585: , p_service_type_code => lv_service_type_code

Line 3678: end jai_trx_repo_extract_pkg;

3674: end get_settled_service_type;
3675:
3676:
3677:
3678: end jai_trx_repo_extract_pkg;