APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on PO_VENDORS

Line 1689: -- Verify if the party_id is valid from HZ_parties,PO_vendors and employee tables

1685: p_party_source_tbl(p_party_count_rec.party_source_count).valid_flag := 'Y';
1686: END IF;
1687: END IF;
1688:
1689: -- Verify if the party_id is valid from HZ_parties,PO_vendors and employee tables
1690: -- based on the value of party_source_table
1691: -- Check the cache before hitting the database.
1692: l_exists_flag := 'N';
1693: l_valid_flag := 'Y';

Line 7570: ELSIF upper(p_party_tbl) = 'PO_VENDORS'

7566: NULL;
7567: END;
7568:
7569:
7570: ELSIF upper(p_party_tbl) = 'PO_VENDORS'
7571: THEN
7572: IF p_contact_flag = 'Y' THEN
7573: BEGIN
7574:

Line 8134: ELSIF x_party_history_tbl(i).old_party_source_table = 'PO_VENDORS' THEN

8130: EXCEPTION
8131: WHEN OTHERS THEN
8132: NULL;
8133: END;
8134: ELSIF x_party_history_tbl(i).old_party_source_table = 'PO_VENDORS' THEN
8135: BEGIN
8136: SELECT segment1,
8137: 'VENDOR'
8138: INTO x_party_history_tbl(i).old_contact_party_number,

Line 8140: FROM po_vendors

8136: SELECT segment1,
8137: 'VENDOR'
8138: INTO x_party_history_tbl(i).old_contact_party_number,
8139: x_party_history_tbl(i).old_contact_party_type
8140: FROM po_vendors
8141: WHERE vendor_id = l_old_contact_party_id;
8142: EXCEPTION
8143: WHEN OTHERS THEN
8144: NULL;

Line 8217: ELSIF x_party_history_tbl(i).old_party_source_table = 'PO_VENDORS' THEN

8213: EXCEPTION
8214: WHEN OTHERS THEN
8215: NULL;
8216: END;
8217: ELSIF x_party_history_tbl(i).old_party_source_table = 'PO_VENDORS' THEN
8218: BEGIN
8219: SELECT segment1,
8220: 'VENDOR',
8221: vendor_name

Line 8225: FROM po_vendors

8221: vendor_name
8222: INTO x_party_history_tbl(i).old_party_number,
8223: x_party_history_tbl(i).old_party_type,
8224: x_party_history_tbl(i).old_party_name
8225: FROM po_vendors
8226: WHERE vendor_id = x_party_history_tbl(i).old_party_id;
8227: EXCEPTION
8228: WHEN OTHERS THEN
8229: NULL;

Line 8326: ELSIF x_party_history_tbl(i).new_party_source_table = 'PO_VENDORS' THEN

8322: EXCEPTION
8323: WHEN OTHERS THEN
8324: NULL;
8325: END;
8326: ELSIF x_party_history_tbl(i).new_party_source_table = 'PO_VENDORS' THEN
8327: BEGIN
8328: SELECT segment1,
8329: 'VENDOR'
8330: INTO x_party_history_tbl(i).new_contact_party_number,

Line 8332: FROM po_vendors

8328: SELECT segment1,
8329: 'VENDOR'
8330: INTO x_party_history_tbl(i).new_contact_party_number,
8331: x_party_history_tbl(i).new_contact_party_type
8332: FROM po_vendors
8333: WHERE vendor_id = l_new_contact_party_id;
8334: EXCEPTION
8335: WHEN OTHERS THEN
8336: NULL;

Line 8410: ELSIF x_party_history_tbl(i).new_party_source_table = 'PO_VENDORS' THEN

8406: EXCEPTION
8407: WHEN OTHERS THEN
8408: NULL;
8409: END;
8410: ELSIF x_party_history_tbl(i).new_party_source_table = 'PO_VENDORS' THEN
8411: BEGIN
8412: SELECT segment1,
8413: 'VENDOR',
8414: vendor_name

Line 8418: FROM po_vendors

8414: vendor_name
8415: INTO x_party_history_tbl(i).new_party_number,
8416: x_party_history_tbl(i).new_party_type,
8417: x_party_history_tbl(i).new_party_name
8418: FROM po_vendors
8419: WHERE vendor_id = x_party_history_tbl(i).new_party_id;
8420: EXCEPTION
8421: WHEN OTHERS THEN
8422: NULL;