PACKAGE: APPS.PSP_MATRIX_DRIVER_PKG

Source

1 package psp_matrix_driver_pkg as
2 /* $Header: PSPLSMTS.pls 120.1.12000000.1 2007/01/18 12:24:14 appldev noship $ */
3 
4 	procedure load_org_schedule(			p_return_status  	OUT NOCOPY	NUMBER,
5 							p_log_message		OUT NOCOPY	VARCHAR2,
6 		    			    		p_list_organization_id  IN 	VARCHAR2,
7 			 				p_period_from 		IN	VARCHAR2,
8 			 				p_period_to	       	IN	VARCHAR2,
9 			 				p_report_type		IN	VARCHAR2,
10 							p_business_group_id	IN	NUMBER,
11 						        p_set_of_books_id	IN	NUMBER
12 	            			);
13 	procedure load_table_schedule(  sch_id  		IN	NUMBER,
14 					p_business_group_id	IN	NUMBER,
15 					p_set_of_books_id	IN	NUMBER
16 	            			);
17 	procedure load_table(sch_id  number);
18 	procedure purge_table;
19 	procedure set_start_period(n NUMBER);
20 	procedure set_runid;
21 	procedure clear_table(event VARCHAR2);
22 
23 	procedure load_organizations	(retcode		OUT NOCOPY NUMBER,
24 					p_organization_id	IN VARCHAR2,
25 					p_period_from		IN DATE,
26 					p_period_to		IN DATE,
27 					p_report_type		IN VARCHAR2,
28 					p_business_group_id	IN NUMBER,
29 					p_set_of_books_id	IN NUMBER);
30 
31 --	FUNCTION check_exceedence       (p_payroll_id		IN  NUMBER) RETURN BOOLEAN; Commneted for Bug 4511249
32 	FUNCTION check_exceedence       (p_assignment_id	IN  NUMBER) RETURN BOOLEAN;
33 	FUNCTION get_max_periods RETURN NUMBER;
34 	FUNCTION get_start_period(n NUMBER) RETURN DATE;
35 	pragma RESTRICT_REFERENCES  ( get_start_period, WNDS, WNPS );
36 	FUNCTION get_end_period(n NUMBER) RETURN DATE;
37 	pragma RESTRICT_REFERENCES  ( get_end_period, WNDS, WNPS );
38 	FUNCTION get_run_id RETURN NUMBER;
39 	pragma RESTRICT_REFERENCES  ( get_run_id, WNDS, WNPS );
40 	FUNCTION get_dynamic_prompt(n NUMBER, s_id number) RETURN VARCHAR2;
41 	FUNCTION get_dynamic_totals(n NUMBER) RETURN NUMBER;
42         FUNCTION check_exceedence_sc_copy RETURN BOOLEAN;
43         PROCEDURE check_sch_hierarchy(p_assignment_id	 IN NUMBER,
44             			     p_payroll_id	 IN NUMBER,
45 				     p_hierarchy_id	 OUT NOCOPY	NUMBER,
46 				     p_invalid_count     OUT NOCOPY	NUMBER);
47 end psp_matrix_driver_pkg;