DBA Data[Home] [Help]

APPS.PA_PRJ_PROGRESS_REPORTS_PKG dependencies on PA_PROJ_PROGRESS_REPORTS_S

Line 78: l_short_description_old PA_PROJ_PROGRESS_REPORTS.short_description%TYPE;

74: AND task_id = p_task_id_old
75: FOR UPDATE of progress_status_code NOWAIT;
76: Recinfo C%ROWTYPE;
77: SAVEPOINT_TAG varchar2(60);
78: l_short_description_old PA_PROJ_PROGRESS_REPORTS.short_description%TYPE;
79: l_progress_asof_date_old date;
80: -- l_progress_asof_date_new date;
81: l_long_description_old PA_PROJ_PROGRESS_REPORTS.long_description%TYPE;
82: l_issues_old PA_PROJ_PROGRESS_REPORTS.issues%TYPE;

Line 568: SELECT PA_PROJ_PROGRESS_REPORTS_S.NEXTVAL

564: BEGIN
565: x_return_status := FND_API.G_RET_STS_SUCCESS;
566:
567: --Fetch the next sequence number for progres report
568: SELECT PA_PROJ_PROGRESS_REPORTS_S.NEXTVAL
569: INTO l_progress_report_id
570: FROM dual;
571:
572: INSERT INTO PA_PROJ_PROGRESS_REPORTS(