DBA Data[Home] [Help]

APPS.PV_LEADLOG_PVT dependencies on PV_ASSIGNMENT_LOGS

Line 73: FROM pv_assignment_logs

69:
70:
71: CURSOR C IS
72: SELECT rowid
73: FROM pv_assignment_logs
74: WHERE assignment_ID = X_assignlog_ID;
75:
76: l_assignment_id number;
77:

Line 83: select pv_assignment_logs_s.nextval

79:
80:
81: x_return_status := 'S';
82:
83: select pv_assignment_logs_s.nextval
84: into l_assignment_ID
85: from sys.dual;
86:
87:

Line 89: insert into pv_assignment_logs (

85: from sys.dual;
86:
87:
88:
89: insert into pv_assignment_logs (
90: ASSIGNMENT_ID ,
91: LAST_UPDATE_DATE,
92: LAST_UPDATED_BY,
93: CREATION_DATE,

Line 393: FROM pv_assignment_logs

389: x_msg_data OUT NOCOPY VARCHAR2) IS
390:
391: CURSOR C IS
392: SELECT rowid
393: FROM pv_assignment_logs
394: WHERE assignment_ID = X_assignlog_ID;
395:
396: l_assignment_id number;
397: l_api_name CONSTANT VARCHAR2(30) := 'InsertLeadStatusLogRow';

Line 404: select pv_assignment_logs_s.nextval

400:
401:
402: x_return_status := FND_API.G_RET_STS_SUCCESS;
403:
404: select pv_assignment_logs_s.nextval
405: into l_assignment_ID
406: from sys.dual;
407:
408:

Line 409: insert into pv_assignment_logs (

405: into l_assignment_ID
406: from sys.dual;
407:
408:
409: insert into pv_assignment_logs (
410: ASSIGNMENT_ID ,
411: LAST_UPDATE_DATE,
412: LAST_UPDATED_BY,
413: CREATION_DATE,