APPS.IGI_CIS2007_CDROM_PKG dependencies on AP_SUPPLIERS

Line 325: l_awt_group_id ap_suppliers.awt_group_id%TYPE;

321:
322: Procedure Match_And_Update(P_Upl_Option IN Varchar2) IS
323: l_message Varchar2(1000);
324: l_match_flag Varchar2(1);
325: l_awt_group_id ap_suppliers.awt_group_id%TYPE;
326: l_vendor_id ap_suppliers.vendor_id%TYPE;
327:
328: l_matched_flag ap_suppliers.match_status_flag%TYPE := 'M';
329: l_date Date := SYSDATE;

Line 326: l_vendor_id ap_suppliers.vendor_id%TYPE;

322: Procedure Match_And_Update(P_Upl_Option IN Varchar2) IS
323: l_message Varchar2(1000);
324: l_match_flag Varchar2(1);
325: l_awt_group_id ap_suppliers.awt_group_id%TYPE;
326: l_vendor_id ap_suppliers.vendor_id%TYPE;
327:
328: l_matched_flag ap_suppliers.match_status_flag%TYPE := 'M';
329: l_date Date := SYSDATE;
330: l_utr_type Varchar2(1) := NULL;

Line 328: l_matched_flag ap_suppliers.match_status_flag%TYPE := 'M';

324: l_match_flag Varchar2(1);
325: l_awt_group_id ap_suppliers.awt_group_id%TYPE;
326: l_vendor_id ap_suppliers.vendor_id%TYPE;
327:
328: l_matched_flag ap_suppliers.match_status_flag%TYPE := 'M';
329: l_date Date := SYSDATE;
330: l_utr_type Varchar2(1) := NULL;
331:
332: l_prof_net_wth Varchar2(100) := 'IGI_CIS2007_NET_WTH_GROUP';

Line 365: From ap_suppliers pov

361: Begin
362: If (C_Igi_Cis_Cdrom_Lines_Rec.subcontractor_utr Is Not Null) Then
363: Select pov.vendor_id
364: Into l_vendor_id
365: From ap_suppliers pov
366: Where pov.partnership_utr = C_Igi_Cis_Cdrom_Lines_Rec.subcontractor_utr and
367: pov.end_date_active IS NULL; -- Bug 8446711
368: End If;
369: Exception

Line 382: From ap_suppliers pov

378: Begin
379: If (C_Igi_Cis_Cdrom_Lines_Rec.subcontractor_utr Is Not Null) Then
380: Select pov.vendor_id
381: Into l_vendor_id
382: From ap_suppliers pov
383: Where pov.unique_tax_reference_num = C_Igi_Cis_Cdrom_Lines_Rec.subcontractor_utr and
384: pov.end_date_active IS NULL; -- Bug 8446711
385: End If;
386: Exception

Line 402: /* if CD-ROM subcontractor matches with AP_SUPPLIERS subcontractor and user asks for Upload also */

398: Update igi_cis_cdrom_lines_t
399: Set match_flag = l_match_flag
400: Where subcontractor_utr = C_Igi_Cis_Cdrom_Lines_Rec.subcontractor_utr;
401:
402: /* if CD-ROM subcontractor matches with AP_SUPPLIERS subcontractor and user asks for Upload also */
403: If (l_match_flag = 'M' And p_upl_option = 'U') Then
404: If (upper(C_Igi_Cis_Cdrom_Lines_Rec.tax_treatment) = 'NET') Then
405: l_awt_group_id := fnd_profile.VALUE(l_prof_net_wth);
406: Elsif (upper(C_Igi_Cis_Cdrom_Lines_Rec.tax_treatment) = 'GROSS') Then

Line 421: /* calling PO API to update PO tables - AP_SUPPLIERS, AP_SUPPLIER_SITES */

417: p_source => 'CDROM',
418: p_effective_date => l_date
419: );
420:
421: /* calling PO API to update PO tables - AP_SUPPLIERS, AP_SUPPLIER_SITES */
422: Igi_cis2007_igipverp_pkg.pr_po_api(l_vendor_id,
423: NULL,
424: l_matched_flag,
425: l_date,

Line 470: From ap_suppliers

466: partnership_utr ,
467: unique_tax_reference_num ,
468: national_insurance_number,
469: company_registration_number
470: From ap_suppliers
471: Where cis_enabled_flag = 'Y'
472: and vendor_id not in (
473: SELECT p.vendor_id
474: FROM ap_suppliers p, igi_cis_cdrom_lines_t l

Line 474: FROM ap_suppliers p, igi_cis_cdrom_lines_t l

470: From ap_suppliers
471: Where cis_enabled_flag = 'Y'
472: and vendor_id not in (
473: SELECT p.vendor_id
474: FROM ap_suppliers p, igi_cis_cdrom_lines_t l
475: WHERE (p.partnership_utr = l.subcontractor_utr
476: Or p.unique_tax_reference_num = l.subcontractor_utr)
477: And match_flag = 'M')
478: Order by vendor_name;

Line 485: From ap_suppliers pv,

481: Select atr.tax_name tax_name,
482: atr.tax_rate tax_rate,
483: pvs.vendor_site_code site_code,
484: nvl(inv.inv_count,0) inv_count
485: From ap_suppliers pv,
486: ap_supplier_sites pvs,
487: ap_awt_tax_rates atr,
488: (Select count(distinct(aps.invoice_id)) inv_count,
489: api.vendor_id,

Line 612: From ap_suppliers

608: l_count Number := 0;
609:
610: Cursor C_Partnership_UTR Is
611: Select PARTNERSHIP_UTR
612: From ap_suppliers
613: Where cis_enabled_flag='Y' and
614: end_date_active IS NULL -- Bug 8446711
615: Group by PARTNERSHIP_UTR
616: Having count(PARTNERSHIP_UTR) > 1;

Line 620: From ap_suppliers

616: Having count(PARTNERSHIP_UTR) > 1;
617:
618: Cursor C_Subcontractor_UTR IS
619: Select UNIQUE_TAX_REFERENCE_NUM
620: From ap_suppliers
621: Where cis_enabled_flag='Y' and
622: end_date_active IS NULL -- Bug 8446711
623: Group by UNIQUE_TAX_REFERENCE_NUM
624: Having count(UNIQUE_TAX_REFERENCE_NUM) > 1;