[Home] [Help]
PACKAGE: APPS.PA_PAGE_LAYOUT_UTILS
Source
1 PACKAGE PA_Page_layout_Utils 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;