1 PACKAGE PO_R12_CAT_UPG_FINAL_GRP AS
2 /* $Header: PO_R12_CAT_UPG_FINAL_GRP.pls 120.7 2006/08/10 22:58:03 pthapliy noship $ */
3
4 g_SNAPSHOT_TOO_OLD EXCEPTION;
5 PRAGMA EXCEPTION_INIT(g_SNAPSHOT_TOO_OLD, -1555);
6
7 PROCEDURE R12_upgrade_processing
8 (
9 p_api_version IN NUMBER
10 , p_commit IN VARCHAR2 default FND_API.G_FALSE
11 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
12 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
13 , p_log_level IN NUMBER default 1
14 , p_start_rowid IN rowid default NULL --Bug#5156673
15 , p_end_rowid IN rowid default NULL --Bug#5156673
16 , p_batch_size IN NUMBER default 2500
17 , x_return_status OUT NOCOPY VARCHAR2
18 , x_msg_count OUT NOCOPY NUMBER
19 , x_msg_data OUT NOCOPY VARCHAR2
20 , x_rows_processed OUT NOCOPY NUMBER --Bug#5156673
21 );
22
23 -- Needed to declare this function in the spec because of the following error:
24 -- PLS-00231: function 'string' may not be used in SQL
25 -- Cause: A proscribed function was used in a SQL statement.
26 -- Looks like a local function can not be used inside a SQL query, whereas if
27 -- it is declared in the spec, then it can be used.
28 FUNCTION get_next_po_number
29 (
30 p_org_id IN NUMBER
31 ) RETURN VARCHAR2;
32
33 -- This procedure is made public for testing purposes only
34 PROCEDURE create_attachment
35 (
36 p_cpa_header_id IN NUMBER
37 , p_cpa_org_id IN NUMBER
38 , p_gbpa_header_id_list IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
39 );
40
41 PROCEDURE attach_gbpa_numbers_in_cpa;
42
43 END PO_R12_CAT_UPG_FINAL_GRP;
[Home] [Help]