APPS.PV_ASSIGN_UTIL_PVT dependencies on DUAL

Line 337: CURSOR C2 IS SELECT PV_PARTY_NOTIFICATIONS_S.nextval FROM sys.dual;

333: IS
334: l_api_name CONSTANT VARCHAR2(30) := 'Create_party_notification';
335: l_api_version_number CONSTANT NUMBER := 1.0;
336:
337: CURSOR C2 IS SELECT PV_PARTY_NOTIFICATIONS_S.nextval FROM sys.dual;
338: l_party_notification_id number;
339:
340: BEGIN
341:

Line 550: select pv_lead_assignments_s.nextval into l_Lead_assignment_ID from sys.dual;

546:
547: raise FND_API.G_EXC_ERROR;
548: end if;
549:
550: select pv_lead_assignments_s.nextval into l_Lead_assignment_ID from sys.dual;
551:
552: -- Debug Message
553: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
554: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

Line 724: select pv_lead_workflows_s.nextval into l_Lead_Workflow_ID from sys.dual;

720: END IF;
721:
722: x_return_status := FND_API.G_RET_STS_SUCCESS ;
723:
724: select pv_lead_workflows_s.nextval into l_Lead_Workflow_ID from sys.dual;
725:
726: insert into pv_lead_workflows(
727: LEAD_WORKFLOW_ID,
728: LAST_UPDATE_DATE,

Line 1045: rel.role_resource_type = 'RS_INDIVIDUAL' and

1041: extn.category = pv_assignment_pub.g_resource_employee and
1042: extn.source_id = per.person_id and
1043: (trunc(sysdate) between per.effective_start_date and per.effective_end_date) and
1044: extn.resource_id = rel.role_resource_id and
1045: rel.role_resource_type = 'RS_INDIVIDUAL' and
1046: (rel.end_date_active is null or rel.end_date_active > sysdate) and
1047: rel.delete_flag = 'N' and
1048: rel.role_id = role.role_id and
1049: role.role_type_code = 'PRM' and

Line 1184: rel.role_resource_type = 'RS_INDIVIDUAL' and

1180: (emp.end_date is null or emp.end_date > sysdate) and
1181: emp.status in ('A', 'I') and
1182: emp.object_id = PT_PROF.partner_party_id and
1183: extn.resource_id = rel.role_resource_id and
1184: rel.role_resource_type = 'RS_INDIVIDUAL' and
1185: (rel.end_date_active is null or rel.end_date_active > sysdate) and
1186: rel.delete_flag = 'N' and
1187: rel.role_id = role.role_id and
1188: role.role_type_code = 'PRM' and

Line 1849: ' Access Action: '||decode(p_access_action, 1, 'ADD', 2, 'REMOVE') into l_debug_string from dual;

1845: fnd_msg_pub.Add;
1846:
1847:
1848: select 'Access Type: '||decode(p_access_type, 1, 'CM', 2, 'PT', 3, 'PT ORG') ||
1849: ' Access Action: '||decode(p_access_action, 1, 'ADD', 2, 'REMOVE') into l_debug_string from dual;
1850:
1851: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1852: fnd_message.Set_Token('TEXT', l_debug_string);
1853: fnd_msg_pub.Add;

Line 1978: 'UNKNOWN') into l_temp from dual;

1974:
1975: select decode(p_access_type, pv_assignment_pub.G_CM_ACCESS, 'CM',
1976: pv_assignment_pub.G_PT_ACCESS, 'PT',
1977: pv_assignment_pub.G_PT_ORG_ACCESS, 'PT_ORG',
1978: 'UNKNOWN') into l_temp from dual;
1979:
1980: l_pt_full_access_opp := fnd_profile.value('PV_ALLOW_PT_FULL_OPP_ACCESS');
1981:
1982:

Line 2454: select as_accesses_s.nextval into l_sales_team_rec.Access_Id from dual;

2450:
2451:
2452: elsif p_access_action = pv_assignment_pub.G_ADD_ACCESS and not l_access_exists_flag then
2453:
2454: select as_accesses_s.nextval into l_sales_team_rec.Access_Id from dual;
2455:
2456: open get_opp_open_flag_csr(p_lead_id);
2457: fetch get_opp_open_flag_csr into l_open_flag;
2458: close get_opp_open_flag_csr;