DBA Data[Home] [Help]

APPS.PV_ASSIGNMENT_PVT dependencies on DUAL

Line 65: CURSOR C2 IS SELECT PV_OPPTY_ROUTING_LOGS_S.nextval FROM sys.dual;

61: IS
62: l_api_name CONSTANT VARCHAR2(30) := 'Create_Oppty_Routing_Log_Row';
63: l_api_version_number CONSTANT NUMBER := 1.0;
64:
65: CURSOR C2 IS SELECT PV_OPPTY_ROUTING_LOGS_S.nextval FROM sys.dual;
66:
67: CURSOR get_org_id ( pc_user_id NUMBER)
68: IS
69: SELECT business_group_id

Line 210: CURSOR C2 IS SELECT PV_ASSIGNMENT_LOGS_S.nextval FROM sys.dual;

206: IS
207: l_api_name CONSTANT VARCHAR2(30) := 'Create_assignment_log_row';
208: l_api_version_number CONSTANT NUMBER := 1.0;
209:
210: CURSOR C2 IS SELECT PV_ASSIGNMENT_LOGS_S.nextval FROM sys.dual;
211: l_assignment_log_id number;
212:
213: BEGIN
214:

Line 4179: select pv_lead_workflows_s.nextval into l_itemkey from dual;

4175:
4176: -- Initialize API return status to success
4177: x_return_status := FND_API.G_RET_STS_SUCCESS;
4178:
4179: select pv_lead_workflows_s.nextval into l_itemkey from dual;
4180:
4181:
4182: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
4183: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');