DBA Data[Home] [Help]

APPS.OKL_TRX_QUOTES_PUB_W dependencies on OKL_TRX_QUOTES_PUB

Line 1: package body okl_trx_quotes_pub_w as

1: package body okl_trx_quotes_pub_w as
2: /* $Header: OKLUQTEB.pls 120.2 2007/11/02 21:03:05 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 196: ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;

192: , p6_a82 out nocopy JTF_VARCHAR2_TABLE_100
193: )
194:
195: as
196: ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
197: ddx_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
198: ddindx binary_integer; indx binary_integer;
199: begin
200:

Line 197: ddx_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;

193: )
194:
195: as
196: ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
197: ddx_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
198: ddindx binary_integer; indx binary_integer;
199: begin
200:
201: -- copy data to the local IN or IN-OUT args, if any

Line 294: okl_trx_quotes_pub.insert_trx_quotes(p_api_version,

290: );
291:
292:
293: -- here's the delegated call to the old PL/SQL routine
294: okl_trx_quotes_pub.insert_trx_quotes(p_api_version,
295: p_init_msg_list,
296: x_return_status,
297: x_msg_count,
298: x_msg_data,

Line 569: ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;

565: , p5_a82 VARCHAR2 := fnd_api.g_miss_char
566: )
567:
568: as
569: ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
570: ddx_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
571: ddindx binary_integer; indx binary_integer;
572: begin
573:

Line 570: ddx_qtev_rec okl_trx_quotes_pub.qtev_rec_type;

566: )
567:
568: as
569: ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
570: ddx_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
571: ddindx binary_integer; indx binary_integer;
572: begin
573:
574: -- copy data to the local IN or IN-OUT args, if any

Line 666: okl_trx_quotes_pub.insert_trx_quotes(p_api_version,

662: ddp_qtev_rec.repo_quote_indicator_yn := p5_a82;
663:
664:
665: -- here's the delegated call to the old PL/SQL routine
666: okl_trx_quotes_pub.insert_trx_quotes(p_api_version,
667: p_init_msg_list,
668: x_return_status,
669: x_msg_count,
670: x_msg_data,

Line 857: ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;

853: , p5_a82 JTF_VARCHAR2_TABLE_100
854: )
855:
856: as
857: ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
858: ddindx binary_integer; indx binary_integer;
859: begin
860:
861: -- copy data to the local IN or IN-OUT args, if any

Line 953: okl_trx_quotes_pub.lock_trx_quotes(p_api_version,

949: , p5_a82
950: );
951:
952: -- here's the delegated call to the old PL/SQL routine
953: okl_trx_quotes_pub.lock_trx_quotes(p_api_version,
954: p_init_msg_list,
955: x_return_status,
956: x_msg_count,
957: x_msg_data,

Line 1059: ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;

1055: , p5_a82 VARCHAR2 := fnd_api.g_miss_char
1056: )
1057:
1058: as
1059: ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
1060: ddindx binary_integer; indx binary_integer;
1061: begin
1062:
1063: -- copy data to the local IN or IN-OUT args, if any

Line 1154: okl_trx_quotes_pub.lock_trx_quotes(p_api_version,

1150: ddp_qtev_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
1151: ddp_qtev_rec.repo_quote_indicator_yn := p5_a82;
1152:
1153: -- here's the delegated call to the old PL/SQL routine
1154: okl_trx_quotes_pub.lock_trx_quotes(p_api_version,
1155: p_init_msg_list,
1156: x_return_status,
1157: x_msg_count,
1158: x_msg_data,

Line 1343: ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;

1339: , p6_a82 out nocopy JTF_VARCHAR2_TABLE_100
1340: )
1341:
1342: as
1343: ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
1344: ddx_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
1345: ddindx binary_integer; indx binary_integer;
1346: begin
1347:

Line 1344: ddx_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;

1340: )
1341:
1342: as
1343: ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
1344: ddx_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
1345: ddindx binary_integer; indx binary_integer;
1346: begin
1347:
1348: -- copy data to the local IN or IN-OUT args, if any

Line 1441: okl_trx_quotes_pub.update_trx_quotes(p_api_version,

1437: );
1438:
1439:
1440: -- here's the delegated call to the old PL/SQL routine
1441: okl_trx_quotes_pub.update_trx_quotes(p_api_version,
1442: p_init_msg_list,
1443: x_return_status,
1444: x_msg_count,
1445: x_msg_data,

Line 1716: ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;

1712: , p5_a82 VARCHAR2 := fnd_api.g_miss_char
1713: )
1714:
1715: as
1716: ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
1717: ddx_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
1718: ddindx binary_integer; indx binary_integer;
1719: begin
1720:

Line 1717: ddx_qtev_rec okl_trx_quotes_pub.qtev_rec_type;

1713: )
1714:
1715: as
1716: ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
1717: ddx_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
1718: ddindx binary_integer; indx binary_integer;
1719: begin
1720:
1721: -- copy data to the local IN or IN-OUT args, if any

Line 1813: okl_trx_quotes_pub.update_trx_quotes(p_api_version,

1809: ddp_qtev_rec.repo_quote_indicator_yn := p5_a82;
1810:
1811:
1812: -- here's the delegated call to the old PL/SQL routine
1813: okl_trx_quotes_pub.update_trx_quotes(p_api_version,
1814: p_init_msg_list,
1815: x_return_status,
1816: x_msg_count,
1817: x_msg_data,

Line 2004: ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;

2000: , p5_a82 JTF_VARCHAR2_TABLE_100
2001: )
2002:
2003: as
2004: ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
2005: ddindx binary_integer; indx binary_integer;
2006: begin
2007:
2008: -- copy data to the local IN or IN-OUT args, if any

Line 2100: okl_trx_quotes_pub.delete_trx_quotes(p_api_version,

2096: , p5_a82
2097: );
2098:
2099: -- here's the delegated call to the old PL/SQL routine
2100: okl_trx_quotes_pub.delete_trx_quotes(p_api_version,
2101: p_init_msg_list,
2102: x_return_status,
2103: x_msg_count,
2104: x_msg_data,

Line 2206: ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;

2202: , p5_a82 VARCHAR2 := fnd_api.g_miss_char
2203: )
2204:
2205: as
2206: ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
2207: ddindx binary_integer; indx binary_integer;
2208: begin
2209:
2210: -- copy data to the local IN or IN-OUT args, if any

Line 2301: okl_trx_quotes_pub.delete_trx_quotes(p_api_version,

2297: ddp_qtev_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
2298: ddp_qtev_rec.repo_quote_indicator_yn := p5_a82;
2299:
2300: -- here's the delegated call to the old PL/SQL routine
2301: okl_trx_quotes_pub.delete_trx_quotes(p_api_version,
2302: p_init_msg_list,
2303: x_return_status,
2304: x_msg_count,
2305: x_msg_data,

Line 2407: ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;

2403: , p5_a82 JTF_VARCHAR2_TABLE_100
2404: )
2405:
2406: as
2407: ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
2408: ddindx binary_integer; indx binary_integer;
2409: begin
2410:
2411: -- copy data to the local IN or IN-OUT args, if any

Line 2503: okl_trx_quotes_pub.validate_trx_quotes(p_api_version,

2499: , p5_a82
2500: );
2501:
2502: -- here's the delegated call to the old PL/SQL routine
2503: okl_trx_quotes_pub.validate_trx_quotes(p_api_version,
2504: p_init_msg_list,
2505: x_return_status,
2506: x_msg_count,
2507: x_msg_data,

Line 2609: ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;

2605: , p5_a82 VARCHAR2 := fnd_api.g_miss_char
2606: )
2607:
2608: as
2609: ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
2610: ddindx binary_integer; indx binary_integer;
2611: begin
2612:
2613: -- copy data to the local IN or IN-OUT args, if any

Line 2704: okl_trx_quotes_pub.validate_trx_quotes(p_api_version,

2700: ddp_qtev_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
2701: ddp_qtev_rec.repo_quote_indicator_yn := p5_a82;
2702:
2703: -- here's the delegated call to the old PL/SQL routine
2704: okl_trx_quotes_pub.validate_trx_quotes(p_api_version,
2705: p_init_msg_list,
2706: x_return_status,
2707: x_msg_count,
2708: x_msg_data,

Line 2719: end okl_trx_quotes_pub_w;

2715:
2716:
2717: end;
2718:
2719: end okl_trx_quotes_pub_w;