DBA Data[Home] [Help]

PACKAGE: APPS.PV_ASSIGN_UTIL_PVT_W

Source


1 package pv_assign_util_pvt_w AUTHID CURRENT_USER as
2   /* $Header: pvwautls.pls 115.13 2002/12/20 23:06:10 pklin ship $ */
3   procedure rosetta_table_copy_in_p4(
4       t out nocopy pv_assign_util_pvt.resource_details_tbl_type
5     , a0 JTF_VARCHAR2_TABLE_100
6     , a1 JTF_VARCHAR2_TABLE_100
7     , a2 JTF_NUMBER_TABLE
8     , a3 JTF_NUMBER_TABLE
9     , a4 JTF_VARCHAR2_TABLE_100
10     , a5 JTF_VARCHAR2_TABLE_100
11     , a6 JTF_NUMBER_TABLE
12     );
13   procedure rosetta_table_copy_out_p4(
14     t pv_assign_util_pvt.resource_details_tbl_type
15     , a0 out nocopy JTF_VARCHAR2_TABLE_100
16     , a1 out nocopy JTF_VARCHAR2_TABLE_100
17     , a2 out nocopy JTF_NUMBER_TABLE
18     , a3 out nocopy JTF_NUMBER_TABLE
19     , a4 out nocopy JTF_VARCHAR2_TABLE_100
20     , a5 out nocopy JTF_VARCHAR2_TABLE_100
21     , a6 out nocopy JTF_NUMBER_TABLE
22     );
23 
24   procedure create_party_notification(p_api_version_number  NUMBER
25     , p_init_msg_list  VARCHAR2
26     , p_commit  VARCHAR2
27     , p_validation_level  NUMBER
28     , p4_a0  NUMBER := 0-1962.0724
29     , p4_a1  DATE := fnd_api.g_miss_date
30     , p4_a2  NUMBER := 0-1962.0724
31     , p4_a3  DATE := fnd_api.g_miss_date
32     , p4_a4  NUMBER := 0-1962.0724
33     , p4_a5  NUMBER := 0-1962.0724
34     , p4_a6  NUMBER := 0-1962.0724
35     , p4_a7  NUMBER := 0-1962.0724
36     , p4_a8  NUMBER := 0-1962.0724
37     , p4_a9  NUMBER := 0-1962.0724
38     , p4_a10  DATE := fnd_api.g_miss_date
39     , p4_a11  NUMBER := 0-1962.0724
40     , p4_a12  VARCHAR2 := fnd_api.g_miss_char
41     , p4_a13  NUMBER := 0-1962.0724
42     , p4_a14  VARCHAR2 := fnd_api.g_miss_char
43     , p4_a15  VARCHAR2 := fnd_api.g_miss_char
44     , p4_a16  NUMBER := 0-1962.0724
45     , p4_a17  VARCHAR2 := fnd_api.g_miss_char
46     , p4_a18  NUMBER := 0-1962.0724
47     , p4_a19  VARCHAR2 := fnd_api.g_miss_char
48     , p4_a20  VARCHAR2 := fnd_api.g_miss_char
49     , p4_a21  DATE := fnd_api.g_miss_date
50     , p4_a22  VARCHAR2 := fnd_api.g_miss_char
51     , p4_a23  VARCHAR2 := fnd_api.g_miss_char
52     , p4_a24  VARCHAR2 := fnd_api.g_miss_char
53     , p4_a25  VARCHAR2 := fnd_api.g_miss_char
54     , p4_a26  VARCHAR2 := fnd_api.g_miss_char
55     , p4_a27  VARCHAR2 := fnd_api.g_miss_char
56     , p4_a28  VARCHAR2 := fnd_api.g_miss_char
57     , p4_a29  VARCHAR2 := fnd_api.g_miss_char
58     , p4_a30  VARCHAR2 := fnd_api.g_miss_char
59     , p4_a31  VARCHAR2 := fnd_api.g_miss_char
60     , p4_a32  VARCHAR2 := fnd_api.g_miss_char
61     , p4_a33  VARCHAR2 := fnd_api.g_miss_char
62     , p4_a34  VARCHAR2 := fnd_api.g_miss_char
63     , p4_a35  VARCHAR2 := fnd_api.g_miss_char
64     , p4_a36  VARCHAR2 := fnd_api.g_miss_char
65     , p4_a37  VARCHAR2 := fnd_api.g_miss_char
66     , x_party_notification_id out  nocopy NUMBER
67     , x_return_status out nocopy  VARCHAR2
68     , x_msg_count out nocopy  NUMBER
69     , x_msg_data out  nocopy VARCHAR2
70   );
71   procedure create_lead_workflow_row(p_api_version_number  NUMBER
72     , p_init_msg_list  VARCHAR2
73     , p_commit  VARCHAR2
74     , p_validation_level  NUMBER
75     , p4_a0  NUMBER := 0-1962.0724
76     , p4_a1  DATE := fnd_api.g_miss_date
77     , p4_a2  NUMBER := 0-1962.0724
78     , p4_a3  DATE := fnd_api.g_miss_date
79     , p4_a4  NUMBER := 0-1962.0724
80     , p4_a5  NUMBER := 0-1962.0724
81     , p4_a6  NUMBER := 0-1962.0724
82     , p4_a7  VARCHAR2 := fnd_api.g_miss_char
83     , p4_a8  NUMBER := 0-1962.0724
84     , p4_a9  VARCHAR2 := fnd_api.g_miss_char
85     , p4_a10  VARCHAR2 := fnd_api.g_miss_char
86     , p4_a11  VARCHAR2 := fnd_api.g_miss_char
87     , p4_a12  DATE := fnd_api.g_miss_date
88     , p4_a13  DATE := fnd_api.g_miss_date
89     , p4_a14  VARCHAR2 := fnd_api.g_miss_char
90     , p4_a15  VARCHAR2 := fnd_api.g_miss_char
91     , p4_a16  VARCHAR2 := fnd_api.g_miss_char
92     , x_itemkey out  nocopy VARCHAR2
93     , x_return_status out nocopy  VARCHAR2
94     , x_msg_count out nocopy  NUMBER
95     , x_msg_data out nocopy  VARCHAR2
96   );
97   procedure create_lead_assignment_row(p_api_version_number  NUMBER
98     , p_init_msg_list  VARCHAR2
99     , p_commit  VARCHAR2
100     , p_validation_level  NUMBER
101     , p4_a0  NUMBER := 0-1962.0724
102     , p4_a1  DATE := fnd_api.g_miss_date
103     , p4_a2  NUMBER := 0-1962.0724
104     , p4_a3  DATE := fnd_api.g_miss_date
105     , p4_a4  NUMBER := 0-1962.0724
106     , p4_a5  NUMBER := 0-1962.0724
107     , p4_a6  NUMBER := 0-1962.0724
108     , p4_a7  NUMBER := 0-1962.0724
109     , p4_a8  NUMBER := 0-1962.0724
110     , p4_a9  VARCHAR2 := fnd_api.g_miss_char
111     , p4_a10  NUMBER := 0-1962.0724
112     , p4_a11  VARCHAR2 := fnd_api.g_miss_char
113     , p4_a12  NUMBER := 0-1962.0724
114     , p4_a13  DATE := fnd_api.g_miss_date
115     , p4_a14  VARCHAR2 := fnd_api.g_miss_char
116     , p4_a15  VARCHAR2 := fnd_api.g_miss_char
117     , p4_a16  VARCHAR2 := fnd_api.g_miss_char
118     , p4_a17  VARCHAR2 := fnd_api.g_miss_char
119     , p4_a18  VARCHAR2 := fnd_api.g_miss_char
120     , p4_a19  VARCHAR2 := fnd_api.g_miss_char
121     , x_lead_assignment_id out nocopy  NUMBER
122     , x_return_status out nocopy  VARCHAR2
123     , x_msg_count out nocopy  NUMBER
124     , x_msg_data out  nocopy VARCHAR2
125   );
126   procedure get_partner_info(p_api_version_number  NUMBER
127     , p_init_msg_list  VARCHAR2
128     , p_commit  VARCHAR2
129     , p_validation_level  NUMBER
130     , p_mode  VARCHAR2
131     , p_partner_id  NUMBER
132     , p_entity  VARCHAR2
133     , p_entity_id  NUMBER
134     , p_retrieve_mode  VARCHAR2
135     , p9_a0 in out nocopy JTF_VARCHAR2_TABLE_100
136     , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
137     , p9_a2 in out nocopy JTF_NUMBER_TABLE
138     , p9_a3 in out nocopy JTF_NUMBER_TABLE
139     , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
140     , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
141     , p9_a6 in out nocopy JTF_NUMBER_TABLE
142     , x_vad_id out nocopy  NUMBER
143     , x_return_status out nocopy  VARCHAR2
144     , x_msg_count out nocopy  NUMBER
145     , x_msg_data out nocopy  VARCHAR2
146   );
147 end pv_assign_util_pvt_w;