DBA Data[Home] [Help]

APPS.CN_CALC_FORMULAS_PVT_W dependencies on CN_CALC_FORMULAS_PVT

Line 1: package body cn_calc_formulas_pvt_w as

1: package body cn_calc_formulas_pvt_w as
2: /* $Header: cnwformb.pls 120.3 2006/01/05 18:09 jxsingh ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy cn_calc_formulas_pvt.input_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p3(t out nocopy cn_calc_formulas_pvt.input_tbl_type, a0 JTF_NUMBER_TABLE

1: package body cn_calc_formulas_pvt_w as
2: /* $Header: cnwformb.pls 120.3 2006/01/05 18:09 jxsingh ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy cn_calc_formulas_pvt.input_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 42: procedure rosetta_table_copy_out_p3(t cn_calc_formulas_pvt.input_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

38: end loop;
39: end if;
40: end if;
41: end rosetta_table_copy_in_p3;
42: procedure rosetta_table_copy_out_p3(t cn_calc_formulas_pvt.input_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_NUMBER_TABLE
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 116: procedure rosetta_table_copy_in_p4(t out nocopy cn_calc_formulas_pvt.rt_assign_tbl_type, a0 JTF_NUMBER_TABLE

112: end if;
113: end if;
114: end rosetta_table_copy_out_p3;
115:
116: procedure rosetta_table_copy_in_p4(t out nocopy cn_calc_formulas_pvt.rt_assign_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_DATE_TABLE
119: , a3 JTF_DATE_TABLE
120: , a4 JTF_VARCHAR2_TABLE_100

Line 147: procedure rosetta_table_copy_out_p4(t cn_calc_formulas_pvt.rt_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

143: end loop;
144: end if;
145: end if;
146: end rosetta_table_copy_in_p4;
147: procedure rosetta_table_copy_out_p4(t cn_calc_formulas_pvt.rt_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
148: , a1 out nocopy JTF_NUMBER_TABLE
149: , a2 out nocopy JTF_DATE_TABLE
150: , a3 out nocopy JTF_DATE_TABLE
151: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 201: procedure rosetta_table_copy_in_p5(t out nocopy cn_calc_formulas_pvt.parent_expression_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as

197: end if;
198: end if;
199: end rosetta_table_copy_out_p4;
200:
201: procedure rosetta_table_copy_in_p5(t out nocopy cn_calc_formulas_pvt.parent_expression_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as
202: ddindx binary_integer; indx binary_integer;
203: begin
204: if a0 is not null and a0.count > 0 then
205: if a0.count > 0 then

Line 219: procedure rosetta_table_copy_out_p5(t cn_calc_formulas_pvt.parent_expression_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

215: end loop;
216: end if;
217: end if;
218: end rosetta_table_copy_in_p5;
219: procedure rosetta_table_copy_out_p5(t cn_calc_formulas_pvt.parent_expression_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
220: ddindx binary_integer; indx binary_integer;
221: begin
222: if t is null or t.count = 0 then
223: a0 := JTF_VARCHAR2_TABLE_100();

Line 242: procedure rosetta_table_copy_in_p6(t out nocopy cn_calc_formulas_pvt.formula_tbl_type, a0 JTF_NUMBER_TABLE

238: end if;
239: end if;
240: end rosetta_table_copy_out_p5;
241:
242: procedure rosetta_table_copy_in_p6(t out nocopy cn_calc_formulas_pvt.formula_tbl_type, a0 JTF_NUMBER_TABLE
243: , a1 JTF_VARCHAR2_TABLE_100
244: , a2 JTF_VARCHAR2_TABLE_100
245: , a3 JTF_VARCHAR2_TABLE_100
246: , a4 JTF_VARCHAR2_TABLE_100

Line 291: procedure rosetta_table_copy_out_p6(t cn_calc_formulas_pvt.formula_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

287: end loop;
288: end if;
289: end if;
290: end rosetta_table_copy_in_p6;
291: procedure rosetta_table_copy_out_p6(t cn_calc_formulas_pvt.formula_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
292: , a1 out nocopy JTF_VARCHAR2_TABLE_100
293: , a2 out nocopy JTF_VARCHAR2_TABLE_100
294: , a3 out nocopy JTF_VARCHAR2_TABLE_100
295: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 435: ddp_input_tbl cn_calc_formulas_pvt.input_tbl_type;

431: , x_msg_data out nocopy VARCHAR2
432: )
433:
434: as
435: ddp_input_tbl cn_calc_formulas_pvt.input_tbl_type;
436: ddp_rt_assign_tbl cn_calc_formulas_pvt.rt_assign_tbl_type;
437: ddindx binary_integer; indx binary_integer;
438: begin
439:

Line 436: ddp_rt_assign_tbl cn_calc_formulas_pvt.rt_assign_tbl_type;

432: )
433:
434: as
435: ddp_input_tbl cn_calc_formulas_pvt.input_tbl_type;
436: ddp_rt_assign_tbl cn_calc_formulas_pvt.rt_assign_tbl_type;
437: ddindx binary_integer; indx binary_integer;
438: begin
439:
440: -- copy data to the local IN or IN-OUT args, if any

Line 459: cn_calc_formulas_pvt_w.rosetta_table_copy_in_p3(ddp_input_tbl, p18_a0

455:
456:
457:
458:
459: cn_calc_formulas_pvt_w.rosetta_table_copy_in_p3(ddp_input_tbl, p18_a0
460: , p18_a1
461: , p18_a2
462: , p18_a3
463: , p18_a4

Line 472: cn_calc_formulas_pvt_w.rosetta_table_copy_in_p4(ddp_rt_assign_tbl, p19_a0

468: , p18_a9
469: , p18_a10
470: );
471:
472: cn_calc_formulas_pvt_w.rosetta_table_copy_in_p4(ddp_rt_assign_tbl, p19_a0
473: , p19_a1
474: , p19_a2
475: , p19_a3
476: , p19_a4

Line 488: cn_calc_formulas_pvt.create_formula(p_api_version,

484:
485:
486:
487: -- here's the delegated call to the old PL/SQL routine
488: cn_calc_formulas_pvt.create_formula(p_api_version,
489: p_init_msg_list,
490: p_commit,
491: p_validation_level,
492: p_generate_packages,

Line 590: ddp_input_tbl cn_calc_formulas_pvt.input_tbl_type;

586: , x_msg_data out nocopy VARCHAR2
587: )
588:
589: as
590: ddp_input_tbl cn_calc_formulas_pvt.input_tbl_type;
591: ddp_rt_assign_tbl cn_calc_formulas_pvt.rt_assign_tbl_type;
592: ddindx binary_integer; indx binary_integer;
593: begin
594:

Line 591: ddp_rt_assign_tbl cn_calc_formulas_pvt.rt_assign_tbl_type;

587: )
588:
589: as
590: ddp_input_tbl cn_calc_formulas_pvt.input_tbl_type;
591: ddp_rt_assign_tbl cn_calc_formulas_pvt.rt_assign_tbl_type;
592: ddindx binary_integer; indx binary_integer;
593: begin
594:
595: -- copy data to the local IN or IN-OUT args, if any

Line 616: cn_calc_formulas_pvt_w.rosetta_table_copy_in_p3(ddp_input_tbl, p20_a0

612:
613:
614:
615:
616: cn_calc_formulas_pvt_w.rosetta_table_copy_in_p3(ddp_input_tbl, p20_a0
617: , p20_a1
618: , p20_a2
619: , p20_a3
620: , p20_a4

Line 629: cn_calc_formulas_pvt_w.rosetta_table_copy_in_p4(ddp_rt_assign_tbl, p21_a0

625: , p20_a9
626: , p20_a10
627: );
628:
629: cn_calc_formulas_pvt_w.rosetta_table_copy_in_p4(ddp_rt_assign_tbl, p21_a0
630: , p21_a1
631: , p21_a2
632: , p21_a3
633: , p21_a4

Line 645: cn_calc_formulas_pvt.update_formula(p_api_version,

641:
642:
643:
644: -- here's the delegated call to the old PL/SQL routine
645: cn_calc_formulas_pvt.update_formula(p_api_version,
646: p_init_msg_list,
647: p_commit,
648: p_validation_level,
649: p_generate_packages,

Line 704: end cn_calc_formulas_pvt_w;

700:
701:
702: end;
703:
704: end cn_calc_formulas_pvt_w;