1 PACKAGE PER_QP_INVOCATIONS AUTHID CURRENT_USER as
2 /* $Header: ffqti01t.pkh 115.2 2002/12/23 13:12:39 arashid ship $ */
3 --
4 function get_qp_session_id return NUMBER;
5 --
6 procedure pre_insert_checks(p_qp_session_id NUMBER
7 ,p_invocation_context NUMBER
8 ,p_invocation_type VARCHAR2
9 ,p_qp_report_id NUMBER
10 ,p_qp_invocation_id IN OUT NOCOPY NUMBER);
11 --
12 procedure populate_fields(p_qp_report_id NUMBER
13 ,p_invocation_context NUMBER
14 ,p_invocation_type VARCHAR2
15 ,p_session_date DATE
16 ,p_qp_report_name IN OUT NOCOPY VARCHAR2
17 ,p_assignment_set IN OUT NOCOPY VARCHAR2
18 ,p_full_name IN OUT NOCOPY VARCHAR2
19 ,p_assignment_number IN OUT NOCOPY VARCHAR2
20 ,p_user_person_type IN OUT NOCOPY VARCHAR2);
21 --
22 function format_date_line(p_textline VARCHAR2) return VARCHAR2;
23 --
24 function load_result(p_assignment_id NUMBER
25 ,p_qp_invocation_id NUMBER) return VARCHAR2;
26 --
27 procedure get_assignment(p_assignment_id NUMBER
28 ,p_qp_invocation_id NUMBER
29 ,p_full_name IN OUT NOCOPY VARCHAR2
30 ,p_user_person_type IN OUT NOCOPY VARCHAR2
31 ,p_assignment_number IN OUT NOCOPY VARCHAR2
32 ,p_result OUT NOCOPY VARCHAR2);
33 --
34 procedure init_cust(p_customized_restriction_id NUMBER
35 ,p_restrict_empapl IN OUT NOCOPY VARCHAR2
36 ,p_restrict_person_type IN OUT NOCOPY VARCHAR2
37 ,p_restrict_inq IN OUT NOCOPY VARCHAR2
38 ,p_restrict_use IN OUT NOCOPY VARCHAR2);
39 --
40 function validate_assignment(p_business_group_id NUMBER
41 ,p_session_date DATE
42 ,p_full_name VARCHAR2
43 ,p_assignment_number VARCHAR2) return NUMBER;
44 --
45 procedure delete_quickpaints(p_qp_session_id NUMBER);
46 --
47 function print_result(p_business_group_id NUMBER
48 ,p_session_date DATE
49 ,p_qp_invocation_id NUMBER) return BOOLEAN;
50 --
51 END PER_QP_INVOCATIONS;
[Home] [Help]