DBA Data[Home] [Help]

PACKAGE: APPS.AHL_WARRANTY_UTILS_PVT_W

Source


1 package ahl_warranty_utils_pvt_w AUTHID CURRENT_USER as
2   /* $Header: AHLWSWUS.pls 120.1.12020000.2 2012/12/14 06:49:14 shnatu ship $ */
3   procedure rosetta_table_copy_in_p0(t out nocopy ahl_warranty_utils_pvt.warranty_contract_id_tbl_type, a0 JTF_NUMBER_TABLE);
4   procedure rosetta_table_copy_out_p0(t ahl_warranty_utils_pvt.warranty_contract_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
5 
6   procedure rosetta_table_copy_in_p1(t out nocopy ahl_warranty_utils_pvt.warranty_vendor_id_tbl_type, a0 JTF_NUMBER_TABLE);
7   procedure rosetta_table_copy_out_p1(t ahl_warranty_utils_pvt.warranty_vendor_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
8 
9   procedure rosetta_table_copy_in_p3(t out nocopy ahl_warranty_utils_pvt.turnover_notes_tbl_type, a0 JTF_NUMBER_TABLE
10     , a1 JTF_NUMBER_TABLE
11     , a2 JTF_VARCHAR2_TABLE_100
12     , a3 JTF_VARCHAR2_TABLE_2000
13     , a4 JTF_NUMBER_TABLE
14     , a5 JTF_VARCHAR2_TABLE_300
15     , a6 JTF_DATE_TABLE
16     );
17   procedure rosetta_table_copy_out_p3(t ahl_warranty_utils_pvt.turnover_notes_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18     , a1 out nocopy JTF_NUMBER_TABLE
19     , a2 out nocopy JTF_VARCHAR2_TABLE_100
20     , a3 out nocopy JTF_VARCHAR2_TABLE_2000
21     , a4 out nocopy JTF_NUMBER_TABLE
22     , a5 out nocopy JTF_VARCHAR2_TABLE_300
23     , a6 out nocopy JTF_DATE_TABLE
24     );
25 
26   procedure calc_contract_exp_date(p_api_version  NUMBER
27     , p_init_msg_list  VARCHAR2
28     , p_commit  VARCHAR2
29     , p_validation_level  NUMBER
30     , p_module_type  VARCHAR2
31     , p_warranty_contract_id_tbl JTF_NUMBER_TABLE
32     , x_return_status out nocopy  VARCHAR2
33     , x_msg_count out nocopy  NUMBER
34     , x_msg_data out nocopy  VARCHAR2
35   );
36   procedure disable_templates_for_vendor(p_api_version  NUMBER
37     , p_init_msg_list  VARCHAR2
38     , p_commit  VARCHAR2
39     , p_validation_level  NUMBER
40     , p_module_type  VARCHAR2
41     , p_warranty_vendor_id_tbl JTF_NUMBER_TABLE
42     , x_return_status out nocopy  VARCHAR2
43     , x_msg_count out nocopy  NUMBER
44     , x_msg_data out nocopy  VARCHAR2
45   );
46   procedure insert_turnover_notes(p_api_version  NUMBER
47     , p_init_msg_list  VARCHAR2
48     , p_commit  VARCHAR2
49     , p_validation_level  NUMBER
50     , p_default  VARCHAR2
51     , p_module_type  VARCHAR2
52     , x_return_status out nocopy  VARCHAR2
53     , x_msg_count out nocopy  NUMBER
54     , x_msg_data out nocopy  VARCHAR2
55     , p9_a0 in out nocopy JTF_NUMBER_TABLE
56     , p9_a1 in out nocopy JTF_NUMBER_TABLE
57     , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
58     , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
59     , p9_a4 in out nocopy JTF_NUMBER_TABLE
60     , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_300
61     , p9_a6 in out nocopy JTF_DATE_TABLE
62   );
63 end ahl_warranty_utils_pvt_w;