APPS.PO_AP_MERGE_GRP dependencies on PO_VENDORS

Line 130: p_from_vendor_id IN PO_VENDORS.vendor_id%TYPE,

126: PROCEDURE validate_merge
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

Line 132: p_to_vendor_id IN PO_VENDORS.vendor_id%TYPE,

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: )
136: IS

Line 150: l_from_vendor_name PO_VENDORS.vendor_name%TYPE; --bug 2814321

146: l_consigned_msg_count NUMBER;
147: l_consigned_msg_data VARCHAR2(2000);
148: l_consigned_can_merge VARCHAR2(1);
149:
150: l_from_vendor_name PO_VENDORS.vendor_name%TYPE; --bug 2814321
151:
152: l_pass_val VARCHAR2(1) := 'Y'; --
153:
154: l_progress VARCHAR2(3);

Line 766: p_from_vendor_id IN PO_VENDORS.vendor_id%TYPE,

762: PROCEDURE update_org_assignments
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: )

Line 768: p_to_vendor_id IN PO_VENDORS.vendor_id%TYPE,

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
772: l_api_name CONSTANT VARCHAR2(30) := 'update_org_assignments';

Line 940: FROM po_vendors PV,

936: SELECT PV.vendor_name,
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;

Line 1011: FROM po_vendors PV

1007:
1008: UPDATE po_requisition_lines_all
1009: SET suggested_vendor_name =
1010: (SELECT PV.vendor_name
1011: FROM po_vendors PV
1012: WHERE PV.vendor_id = p_to_vendor_id),
1013: suggested_vendor_location =
1014: (SELECT PVS.vendor_site_code
1015: FROM po_vendor_sites PVS

Line 1043: FROM po_vendors PV

1039:
1040: UPDATE po_requisition_lines_all
1041: SET suggested_vendor_name =
1042: (SELECT PV.vendor_name
1043: FROM po_vendors PV
1044: WHERE PV.vendor_id = p_to_vendor_id),
1045: vendor_id = p_to_vendor_id,
1046: last_update_date = SYSDATE,
1047: last_updated_by = FND_GLOBAL.user_id,

Line 1053: FROM po_vendors PV

1049: WHERE vendor_id = p_from_vendor_id
1050: AND vendor_site_id IS NULL
1051: AND EXISTS
1052: (SELECT vendor_id
1053: FROM po_vendors PV
1054: WHERE vendor_id = p_from_vendor_id
1055: AND NVL(PV.end_date_active, SYSDATE+1) <= SYSDATE);
1056:
1057:

Line 1170: FROM po_vendors PV

1166: WHERE PRL.suggested_vendor_id = p_from_vendor_id
1167: AND PRL.suggested_vendor_site_id IS NULL
1168: AND EXISTS (
1169: SELECT NULL
1170: FROM po_vendors PV
1171: WHERE PV.vendor_id = p_from_vendor_id
1172: AND NVL(PV.end_date_active, SYSDATE + 1) <= SYSDATE);
1173:
1174: IF (g_debug_stmt) THEN