APPS.PV_OPPORTUNITY_VHUK dependencies on PV_ASSIGNMENT_PUB

Line 66: l_username_tbl pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type();

62: select name from wf_local_roles
63: where name = pc_rolename;
64:
65: l_role_list wf_directory.usertable;
66: l_username_tbl pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type();
67: l_username varchar2(50);
68: l_adhoc_role varchar2(80);
69: l_exist_rolename varchar2(80);
70:

Line 871: lc_cursor pv_assignment_pub.g_ref_cursor_type;

867: NVL(grp.end_date_active,sysdate) AND
868: mem.resource_id = RES.resource_id AND
869: RES.resource_id = pc_resource_id;
870:
871: lc_cursor pv_assignment_pub.g_ref_cursor_type;
872:
873: CURSOR lc_opportunity (pc_lead_id number) is
874: SELECT ld.customer_id, ld.address_id
875: , pt.party_name, ld.currency_code

Line 979: ,p_mode => pv_assignment_pub.g_external_org

975: ( p_api_version_number => 1.0
976: ,p_init_msg_list => FND_API.G_FALSE
977: ,p_commit => FND_API.G_FALSE
978: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
979: ,p_mode => pv_assignment_pub.g_external_org
980: ,p_partner_id => p_party_relation_id
981: ,p_entity => l_entity
982: ,p_entity_id => l_lead_id
983: ,p_retrieve_mode => 'BOTH' -- change from CM to BOTH for 11.5.10

Line 1096: if l_rs_details_tbl(i).person_type = pv_assignment_pub.g_resource_employee then

1092: loop
1093: -- The returned table has all CM from Vendor and VAD.
1094: -- Since VAD CM does not have person id, we need to populate partner_cont_party_id
1095:
1096: if l_rs_details_tbl(i).person_type = pv_assignment_pub.g_resource_employee then
1097: l_sales_team_rec.partner_cont_party_id := null;
1098: l_sales_team_rec.person_id := l_rs_details_tbl(i).person_id;
1099: else
1100: l_sales_team_rec.person_id := null;

Line 1828: IF l_category = pv_assignment_pub.g_resource_employee THEN

1824: fetch lc_get_pt_emp_cat into l_party_id, l_category,
1825: l_party_name, l_creating_username;
1826: close lc_get_pt_emp_cat;
1827:
1828: IF l_category = pv_assignment_pub.g_resource_employee THEN
1829:
1830: l_vendor_org_name := l_party_name;
1831:
1832: ELSIF l_category = pv_assignment_pub.g_resource_party THEN

Line 1832: ELSIF l_category = pv_assignment_pub.g_resource_party THEN

1828: IF l_category = pv_assignment_pub.g_resource_employee THEN
1829:
1830: l_vendor_org_name := l_party_name;
1831:
1832: ELSIF l_category = pv_assignment_pub.g_resource_party THEN
1833:
1834: open lc_get_pt_ven_name(l_party_id);
1835: fetch lc_get_pt_ven_name into l_vendor_org_name;
1836: close lc_get_pt_ven_name;