APPS.PON_NEGOTIATION_COPY_GRP dependencies on HZ_PARTIES

Line 635: l_tp_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;

631: l_user_id NUMBER;
632: l_tp_id NUMBER;
633: l_tp_contact_id NUMBER;
634:
635: l_tp_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
636: l_tpc_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
637:
638: l_source_doctype_id NUMBER := NULL;
639: l_source_orig_round_id NUMBER := NULL;

Line 636: l_tpc_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;

632: l_tp_id NUMBER;
633: l_tp_contact_id NUMBER;
634:
635: l_tp_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
636: l_tpc_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
637:
638: l_source_doctype_id NUMBER := NULL;
639: l_source_orig_round_id NUMBER := NULL;
640: l_source_prev_round_id NUMBER := NULL;

Line 810: FROM HZ_PARTIES

806: --
807: BEGIN
808: SELECT PARTY_NAME
809: INTO l_tp_name
810: FROM HZ_PARTIES
811: WHERE PARTY_ID = l_tp_id;
812: EXCEPTION
813: WHEN NO_DATA_FOUND THEN
814: -- The way I am adding this error may get changed in the future.

Line 8105: l_tp_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;

8101: IS_LARGE_DESTINATION VARCHAR2(1);
8102: l_auction_header_id NUMBER := p_destination_auction_hdr_id;
8103: l_tp_id NUMBER := p_trading_partner_id;
8104: l_tp_contact_id NUMBER := p_trading_partner_contact_id;
8105: l_tp_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
8106: l_tpc_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
8107: l_user_id NUMBER := p_user_id;
8108: l_source_doctype_id NUMBER := p_source_doctype_id;
8109: l_round_number NUMBER := p_round_number;

Line 8106: l_tpc_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;

8102: l_auction_header_id NUMBER := p_destination_auction_hdr_id;
8103: l_tp_id NUMBER := p_trading_partner_id;
8104: l_tp_contact_id NUMBER := p_trading_partner_contact_id;
8105: l_tp_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
8106: l_tpc_name HZ_PARTIES.PARTY_NAME%TYPE := NULL;
8107: l_user_id NUMBER := p_user_id;
8108: l_source_doctype_id NUMBER := p_source_doctype_id;
8109: l_round_number NUMBER := p_round_number;
8110: L_SOURCE_DOC_NUM VARCHAR2(25) := p_source_doc_num;