[Home] [Help]
PACKAGE: APPS.CN_SF_PARAMS_PVT_W
Source
1 package cn_sf_params_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cnwprmss.pls 115.5 2002/12/04 05:04:59 fmburu ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cn_sf_params_pvt.sf_repositories_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_2000
6 , a3 JTF_VARCHAR2_TABLE_1000
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 );
15 procedure rosetta_table_copy_out_p1(t cn_sf_params_pvt.sf_repositories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16 , a1 out nocopy JTF_VARCHAR2_TABLE_100
17 , a2 out nocopy JTF_VARCHAR2_TABLE_2000
18 , a3 out nocopy JTF_VARCHAR2_TABLE_1000
19 , a4 out nocopy JTF_VARCHAR2_TABLE_100
20 , a5 out nocopy JTF_VARCHAR2_TABLE_100
21 , a6 out nocopy JTF_VARCHAR2_TABLE_100
22 , a7 out nocopy JTF_NUMBER_TABLE
23 , a8 out nocopy JTF_VARCHAR2_TABLE_100
24 , a9 out nocopy JTF_NUMBER_TABLE
25 , a10 out nocopy JTF_NUMBER_TABLE
26 );
27
28 procedure get_sf_parameters(p_api_version NUMBER
29 , p_init_msg_list VARCHAR2
30 , p_commit VARCHAR2
31 , p_validation_level NUMBER
32 , p4_a0 out nocopy NUMBER
33 , p4_a1 out nocopy VARCHAR2
34 , p4_a2 out nocopy VARCHAR2
35 , p4_a3 out nocopy VARCHAR2
36 , p4_a4 out nocopy VARCHAR2
37 , p4_a5 out nocopy VARCHAR2
38 , p4_a6 out nocopy VARCHAR2
39 , p4_a7 out nocopy NUMBER
40 , p4_a8 out nocopy VARCHAR2
41 , p4_a9 out nocopy NUMBER
42 , p4_a10 out nocopy NUMBER
43 , x_return_status out nocopy VARCHAR2
44 , x_msg_count out nocopy NUMBER
45 , x_msg_data out nocopy VARCHAR2
46 );
47 procedure update_sf_parameters(p_api_version NUMBER
48 , p_init_msg_list VARCHAR2
49 , p_commit VARCHAR2
50 , p_validation_level NUMBER
51 , p4_a0 NUMBER
52 , p4_a1 VARCHAR2
53 , p4_a2 VARCHAR2
54 , p4_a3 VARCHAR2
55 , p4_a4 VARCHAR2
56 , p4_a5 VARCHAR2
57 , p4_a6 VARCHAR2
58 , p4_a7 NUMBER
59 , p4_a8 VARCHAR2
60 , p4_a9 NUMBER
61 , p4_a10 NUMBER
62 , x_return_status out nocopy VARCHAR2
63 , x_msg_count out nocopy NUMBER
64 , x_msg_data out nocopy VARCHAR2
65 );
66 procedure insert_sf_parameters(p_api_version NUMBER
67 , p_init_msg_list VARCHAR2
68 , p_commit VARCHAR2
69 , p_validation_level NUMBER
70 , p4_a0 NUMBER
71 , p4_a1 VARCHAR2
72 , p4_a2 VARCHAR2
73 , p4_a3 VARCHAR2
74 , p4_a4 VARCHAR2
75 , p4_a5 VARCHAR2
76 , p4_a6 VARCHAR2
77 , p4_a7 NUMBER
78 , p4_a8 VARCHAR2
79 , p4_a9 NUMBER
80 , p4_a10 NUMBER
81 , x_return_status out nocopy VARCHAR2
82 , x_msg_count out nocopy NUMBER
83 , x_msg_data out nocopy VARCHAR2
84 );
85 end cn_sf_params_pvt_w;