DBA Data[Home] [Help]

APPS.PV_OPPORTUNITY_VHUK dependencies on JTF_NUMBER_TABLE

Line 1764: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1760: AND VENDOR.PARTY_TYPE = 'ORGANIZATION'
1761: AND VENDOR.status = 'A'
1762: AND PVPP.SALES_PARTNER_FLAG = 'Y';
1763:
1764: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1765:
1766: cursor lc_get_pt_org_name(pc_item_type varchar2, pc_item_key varchar2) is
1767: select pt.party_name, pvas.partner_id
1768: from hz_parties pt,

Line 1964: l_partner_id_tbl := JTF_NUMBER_TABLE();

1960: l_notify_cm_flag || l_notify_others_flag);
1961: fnd_msg_pub.Add;
1962: END IF;
1963:
1964: l_partner_id_tbl := JTF_NUMBER_TABLE();
1965:
1966: OPEN lc_users(l_lead_id, l_notify_cm_flag, l_notify_am_flag, l_notify_pt_flag, l_notify_others_flag);
1967: LOOP
1968: FETCH lc_users INTO l_user_id, l_resource_id, l_user_name, l_user_type, l_partner_id;