DBA Data[Home] [Help]

APPS.PER_QP_INVOCATIONS dependencies on PER_QUICKPAINT_INVOCATIONS

Line 7: select per_quickpaint_invocations_s.nextval

3: --
4: function get_qp_session_id return NUMBER is
5: --
6: cursor c is
7: select per_quickpaint_invocations_s.nextval
8: from sys.dual;
9: --
10: l_id NUMBER;
11: --

Line 29: from per_quickpaint_invocations

25: ,p_qp_invocation_id IN OUT NOCOPY NUMBER) is
26: --
27: cursor c is
28: select 'x'
29: from per_quickpaint_invocations
30: where qp_session_id = p_qp_session_id
31: and invocation_context = p_invocation_context
32: and invocation_type = p_invocation_type
33: and qp_report_id = p_qp_report_id;

Line 36: select per_quickpaint_invocations_s.nextval

32: and invocation_type = p_invocation_type
33: and qp_report_id = p_qp_report_id;
34: --
35: cursor c1 is
36: select per_quickpaint_invocations_s.nextval
37: from sys.dual;
38: --
39: l_exists varchar2(1);
40: --

Line 356: delete from per_quickpaint_invocations

352: begin
353: --
354: hr_utility.set_location('per_qp_invocations.delete_quickpaints',1);
355: --
356: delete from per_quickpaint_invocations
357: where qp_session_id = p_qp_session_id;
358: --
359: commit;
360: --