DBA Data[Home] [Help]

APPS.OKL_AM_SEND_FULFILLMENT_PVT_W dependencies on OKL_AM_SEND_FULFILLMENT_PVT

Line 1: package body okl_am_send_fulfillment_pvt_w as

1: package body okl_am_send_fulfillment_pvt_w as
2: /* $Header: OKLESFWB.pls 115.9 2002/12/13 19:34:08 gkadarka noship $ */
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_p9(t out nocopy okl_am_send_fulfillment_pvt.full_tbl_type, a0 JTF_VARCHAR2_TABLE_200

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

Line 57: procedure rosetta_table_copy_out_p9(t okl_am_send_fulfillment_pvt.full_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200

53: end loop;
54: end if;
55: end if;
56: end rosetta_table_copy_in_p9;
57: procedure rosetta_table_copy_out_p9(t okl_am_send_fulfillment_pvt.full_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_VARCHAR2_TABLE_200
61: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 147: ddp_send_rec okl_am_send_fulfillment_pvt.full_rec_type;

143: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
144: )
145:
146: as
147: ddp_send_rec okl_am_send_fulfillment_pvt.full_rec_type;
148: ddx_send_rec okl_am_send_fulfillment_pvt.full_rec_type;
149: ddindx binary_integer; indx binary_integer;
150: begin
151:

Line 148: ddx_send_rec okl_am_send_fulfillment_pvt.full_rec_type;

144: )
145:
146: as
147: ddp_send_rec okl_am_send_fulfillment_pvt.full_rec_type;
148: ddx_send_rec okl_am_send_fulfillment_pvt.full_rec_type;
149: ddindx binary_integer; indx binary_integer;
150: begin
151:
152: -- copy data to the local IN or IN-OUT args, if any

Line 170: okl_am_send_fulfillment_pvt.send_fulfillment(p_api_version,

166: ddp_send_rec.p_recipient_email := p5_a8;
167:
168:
169: -- here's the delegated call to the old PL/SQL routine
170: okl_am_send_fulfillment_pvt.send_fulfillment(p_api_version,
171: p_init_msg_list,
172: x_return_status,
173: x_msg_count,
174: x_msg_data,

Line 222: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;

218: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
219: )
220:
221: as
222: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
223: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
224: ddindx binary_integer; indx binary_integer;
225: begin
226:

Line 223: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;

219: )
220:
221: as
222: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
223: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
224: ddindx binary_integer; indx binary_integer;
225: begin
226:
227: -- copy data to the local IN or IN-OUT args, if any

Line 233: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_in_p9(ddp_send_tbl, p5_a0

229:
230:
231:
232:
233: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_in_p9(ddp_send_tbl, p5_a0
234: , p5_a1
235: , p5_a2
236: , p5_a3
237: , p5_a4

Line 246: okl_am_send_fulfillment_pvt.send_fulfillment(p_api_version,

242: );
243:
244:
245: -- here's the delegated call to the old PL/SQL routine
246: okl_am_send_fulfillment_pvt.send_fulfillment(p_api_version,
247: p_init_msg_list,
248: x_return_status,
249: x_msg_count,
250: x_msg_data,

Line 261: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_out_p9(ddx_send_tbl, p6_a0

257:
258:
259:
260:
261: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_out_p9(ddx_send_tbl, p6_a0
262: , p6_a1
263: , p6_a2
264: , p6_a3
265: , p6_a4

Line 513: ddp_party_tbl okl_am_send_fulfillment_pvt.q_party_uv_tbl_type;

509: , p7_a79 DATE := fnd_api.g_miss_date
510: )
511:
512: as
513: ddp_party_tbl okl_am_send_fulfillment_pvt.q_party_uv_tbl_type;
514: ddx_party_tbl okl_am_send_fulfillment_pvt.q_party_uv_tbl_type;
515: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
516: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
517: ddindx binary_integer; indx binary_integer;

Line 514: ddx_party_tbl okl_am_send_fulfillment_pvt.q_party_uv_tbl_type;

510: )
511:
512: as
513: ddp_party_tbl okl_am_send_fulfillment_pvt.q_party_uv_tbl_type;
514: ddx_party_tbl okl_am_send_fulfillment_pvt.q_party_uv_tbl_type;
515: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
516: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
517: ddindx binary_integer; indx binary_integer;
518: begin

Line 515: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;

511:
512: as
513: ddp_party_tbl okl_am_send_fulfillment_pvt.q_party_uv_tbl_type;
514: ddx_party_tbl okl_am_send_fulfillment_pvt.q_party_uv_tbl_type;
515: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
516: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
517: ddindx binary_integer; indx binary_integer;
518: begin
519:

Line 516: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;

512: as
513: ddp_party_tbl okl_am_send_fulfillment_pvt.q_party_uv_tbl_type;
514: ddx_party_tbl okl_am_send_fulfillment_pvt.q_party_uv_tbl_type;
515: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
516: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
517: ddindx binary_integer; indx binary_integer;
518: begin
519:
520: -- copy data to the local IN or IN-OUT args, if any

Line 648: okl_am_send_fulfillment_pvt.send_terminate_quote(p_api_version,

644: ddp_qtev_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p7_a79);
645:
646:
647: -- here's the delegated call to the old PL/SQL routine
648: okl_am_send_fulfillment_pvt.send_terminate_quote(p_api_version,
649: p_init_msg_list,
650: x_return_status,
651: x_msg_count,
652: x_msg_data,

Line 972: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;

968: , p7_a79 DATE := fnd_api.g_miss_date
969: )
970:
971: as
972: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
973: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
974: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
975: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
976: ddindx binary_integer; indx binary_integer;

Line 973: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;

969: )
970:
971: as
972: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
973: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
974: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
975: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
976: ddindx binary_integer; indx binary_integer;
977: begin

Line 974: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;

970:
971: as
972: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
973: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
974: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
975: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
976: ddindx binary_integer; indx binary_integer;
977: begin
978:

Line 975: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;

971: as
972: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
973: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
974: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
975: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
976: ddindx binary_integer; indx binary_integer;
977: begin
978:
979: -- copy data to the local IN or IN-OUT args, if any

Line 985: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_in_p9(ddp_send_tbl, p5_a0

981:
982:
983:
984:
985: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_in_p9(ddp_send_tbl, p5_a0
986: , p5_a1
987: , p5_a2
988: , p5_a3
989: , p5_a4

Line 1080: okl_am_send_fulfillment_pvt.send_repurchase_quote(p_api_version,

1076: ddp_qtev_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p7_a79);
1077:
1078:
1079: -- here's the delegated call to the old PL/SQL routine
1080: okl_am_send_fulfillment_pvt.send_repurchase_quote(p_api_version,
1081: p_init_msg_list,
1082: x_return_status,
1083: x_msg_count,
1084: x_msg_data,

Line 1097: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_out_p9(ddx_send_tbl, p6_a0

1093:
1094:
1095:
1096:
1097: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_out_p9(ddx_send_tbl, p6_a0
1098: , p6_a1
1099: , p6_a2
1100: , p6_a3
1101: , p6_a4

Line 1377: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;

1373: , p7_a79 DATE := fnd_api.g_miss_date
1374: )
1375:
1376: as
1377: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1378: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1379: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1380: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1381: ddindx binary_integer; indx binary_integer;

Line 1378: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;

1374: )
1375:
1376: as
1377: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1378: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1379: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1380: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1381: ddindx binary_integer; indx binary_integer;
1382: begin

Line 1379: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;

1375:
1376: as
1377: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1378: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1379: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1380: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1381: ddindx binary_integer; indx binary_integer;
1382: begin
1383:

Line 1380: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;

1376: as
1377: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1378: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1379: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1380: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1381: ddindx binary_integer; indx binary_integer;
1382: begin
1383:
1384: -- copy data to the local IN or IN-OUT args, if any

Line 1390: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_in_p9(ddp_send_tbl, p5_a0

1386:
1387:
1388:
1389:
1390: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_in_p9(ddp_send_tbl, p5_a0
1391: , p5_a1
1392: , p5_a2
1393: , p5_a3
1394: , p5_a4

Line 1485: okl_am_send_fulfillment_pvt.send_restructure_quote(p_api_version,

1481: ddp_qtev_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p7_a79);
1482:
1483:
1484: -- here's the delegated call to the old PL/SQL routine
1485: okl_am_send_fulfillment_pvt.send_restructure_quote(p_api_version,
1486: p_init_msg_list,
1487: x_return_status,
1488: x_msg_count,
1489: x_msg_data,

Line 1502: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_out_p9(ddx_send_tbl, p6_a0

1498:
1499:
1500:
1501:
1502: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_out_p9(ddx_send_tbl, p6_a0
1503: , p6_a1
1504: , p6_a2
1505: , p6_a3
1506: , p6_a4

Line 1782: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;

1778: , p7_a79 DATE := fnd_api.g_miss_date
1779: )
1780:
1781: as
1782: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1783: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1784: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1785: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1786: ddindx binary_integer; indx binary_integer;

Line 1783: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;

1779: )
1780:
1781: as
1782: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1783: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1784: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1785: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1786: ddindx binary_integer; indx binary_integer;
1787: begin

Line 1784: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;

1780:
1781: as
1782: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1783: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1784: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1785: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1786: ddindx binary_integer; indx binary_integer;
1787: begin
1788:

Line 1785: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;

1781: as
1782: ddp_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1783: ddx_send_tbl okl_am_send_fulfillment_pvt.full_tbl_type;
1784: ddp_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1785: ddx_qtev_rec okl_am_send_fulfillment_pvt.qtev_rec_type;
1786: ddindx binary_integer; indx binary_integer;
1787: begin
1788:
1789: -- copy data to the local IN or IN-OUT args, if any

Line 1795: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_in_p9(ddp_send_tbl, p5_a0

1791:
1792:
1793:
1794:
1795: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_in_p9(ddp_send_tbl, p5_a0
1796: , p5_a1
1797: , p5_a2
1798: , p5_a3
1799: , p5_a4

Line 1890: okl_am_send_fulfillment_pvt.send_consolidate_quote(p_api_version,

1886: ddp_qtev_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p7_a79);
1887:
1888:
1889: -- here's the delegated call to the old PL/SQL routine
1890: okl_am_send_fulfillment_pvt.send_consolidate_quote(p_api_version,
1891: p_init_msg_list,
1892: x_return_status,
1893: x_msg_count,
1894: x_msg_data,

Line 1907: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_out_p9(ddx_send_tbl, p6_a0

1903:
1904:
1905:
1906:
1907: okl_am_send_fulfillment_pvt_w.rosetta_table_copy_out_p9(ddx_send_tbl, p6_a0
1908: , p6_a1
1909: , p6_a2
1910: , p6_a3
1911: , p6_a4

Line 2001: end okl_am_send_fulfillment_pvt_w;

1997: p8_a78 := rosetta_g_miss_num_map(ddx_qtev_rec.currency_conversion_rate);
1998: p8_a79 := ddx_qtev_rec.currency_conversion_date;
1999: end;
2000:
2001: end okl_am_send_fulfillment_pvt_w;