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.PO_AP_MERGE_GRP dependencies on PO_VENDOR_SITES_ALL

Line 81: -- ( p_org_id IN PO_VENDOR_SITES_ALL.org_id%TYPE,

77: -- ( p_vendor_site_id IN PO_VENDOR_SITES.vendor_site_id%TYPE
78: -- ) RETURN VARCHAR2;
79: --
80: -- FUNCTION supplier_site_exist
81: -- ( p_org_id IN PO_VENDOR_SITES_ALL.org_id%TYPE,
82: -- p_vendor_id IN PO_VENDOR_SITES_ALL.vendor_id%TYPE,
83: -- p_vendor_site_code IN PO_VENDOR_SITES_ALL.vendor_site_code%TYPE
84: -- ) RETURN BOOLEAN;
85: --

Line 82: -- p_vendor_id IN PO_VENDOR_SITES_ALL.vendor_id%TYPE,

78: -- ) RETURN VARCHAR2;
79: --
80: -- FUNCTION supplier_site_exist
81: -- ( p_org_id IN PO_VENDOR_SITES_ALL.org_id%TYPE,
82: -- p_vendor_id IN PO_VENDOR_SITES_ALL.vendor_id%TYPE,
83: -- p_vendor_site_code IN PO_VENDOR_SITES_ALL.vendor_site_code%TYPE
84: -- ) RETURN BOOLEAN;
85: --
86: --FUNCTION referencing_asl_exist

Line 83: -- p_vendor_site_code IN PO_VENDOR_SITES_ALL.vendor_site_code%TYPE

79: --
80: -- FUNCTION supplier_site_exist
81: -- ( p_org_id IN PO_VENDOR_SITES_ALL.org_id%TYPE,
82: -- p_vendor_id IN PO_VENDOR_SITES_ALL.vendor_id%TYPE,
83: -- p_vendor_site_code IN PO_VENDOR_SITES_ALL.vendor_site_code%TYPE
84: -- ) RETURN BOOLEAN;
85: --
86: --FUNCTION referencing_asl_exist
87: --( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,

Line 108: * The TO vendor_site_id must be defined in po_vendor_sites_all.

104: *
105: * PUBLIC PROCEDURE : validate_merge
106: *
107: * REQUIRES:
108: * The TO vendor_site_id must be defined in po_vendor_sites_all.
109: *
110: * MODIFIES:
111: * API Message List - any messages will be appended to the API Message List
112: *

Line 131: p_from_site_id IN PO_VENDOR_SITES_ALL.vendor_site_id%TYPE,

127: (
128: p_api_version IN NUMBER,
129: x_return_status OUT NOCOPY VARCHAR2,
130: p_from_vendor_id IN PO_VENDORS.vendor_id%TYPE,
131: p_from_site_id IN PO_VENDOR_SITES_ALL.vendor_site_id%TYPE,
132: p_to_vendor_id IN PO_VENDORS.vendor_id%TYPE,
133: p_to_site_id IN PO_VENDOR_SITES_ALL.vendor_site_id%TYPE,
134: x_result OUT NOCOPY VARCHAR2
135: )

Line 133: p_to_site_id IN PO_VENDOR_SITES_ALL.vendor_site_id%TYPE,

129: x_return_status OUT NOCOPY VARCHAR2,
130: p_from_vendor_id IN PO_VENDORS.vendor_id%TYPE,
131: p_from_site_id IN PO_VENDOR_SITES_ALL.vendor_site_id%TYPE,
132: p_to_vendor_id IN PO_VENDORS.vendor_id%TYPE,
133: p_to_site_id IN PO_VENDOR_SITES_ALL.vendor_site_id%TYPE,
134: x_result OUT NOCOPY VARCHAR2
135: )
136: IS
137: l_api_name CONSTANT VARCHAR2(30) := 'validate_merge';

Line 142: l_from_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;

138: l_api_version CONSTANT NUMBER := 1.0;
139: l_module FND_LOG_MESSAGES.module%TYPE :=
140: G_MODULE_PREFIX || l_api_name;
141:
142: l_from_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
143:
144: x_validation_error VARCHAR2(80);
145: l_consigned_ret_sts VARCHAR2(1);
146: l_consigned_msg_count NUMBER;

Line 746: * The To vendor_site_id must be defined in po_vendor_sites_all.

742: * PUBLIC PROCEDURE : update_org_assignments
743: *
744: * REQUIRES:
745: * validate_purge must have been successful.
746: * The To vendor_site_id must be defined in po_vendor_sites_all.
747: *
748: * MODIFIES:
749: * API Message List - any messages will be appended to the API Message List
750: *

Line 767: p_from_site_id IN PO_VENDOR_SITES_ALL.vendor_site_id%TYPE,

763: (
764: p_api_version IN NUMBER,
765: x_return_status OUT NOCOPY VARCHAR2,
766: p_from_vendor_id IN PO_VENDORS.vendor_id%TYPE,
767: p_from_site_id IN PO_VENDOR_SITES_ALL.vendor_site_id%TYPE,
768: p_to_vendor_id IN PO_VENDORS.vendor_id%TYPE,
769: p_to_site_id IN PO_VENDOR_SITES_ALL.vendor_site_id%TYPE
770: )
771: IS

Line 769: p_to_site_id IN PO_VENDOR_SITES_ALL.vendor_site_id%TYPE

765: x_return_status OUT NOCOPY VARCHAR2,
766: p_from_vendor_id IN PO_VENDORS.vendor_id%TYPE,
767: p_from_site_id IN PO_VENDOR_SITES_ALL.vendor_site_id%TYPE,
768: p_to_vendor_id IN PO_VENDORS.vendor_id%TYPE,
769: p_to_site_id IN PO_VENDOR_SITES_ALL.vendor_site_id%TYPE
770: )
771: IS
772: l_api_name CONSTANT VARCHAR2(30) := 'update_org_assignments';
773: l_module FND_LOG_MESSAGES.module%TYPE :=

Line 941: po_vendor_sites_all PVS

937: PVS.vendor_site_code
938: INTO x_vendor_name,
939: x_vendor_site_code
940: FROM po_vendors PV,
941: po_vendor_sites_all PVS
942: WHERE PV.vendor_id = p_vendor_id
943: AND PVS.vendor_site_id = p_vendor_site_id
944: AND PV.vendor_id = PVS.vendor_id;
945: