PACKAGE: APPS.PQH_WKS_ERROR_CHK

Source

1 PACKAGE pqh_wks_error_chk AUTHID CURRENT_USER AS
2 /* $Header: pqwkserr.pkh 115.9 2002/12/05 00:32:07 rpasapul ship $ */
3 
4 PROCEDURE check_wks_errors
5 (
6   p_worksheet_detail_id     IN pqh_worksheet_details.worksheet_detail_id%TYPE,
7   p_status                  OUT NOCOPY varchar2
8 );
9 
10 PROCEDURE check_wks_dates
11 (
12   p_worksheet_detail_id     IN pqh_worksheet_details.worksheet_detail_id%TYPE,
13   p_status                  OUT NOCOPY varchar2,
14   p_message                 OUT NOCOPY varchar2
15 );
16 PROCEDURE populate_globals
17 (
18   p_worksheet_detail_id     IN pqh_worksheet_details.worksheet_detail_id%TYPE
19 );
20 
21 PROCEDURE check_level1_rows
22 (
23   p_worksheet_detail_id     IN pqh_worksheet_details.worksheet_detail_id%TYPE
24 );
25 
26 PROCEDURE check_wks_details
27 (
28   p_worksheet_detail_id     IN pqh_worksheet_details.worksheet_detail_id%TYPE
29 );
30 
31 PROCEDURE check_wks_periods
32 (
33   p_worksheet_detail_id     IN pqh_worksheet_details.worksheet_detail_id%TYPE,
34   p_worksheet_period_id     IN pqh_worksheet_periods.worksheet_period_id%TYPE
35 );
36 
37 
38 PROCEDURE check_wks_budget_sets
39 (
40   p_worksheet_period_id       IN pqh_worksheet_periods.worksheet_period_id%TYPE,
41   p_worksheet_budget_set_id   IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE
42 );
43 
44 PROCEDURE check_wks_budget_elements
45 (
46   p_worksheet_budget_set_id   IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE,
47   p_worksheet_bdgt_elmnt_id   IN pqh_worksheet_fund_srcs.worksheet_bdgt_elmnt_id%TYPE
48 );
49 
50 PROCEDURE check_wks_fund_srcs
51 (
52   p_worksheet_bdgt_elmnt_id   IN pqh_worksheet_fund_srcs.worksheet_bdgt_elmnt_id%TYPE,
53   p_worksheet_fund_src_id     IN pqh_worksheet_fund_srcs.worksheet_fund_src_id%TYPE
54 );
55 
56 PROCEDURE set_wks_log_context
57 (
58   p_worksheet_detail_id     IN  pqh_worksheet_details.worksheet_detail_id%TYPE,
59   p_log_context             OUT NOCOPY pqh_process_log.log_context%TYPE
60 );
61 
62 PROCEDURE set_wpr_log_context
63 (
64   p_worksheet_period_id     IN  pqh_worksheet_periods.worksheet_period_id%TYPE,
65   p_log_context             OUT NOCOPY pqh_process_log.log_context%TYPE
66 );
67 
68 PROCEDURE set_wst_log_context
69 (
70   p_worksheet_budget_set_id     IN  pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE,
71   p_log_context                 OUT NOCOPY pqh_process_log.log_context%TYPE
72 );
73 
74 PROCEDURE set_wel_log_context
75 (
76   p_worksheet_bdgt_elmnt_id     IN  pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE,
77   p_log_context                 OUT NOCOPY pqh_process_log.log_context%TYPE
78 );
79 
80 PROCEDURE set_wfs_log_context
81 (
82   p_worksheet_fund_src_id       IN  pqh_worksheet_fund_srcs.worksheet_fund_src_id%TYPE,
83   p_log_context                 OUT NOCOPY pqh_process_log.log_context%TYPE
84 );
85 
86 PROCEDURE check_input_wks_details
87 (
88   p_worksheet_detail_id     IN pqh_worksheet_details.worksheet_detail_id%TYPE
89 );
90 
91 PROCEDURE end_log;
92 
93 PROCEDURE updt_batch
94 (
95  p_message_text   IN pqh_process_log.message_text%TYPE
96 );
97 
98 PROCEDURE check_pc_posn
99 (
100   p_position_id             IN pqh_worksheet_details.position_id%TYPE,
101   p_status                  OUT NOCOPY varchar2
102 );
103 
104 END ; -- end of specification for package pqh_wks_error_chk