[Home] [Help]
PACKAGE: APPS.AHL_STATUS_ORDER_RULES_PVT_W
Source
1 package ahl_status_order_rules_pvt_w AUTHID CURRENT_USER as
2 /* $Header: AHLWSORS.pls 115.0 2003/07/07 19:07:58 sdevaki noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy ahl_status_order_rules_pvt.status_order_rules_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_DATE_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_DATE_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_NUMBER_TABLE
15 );
16 procedure rosetta_table_copy_out_p1(t ahl_status_order_rules_pvt.status_order_rules_tbl, a0 out nocopy JTF_NUMBER_TABLE
17 , a1 out nocopy JTF_NUMBER_TABLE
18 , a2 out nocopy JTF_DATE_TABLE
19 , a3 out nocopy JTF_NUMBER_TABLE
20 , a4 out nocopy JTF_DATE_TABLE
21 , a5 out nocopy JTF_NUMBER_TABLE
22 , a6 out nocopy JTF_NUMBER_TABLE
23 , a7 out nocopy JTF_VARCHAR2_TABLE_100
24 , a8 out nocopy JTF_VARCHAR2_TABLE_100
25 , a9 out nocopy JTF_VARCHAR2_TABLE_100
26 , a10 out nocopy JTF_VARCHAR2_TABLE_100
27 , a11 out nocopy JTF_NUMBER_TABLE
28 );
29
30 procedure get_status_order_rules(p_api_version NUMBER
31 , p_init_msg_list VARCHAR2
32 , p_validation_level NUMBER
33 , p_module_type VARCHAR2
34 , p_current_status_code VARCHAR2
35 , p_system_status_type VARCHAR2
36 , p6_a0 out nocopy JTF_NUMBER_TABLE
37 , p6_a1 out nocopy JTF_NUMBER_TABLE
38 , p6_a2 out nocopy JTF_DATE_TABLE
39 , p6_a3 out nocopy JTF_NUMBER_TABLE
40 , p6_a4 out nocopy JTF_DATE_TABLE
41 , p6_a5 out nocopy JTF_NUMBER_TABLE
42 , p6_a6 out nocopy JTF_NUMBER_TABLE
43 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
44 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
45 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
46 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
47 , p6_a11 out nocopy JTF_NUMBER_TABLE
48 , x_return_status out nocopy VARCHAR2
49 , x_msg_count out nocopy NUMBER
50 , x_msg_data out nocopy VARCHAR2
51 );
52 end ahl_status_order_rules_pvt_w;