PACKAGE: APPS.PA_PAGE_LAYOUT_UTILS

Source

1 PACKAGE PA_Page_layout_Utils AUTHID CURRENT_USER AS
2 /* $Header: PAPGLUTS.pls 120.1 2005/08/19 16:40:38 mwasowic noship $ */
3 	procedure	copy_object_page_layouts(
4                         p_object_type		IN     VARCHAR2,
5 			P_object_id_from        IN     number,
6 			P_object_id_to 	        IN     number,
7 			--p_function_name         IN     VARCHAR2 := NULL,  --Bug 3665562
8 		        x_return_status         OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9    			x_msg_count             OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
10    			x_msg_data              OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11 			);
12 
13      /* This is the function to check customer and project value columns
14         exists in the project header at the project level */
15      procedure	check_cols_in_proj_header(
16                         p_object_type	   IN     VARCHAR2,
17 			p_object_id        IN     number,
18                         x_customer_exists  OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
19                         x_proj_val_exists  OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
20 
21 	Function get_ak_region_code
22 	  (
23 	   p_region_name IN VARCHAR2,
24 	   p_application_id IN number
25 	   )  RETURN VARCHAR2  ;
26 
27 	Function get_region_source_code
28 	  (
29 	   p_region_source_name IN VARCHAR2,
30 	   p_region_source_type IN VARCHAR2,
31 	   p_application_id IN NUMBER,
32 	   p_flex_name IN VARCHAR2
33 	   )  RETURN VARCHAR2 ;
34 
35 	FUNCTION is_page_type_region_deletable(
36 					       p_page_type_code IN VARCHAR2,
37 					       p_region_source_type IN VARCHAR2,
38 					       p_region_source_code IN VARCHAR2) RETURN VARCHAR2  ;
39 
40 	FUNCTION get_context_name( p_context_code IN VARCHAR2)
41 	RETURN VARCHAR2  ;
42 
43 	 procedure Check_pagelayout_Name_Or_Id (
44 			p_pagelayout_name	IN	VARCHAR2 :=FND_API.G_MISS_CHAR,
45 			p_pagetype_code		IN	VARCHAR2 :=FND_API.G_MISS_CHAR,
46 			p_check_id_flag		IN	VARCHAR2 := 'A',
47 			x_pagelayout_id		IN OUT	NOCOPY NUMBER , --File.Sql.39 bug 4440895
48 			x_return_status		OUT	NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
49 			x_error_message_code	OUT	NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
50 
51          FUNCTION check_page_layout_deletable (p_page_id NUMBER)
52          return varchar2;
53 
54          FUNCTION GET_PAGE_ID_FROM_FUNCTION(
55 			p_page_type_code	IN	VARCHAR2,
56 			p_pers_function_name	IN	VARCHAR2
57 			)
58 	 return NUMBER;
59 
60 	 PROCEDURE POPULATE_PERS_FUNCTIONS (p_page_type_code_tbl  IN	 SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
61 				   p_function_name_tbl		  IN	 SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
62 				   x_return_status		  OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
63 	   			   x_msg_count			  OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
64 			           x_msg_data			  OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
65 				  );
66 END PA_Page_layout_Utils;