1 package CSM_HTML5_PKG AUTHID CURRENT_USER as
2 /*$Header: csmhtm5s.pls 120.1.12020000.2 2013/04/09 06:24:57 saradhak noship $*/
3
4 -- DESCRIPTION
5 -- This package is used by CSM HTML5 MFS Application
6 --
7 -- HISTORY
8 -- 01-jun-2010 saradhak Created
9 --
10 procedure query_validate_user( p_user_name IN VARCHAR2,p_password IN VARCHAR2,
11 p_result OUT nocopy CLOB,
12 x_return_status OUT nocopy VARCHAR2,x_error_message OUT nocopy VARCHAR2);
13
14 procedure query_sync_data_js(
15 p_user_name IN VARCHAR2, p_password IN VARCHAR2, p_result OUT nocopy CLOB,
16 x_return_status OUT nocopy VARCHAR2, x_error_message OUT nocopy VARCHAR2,
17 p_bypass_auth IN BOOLEAN DEFAULT FALSE
18 );
19 procedure query_get_schema_js(
20 p_result OUT nocopy CLOB, x_return_status OUT nocopy VARCHAR2, x_error_message OUT nocopy VARCHAR2
21 ) ;
22 procedure query_schema_js(
23 p_user_name IN VARCHAR2,p_result OUT nocopy CLOB, x_return_status OUT nocopy VARCHAR2, x_error_message OUT nocopy VARCHAR2
24 );
25 procedure q_inc_sync_cref_js(
26 p_user_name IN VARCHAR2, p_password IN VARCHAR2, p_result OUT nocopy CLOB,
27 x_return_status OUT nocopy VARCHAR2, x_error_message OUT nocopy VARCHAR2
28 ) ;
29 procedure q_inc_sync_data_js( p_user_name IN VARCHAR2, p_password IN VARCHAR2,
30 p_tranid IN NUMBER, p_result OUT nocopy CLOB, x_return_status OUT nocopy VARCHAR2,
31 x_error_message OUT nocopy VARCHAR2, p_refresh_all boolean :=false ) ;
32 FUNCTION has_upgraded_version(p_user_name IN VARCHAR2,p_version IN VARCHAR2 :=NULL) RETURN BOOLEAN;
33 PROCEDURE set_app_revision(p_version IN VARCHAR2,p_force_update IN VARCHAR2 :='N');
34 FUNCTION get_app_revision(p_u IN VARCHAR2:=NULL,p_v IN VARCHAR2:=NULL) RETURN VARCHAR2;
35 PROCEDURE set_comp_ref(p_pi IN VARCHAR2);
36 PROCEDURE set_comp_ref(p_user_name IN VARCHAR2,p_pi IN VARCHAR2);
37 PROCEDURE set_indx_ref(p_idx IN VARCHAR2);
38 PROCEDURE set_indx_ref(p_user_name IN VARCHAR2,p_idx IN VARCHAR2);
39 FUNCTION get_MD5_hash (p_input IN VARCHAR2) RETURN VARCHAR2;
40 FUNCTION generate_rsa_keys RETURN VARCHAR2;
41 PROCEDURE mark_pi_altered(p_pi IN VARCHAR2);
42 PROCEDURE enable_pi(p_pi IN VARCHAR2);
43 PROCEDURE disable_pi(p_pi IN VARCHAR2);
44 PROCEDURE PURGE_HTML5_DATA(p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2);
45 FUNCTION nextInt(minN IN NUMBER, maxN IN number) RETURN NUMBER;
46 FUNCTION isHTML5User(p_user_name IN VARCHAR2) return BOOLEAN;
47 FUNCTION SUBMIT_CON_QUERY(p_USER_ID IN NUMBER,
48 p_QUERY_ID IN NUMBER,
49 p_INSTANCE_ID IN NUMBER) RETURN NUMBER;
50 PROCEDURE CONC_EXECUTE_QUERY(errbuf OUT NOCOPY VARCHAR2,
51 RETCODE OUT NOCOPY VARCHAR2,
52 p_USER_ID IN NUMBER,
53 p_QUERY_ID IN NUMBER,
54 p_INSTANCE_ID IN NUMBER
55 );
56 FUNCTION GET_SECURE_SESSION(p_uname IN VARCHAR2) RETURN VARCHAR2;
57 FUNCTION GET_REUSABLE(p_USER_NAME IN VARCHAR2,p_password IN VARCHAR2,p_QUERY_ID IN NUMBER) RETURN VARCHAR2;
58 PROCEDURE SET_REUSABLE(p_user_name IN VARCHAR2,p_QUERY_ID IN NUMBER,p_INSTANCE_ID IN NUMBER);
59 FUNCTION authenticate(p_user_name IN VARCHAR2, p_password IN VARCHAR2) RETURN BOOLEAN;
60 procedure query_generate_html5_data( p_user_name IN VARCHAR2,p_result OUT nocopy CLOB, x_return_status OUT nocopy VARCHAR2,
61 x_error_message OUT nocopy VARCHAR2);
62 procedure generate_html5_data(p_user_name IN VARCHAR2);
63 procedure dbms_createContext;
64 procedure dbms_clearAllContext;
65 PROCEDURE HTML5_PARSE_XML(p_SYNC_ID IN NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
66 PROCEDURE setup_inq_info(p_user_name IN VARCHAR2,p_tranid IN NUMBER, x_return_status OUT NOCOPY VARCHAR2);
67 PROCEDURE process_upload(curr_user IN VARCHAR2);
68 PROCEDURE get_all_pub_items(p_user_name IN VARCHAR2,
69 p_tranid IN NUMBER,
70 x_pubitems_tbl OUT NOCOPY asg_apply.vc2_tbl_type,
71 x_return_status OUT NOCOPY VARCHAR2);
72
73 PROCEDURE reapply_transaction(p_user_name IN VARCHAR2,
74 p_tranid IN NUMBER,
75 x_return_status OUT NOCOPY VARCHAR2,
76 p_commit_flag IN BOOLEAN:=true);
77
78 PROCEDURE CONC_PROCESS_UPLOAD(errbuf OUT NOCOPY VARCHAR2,RETCODE OUT NOCOPY VARCHAR2);
79
80 FUNCTION uploadData(p_user_name IN VARCHAR2,p_password IN VARCHAR2,p_sync_data IN CLOB,p_seq_data IN CLOB,p_result OUT nocopy VARCHAR2) RETURN NUMBER;
81 PROCEDURE query_parse_upload(p_user_name IN VARCHAR2,p_session_id IN NUMBER,p_result OUT nocopy CLOB,x_return_status OUT nocopy VARCHAR2,x_error_message OUT nocopy VARCHAR2);
82
83 FUNCTION isSSOEnabled RETURN VARCHAR2;
84 FUNCTION isOIDAuth(p_user_name IN VARCHAR2) RETURN BOOLEAN;
85 PROCEDURE setForceLocalLogin(p_user_name IN VARCHAR2,p_v IN VARCHAR2:='Y');
86 PROCEDURE DROP_USER(p_user_id IN NUMBER);
87 FUNCTION IS_FIRST_SYNC(p_user_name IN VARCHAR2) RETURN BOOLEAN;
88 FUNCTION get_app_upg_info(p_user_name IN VARCHAR2) RETURN VARCHAR2;
89
90 /*--for debugging only
91 PROCEDURE set_rsa_keys(p_user_name IN VARCHAR2,x_e OUT NOCOPY NUMBER,x_d OUT NOCOPY NUMBER, x_n OUT NOCOPY NUMBER
92 ,p_in_prof IN VARCHAR2 :='RSA_KEY') ;
93 procedure set_user_profile(p_uname IN VARCHAR2,pname IN VARCHAR2, pvalue IN VARCHAR2);
94 */
95
96
97 end CSM_HTML5_PKG;