1 PACKAGE asg_defer AUTHID CURRENT_USER AS
2 /*$Header: asgdfrs.pls 120.3 2009/07/14 09:08:31 saradhak ship $*/
3
4 -- DESCRIPTION
5 -- This package supports deferred transactions.
6 --
7 --
8 -- HISTORY
9 -- 13-jul-2009 saradhak added commit flag to reapply_txn & discard_txn apis
10 -- 15-sep-2004 ssabesan Changes for delivery notification
11 -- 28-nov-2002 ssabesan Added NOCOPY in function definition
12 -- 22-feb-2002 rsripada Finalized api spec
13 -- 19-feb-2002 rsripada Created
14
15
16 -- Defers a row. Returns FND_API.G_RET_STS_SUCCESS if the row was
17 -- successfully deferred. FND_API.G_RET_STS_ERROR otherwise. Will
18 -- commit any work done as part of this proceduer using autonomous
19 -- transaction. sequence is a column in the inq that together with
20 -- the user_name, tran_id, pub_item can uniquely identify a record
21 -- in the inq.
22 PROCEDURE defer_row(p_user_name IN VARCHAR2,
23 p_tranid IN NUMBER,
24 p_pubitem IN VARCHAR2,
25 p_sequence IN NUMBER,
26 p_error_msg IN VARCHAR2,
27 x_return_status OUT NOCOPY VARCHAR2);
28
29 -- Removes the deferred row from inq and removes references
30 -- to it as a deferred row.
31 PROCEDURE delete_deferred_row(p_user_name IN VARCHAR2,
32 p_tranid IN NUMBER,
33 p_pubitem IN VARCHAR2,
34 p_sequence IN NUMBER,
35 x_return_status OUT NOCOPY VARCHAR2);
36
37 -- Marks this records for delete in the client's Olite database.
38 PROCEDURE reject_row(p_user_name IN VARCHAR2,
39 p_tranid IN NUMBER,
40 p_pubitem IN VARCHAR2,
41 p_sequence IN NUMBER,
42 p_error_msg IN VARCHAR2,
43 x_return_status OUT NOCOPY VARCHAR2);
44
45 -- Returns FND_API.G_TRUE if the transaction is deferred
46 FUNCTION is_deferred(p_user_name IN VARCHAR2,
47 p_tranid IN NUMBER)
48 RETURN VARCHAR2;
49
50 -- Returns FND_API.G_TRUE if the record is deferred
51 FUNCTION is_deferred(p_user_name IN VARCHAR2,
52 p_tranid IN NUMBER,
53 p_pubitem IN VARCHAR2,
54 p_sequence IN NUMBER)
55 RETURN VARCHAR2;
56
57 -- Set transaction status to discarded
58 PROCEDURE discard_transaction(p_user_name IN VARCHAR2,
59 p_tranid IN NUMBER,
60 x_return_status OUT NOCOPY VARCHAR2);
61
62 -- Discard the specified deferred row
63 PROCEDURE discard_transaction(p_user_name IN VARCHAR2,
64 p_tranid IN NUMBER,
65 p_pubitem IN VARCHAR2,
66 p_sequence IN NUMBER,
67 x_return_status OUT NOCOPY VARCHAR2,
68 p_commit_flag IN BOOLEAN DEFAULT TRUE);
69
70 -- Reapply the given transaction
71 PROCEDURE reapply_transaction(p_user_name IN VARCHAR2,
72 p_tranid IN NUMBER,
73 x_return_status OUT NOCOPY VARCHAR2,
74 p_commit_flag IN BOOLEAN DEFAULT TRUE);
75
76 -- Purge all the inq entries
77 PROCEDURE purge_transaction(p_user_name IN VARCHAR2,
78 p_tranid IN NUMBER,
79 x_return_status OUT NOCOPY VARCHAR2);
80
81 function raise_row_deferred(p_user_name IN VARCHAR2,
82 p_tranid IN NUMBER,
83 p_pubitem IN VARCHAR2,
84 p_sequence IN NUMBER,
85 p_error_msg IN VARCHAR2)
86 return boolean;
87
88 -- Delete rows in asg_deferred_traninfo/asg_users_inqinfo with no data in INQ.
89 PROCEDURE delete_deferred(p_status OUT NOCOPY VARCHAR2,
90 p_message OUT NOCOPY VARCHAR2);
91
92 END asg_defer;