DBA Data[Home] [Help]

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;
367: End If;
368: Exception
369: When Others Then

Line 381: From ap_suppliers pov

377: Begin
378: If (C_Igi_Cis_Cdrom_Lines_Rec.subcontractor_utr Is Not Null) Then
379: Select pov.vendor_id
380: Into l_vendor_id
381: From ap_suppliers pov
382: Where pov.unique_tax_reference_num = C_Igi_Cis_Cdrom_Lines_Rec.subcontractor_utr;
383: End If;
384: Exception
385: When Others Then

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

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

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

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

Line 468: From ap_suppliers

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

Line 472: FROM ap_suppliers p, igi_cis_cdrom_lines_t l

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

Line 483: From ap_suppliers pv,

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

Line 610: From ap_suppliers

606: l_count Number := 0;
607:
608: Cursor C_Partnership_UTR Is
609: Select PARTNERSHIP_UTR
610: From ap_suppliers
611: Where cis_enabled_flag='Y'
612: Group by PARTNERSHIP_UTR
613: Having count(PARTNERSHIP_UTR) > 1;
614:

Line 617: From ap_suppliers

613: Having count(PARTNERSHIP_UTR) > 1;
614:
615: Cursor C_Subcontractor_UTR IS
616: Select UNIQUE_TAX_REFERENCE_NUM
617: From ap_suppliers
618: Where cis_enabled_flag='Y'
619: Group by UNIQUE_TAX_REFERENCE_NUM
620: Having count(UNIQUE_TAX_REFERENCE_NUM) > 1;
621: Begin