DBA Data[Home] [Help]

APPS.JTF_FULFILLMENT_PUB_W dependencies on JTF_FULFILLMENT_PUB

Line 1: package body jtf_fulfillment_pub_w as

1: package body jtf_fulfillment_pub_w as
2: /* $Header: jtfgfmpwb.pls 120.0 2005/05/11 08:14:42 appldev 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_p2(t out nocopy jtf_fulfillment_pub.order_line_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_p2(t out nocopy jtf_fulfillment_pub.order_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: ) as

Line 47: procedure rosetta_table_copy_out_p2(t jtf_fulfillment_pub.order_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

43: end loop;
44: end if;
45: end if;
46: end rosetta_table_copy_in_p2;
47: procedure rosetta_table_copy_out_p2(t jtf_fulfillment_pub.order_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_VARCHAR2_TABLE_100
50: , a3 out nocopy JTF_NUMBER_TABLE
51: ) as

Line 119: ddp_order_header_rec jtf_fulfillment_pub.order_header_rec_type;

115: , p6_a14 NUMBER := 0-1962.0724
116: )
117:
118: as
119: ddp_order_header_rec jtf_fulfillment_pub.order_header_rec_type;
120: ddp_order_line_tbl jtf_fulfillment_pub.order_line_tbl_type;
121: ddx_order_header_rec aso_order_int.order_header_rec_type;
122: ddindx binary_integer; indx binary_integer;
123: begin

Line 120: ddp_order_line_tbl jtf_fulfillment_pub.order_line_tbl_type;

116: )
117:
118: as
119: ddp_order_header_rec jtf_fulfillment_pub.order_header_rec_type;
120: ddp_order_line_tbl jtf_fulfillment_pub.order_line_tbl_type;
121: ddx_order_header_rec aso_order_int.order_header_rec_type;
122: ddindx binary_integer; indx binary_integer;
123: begin
124:

Line 148: jtf_fulfillment_pub_w.rosetta_table_copy_in_p2(ddp_order_line_tbl, p7_a0

144: ddp_order_header_rec.uom_code := p6_a12;
145: ddp_order_header_rec.line_category_code := p6_a13;
146: ddp_order_header_rec.inv_organization_id := rosetta_g_miss_num_map(p6_a14);
147:
148: jtf_fulfillment_pub_w.rosetta_table_copy_in_p2(ddp_order_line_tbl, p7_a0
149: , p7_a1
150: , p7_a2
151: , p7_a3
152: );

Line 157: jtf_fulfillment_pub.create_fulfill_physical(p_init_msg_list,

153:
154:
155:
156: -- here's the delegated call to the old PL/SQL routine
157: jtf_fulfillment_pub.create_fulfill_physical(p_init_msg_list,
158: p_api_version,
159: p_commit,
160: x_return_status,
161: x_msg_count,

Line 184: end jtf_fulfillment_pub_w;

180: p8_a3 := ddx_order_header_rec.status;
181:
182: end;
183:
184: end jtf_fulfillment_pub_w;