[Home] [Help]
PACKAGE: APPS.PV_PG_ENRQ_INIT_SOURCES_PVT_W
Source
1 package pv_pg_enrq_init_sources_pvt_w AUTHID CURRENT_USER as
2 /* $Header: pvxwpeis.pls 115.1 2002/11/28 01:15:54 jkylee ship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy pv_pg_enrq_init_sources_pvt.enrq_init_sources_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_DATE_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_DATE_TABLE
12 , a9 JTF_NUMBER_TABLE
13 );
14 procedure rosetta_table_copy_out_p2(t pv_pg_enrq_init_sources_pvt.enrq_init_sources_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_NUMBER_TABLE
18 , a4 out nocopy JTF_NUMBER_TABLE
19 , a5 out nocopy JTF_NUMBER_TABLE
20 , a6 out nocopy JTF_DATE_TABLE
21 , a7 out nocopy JTF_NUMBER_TABLE
22 , a8 out nocopy JTF_DATE_TABLE
23 , a9 out nocopy JTF_NUMBER_TABLE
24 );
25
26 procedure create_pg_enrq_init_sources(p_api_version_number NUMBER
27 , p_init_msg_list VARCHAR2
28 , p_commit VARCHAR2
29 , p_validation_level NUMBER
30 , x_return_status out nocopy VARCHAR2
31 , x_msg_count out nocopy NUMBER
32 , x_msg_data out nocopy VARCHAR2
33 , p7_a0 NUMBER
34 , p7_a1 NUMBER
35 , p7_a2 NUMBER
36 , p7_a3 NUMBER
37 , p7_a4 NUMBER
38 , p7_a5 NUMBER
39 , p7_a6 DATE
40 , p7_a7 NUMBER
41 , p7_a8 DATE
42 , p7_a9 NUMBER
43 , x_initiation_source_id out nocopy NUMBER
44 );
45 procedure update_pg_enrq_init_sources(p_api_version_number NUMBER
46 , p_init_msg_list VARCHAR2
47 , p_commit VARCHAR2
48 , p_validation_level NUMBER
49 , x_return_status out nocopy VARCHAR2
50 , x_msg_count out nocopy NUMBER
51 , x_msg_data out nocopy VARCHAR2
52 , p7_a0 NUMBER
53 , p7_a1 NUMBER
54 , p7_a2 NUMBER
55 , p7_a3 NUMBER
56 , p7_a4 NUMBER
57 , p7_a5 NUMBER
58 , p7_a6 DATE
59 , p7_a7 NUMBER
60 , p7_a8 DATE
61 , p7_a9 NUMBER
62 );
63 procedure validate_pg_init_src(p_api_version_number NUMBER
64 , p_init_msg_list VARCHAR2
65 , p_validation_level NUMBER
66 , p3_a0 NUMBER
67 , p3_a1 NUMBER
68 , p3_a2 NUMBER
69 , p3_a3 NUMBER
70 , p3_a4 NUMBER
71 , p3_a5 NUMBER
72 , p3_a6 DATE
73 , p3_a7 NUMBER
74 , p3_a8 DATE
75 , p3_a9 NUMBER
76 , p_validation_mode VARCHAR2
77 , x_return_status out nocopy VARCHAR2
78 , x_msg_count out nocopy NUMBER
79 , x_msg_data out nocopy VARCHAR2
80 );
81 procedure check_init_src_items(p0_a0 NUMBER
82 , p0_a1 NUMBER
83 , p0_a2 NUMBER
84 , p0_a3 NUMBER
85 , p0_a4 NUMBER
86 , p0_a5 NUMBER
87 , p0_a6 DATE
88 , p0_a7 NUMBER
89 , p0_a8 DATE
90 , p0_a9 NUMBER
91 , p_validation_mode VARCHAR2
92 , x_return_status out nocopy VARCHAR2
93 );
94 procedure validate_init_src_rec(p_api_version_number NUMBER
95 , p_init_msg_list VARCHAR2
96 , x_return_status out nocopy VARCHAR2
97 , x_msg_count out nocopy NUMBER
98 , x_msg_data out nocopy VARCHAR2
99 , p5_a0 NUMBER
100 , p5_a1 NUMBER
101 , p5_a2 NUMBER
102 , p5_a3 NUMBER
103 , p5_a4 NUMBER
104 , p5_a5 NUMBER
105 , p5_a6 DATE
106 , p5_a7 NUMBER
107 , p5_a8 DATE
108 , p5_a9 NUMBER
109 );
110 end pv_pg_enrq_init_sources_pvt_w;