[Home] [Help]
PACKAGE BODY: APPS.FPA_PROCESS_RST_PVT_W
Source
1 package body fpa_process_rst_pvt_w as
2 /* $Header: FPAERSTB.pls 120.2 2005/09/14 11:37:48 appldev noship $ */
3 procedure update_calc_pjt_scorecard_aw(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_planning_cycle_id NUMBER
7 , p_project_id NUMBER
8 , p5_a0 JTF_NUMBER_TABLE
9 , p5_a1 JTF_NUMBER_TABLE
10 , p5_a2 JTF_VARCHAR2_TABLE_2000
11 , x_return_status out nocopy VARCHAR2
12 , x_msg_count out nocopy NUMBER
13 , x_msg_data out nocopy VARCHAR2
14 )
15
16 as
17 ddp_scorecard_tbl fpa_scorecards_pvt.fpa_scorecard_tbl_type;
18 ddindx binary_integer; indx binary_integer;
19 begin
20
21 -- copy data to the local IN or IN-OUT args, if any
22
23
24
25
26
27 fpa_scorecards_pvt_w.rosetta_table_copy_in_p2(ddp_scorecard_tbl, p5_a0
28 , p5_a1
29 , p5_a2
30 );
31
32
33
34
35 -- here's the delegated call to the old PL/SQL routine
36 fpa_process_rst_pvt.update_calc_pjt_scorecard_aw(p_api_version,
37 p_init_msg_list,
38 p_commit,
39 p_planning_cycle_id,
40 p_project_id,
41 ddp_scorecard_tbl,
42 x_return_status,
43 x_msg_count,
44 x_msg_data);
45
46 -- copy data back from the local variables to OUT or IN-OUT args, if any
47
48
49
50
51
52
53
54
55 end;
56
57 procedure update_calc_scen_scorecard_aw(p_api_version NUMBER
58 , p_init_msg_list VARCHAR2
59 , p_commit VARCHAR2
60 , p_planning_cycle_id NUMBER
61 , p_scenario_id NUMBER
62 , p_project_id NUMBER
63 , p6_a0 JTF_NUMBER_TABLE
64 , p6_a1 JTF_NUMBER_TABLE
65 , p6_a2 JTF_VARCHAR2_TABLE_2000
66 , x_return_status out nocopy VARCHAR2
67 , x_msg_count out nocopy NUMBER
68 , x_msg_data out nocopy VARCHAR2
69 )
70
71 as
72 ddp_scorecard_tbl fpa_scorecards_pvt.fpa_scorecard_tbl_type;
73 ddindx binary_integer; indx binary_integer;
74 begin
75
76 -- copy data to the local IN or IN-OUT args, if any
77
78
79
80
81
82
83 fpa_scorecards_pvt_w.rosetta_table_copy_in_p2(ddp_scorecard_tbl, p6_a0
84 , p6_a1
85 , p6_a2
86 );
87
88
89
90
91 -- here's the delegated call to the old PL/SQL routine
92 fpa_process_rst_pvt.update_calc_scen_scorecard_aw(p_api_version,
93 p_init_msg_list,
94 p_commit,
95 p_planning_cycle_id,
96 p_scenario_id,
97 p_project_id,
98 ddp_scorecard_tbl,
99 x_return_status,
100 x_msg_count,
101 x_msg_data);
102
103 -- copy data back from the local variables to OUT or IN-OUT args, if any
104
105
106
107
108
109
110
111
112
113 end;
114
115 end fpa_process_rst_pvt_w;