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