[Home] [Help]
PACKAGE: APPS.AS_SALES_LEAD_OWNER_W
Source
1 package as_sales_lead_owner_w as
2 /* $Header: asxwslns.pls 120.1 2005/06/23 16:05 appldev noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy as_sales_lead_owner.lead_owner_rec_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_DATE_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_DATE_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_DATE_TABLE
21 );
22 procedure rosetta_table_copy_out_p1(t as_sales_lead_owner.lead_owner_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
23 , a1 out nocopy JTF_VARCHAR2_TABLE_100
24 , a2 out nocopy JTF_VARCHAR2_TABLE_100
25 , a3 out nocopy JTF_VARCHAR2_TABLE_100
26 , a4 out nocopy JTF_VARCHAR2_TABLE_100
27 , a5 out nocopy JTF_NUMBER_TABLE
28 , a6 out nocopy JTF_VARCHAR2_TABLE_100
29 , a7 out nocopy JTF_VARCHAR2_TABLE_100
30 , a8 out nocopy JTF_DATE_TABLE
31 , a9 out nocopy JTF_NUMBER_TABLE
32 , a10 out nocopy JTF_DATE_TABLE
33 , a11 out nocopy JTF_NUMBER_TABLE
34 , a12 out nocopy JTF_NUMBER_TABLE
35 , a13 out nocopy JTF_NUMBER_TABLE
36 , a14 out nocopy JTF_NUMBER_TABLE
37 , a15 out nocopy JTF_NUMBER_TABLE
38 , a16 out nocopy JTF_NUMBER_TABLE
39 , a17 out nocopy JTF_DATE_TABLE
40 );
41
42 procedure create_lead_owner(p_api_version NUMBER
43 , p_init_msg_list VARCHAR2
44 , p_commit VARCHAR2
45 , p_validation_level NUMBER
46 , x_return_status out nocopy VARCHAR2
47 , x_msg_count out nocopy NUMBER
48 , x_msg_data out nocopy VARCHAR2
49 , x_lead_owner_id out nocopy NUMBER
50 , p7_a0 NUMBER := 0-1962.0724
51 , p7_a1 VARCHAR2 := fnd_api.g_miss_char
52 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
53 , p7_a3 VARCHAR2 := fnd_api.g_miss_char
54 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
55 , p7_a5 NUMBER := 0-1962.0724
56 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
57 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
58 , p7_a8 DATE := fnd_api.g_miss_date
59 , p7_a9 NUMBER := 0-1962.0724
60 , p7_a10 DATE := fnd_api.g_miss_date
61 , p7_a11 NUMBER := 0-1962.0724
62 , p7_a12 NUMBER := 0-1962.0724
63 , p7_a13 NUMBER := 0-1962.0724
64 , p7_a14 NUMBER := 0-1962.0724
65 , p7_a15 NUMBER := 0-1962.0724
66 , p7_a16 NUMBER := 0-1962.0724
67 , p7_a17 DATE := fnd_api.g_miss_date
68 );
69 procedure update_lead_owner(p_api_version NUMBER
70 , p_init_msg_list VARCHAR2
71 , p_commit VARCHAR2
72 , p_validation_level NUMBER
73 , x_return_status out nocopy VARCHAR2
74 , x_msg_count out nocopy NUMBER
75 , x_msg_data out nocopy VARCHAR2
76 , p7_a0 NUMBER := 0-1962.0724
77 , p7_a1 VARCHAR2 := fnd_api.g_miss_char
78 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
79 , p7_a3 VARCHAR2 := fnd_api.g_miss_char
80 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
81 , p7_a5 NUMBER := 0-1962.0724
82 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
83 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
84 , p7_a8 DATE := fnd_api.g_miss_date
85 , p7_a9 NUMBER := 0-1962.0724
86 , p7_a10 DATE := fnd_api.g_miss_date
87 , p7_a11 NUMBER := 0-1962.0724
88 , p7_a12 NUMBER := 0-1962.0724
89 , p7_a13 NUMBER := 0-1962.0724
90 , p7_a14 NUMBER := 0-1962.0724
91 , p7_a15 NUMBER := 0-1962.0724
92 , p7_a16 NUMBER := 0-1962.0724
93 , p7_a17 DATE := fnd_api.g_miss_date
94 );
95 procedure get_salesreps(p_api_version NUMBER
96 , p_init_msg_list VARCHAR2
97 , p_commit VARCHAR2
98 , p_validation_level NUMBER
99 , p_sales_lead_id NUMBER
100 , p5_a0 out nocopy JTF_NUMBER_TABLE
101 , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
102 , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
103 , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
104 , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
105 , p5_a5 out nocopy JTF_NUMBER_TABLE
106 , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
107 , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
108 , p5_a8 out nocopy JTF_DATE_TABLE
109 , p5_a9 out nocopy JTF_NUMBER_TABLE
110 , p5_a10 out nocopy JTF_DATE_TABLE
111 , p5_a11 out nocopy JTF_NUMBER_TABLE
112 , p5_a12 out nocopy JTF_NUMBER_TABLE
113 , p5_a13 out nocopy JTF_NUMBER_TABLE
114 , p5_a14 out nocopy JTF_NUMBER_TABLE
115 , p5_a15 out nocopy JTF_NUMBER_TABLE
116 , p5_a16 out nocopy JTF_NUMBER_TABLE
117 , p5_a17 out nocopy JTF_DATE_TABLE
118 , x_return_status out nocopy VARCHAR2
119 , x_msg_count out nocopy NUMBER
120 , x_msg_data out nocopy VARCHAR2
121 );
122 end as_sales_lead_owner_w;