DBA Data[Home] [Help]

APPS.OKL_AM_CREATE_QUOTE_PVT_W dependencies on OKL_AM_CREATE_QUOTE_PVT

Line 1: package body okl_am_create_quote_pvt_w as

1: package body okl_am_create_quote_pvt_w as
2: /* $Header: OKLECQTB.pls 120.4 2007/11/02 21:03:44 rmunjulu ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 22: procedure rosetta_table_copy_in_p17(t out nocopy okl_am_create_quote_pvt.assn_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p17(t out nocopy okl_am_create_quote_pvt.assn_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_200

Line 49: procedure rosetta_table_copy_out_p17(t okl_am_create_quote_pvt.assn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

45: end loop;
46: end if;
47: end if;
48: end rosetta_table_copy_in_p17;
49: procedure rosetta_table_copy_out_p17(t okl_am_create_quote_pvt.assn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_VARCHAR2_TABLE_200
51: , a2 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 93: procedure rosetta_table_copy_in_p19(t out nocopy okl_am_create_quote_pvt.achr_tbl_type, a0 JTF_VARCHAR2_TABLE_200

89: end if;
90: end if;
91: end rosetta_table_copy_out_p17;
92:
93: procedure rosetta_table_copy_in_p19(t out nocopy okl_am_create_quote_pvt.achr_tbl_type, a0 JTF_VARCHAR2_TABLE_200
94: , a1 JTF_VARCHAR2_TABLE_100
95: , a2 JTF_NUMBER_TABLE
96: , a3 JTF_VARCHAR2_TABLE_200
97: , a4 JTF_DATE_TABLE

Line 134: procedure rosetta_table_copy_out_p19(t okl_am_create_quote_pvt.achr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200

130: end loop;
131: end if;
132: end if;
133: end rosetta_table_copy_in_p19;
134: procedure rosetta_table_copy_out_p19(t okl_am_create_quote_pvt.achr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
135: , a1 out nocopy JTF_VARCHAR2_TABLE_100
136: , a2 out nocopy JTF_NUMBER_TABLE
137: , a3 out nocopy JTF_VARCHAR2_TABLE_200
138: , a4 out nocopy JTF_DATE_TABLE

Line 245: ddp_achr_rec okl_am_create_quote_pvt.achr_rec_type;

241: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
242: )
243:
244: as
245: ddp_achr_rec okl_am_create_quote_pvt.achr_rec_type;
246: ddx_achr_tbl okl_am_create_quote_pvt.achr_tbl_type;
247: ddindx binary_integer; indx binary_integer;
248: begin
249:

Line 246: ddx_achr_tbl okl_am_create_quote_pvt.achr_tbl_type;

242: )
243:
244: as
245: ddp_achr_rec okl_am_create_quote_pvt.achr_rec_type;
246: ddx_achr_tbl okl_am_create_quote_pvt.achr_tbl_type;
247: ddindx binary_integer; indx binary_integer;
248: begin
249:
250: -- copy data to the local IN or IN-OUT args, if any

Line 271: okl_am_create_quote_pvt.advance_contract_search(p_api_version,

267: ddp_achr_rec.party_name := p5_a11;
268:
269:
270: -- here's the delegated call to the old PL/SQL routine
271: okl_am_create_quote_pvt.advance_contract_search(p_api_version,
272: p_init_msg_list,
273: x_return_status,
274: x_msg_count,
275: x_msg_data,

Line 286: okl_am_create_quote_pvt_w.rosetta_table_copy_out_p19(ddx_achr_tbl, p6_a0

282:
283:
284:
285:
286: okl_am_create_quote_pvt_w.rosetta_table_copy_out_p19(ddx_achr_tbl, p6_a0
287: , p6_a1
288: , p6_a2
289: , p6_a3
290: , p6_a4

Line 391: ddp_quot_rec okl_am_create_quote_pvt.quot_rec_type;

387: , p0_a82 VARCHAR2 := fnd_api.g_miss_char
388: )
389:
390: as
391: ddp_quot_rec okl_am_create_quote_pvt.quot_rec_type;
392: ddindx binary_integer; indx binary_integer;
393: begin
394:
395: -- copy data to the local IN or IN-OUT args, if any

Line 485: okl_am_create_quote_pvt.quote_effectivity(ddp_quot_rec,

481:
482:
483:
484: -- here's the delegated call to the old PL/SQL routine
485: okl_am_create_quote_pvt.quote_effectivity(ddp_quot_rec,
486: p_rule_chr_id,
487: x_quote_eff_days,
488: x_quote_eff_max_days,
489: x_return_status);

Line 763: ddp_quot_rec okl_am_create_quote_pvt.quot_rec_type;

759: , p5_a82 VARCHAR2 := fnd_api.g_miss_char
760: )
761:
762: as
763: ddp_quot_rec okl_am_create_quote_pvt.quot_rec_type;
764: ddp_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
765: ddp_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
766: ddx_quot_rec okl_am_create_quote_pvt.quot_rec_type;
767: ddx_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;

Line 764: ddp_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;

760: )
761:
762: as
763: ddp_quot_rec okl_am_create_quote_pvt.quot_rec_type;
764: ddp_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
765: ddp_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
766: ddx_quot_rec okl_am_create_quote_pvt.quot_rec_type;
767: ddx_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
768: ddx_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;

Line 765: ddp_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;

761:
762: as
763: ddp_quot_rec okl_am_create_quote_pvt.quot_rec_type;
764: ddp_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
765: ddp_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
766: ddx_quot_rec okl_am_create_quote_pvt.quot_rec_type;
767: ddx_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
768: ddx_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
769: ddindx binary_integer; indx binary_integer;

Line 766: ddx_quot_rec okl_am_create_quote_pvt.quot_rec_type;

762: as
763: ddp_quot_rec okl_am_create_quote_pvt.quot_rec_type;
764: ddp_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
765: ddp_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
766: ddx_quot_rec okl_am_create_quote_pvt.quot_rec_type;
767: ddx_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
768: ddx_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
769: ddindx binary_integer; indx binary_integer;
770: begin

Line 767: ddx_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;

763: ddp_quot_rec okl_am_create_quote_pvt.quot_rec_type;
764: ddp_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
765: ddp_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
766: ddx_quot_rec okl_am_create_quote_pvt.quot_rec_type;
767: ddx_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
768: ddx_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
769: ddindx binary_integer; indx binary_integer;
770: begin
771:

Line 768: ddx_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;

764: ddp_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
765: ddp_qpyv_tbl okl_am_create_quote_pvt.qpyv_tbl_type;
766: ddx_quot_rec okl_am_create_quote_pvt.quot_rec_type;
767: ddx_tqlv_tbl okl_am_create_quote_pvt.tqlv_tbl_type;
768: ddx_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
769: ddindx binary_integer; indx binary_integer;
770: begin
771:
772: -- copy data to the local IN or IN-OUT args, if any

Line 862: okl_am_create_quote_pvt_w.rosetta_table_copy_in_p17(ddp_assn_tbl, p6_a0

858: ddp_quot_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a80);
859: ddp_quot_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
860: ddp_quot_rec.repo_quote_indicator_yn := p5_a82;
861:
862: okl_am_create_quote_pvt_w.rosetta_table_copy_in_p17(ddp_assn_tbl, p6_a0
863: , p6_a1
864: , p6_a2
865: , p6_a3
866: , p6_a4

Line 895: okl_am_create_quote_pvt.create_terminate_quote(p_api_version,

891:
892:
893:
894: -- here's the delegated call to the old PL/SQL routine
895: okl_am_create_quote_pvt.create_terminate_quote(p_api_version,
896: p_init_msg_list,
897: x_return_status,
898: x_msg_count,
899: x_msg_data,

Line 1063: okl_am_create_quote_pvt_w.rosetta_table_copy_out_p17(ddx_assn_tbl, p10_a0

1059: , p9_a59
1060: , p9_a60
1061: );
1062:
1063: okl_am_create_quote_pvt_w.rosetta_table_copy_out_p17(ddx_assn_tbl, p10_a0
1064: , p10_a1
1065: , p10_a2
1066: , p10_a3
1067: , p10_a4

Line 1160: ddp_quote_rec okl_am_create_quote_pvt.quot_rec_type;

1156: , p0_a82 VARCHAR2 := fnd_api.g_miss_char
1157: )
1158:
1159: as
1160: ddp_quote_rec okl_am_create_quote_pvt.quot_rec_type;
1161: ddindx binary_integer; indx binary_integer;
1162: begin
1163:
1164: -- copy data to the local IN or IN-OUT args, if any

Line 1253: okl_am_create_quote_pvt.get_net_gain_loss(ddp_quote_rec,

1249:
1250:
1251:
1252: -- here's the delegated call to the old PL/SQL routine
1253: okl_am_create_quote_pvt.get_net_gain_loss(ddp_quote_rec,
1254: p_chr_id,
1255: x_return_status,
1256: x_net_gain_loss);
1257:

Line 1264: end okl_am_create_quote_pvt_w;

1260:
1261:
1262: end;
1263:
1264: end okl_am_create_quote_pvt_w;