[Home] [Help]
1133: p_tax_amount => rec_c_fetch_receipt_rec.func_tax_amt ,
1134: p_recoverable_amount => 0 ,
1135: p_recovered_amount => 0
1136: /*
1137: Item_line_id should be checked in jai_trx_repo_extract_pkg.get_doc_from_reference, if it is null,
1138: can't pass it. But, no item exists in receipts.So, assign hardcode 1 to item_line_id.
1139: Added by Qiong
1140: */ ,
1141: p_item_line_id => 1,
1373: lv_service_type_code := NULL;
1374: lv_process_flag := NULL;
1375: lv_process_message := NULL;
1376:
1377: jai_trx_repo_extract_pkg.get_doc_from_reference(p_reference_id => rec_c_get_cm_cm_app_rec.reference_id,
1378: p_organization_id => ln_organization_id,
1379: p_location_id => ln_location_id,
1380: p_service_type_code => lv_service_type_code,
1381: p_process_flag => lv_process_flag,
1529: lv_service_type_code := NULL;
1530: lv_process_flag := NULL;
1531: lv_process_message := NULL;
1532:
1533: jai_trx_repo_extract_pkg.get_doc_from_reference(p_reference_id => rec_c_get_cm_inv_app_rec.reference_id,
1534: p_organization_id => ln_organization_id,
1535: p_location_id => ln_location_id,
1536: p_service_type_code => lv_service_type_code,
1537: p_process_flag => lv_process_flag,
2143: lv_service_type_code := NULL;
2144: lv_process_flag := NULL;
2145: lv_process_message := NULL;
2146:
2147: jai_trx_repo_extract_pkg.get_doc_from_reference(p_reference_id => rec_c_get_refinvrec_for_upd.reference_id,
2148: p_organization_id => ln_organization_id,
2149: p_location_id => ln_location_id,
2150: p_service_type_code => lv_service_type_code,
2151: p_process_flag => lv_process_flag,
2340: lv_service_type_code := NULL;
2341: lv_process_flag := NULL;
2342: lv_process_message := NULL;
2343:
2344: jai_trx_repo_extract_pkg.get_doc_from_reference(p_reference_id => rec_c_get_refcmrec_for_upd.reference_id,
2345: p_organization_id => ln_organization_id,
2346: p_location_id => ln_location_id,
2347: p_service_type_code => lv_service_type_code,
2348: p_process_flag => lv_process_flag,
3166: lv_service_type_code := NULL;
3167: lv_process_flag := NULL;
3168: lv_process_message := NULL;
3169:
3170: jai_trx_repo_extract_pkg.get_doc_from_reference(p_reference_id => rec_c_get_refrec_for_upd.reference_id,
3171: p_organization_id => ln_organization_id,
3172: p_location_id => ln_location_id,
3173: p_service_type_code => lv_service_type_code,
3174: p_process_flag => lv_process_flag,
3887: --Add by Xiao for POT change, reg bug#12533434 on 16-May-2011, end
3888: --Commented by zhiwei for POT 12925963 on 20110908 begin
3889: ----------------------------------------------------------------------------------------------
3890: /*
3891: jai_trx_repo_extract_pkg.get_doc_from_reference(p_reference_id => r_ar_ref_records.reference_id,
3892: p_organization_id => ln_organization_id,
3893: p_location_id => ln_location_id,
3894: p_service_type_code => lv_service_type_code,
3895: p_process_flag => lv_process_flag,
3996: OPEN c_ar_ref_records(rec_reversal_entries.customer_trx_line_id, 'AR');
3997: FETCH c_ar_ref_records INTO lr_ar_ref_records;
3998: CLOSE c_ar_ref_records;
3999:
4000: jai_trx_repo_extract_pkg.get_doc_from_reference(p_reference_id => lr_ar_ref_records.reference_id,
4001: p_organization_id => ln_organization_id,
4002: p_location_id => ln_location_id,
4003: p_service_type_code => lv_service_type_code,
4004: p_process_flag => lv_process_flag,
4081: OPEN c_ar_ref_records(rec_claim_entries.customer_trx_line_id, 'AR');
4082: FETCH c_ar_ref_records INTO lr_ar_ref_records;
4083: CLOSE c_ar_ref_records;
4084:
4085: jai_trx_repo_extract_pkg.get_doc_from_reference(p_reference_id => lr_ar_ref_records.reference_id,
4086: p_organization_id => ln_organization_id,
4087: p_location_id => ln_location_id,
4088: p_service_type_code => lv_service_type_code,
4089: p_process_flag => lv_process_flag,
4168: FETCH c_rcpt_ref_records INTO lr_ar_ref_records;
4169: CLOSE c_rcpt_ref_records;
4170:
4171:
4172: jai_trx_repo_extract_pkg.get_doc_from_reference(p_reference_id => lr_ar_ref_records.reference_id,
4173: p_source_trx_type => jai_constants.trx_type_adv_rcpts,
4174: p_organization_id => ln_organization_id,
4175: p_location_id => ln_location_id,
4176: p_service_type_code => lv_service_type_code,
4258: ln_tax_amount := - ABS(lr_ar_ref_records.TAX_AMOUNT);
4259: ln_trx_tax_amount := - ABS(lr_ar_ref_records.TRX_TAX_AMOUNT);
4260:
4261:
4262: jai_trx_repo_extract_pkg.get_doc_from_reference(p_reference_id => lr_ar_ref_records.reference_id,
4263: p_source_trx_type => jai_constants.trx_type_adv_rvs,
4264: --Modified jai_constants.trx_type_rct_rvs to jai_constants.trx_type_adv_rvs
4265: --by Qinglei on 28-Dec-2012 for bug#13741544
4266: p_organization_id => ln_organization_id,
4366: * (rec_c_receipts_application.AMOUNT_APPLIED_FROM/
4367: (rec_c_receipts_application.AMOUNT * NVL(ln_converted_rate,1)))),
4368: jai_constants.service_rgm_rnd_factor);
4369: --Modified by Qinglei on 05-Jan-2012 for bug#13556198
4370: jai_trx_repo_extract_pkg.get_doc_from_reference(p_reference_id => lr_ar_ref_records.reference_id,
4371: p_source_trx_type => jai_constants.trx_type_adv_app,
4372: p_application_id => rec_c_receipts_application.receivable_application_id,
4373: p_organization_id => ln_organization_id,
4374: p_location_id => ln_location_id,
4473: jai_constants.service_rgm_rnd_factor);
4474: --Modified by Qinglei on 05-Jan-2012 for bug#13556198
4475: --Added rounding factor by Qinglei on 13-Jan-2012 for bug#13557031
4476:
4477: jai_trx_repo_extract_pkg.get_doc_from_reference(p_reference_id => lr_ar_ref_records.reference_id,
4478: p_source_trx_type => jai_constants.trx_type_adv_unapp,
4479: p_application_id => rec_c_receipts_unapplication.receivable_application_id,
4480: p_organization_id => ln_organization_id,
4481: p_location_id => ln_location_id,