DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_DOC dependencies on PO_PCARD_PKG

Line 949: decode(pls.pcard_flag, 'Y', phs.pcard_id,'S',nvl((po_pcard_pkg.get_valid_pcard_id(-99999,pls.vendor_id,pls.vendor_site_id)),-99999),'N', null),

945: pls.pcard_flag,
946: /* Supplier PCard FPH */
947: --decode(pls.pcard_flag, 'Y', phs.pcard_id,'S',-99999,'N', null),
948: --16027770
949: decode(pls.pcard_flag, 'Y', phs.pcard_id,'S',nvl((po_pcard_pkg.get_valid_pcard_id(-99999,pls.vendor_id,pls.vendor_site_id)),-99999),'N', null),
950: pls.destination_organization_id,
951: pls.catalog_type,
952: pls.vendor_id, /* Bug 2577940 */
953: pls.vendor_site_id,

Line 3482: c1_pcard_id := po_pcard_pkg.get_valid_pcard_id(c1_pcard_id,c1_suggested_vendor_id,c1_suggested_vendor_site_id);

3478: * will return pcard_id if valid else will have value null if not.
3479: */
3480:
3481: If (c1_pcard_id is not null) then
3482: c1_pcard_id := po_pcard_pkg.get_valid_pcard_id(c1_pcard_id,c1_suggested_vendor_id,c1_suggested_vendor_site_id);
3483: end if;
3484: /* Supplier PCard FPH */
3485: x_first_time_for_this_comb := 'TRUE';
3486: x_suggested_vendor_contact_id := NULL;

Line 3670: c2_pcard_id := po_pcard_pkg.get_valid_pcard_id(c2_pcard_id,c2_suggested_vendor_id,c2_suggested_vendor_site_id);

3666: /* Supplier PCard FPH. Check whether c2_pcard_id is valid. The function
3667: * will return pcard_id if valid else will have value null if not.
3668: */
3669: If (c2_pcard_id is not null) then
3670: c2_pcard_id := po_pcard_pkg.get_valid_pcard_id(c2_pcard_id,c2_suggested_vendor_id,c2_suggested_vendor_site_id);
3671: end if;
3672: /* Supplier PCard FPH */
3673: /* Associate similiar lines with the same header. This is the core
3674: * grouping logic.