eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSMPLBMI_W dependencies on WSMPLBMI

Line 1: package body wsmplbmi_w as

1: package body wsmplbmi_w as
2: /* $Header: WSMLBMWB.pls 120.0 2005/07/06 11:11 skaradib noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy wsmplbmi.t_sec_uom_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as
4: ddindx binary_integer; indx binary_integer;
5: begin

Line 3: procedure rosetta_table_copy_in_p0(t out nocopy wsmplbmi.t_sec_uom_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as

1: package body wsmplbmi_w as
2: /* $Header: WSMLBMWB.pls 120.0 2005/07/06 11:11 skaradib noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy wsmplbmi.t_sec_uom_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as
4: ddindx binary_integer; indx binary_integer;
5: begin
6: if a0 is not null and a0.count > 0 then
7: if a0.count > 0 then

Line 21: procedure rosetta_table_copy_out_p0(t wsmplbmi.t_sec_uom_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

17: end loop;
18: end if;
19: end if;
20: end rosetta_table_copy_in_p0;
21: procedure rosetta_table_copy_out_p0(t wsmplbmi.t_sec_uom_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
22: ddindx binary_integer; indx binary_integer;
23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_VARCHAR2_TABLE_100();

Line 44: procedure rosetta_table_copy_in_p1(t out nocopy wsmplbmi.t_sec_move_out_qty_tbl_type, a0 JTF_NUMBER_TABLE) as

40: end if;
41: end if;
42: end rosetta_table_copy_out_p0;
43:
44: procedure rosetta_table_copy_in_p1(t out nocopy wsmplbmi.t_sec_move_out_qty_tbl_type, a0 JTF_NUMBER_TABLE) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if a0 is not null and a0.count > 0 then
48: if a0.count > 0 then

Line 62: procedure rosetta_table_copy_out_p1(t wsmplbmi.t_sec_move_out_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

58: end loop;
59: end if;
60: end if;
61: end rosetta_table_copy_in_p1;
62: procedure rosetta_table_copy_out_p1(t wsmplbmi.t_sec_move_out_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
63: ddindx binary_integer; indx binary_integer;
64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_NUMBER_TABLE();

Line 85: procedure rosetta_table_copy_in_p2(t out nocopy wsmplbmi.t_scrap_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as

81: end if;
82: end if;
83: end rosetta_table_copy_out_p1;
84:
85: procedure rosetta_table_copy_in_p2(t out nocopy wsmplbmi.t_scrap_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as
86: ddindx binary_integer; indx binary_integer;
87: begin
88: if a0 is not null and a0.count > 0 then
89: if a0.count > 0 then

Line 103: procedure rosetta_table_copy_out_p2(t wsmplbmi.t_scrap_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t wsmplbmi.t_scrap_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
104: ddindx binary_integer; indx binary_integer;
105: begin
106: if t is null or t.count = 0 then
107: a0 := JTF_VARCHAR2_TABLE_100();

Line 126: procedure rosetta_table_copy_in_p3(t out nocopy wsmplbmi.t_scrap_code_qty_tbl_type, a0 JTF_NUMBER_TABLE) as

122: end if;
123: end if;
124: end rosetta_table_copy_out_p2;
125:
126: procedure rosetta_table_copy_in_p3(t out nocopy wsmplbmi.t_scrap_code_qty_tbl_type, a0 JTF_NUMBER_TABLE) as
127: ddindx binary_integer; indx binary_integer;
128: begin
129: if a0 is not null and a0.count > 0 then
130: if a0.count > 0 then

Line 144: procedure rosetta_table_copy_out_p3(t wsmplbmi.t_scrap_code_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

140: end loop;
141: end if;
142: end if;
143: end rosetta_table_copy_in_p3;
144: procedure rosetta_table_copy_out_p3(t wsmplbmi.t_scrap_code_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
145: ddindx binary_integer; indx binary_integer;
146: begin
147: if t is null or t.count = 0 then
148: a0 := JTF_NUMBER_TABLE();

Line 167: procedure rosetta_table_copy_in_p4(t out nocopy wsmplbmi.t_bonus_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as

163: end if;
164: end if;
165: end rosetta_table_copy_out_p3;
166:
167: procedure rosetta_table_copy_in_p4(t out nocopy wsmplbmi.t_bonus_codes_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as
168: ddindx binary_integer; indx binary_integer;
169: begin
170: if a0 is not null and a0.count > 0 then
171: if a0.count > 0 then

Line 185: procedure rosetta_table_copy_out_p4(t wsmplbmi.t_bonus_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

181: end loop;
182: end if;
183: end if;
184: end rosetta_table_copy_in_p4;
185: procedure rosetta_table_copy_out_p4(t wsmplbmi.t_bonus_codes_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
186: ddindx binary_integer; indx binary_integer;
187: begin
188: if t is null or t.count = 0 then
189: a0 := JTF_VARCHAR2_TABLE_100();

Line 208: procedure rosetta_table_copy_in_p5(t out nocopy wsmplbmi.t_bonus_code_qty_tbl_type, a0 JTF_NUMBER_TABLE) as

204: end if;
205: end if;
206: end rosetta_table_copy_out_p4;
207:
208: procedure rosetta_table_copy_in_p5(t out nocopy wsmplbmi.t_bonus_code_qty_tbl_type, a0 JTF_NUMBER_TABLE) as
209: ddindx binary_integer; indx binary_integer;
210: begin
211: if a0 is not null and a0.count > 0 then
212: if a0.count > 0 then

Line 226: procedure rosetta_table_copy_out_p5(t wsmplbmi.t_bonus_code_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

222: end loop;
223: end if;
224: end if;
225: end rosetta_table_copy_in_p5;
226: procedure rosetta_table_copy_out_p5(t wsmplbmi.t_bonus_code_qty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
227: ddindx binary_integer; indx binary_integer;
228: begin
229: if t is null or t.count = 0 then
230: a0 := JTF_NUMBER_TABLE();

Line 249: procedure rosetta_table_copy_in_p7(t out nocopy wsmplbmi.t_jobop_res_usages_tbl_type, a0 JTF_NUMBER_TABLE

245: end if;
246: end if;
247: end rosetta_table_copy_out_p5;
248:
249: procedure rosetta_table_copy_in_p7(t out nocopy wsmplbmi.t_jobop_res_usages_tbl_type, a0 JTF_NUMBER_TABLE
250: , a1 JTF_NUMBER_TABLE
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_NUMBER_TABLE

Line 316: procedure rosetta_table_copy_out_p7(t wsmplbmi.t_jobop_res_usages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

312: end loop;
313: end if;
314: end if;
315: end rosetta_table_copy_in_p7;
316: procedure rosetta_table_copy_out_p7(t wsmplbmi.t_jobop_res_usages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
317: , a1 out nocopy JTF_NUMBER_TABLE
318: , a2 out nocopy JTF_NUMBER_TABLE
319: , a3 out nocopy JTF_NUMBER_TABLE
320: , a4 out nocopy JTF_NUMBER_TABLE

Line 1301: ddp_sec_uom_code_tbl wsmplbmi.t_sec_uom_code_tbl_type;

1297: , x_msg_data out nocopy VARCHAR2
1298: )
1299:
1300: as
1301: ddp_sec_uom_code_tbl wsmplbmi.t_sec_uom_code_tbl_type;
1302: ddp_sec_move_out_qty_tbl wsmplbmi.t_sec_move_out_qty_tbl_type;
1303: ddp_jobop_scrap_serials_tbl WSM_Serial_support_GRP.WSM_SERIAL_NUM_TBL;
1304: ddp_jobop_bonus_serials_tbl WSM_Serial_support_GRP.WSM_SERIAL_NUM_TBL;
1305: ddp_scrap_codes_tbl wsmplbmi.t_scrap_codes_tbl_type;

Line 1302: ddp_sec_move_out_qty_tbl wsmplbmi.t_sec_move_out_qty_tbl_type;

1298: )
1299:
1300: as
1301: ddp_sec_uom_code_tbl wsmplbmi.t_sec_uom_code_tbl_type;
1302: ddp_sec_move_out_qty_tbl wsmplbmi.t_sec_move_out_qty_tbl_type;
1303: ddp_jobop_scrap_serials_tbl WSM_Serial_support_GRP.WSM_SERIAL_NUM_TBL;
1304: ddp_jobop_bonus_serials_tbl WSM_Serial_support_GRP.WSM_SERIAL_NUM_TBL;
1305: ddp_scrap_codes_tbl wsmplbmi.t_scrap_codes_tbl_type;
1306: ddp_scrap_code_qty_tbl wsmplbmi.t_scrap_code_qty_tbl_type;

Line 1305: ddp_scrap_codes_tbl wsmplbmi.t_scrap_codes_tbl_type;

1301: ddp_sec_uom_code_tbl wsmplbmi.t_sec_uom_code_tbl_type;
1302: ddp_sec_move_out_qty_tbl wsmplbmi.t_sec_move_out_qty_tbl_type;
1303: ddp_jobop_scrap_serials_tbl WSM_Serial_support_GRP.WSM_SERIAL_NUM_TBL;
1304: ddp_jobop_bonus_serials_tbl WSM_Serial_support_GRP.WSM_SERIAL_NUM_TBL;
1305: ddp_scrap_codes_tbl wsmplbmi.t_scrap_codes_tbl_type;
1306: ddp_scrap_code_qty_tbl wsmplbmi.t_scrap_code_qty_tbl_type;
1307: ddp_bonus_codes_tbl wsmplbmi.t_bonus_codes_tbl_type;
1308: ddp_bonus_code_qty_tbl wsmplbmi.t_bonus_code_qty_tbl_type;
1309: ddp_jobop_resource_usages_tbl wsmplbmi.t_jobop_res_usages_tbl_type;

Line 1306: ddp_scrap_code_qty_tbl wsmplbmi.t_scrap_code_qty_tbl_type;

1302: ddp_sec_move_out_qty_tbl wsmplbmi.t_sec_move_out_qty_tbl_type;
1303: ddp_jobop_scrap_serials_tbl WSM_Serial_support_GRP.WSM_SERIAL_NUM_TBL;
1304: ddp_jobop_bonus_serials_tbl WSM_Serial_support_GRP.WSM_SERIAL_NUM_TBL;
1305: ddp_scrap_codes_tbl wsmplbmi.t_scrap_codes_tbl_type;
1306: ddp_scrap_code_qty_tbl wsmplbmi.t_scrap_code_qty_tbl_type;
1307: ddp_bonus_codes_tbl wsmplbmi.t_bonus_codes_tbl_type;
1308: ddp_bonus_code_qty_tbl wsmplbmi.t_bonus_code_qty_tbl_type;
1309: ddp_jobop_resource_usages_tbl wsmplbmi.t_jobop_res_usages_tbl_type;
1310: ddindx binary_integer; indx binary_integer;

Line 1307: ddp_bonus_codes_tbl wsmplbmi.t_bonus_codes_tbl_type;

1303: ddp_jobop_scrap_serials_tbl WSM_Serial_support_GRP.WSM_SERIAL_NUM_TBL;
1304: ddp_jobop_bonus_serials_tbl WSM_Serial_support_GRP.WSM_SERIAL_NUM_TBL;
1305: ddp_scrap_codes_tbl wsmplbmi.t_scrap_codes_tbl_type;
1306: ddp_scrap_code_qty_tbl wsmplbmi.t_scrap_code_qty_tbl_type;
1307: ddp_bonus_codes_tbl wsmplbmi.t_bonus_codes_tbl_type;
1308: ddp_bonus_code_qty_tbl wsmplbmi.t_bonus_code_qty_tbl_type;
1309: ddp_jobop_resource_usages_tbl wsmplbmi.t_jobop_res_usages_tbl_type;
1310: ddindx binary_integer; indx binary_integer;
1311: begin

Line 1308: ddp_bonus_code_qty_tbl wsmplbmi.t_bonus_code_qty_tbl_type;

1304: ddp_jobop_bonus_serials_tbl WSM_Serial_support_GRP.WSM_SERIAL_NUM_TBL;
1305: ddp_scrap_codes_tbl wsmplbmi.t_scrap_codes_tbl_type;
1306: ddp_scrap_code_qty_tbl wsmplbmi.t_scrap_code_qty_tbl_type;
1307: ddp_bonus_codes_tbl wsmplbmi.t_bonus_codes_tbl_type;
1308: ddp_bonus_code_qty_tbl wsmplbmi.t_bonus_code_qty_tbl_type;
1309: ddp_jobop_resource_usages_tbl wsmplbmi.t_jobop_res_usages_tbl_type;
1310: ddindx binary_integer; indx binary_integer;
1311: begin
1312:

Line 1309: ddp_jobop_resource_usages_tbl wsmplbmi.t_jobop_res_usages_tbl_type;

1305: ddp_scrap_codes_tbl wsmplbmi.t_scrap_codes_tbl_type;
1306: ddp_scrap_code_qty_tbl wsmplbmi.t_scrap_code_qty_tbl_type;
1307: ddp_bonus_codes_tbl wsmplbmi.t_bonus_codes_tbl_type;
1308: ddp_bonus_code_qty_tbl wsmplbmi.t_bonus_code_qty_tbl_type;
1309: ddp_jobop_resource_usages_tbl wsmplbmi.t_jobop_res_usages_tbl_type;
1310: ddindx binary_integer; indx binary_integer;
1311: begin
1312:
1313: -- copy data to the local IN or IN-OUT args, if any

Line 1352: wsmplbmi_w.rosetta_table_copy_in_p0(ddp_sec_uom_code_tbl, p_sec_uom_code_tbl);

1348:
1349:
1350:
1351:
1352: wsmplbmi_w.rosetta_table_copy_in_p0(ddp_sec_uom_code_tbl, p_sec_uom_code_tbl);
1353:
1354: wsmplbmi_w.rosetta_table_copy_in_p1(ddp_sec_move_out_qty_tbl, p_sec_move_out_qty_tbl);
1355:
1356: wsmplbmi_w.rosetta_table_copy_in_p9(ddp_jobop_scrap_serials_tbl, p40_a0

Line 1354: wsmplbmi_w.rosetta_table_copy_in_p1(ddp_sec_move_out_qty_tbl, p_sec_move_out_qty_tbl);

1350:
1351:
1352: wsmplbmi_w.rosetta_table_copy_in_p0(ddp_sec_uom_code_tbl, p_sec_uom_code_tbl);
1353:
1354: wsmplbmi_w.rosetta_table_copy_in_p1(ddp_sec_move_out_qty_tbl, p_sec_move_out_qty_tbl);
1355:
1356: wsmplbmi_w.rosetta_table_copy_in_p9(ddp_jobop_scrap_serials_tbl, p40_a0
1357: , p40_a1
1358: , p40_a2

Line 1356: wsmplbmi_w.rosetta_table_copy_in_p9(ddp_jobop_scrap_serials_tbl, p40_a0

1352: wsmplbmi_w.rosetta_table_copy_in_p0(ddp_sec_uom_code_tbl, p_sec_uom_code_tbl);
1353:
1354: wsmplbmi_w.rosetta_table_copy_in_p1(ddp_sec_move_out_qty_tbl, p_sec_move_out_qty_tbl);
1355:
1356: wsmplbmi_w.rosetta_table_copy_in_p9(ddp_jobop_scrap_serials_tbl, p40_a0
1357: , p40_a1
1358: , p40_a2
1359: , p40_a3
1360: , p40_a4

Line 1439: wsmplbmi_w.rosetta_table_copy_in_p9(ddp_jobop_bonus_serials_tbl, p41_a0

1435: , p40_a79
1436: , p40_a80
1437: );
1438:
1439: wsmplbmi_w.rosetta_table_copy_in_p9(ddp_jobop_bonus_serials_tbl, p41_a0
1440: , p41_a1
1441: , p41_a2
1442: , p41_a3
1443: , p41_a4

Line 1522: wsmplbmi_w.rosetta_table_copy_in_p2(ddp_scrap_codes_tbl, p_scrap_codes_tbl);

1518: , p41_a79
1519: , p41_a80
1520: );
1521:
1522: wsmplbmi_w.rosetta_table_copy_in_p2(ddp_scrap_codes_tbl, p_scrap_codes_tbl);
1523:
1524: wsmplbmi_w.rosetta_table_copy_in_p3(ddp_scrap_code_qty_tbl, p_scrap_code_qty_tbl);
1525:
1526: wsmplbmi_w.rosetta_table_copy_in_p4(ddp_bonus_codes_tbl, p_bonus_codes_tbl);

Line 1524: wsmplbmi_w.rosetta_table_copy_in_p3(ddp_scrap_code_qty_tbl, p_scrap_code_qty_tbl);

1520: );
1521:
1522: wsmplbmi_w.rosetta_table_copy_in_p2(ddp_scrap_codes_tbl, p_scrap_codes_tbl);
1523:
1524: wsmplbmi_w.rosetta_table_copy_in_p3(ddp_scrap_code_qty_tbl, p_scrap_code_qty_tbl);
1525:
1526: wsmplbmi_w.rosetta_table_copy_in_p4(ddp_bonus_codes_tbl, p_bonus_codes_tbl);
1527:
1528: wsmplbmi_w.rosetta_table_copy_in_p5(ddp_bonus_code_qty_tbl, p_bonus_code_qty_tbl);

Line 1526: wsmplbmi_w.rosetta_table_copy_in_p4(ddp_bonus_codes_tbl, p_bonus_codes_tbl);

1522: wsmplbmi_w.rosetta_table_copy_in_p2(ddp_scrap_codes_tbl, p_scrap_codes_tbl);
1523:
1524: wsmplbmi_w.rosetta_table_copy_in_p3(ddp_scrap_code_qty_tbl, p_scrap_code_qty_tbl);
1525:
1526: wsmplbmi_w.rosetta_table_copy_in_p4(ddp_bonus_codes_tbl, p_bonus_codes_tbl);
1527:
1528: wsmplbmi_w.rosetta_table_copy_in_p5(ddp_bonus_code_qty_tbl, p_bonus_code_qty_tbl);
1529:
1530: wsmplbmi_w.rosetta_table_copy_in_p7(ddp_jobop_resource_usages_tbl, p46_a0

Line 1528: wsmplbmi_w.rosetta_table_copy_in_p5(ddp_bonus_code_qty_tbl, p_bonus_code_qty_tbl);

1524: wsmplbmi_w.rosetta_table_copy_in_p3(ddp_scrap_code_qty_tbl, p_scrap_code_qty_tbl);
1525:
1526: wsmplbmi_w.rosetta_table_copy_in_p4(ddp_bonus_codes_tbl, p_bonus_codes_tbl);
1527:
1528: wsmplbmi_w.rosetta_table_copy_in_p5(ddp_bonus_code_qty_tbl, p_bonus_code_qty_tbl);
1529:
1530: wsmplbmi_w.rosetta_table_copy_in_p7(ddp_jobop_resource_usages_tbl, p46_a0
1531: , p46_a1
1532: , p46_a2

Line 1530: wsmplbmi_w.rosetta_table_copy_in_p7(ddp_jobop_resource_usages_tbl, p46_a0

1526: wsmplbmi_w.rosetta_table_copy_in_p4(ddp_bonus_codes_tbl, p_bonus_codes_tbl);
1527:
1528: wsmplbmi_w.rosetta_table_copy_in_p5(ddp_bonus_code_qty_tbl, p_bonus_code_qty_tbl);
1529:
1530: wsmplbmi_w.rosetta_table_copy_in_p7(ddp_jobop_resource_usages_tbl, p46_a0
1531: , p46_a1
1532: , p46_a2
1533: , p46_a3
1534: , p46_a4

Line 1562: wsmplbmi.movetransaction(p_group_id,

1558:
1559:
1560:
1561: -- here's the delegated call to the old PL/SQL routine
1562: wsmplbmi.movetransaction(p_group_id,
1563: p_transaction_id,
1564: p_source_code,
1565: p_transaction_type,
1566: p_organization_id,

Line 1667: end wsmplbmi_w;

1663:
1664:
1665: end;
1666:
1667: end wsmplbmi_w;