1 package cn_srp_pmt_plans_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cnwsppas.pls 120.3 2005/09/14 03:43 vensrini noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cn_srp_pmt_plans_pvt.payrun_tbl, a0 JTF_VARCHAR2_TABLE_100);
4 procedure rosetta_table_copy_out_p1(t cn_srp_pmt_plans_pvt.payrun_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5
6 procedure create_srp_pmt_plan(p_api_version NUMBER
7 , p_init_msg_list VARCHAR2
8 , p_commit VARCHAR2
9 , p_validation_level NUMBER
10 , x_return_status out nocopy VARCHAR2
11 , x_loading_status out nocopy VARCHAR2
12 , x_msg_count out nocopy NUMBER
13 , x_msg_data out nocopy VARCHAR2
14 , p8_a0 in out nocopy NUMBER
15 , p8_a1 in out nocopy NUMBER
16 , p8_a2 in out nocopy NUMBER
17 , p8_a3 in out nocopy NUMBER
18 , p8_a4 in out nocopy DATE
19 , p8_a5 in out nocopy DATE
20 , p8_a6 in out nocopy NUMBER
21 , p8_a7 in out nocopy NUMBER
22 , p8_a8 in out nocopy NUMBER
23 , p8_a9 in out nocopy NUMBER
24 , p8_a10 in out nocopy VARCHAR2
25 , p8_a11 in out nocopy NUMBER
26 );
27 procedure update_srp_pmt_plan(p_api_version NUMBER
28 , p_init_msg_list VARCHAR2
29 , p_commit VARCHAR2
30 , p_validation_level NUMBER
31 , x_return_status out nocopy VARCHAR2
32 , x_loading_status out nocopy VARCHAR2
33 , x_msg_count out nocopy NUMBER
34 , x_msg_data out nocopy VARCHAR2
35 , p8_a0 in out nocopy NUMBER
36 , p8_a1 in out nocopy NUMBER
37 , p8_a2 in out nocopy NUMBER
38 , p8_a3 in out nocopy NUMBER
39 , p8_a4 in out nocopy DATE
40 , p8_a5 in out nocopy DATE
41 , p8_a6 in out nocopy NUMBER
42 , p8_a7 in out nocopy NUMBER
43 , p8_a8 in out nocopy NUMBER
44 , p8_a9 in out nocopy NUMBER
45 , p8_a10 in out nocopy VARCHAR2
46 , p8_a11 in out nocopy NUMBER
47 );
48 procedure check_payruns(p_operation VARCHAR2
49 , p_srp_pmt_plan_id NUMBER
50 , p_salesrep_id NUMBER
51 , p_start_date DATE
52 , p_end_date DATE
53 , x_payrun_tbl out nocopy JTF_VARCHAR2_TABLE_100
54 );
55 end cn_srp_pmt_plans_pvt_w;
[Home] [Help]