APPS.PA_PROGRESS_REPORT_PKG dependencies on PA_PROGRESS_REPORT_VERS

Line 31: cursor C is select ROWID from PA_PROGRESS_REPORT_VERS

27:
28: l_version_id NUMBER;
29: l_rowid ROWID;
30:
31: cursor C is select ROWID from PA_PROGRESS_REPORT_VERS
32: where VERSION_ID = l_VERSION_ID
33: ;
34:
35: BEGIN

Line 45: insert into PA_PROGRESS_REPORT_VERS (

41: --INTO l_version_id
42: -- FROM dual;
43:
44:
45: insert into PA_PROGRESS_REPORT_VERS (
46: OBJECT_ID,
47: OBJECT_TYPE,
48: PAGE_ID,
49: VERSION_ID,

Line 76: pa_progress_report_vers_s.NEXTVAL,

72: ) VALUES (
73: P_OBJECT_ID,
74: P_OBJECT_TYPE,
75: P_PAGE_ID,
76: pa_progress_report_vers_s.NEXTVAL,
77: P_PAGE_TYPE,
78: P_PAGE_STATUS,
79:
80: p_report_start_date,

Line 148: update PA_PROGRESS_REPORT_VERS set

144:
145: --debug_msg ('before update ');
146: --debug_msg ('before update ' || To_char (p_version_id));
147:
148: update PA_PROGRESS_REPORT_VERS set
149: OBJECT_ID = Nvl(p_object_id, object_id),
150: OBJECT_TYPE = Nvl(p_object_type, object_type),
151: PAGE_ID = Nvl(p_page_id, page_id),
152: PAGE_TYPE_CODE = Nvl(p_page_type, page_type_CODE),

Line 204: delete from PA_PROGRESS_REPORT_VERS

200: begin
201:
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
204: delete from PA_PROGRESS_REPORT_VERS
205: where VERSION_ID = p_version_id AND record_version_number = nvl(p_record_version_number, record_version_number);
206:
207: EXCEPTION
208: WHEN OTHERS THEN

Line 338: pa_progress_report_vers_s.NEXTVAL,

334: ) VALUES(
335: P_VERSION_ID,
336: P_REGION_SOURCE_TYPE,
337: P_REGION_CODE,
338: pa_progress_report_vers_s.NEXTVAL,
339: 1,
340: P_ATTRIBUTE1,
341: P_ATTRIBUTE2,
342: P_ATTRIBUTE3,