1 PACKAGE BODY PA_CLIENT_EXTN_PROJ_LIMIT AS
2 /* $Header: PACEPLTB.pls 120.0.12020000.3 2013/03/25 10:16:00 udshanmu noship $*/
3
4 FUNCTION CLIENT_EXTN_ENABLED
5 RETURN VARCHAR2
6 IS
7 l_client_extn_enabled VARCHAR2(1):='N';
8 BEGIN
9 /* Here the variable l_client_extn_enabled is by default set to 'N' .
10 If customer wants to enable the client
11 extension, uncomment the below code */
12 --l_client_extn_enabled:='Y';
13
14 RETURN l_client_extn_enabled;
15
16 END ;
17
18 PROCEDURE POPULATE_PROJECT_ID_LIST(p_project_id OUT NOCOPY PROJ_LIST)
19 IS
20 BEGIN
21 /* Below is the code to be specified by client to populate
22 list of projects to be processed by the
23 program PRC: Refresh Project Summary amounts .
24 This output ,which is out of table type PROJ_LIST,
25 is picked up by
26 PA_PROJ_ACCUM_MAIN.proj_refresh procedure for processing*/
27
28 /* Below commented coded is the sample code to populate
29 output table p_project_id from table pa_projects.
30 customer needs to modify the query as per the requirements*/
31
32 --select project_id bulk collect into p_project_id from pa_projects;
33 null;
34 END POPULATE_PROJECT_ID_LIST;
35
36 END PA_CLIENT_EXTN_PROJ_LIMIT;
[Home] [Help]