1 PACKAGE asg_cons_qpkg AUTHID DEFINER AS
2 /*$Header: asgconqs.pls 120.2.12020000.2 2012/07/24 11:48:59 ravir ship $*/
3
4 -- DESCRIPTION
5 -- This package contains callbacks registered with Oracle Lite
6 --
7 --
8 -- HISTORY
9 -- 22-oct-2003 ssabesan Merge 115.7.1158.12 into main line
10 -- 12-jun-2003 rsripada Added support to store device type
11 -- 31-mar-2003 rsripada Fix Online-query bug: 2878674
12 -- 25-feb-2003 rsripada Added validate_login method
13 -- 19-feb-2003 pkanukol Support for processing asg_purge_sdq at synch time
14 -- 11-feb-2003 rsripada Support for conflict detection
15 -- 06-jan-2003 ssabesan Added NOCOPY in function definition
16 -- 11-nov-2002 ssabesan added code for pub items upgrade
17 -- 29-may-2002 rsripada Removed temporary logging support
18 -- 25-apr-2002 rsripada Added final api for download_init
19 -- 16-apr-2002 rsripada Created
20
21
22 -- Notifies that inq has a new transaction
23 PROCEDURE upload_complete(p_clientid IN VARCHAR2,
24 p_tranid IN NUMBER);
25
26 -- Initialize data for download
27 -- Final API
28 PROCEDURE download_init(p_clientid IN VARCHAR2,
29 p_last_tranid IN NUMBER,
30 p_curr_tranid IN NUMBER,
31 p_high_prty IN VARCHAR2);
32
33 -- Notifies when all the client's data is sent
34 PROCEDURE download_complete(p_clientid IN VARCHAR2);
35
36 -- Populates the number of records for each publication item downloaded
37 PROCEDURE populate_q_rec_count(p_clientid IN VARCHAR2);
38
39 --routine that sets PI's in c$pub_list_q that have
40 --synch_completed (in asg_complete_refresh) set to 'N' for complete refresh
41 PROCEDURE set_complete_refresh;
42
43 --sets synch_completed flag in asg_complete_refresh to 'Y' for
44 --a particular pub_item and user_name
45 PROCEDURE set_synch_completed(p_user_name IN VARCHAR2,
46 p_pub_item IN VARCHAR2);
47
48 --sets synch_completed flag in asg_complete_refresh to 'Y' for
49 --pub_item for a given user_name
50 PROCEDURE set_synch_completed(p_user_name IN VARCHAR2);
51
52 --removes the row corresponding to a user_name and pub_item
53 --from asg_complete_refresh
54 PROCEDURE delete_row(p_user_name IN VARCHAR2,
55 p_pub_item IN VARCHAR2);
56
57 --removes all rows for user_name from asg_complete_refresh
58 --and for the current publication item with synch_completed='Y'.
59 PROCEDURE delete_row(p_user_name IN VARCHAR2);
60
61
62 --ROUTINE FOR REMOVING RECORDS FROM asg_complete_refresh
63 -- if the previous synch was successful
64 PROCEDURE process_compref_table(p_user_name IN VARCHAR2,
65 p_last_tranid IN NUMBER);
66
67 -- Routine for removing records from c$pub_list_q
68 -- If customization is disabled
69 PROCEDURE process_custom_pub_items(p_user_name IN VARCHAR2);
70
71 -- Routine for processing conflicts
72 PROCEDURE process_conflicts(p_user_name IN VARCHAR2);
73
74 -- Routine to determine if conflicts should be detected
75 PROCEDURE is_conflict_detection_needed(
76 p_user_name IN VARCHAR2,
77 p_upload_tranid IN NUMBER,
78 p_detect_conflict IN OUT NOCOPY VARCHAR2,
79 p_pubitem_tbl IN OUT NOCOPY asg_base.pub_item_tbl_type);
80
81 FUNCTION conflict_pub_items_exist(p_user_name IN VARCHAR2,
82 p_upload_tran_id IN NUMBER)
83 RETURN VARCHAR2;
84 PROCEDURE get_conf_pub_items_list(
85 p_user_name IN VARCHAR2,
86 p_upload_tranid IN NUMBER,
87 l_conf_pubs IN VARCHAR2,
88 p_pubitem_tbl IN OUT NOCOPY asg_base.pub_item_tbl_type);
89
90 -- Routine for processing conflicts
91 PROCEDURE process_pubitem_conflicts(p_user_name IN VARCHAR2,
92 p_upload_tranid IN NUMBER,
93 p_pubitem IN VARCHAR2);
94
95 FUNCTION get_pk_predicate(l_primary_key_columns IN VARCHAR2)
96 RETURN VARCHAR2;
97
98 PROCEDURE set_user_hwm_tranid(p_user_name IN VARCHAR2,
99 p_upload_tranid IN NUMBER);
100
101 --procedure for processing asg_purge_sdq at synch time
102 PROCEDURE process_purge_Sdq ( p_clientid IN VARCHAR2,
103 p_last_tranid IN NUMBER,
104 p_curr_tranid IN NUMBER);
105
106 -- Wrapper procedure on fnd_user_pkg
107 FUNCTION validate_login(p_user_name IN VARCHAR2,
108 p_password IN VARCHAR2) RETURN VARCHAR2;
109
110 FUNCTION is_previous_synch_successful(p_user_name IN VARCHAR2,
111 p_last_tranid IN NUMBER)
112 RETURN VARCHAR2;
113
114 FUNCTION find_last_synch_date(p_user_name IN VARCHAR2,
115 p_last_tranid IN NUMBER)
116 RETURN DATE;
117
118 FUNCTION find_device_type (p_user_name IN VARCHAR2)
119 RETURN VARCHAR2;
120
121 END asg_cons_qpkg;