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_AP_DTC_DEFAULTATION_PKG dependencies on JAI_AP_UTILS_PKG

Line 805: lv_segment_name := JAI_AP_UTILS_PKG.GET_NATURAL_ACCOUNT(ln_ledger_id, ln_legal_entity_id);

801: fetch c_get_inv_info into ln_org_id, ln_legal_entity_id, ln_ledger_id, lv_inv_tlc, ln_vendor_site_id;
802: close c_get_inv_info;
803:
804: -- get natural account
805: lv_segment_name := JAI_AP_UTILS_PKG.GET_NATURAL_ACCOUNT(ln_ledger_id, ln_legal_entity_id);
806:
807: -- get pan number
808: open c_get_vendor_pan_tan(ln_vendor_id, ln_vendor_site_id);
809: fetch c_get_vendor_pan_tan into lv_pan_no, lv_tan_no, lv_confirm_flg; -- added lv_confirm_flg by zhiwei.xin for bug 13792748 on 08-Mar-2012

Line 1024: JAI_AP_UTILS_PKG.GET_SECTION_CODE(la_aida_tab(l_index).DIST_CODE_COMBINATION_ID

1020: la_aida_tab(l_index).DISTRIBUTION_LINE_NUMBER,
1021: la_aida_tab(l_index).INVOICE_DISTRIBUTION_ID,
1022: la_aida_tab(l_index).DIST_CODE_COMBINATION_ID,
1023: la_aida_tab(l_index).AMOUNT,
1024: JAI_AP_UTILS_PKG.GET_SECTION_CODE(la_aida_tab(l_index).DIST_CODE_COMBINATION_ID
1025: ,lv_segment_name
1026: ,ln_legal_entity_id
1027: ,la_aida_tab(l_index).ACCOUNTING_DATE), --Added accounting_date by Chong for bug15939571
1028: JAI_AP_UTILS_PKG.GET_NATURAL_ACCOUNT_VALUE(la_aida_tab(l_index).DIST_CODE_COMBINATION_ID, lv_segment_name),

Line 1028: JAI_AP_UTILS_PKG.GET_NATURAL_ACCOUNT_VALUE(la_aida_tab(l_index).DIST_CODE_COMBINATION_ID, lv_segment_name),

1024: JAI_AP_UTILS_PKG.GET_SECTION_CODE(la_aida_tab(l_index).DIST_CODE_COMBINATION_ID
1025: ,lv_segment_name
1026: ,ln_legal_entity_id
1027: ,la_aida_tab(l_index).ACCOUNTING_DATE), --Added accounting_date by Chong for bug15939571
1028: JAI_AP_UTILS_PKG.GET_NATURAL_ACCOUNT_VALUE(la_aida_tab(l_index).DIST_CODE_COMBINATION_ID, lv_segment_name),
1029: la_aida_tab(l_index).DESCRIPTION,
1030: NVL(la_aida_tab(l_index).MATCH_STATUS_FLAG,'N'), --Added NVL for bug16707946
1031: la_aida_tab(l_index).LINE_TYPE_LOOKUP_CODE,
1032: la_aida_tab(l_index).ACCOUNTING_DATE,

Line 1916: open c_get_tds_on_service(JAI_AP_UTILS_PKG.GET_SECTION_CODE(ln_parent_dist_ccid, lv_segment_name, ln_legal_entity_id));

1912: -- fetch distribution accid
1913: p_get_dist_ccid(p_inv_id, ln_parent_dist_id, ln_parent_dist_ccid); -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012
1914:
1915: -- check tds on service flg
1916: open c_get_tds_on_service(JAI_AP_UTILS_PKG.GET_SECTION_CODE(ln_parent_dist_ccid, lv_segment_name, ln_legal_entity_id));
1917: fetch c_get_tds_on_service into lv_tds_on_service_flg;
1918: close c_get_tds_on_service;
1919: if NVL(lv_tds_on_service_flg, 'N') = 'Y' then
1920:

Line 1923: set TDS_SECTION_CODE = JAI_AP_UTILS_PKG.GET_SECTION_CODE(ln_parent_dist_ccid, lv_segment_name, ln_legal_entity_id)

1919: if NVL(lv_tds_on_service_flg, 'N') = 'Y' then
1920:
1921: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin
1922: update JAI_AP_TDS_DEFAULT
1923: set TDS_SECTION_CODE = JAI_AP_UTILS_PKG.GET_SECTION_CODE(ln_parent_dist_ccid, lv_segment_name, ln_legal_entity_id)
1924: where INVOICE_ID = p_inv_id
1925: and INVOICE_DISTRIBUTION_ID = ap_tds_def_rec.INVOICE_DISTRIBUTION_ID;
1926: ap_tds_def_rec.TDS_SECTION_CODE := JAI_AP_UTILS_PKG.GET_SECTION_CODE(ln_parent_dist_ccid, lv_segment_name, ln_legal_entity_id);
1927: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 end.

Line 1926: ap_tds_def_rec.TDS_SECTION_CODE := JAI_AP_UTILS_PKG.GET_SECTION_CODE(ln_parent_dist_ccid, lv_segment_name, ln_legal_entity_id);

1922: update JAI_AP_TDS_DEFAULT
1923: set TDS_SECTION_CODE = JAI_AP_UTILS_PKG.GET_SECTION_CODE(ln_parent_dist_ccid, lv_segment_name, ln_legal_entity_id)
1924: where INVOICE_ID = p_inv_id
1925: and INVOICE_DISTRIBUTION_ID = ap_tds_def_rec.INVOICE_DISTRIBUTION_ID;
1926: ap_tds_def_rec.TDS_SECTION_CODE := JAI_AP_UTILS_PKG.GET_SECTION_CODE(ln_parent_dist_ccid, lv_segment_name, ln_legal_entity_id);
1927: -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 end.
1928:
1929: -- get tax category id
1930: open c_get_tax_ctg_id(ln_parent_dist_id);