DBA Data[Home] [Help]

APPS.CN_SRP_PMT_PLANS_PVT_W dependencies on CN_SRP_PMT_PLANS_PVT

Line 1: package body cn_srp_pmt_plans_pvt_w as

1: package body cn_srp_pmt_plans_pvt_w as
2: /* $Header: cnwsppab.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) as
4: ddindx binary_integer; indx binary_integer;
5: begin

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_srp_pmt_plans_pvt.payrun_tbl, a0 JTF_VARCHAR2_TABLE_100) as

1: package body cn_srp_pmt_plans_pvt_w as
2: /* $Header: cnwsppab.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) as
4: ddindx binary_integer; indx binary_integer;
5: begin
6: if a0 is null then
7: t := null;

Line 9: t := cn_srp_pmt_plans_pvt.payrun_tbl();

5: begin
6: if a0 is null then
7: t := null;
8: elsif a0.count = 0 then
9: t := cn_srp_pmt_plans_pvt.payrun_tbl();
10: else
11: if a0.count > 0 then
12: t := cn_srp_pmt_plans_pvt.payrun_tbl();
13: t.extend(a0.count);

Line 12: t := cn_srp_pmt_plans_pvt.payrun_tbl();

8: elsif a0.count = 0 then
9: t := cn_srp_pmt_plans_pvt.payrun_tbl();
10: else
11: if a0.count > 0 then
12: t := cn_srp_pmt_plans_pvt.payrun_tbl();
13: t.extend(a0.count);
14: indx := a0.first;
15: ddindx := 1;
16: while true loop

Line 27: procedure rosetta_table_copy_out_p1(t cn_srp_pmt_plans_pvt.payrun_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

23: end loop;
24: end if;
25: end if;
26: end rosetta_table_copy_in_p1;
27: procedure rosetta_table_copy_out_p1(t cn_srp_pmt_plans_pvt.payrun_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
28: ddindx binary_integer; indx binary_integer;
29: begin
30: if t is null then
31: a0 := null;

Line 75: ddp_pmt_plan_assign_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;

71: , p8_a11 in out nocopy NUMBER
72: )
73:
74: as
75: ddp_pmt_plan_assign_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;
76: ddindx binary_integer; indx binary_integer;
77: begin
78:
79: -- copy data to the local IN or IN-OUT args, if any

Line 102: cn_srp_pmt_plans_pvt.create_srp_pmt_plan(p_api_version,

98: ddp_pmt_plan_assign_rec.lock_flag := p8_a10;
99: ddp_pmt_plan_assign_rec.object_version_number := p8_a11;
100:
101: -- here's the delegated call to the old PL/SQL routine
102: cn_srp_pmt_plans_pvt.create_srp_pmt_plan(p_api_version,
103: p_init_msg_list,
104: p_commit,
105: p_validation_level,
106: x_return_status,

Line 158: ddp_pmt_plan_assign_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;

154: , p8_a11 in out nocopy NUMBER
155: )
156:
157: as
158: ddp_pmt_plan_assign_rec cn_srp_pmt_plans_pvt.pmt_plan_assign_rec;
159: ddindx binary_integer; indx binary_integer;
160: begin
161:
162: -- copy data to the local IN or IN-OUT args, if any

Line 185: cn_srp_pmt_plans_pvt.update_srp_pmt_plan(p_api_version,

181: ddp_pmt_plan_assign_rec.lock_flag := p8_a10;
182: ddp_pmt_plan_assign_rec.object_version_number := p8_a11;
183:
184: -- here's the delegated call to the old PL/SQL routine
185: cn_srp_pmt_plans_pvt.update_srp_pmt_plan(p_api_version,
186: p_init_msg_list,
187: p_commit,
188: p_validation_level,
189: x_return_status,

Line 227: ddx_payrun_tbl cn_srp_pmt_plans_pvt.payrun_tbl;

223: , x_payrun_tbl out nocopy JTF_VARCHAR2_TABLE_100
224: )
225:
226: as
227: ddx_payrun_tbl cn_srp_pmt_plans_pvt.payrun_tbl;
228: ddindx binary_integer; indx binary_integer;
229: begin
230:
231: -- copy data to the local IN or IN-OUT args, if any

Line 239: cn_srp_pmt_plans_pvt.check_payruns(p_operation,

235:
236:
237:
238: -- here's the delegated call to the old PL/SQL routine
239: cn_srp_pmt_plans_pvt.check_payruns(p_operation,
240: p_srp_pmt_plan_id,
241: p_salesrep_id,
242: p_start_date,
243: p_end_date,

Line 252: cn_srp_pmt_plans_pvt_w.rosetta_table_copy_out_p1(ddx_payrun_tbl, x_payrun_tbl);

248:
249:
250:
251:
252: cn_srp_pmt_plans_pvt_w.rosetta_table_copy_out_p1(ddx_payrun_tbl, x_payrun_tbl);
253: end;
254:
255: end cn_srp_pmt_plans_pvt_w;

Line 255: end cn_srp_pmt_plans_pvt_w;

251:
252: cn_srp_pmt_plans_pvt_w.rosetta_table_copy_out_p1(ddx_payrun_tbl, x_payrun_tbl);
253: end;
254:
255: end cn_srp_pmt_plans_pvt_w;