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:
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:
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,
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';
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:
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,