[Home] [Help]
PACKAGE: APPS.PV_OFFER_PUB_W
Source
1 package pv_offer_pub_w AUTHID CURRENT_USER as
2 /* $Header: pvxwoffs.pls 120.1 2005/06/16 17:26 appldev $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy pv_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_VARCHAR2_TABLE_100
13 );
14 procedure rosetta_table_copy_out_p2(t pv_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15 , a1 out nocopy JTF_NUMBER_TABLE
16 , a2 out nocopy JTF_NUMBER_TABLE
17 , a3 out nocopy JTF_VARCHAR2_TABLE_100
18 , a4 out nocopy JTF_VARCHAR2_TABLE_100
19 , a5 out nocopy JTF_VARCHAR2_TABLE_100
20 , a6 out nocopy JTF_NUMBER_TABLE
21 , a7 out nocopy JTF_VARCHAR2_TABLE_100
22 , a8 out nocopy JTF_NUMBER_TABLE
23 , a9 out nocopy JTF_VARCHAR2_TABLE_100
24 );
25
26 procedure rosetta_table_copy_in_p4(t out nocopy pv_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
27 , a1 JTF_VARCHAR2_TABLE_100
28 , a2 JTF_VARCHAR2_TABLE_100
29 , a3 JTF_VARCHAR2_TABLE_300
30 , a4 JTF_NUMBER_TABLE
31 , a5 JTF_VARCHAR2_TABLE_100
32 );
33 procedure rosetta_table_copy_out_p4(t pv_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34 , a1 out nocopy JTF_VARCHAR2_TABLE_100
35 , a2 out nocopy JTF_VARCHAR2_TABLE_100
36 , a3 out nocopy JTF_VARCHAR2_TABLE_300
37 , a4 out nocopy JTF_NUMBER_TABLE
38 , a5 out nocopy JTF_VARCHAR2_TABLE_100
39 );
40
41 procedure rosetta_table_copy_in_p6(t out nocopy pv_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
42 , a1 JTF_NUMBER_TABLE
43 , a2 JTF_NUMBER_TABLE
44 , a3 JTF_VARCHAR2_TABLE_100
45 );
46 procedure rosetta_table_copy_out_p6(t pv_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
47 , a1 out nocopy JTF_NUMBER_TABLE
48 , a2 out nocopy JTF_NUMBER_TABLE
49 , a3 out nocopy JTF_VARCHAR2_TABLE_100
50 );
51
52 procedure create_offer(p_init_msg_list VARCHAR2
53 , p_api_version NUMBER
54 , p_commit VARCHAR2
55 , p_benefit_id NUMBER
56 , p_operation VARCHAR2
57 , p_offer_id NUMBER
58 , p7_a0 JTF_NUMBER_TABLE
59 , p7_a1 JTF_NUMBER_TABLE
60 , p7_a2 JTF_NUMBER_TABLE
61 , p7_a3 JTF_VARCHAR2_TABLE_100
62 , p8_a0 JTF_NUMBER_TABLE
63 , p8_a1 JTF_NUMBER_TABLE
64 , p8_a2 JTF_NUMBER_TABLE
65 , p8_a3 JTF_VARCHAR2_TABLE_100
66 , p8_a4 JTF_VARCHAR2_TABLE_100
67 , p8_a5 JTF_VARCHAR2_TABLE_100
68 , p8_a6 JTF_NUMBER_TABLE
69 , p8_a7 JTF_VARCHAR2_TABLE_100
70 , p8_a8 JTF_NUMBER_TABLE
71 , p8_a9 JTF_VARCHAR2_TABLE_100
72 , p9_a0 JTF_NUMBER_TABLE
73 , p9_a1 JTF_VARCHAR2_TABLE_100
74 , p9_a2 JTF_VARCHAR2_TABLE_100
75 , p9_a3 JTF_VARCHAR2_TABLE_300
76 , p9_a4 JTF_NUMBER_TABLE
77 , p9_a5 JTF_VARCHAR2_TABLE_100
78 , x_offer_id out nocopy NUMBER
79 , x_qp_list_header_id out nocopy NUMBER
80 , x_error_location out nocopy NUMBER
81 , x_return_status out nocopy VARCHAR2
82 , x_msg_count out nocopy NUMBER
83 , x_msg_data out nocopy VARCHAR2
84 , p6_a0 NUMBER := 0-1962.0724
85 , p6_a1 NUMBER := 0-1962.0724
86 , p6_a2 VARCHAR2 := fnd_api.g_miss_char
87 , p6_a3 VARCHAR2 := fnd_api.g_miss_char
88 , p6_a4 NUMBER := 0-1962.0724
89 , p6_a5 NUMBER := 0-1962.0724
90 , p6_a6 VARCHAR2 := fnd_api.g_miss_char
91 , p6_a7 NUMBER := 0-1962.0724
92 , p6_a8 NUMBER := 0-1962.0724
93 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
94 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
95 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
96 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
97 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
98 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
99 , p6_a15 VARCHAR2 := fnd_api.g_miss_char
100 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
101 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
102 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
103 );
104 end pv_offer_pub_w;