[Home] [Help]
PACKAGE: APPS.QA_SEQUENCE_API
Source
1 PACKAGE QA_SEQUENCE_API AUTHID CURRENT_USER AS
2 /* $Header: qltseqs.pls 120.3.12010000.1 2008/07/25 09:22:21 appldev ship $ */
3
4 -- Gapless Sequence Proj. rponnusa Wed Jul 30 04:52:45 PDT 2003
5 TYPE ID_TABLE IS TABLE OF NUMBER index by BINARY_INTEGER;
6
7
8 FUNCTION get_nextval(p_char_id NUMBER) RETURN NUMBER;
9
10 -- Gapless Sequence Proj. Added new parameter p_commit
11 FUNCTION get_next_seq(p_char_id NUMBER,
12 p_commit BOOLEAN DEFAULT NULL) RETURN VARCHAR2;
13
14 FUNCTION max_sequence RETURN NUMBER;
15
16 -- Added the below procedure for bug 2548710. rponnusa Mon Nov 18 03:49:15 PST 2002
17 PROCEDURE FILL_SEQ_TABLE (p_char_id IN NUMBER,
18 p_count IN NUMBER,
19 x_seq_table OUT NOCOPY QLTTRAWB.CHAR50_TABLE);
20
21
22 -- Gapless Sequence Proj Start. rponnusa Wed Jul 30 04:52:45 PDT 2003
23
24 FUNCTION get_nextval_nocommit(p_char_id NUMBER) RETURN NUMBER;
25
26 -- Bug 5335509. SHKALYAN 15-Jun-2006
27 -- This function is needed as public becuase we are including
28 -- a call to this function to get the translated value for
29 -- 'Automatic' while inserting background results.
30 FUNCTION get_sequence_default_value RETURN VARCHAR2;
31
32 PROCEDURE generate_seq_for_Txn(p_collection_id NUMBER,
33 p_return_status OUT NOCOPY VARCHAR2);
34
35 PROCEDURE generate_seq_for_DDE(p_txn_header_id NUMBER,
36 p_plan_id NUMBER,
37 p_return_status OUT NOCOPY VARCHAR2);
38
39 -- Bug 3160651. Added following overloaded procedure.
40 -- rponnusa Thu Sep 25 02:24:28 PDT 2003
41
42 PROCEDURE generate_seq_for_DDE(p_txn_header_id NUMBER,
43 p_plan_id NUMBER,
44 p_return_status OUT NOCOPY VARCHAR2,
45 x_message OUT NOCOPY VARCHAR2);
46
47 PROCEDURE audit_sequence_values(p_plan_id NUMBER,
48 p_collection_id NUMBER,
49 p_occurrence NUMBER,
50 p_enabled_flag VARCHAR2);
51
52 PROCEDURE audit_sequence_values(p_plan_ids DBMS_SQL.number_table,
53 p_collection_ids DBMS_SQL.number_table,
54 p_occurrences DBMS_SQL.number_table,
55 p_parent_plan_id NUMBER,
56 p_parent_collection_id NUMBER,
57 p_parent_occurrence NUMBER);
58
59 PROCEDURE sequence_audit_log(p_plan_id NUMBER,
60 p_collection_id NUMBER,
61 p_occurrence NUMBER,
62 p_char_id NUMBER,
63 p_txn_header_id NUMBER,
64 p_sequence_value VARCHAR2,
65 p_user_id NUMBER,
66 p_source_code VARCHAR2,
67 p_source_id NUMBER,
68 p_audit_type VARCHAR2,
69 p_audit_date DATE,
70 p_last_update_date DATE,
71 p_last_updated_by NUMBER,
72 p_creation_date DATE,
73 p_created_by NUMBER,
74 p_last_update_login NUMBER);
75
76 PROCEDURE delete_auditinfo_for_Txn(p_collection_id NUMBER);
77
78 PROCEDURE delete_auditinfo_for_DDE(p_txn_header_id NUMBER);
79
80 -- Gapless Sequence Proj End
81
82 -- Bug 5368983. saugupta Fri, 01 Sep 2006 02:00:42 -0700 PDT
83 -- Generating Sequence Number for OA Txn Integration Flows.
84 /**
85 ** generate_seq_for_txninteg
86 ** Description:
87 ** This procedure is called from OA Txn Integ flows to
88 ** generate Sequence Numbers.
89 **
90 ** Arguments:
91 ** p_collection_id: takes the new collection_id
92 **
93 ** Returns:
94 ** Sequence Message String
95 **
96 */
97
98 PROCEDURE generate_seq_for_txninteg(p_collection_id IN NUMBER,
99 p_return_status OUT nocopy VARCHAR2,
100 x_message OUT nocopy VARCHAR2);
101
102 --
103 -- Bug 5955808
104 -- New procedure to support sequence generation in
105 -- Mobile application
106 -- ntungare Mon Jul 23 12:36:31 PDT 2007
107 --
108 PROCEDURE generate_seq_for_txn(p_collection_id NUMBER,
109 p_return_status OUT NOCOPY VARCHAR2,
110 x_message OUT NOCOPY VARCHAR2);
111
112
113
114 END QA_SEQUENCE_API;