[Home] [Help]
109: cursor c_get_vendor_info
110: is
111: SELECT aia.VENDOR_ID,
112: jatvh.TDS_VENDOR_TYPE_LOOKUP_CODE
113: FROM JAI_AP_TDS_VENDOR_HDRS jatvh,
114: AP_INVOICES_ALL aia
115: WHERE aia.VENDOR_ID = jatvh.VENDOR_ID
116: AND aia.INVOICE_ID = p_inv_id;
117:
132: JATOTV.ORG_TAN_NUM TAN_NO,
133: JATVH.CONFIRM_PAN_FLAG CONFIRM_PAN_FLAG -- added by zhiwei.xin for bug 13792748 on 08-Mar-2012
134: FROM PO_VENDORS PV,
135: PO_VENDOR_SITES_ALL PVSA,
136: JAI_AP_TDS_VENDOR_HDRS JATVH,
137: JAI_AP_TDS_ORG_TAN_V JATOTV
138: WHERE PV.VENDOR_ID = PVSA.VENDOR_ID
139: AND PVSA.VENDOR_ID = JATVH.VENDOR_ID
140: AND PVSA.VENDOR_SITE_ID = JATVH.VENDOR_SITE_ID
285: ----------------------------------------------
286: -- Added by Chong for bug#15939571 on 20121213 End
287:
288: -- cursor to fetch JAI_AP_TDS_TH_VSITE_V
289: cursor c_tds_th_vsite_v (cp_tds_vendor_tlc JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE,
290: cp_vendor_id JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE,
291: cp_vendor_site_id PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
292: cp_tds_sec_code JAI_AP_TDS_THHOLD_HDRS.SECTION_CODE%TYPE)
293: is
286: -- Added by Chong for bug#15939571 on 20121213 End
287:
288: -- cursor to fetch JAI_AP_TDS_TH_VSITE_V
289: cursor c_tds_th_vsite_v (cp_tds_vendor_tlc JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE,
290: cp_vendor_id JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE,
291: cp_vendor_site_id PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
292: cp_tds_sec_code JAI_AP_TDS_THHOLD_HDRS.SECTION_CODE%TYPE)
293: is
294: SELECT THRESHOLD_HDR_ID,
351: -- cursor to fetch default section code from vendor additional information
352: cursor c_get_def_sec_code (cp_vendor_id number, cp_vendor_site_id number)
353: is
354: SELECT SECTION_CODE
355: FROM JAI_AP_TDS_VENDOR_HDRS
356: WHERE VENDOR_ID = cp_vendor_id
357: AND VENDOR_SITE_ID = cp_vendor_site_id;
358:
359: -- Added by Chong for bug#15939571 on 20121213 Start
361: -- cursor to fetch default section code from vendor NULL site
362: cursor c_get_null_sec_code (cp_vendor_id number)
363: is
364: SELECT SECTION_CODE
365: FROM JAI_AP_TDS_VENDOR_HDRS
366: WHERE VENDOR_ID = cp_vendor_id
367: AND VENDOR_SITE_ID = 0;
368: ----------------------------------------------
369: -- Added by Chong for bug#15939571 on 20121213 End
654: AND cp_max_date between nvl(from_date, cp_max_date) and nvl(to_date, cp_max_date)
655: AND cp_min_date between nvl(from_date, cp_min_date) and nvl(to_date, cp_min_date);
656:
657: -- cursor to get threshold header id
658: cursor c_get_thr_hdr_id (cp_vendor_tlc JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE,
659: cp_sec_code varchar2)
660: is
661: SELECT threshold_hdr_id,
662: NVL(MULTIPLE_RATE_SETUP,'N')
723: -----------------------------------------------------------------------------------------------------
724: --Added by Chong for bug#15939571 20121210 End
725:
726: -- variables
727: ln_vendor_id JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE;
728: lv_vendor_type JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE;
729: ln_vendor_site_id AP_INVOICES_ALL.VENDOR_SITE_ID%TYPE;
730: ln_org_id AP_INVOICES_ALL.ORG_ID%TYPE;
731: ln_legal_entity_id AP_INVOICES_ALL.LEGAL_ENTITY_ID%TYPE;
724: --Added by Chong for bug#15939571 20121210 End
725:
726: -- variables
727: ln_vendor_id JAI_AP_TDS_VENDOR_HDRS.VENDOR_ID%TYPE;
728: lv_vendor_type JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE;
729: ln_vendor_site_id AP_INVOICES_ALL.VENDOR_SITE_ID%TYPE;
730: ln_org_id AP_INVOICES_ALL.ORG_ID%TYPE;
731: ln_legal_entity_id AP_INVOICES_ALL.LEGAL_ENTITY_ID%TYPE;
732: ln_ledger_id AP_INVOICES_ALL.SET_OF_BOOKS_ID%TYPE;
745: lv_multi_rate_flg JAI_AP_TDS_THHOLD_HDRS.MULTIPLE_RATE_SETUP%TYPE;
746: ln_effective_amount NUMBER;
747: lv_pan_no VARCHAR2(30);
748: lv_tan_no VARCHAR2(30);
749: lv_default_section_code JAI_AP_TDS_VENDOR_HDRS.SECTION_CODE%TYPE;
750: ln_line_no NUMBER;
751: lr_tax_code_details JAI_CMN_TAXES_ALL%ROWTYPE;
752: lv_rec_exists VARCHAR2(1);
753: ln_tax_ctg_id NUMBER;