DBA Data[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;