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.ASO_SERVICE_CONTRACTS_INT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p2(t OUT NOCOPY aso_service_contracts_int.order_service_tbl_type, a0 JTF_NUMBER_TABLE

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t OUT NOCOPY aso_service_contracts_int.order_service_tbl_type, a0 JTF_NUMBER_TABLE
23: ) as
24: ddindx binary_integer; indx binary_integer;
25: begin
26: if a0 is not null and a0.count > 0 then

Line 41: procedure rosetta_table_copy_out_p2(t aso_service_contracts_int.order_service_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

37: end loop;
38: end if;
39: end if;
40: end rosetta_table_copy_in_p2;
41: procedure rosetta_table_copy_out_p2(t aso_service_contracts_int.order_service_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if t is null or t.count = 0 then

Line 46: a0 := JTF_NUMBER_TABLE();

42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if t is null or t.count = 0 then
46: a0 := JTF_NUMBER_TABLE();
47: else
48: a0 := JTF_NUMBER_TABLE();
49: if t.count > 0 then
50: a0.extend(t.count);

Line 48: a0 := JTF_NUMBER_TABLE();

44: begin
45: if t is null or t.count = 0 then
46: a0 := JTF_NUMBER_TABLE();
47: else
48: a0 := JTF_NUMBER_TABLE();
49: if t.count > 0 then
50: a0.extend(t.count);
51: ddindx := t.first;
52: indx := 1;

Line 65: procedure rosetta_table_copy_in_p4(t OUT NOCOPY aso_service_contracts_int.war_tbl_type, a0 JTF_NUMBER_TABLE

61: end if;
62: end if;
63: end rosetta_table_copy_out_p2;
64:
65: procedure rosetta_table_copy_in_p4(t OUT NOCOPY aso_service_contracts_int.war_tbl_type, a0 JTF_NUMBER_TABLE
66: , a1 JTF_VARCHAR2_TABLE_2000
67: , a2 JTF_VARCHAR2_TABLE_300
68: , a3 JTF_NUMBER_TABLE
69: , a4 JTF_VARCHAR2_TABLE_100

Line 68: , a3 JTF_NUMBER_TABLE

64:
65: procedure rosetta_table_copy_in_p4(t OUT NOCOPY aso_service_contracts_int.war_tbl_type, a0 JTF_NUMBER_TABLE
66: , a1 JTF_VARCHAR2_TABLE_2000
67: , a2 JTF_VARCHAR2_TABLE_300
68: , a3 JTF_NUMBER_TABLE
69: , a4 JTF_VARCHAR2_TABLE_100
70: , a5 JTF_NUMBER_TABLE
71: , a6 JTF_DATE_TABLE
72: , a7 JTF_DATE_TABLE

Line 70: , a5 JTF_NUMBER_TABLE

66: , a1 JTF_VARCHAR2_TABLE_2000
67: , a2 JTF_VARCHAR2_TABLE_300
68: , a3 JTF_NUMBER_TABLE
69: , a4 JTF_VARCHAR2_TABLE_100
70: , a5 JTF_NUMBER_TABLE
71: , a6 JTF_DATE_TABLE
72: , a7 JTF_DATE_TABLE
73: ) as
74: ddindx binary_integer; indx binary_integer;

Line 98: procedure rosetta_table_copy_out_p4(t aso_service_contracts_int.war_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

94: end loop;
95: end if;
96: end if;
97: end rosetta_table_copy_in_p4;
98: procedure rosetta_table_copy_out_p4(t aso_service_contracts_int.war_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
99: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
100: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_300
101: , a3 OUT NOCOPY JTF_NUMBER_TABLE
102: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 101: , a3 OUT NOCOPY JTF_NUMBER_TABLE

97: end rosetta_table_copy_in_p4;
98: procedure rosetta_table_copy_out_p4(t aso_service_contracts_int.war_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
99: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
100: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_300
101: , a3 OUT NOCOPY JTF_NUMBER_TABLE
102: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
103: , a5 OUT NOCOPY JTF_NUMBER_TABLE
104: , a6 OUT NOCOPY JTF_DATE_TABLE
105: , a7 OUT NOCOPY JTF_DATE_TABLE

Line 103: , a5 OUT NOCOPY JTF_NUMBER_TABLE

99: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
100: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_300
101: , a3 OUT NOCOPY JTF_NUMBER_TABLE
102: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
103: , a5 OUT NOCOPY JTF_NUMBER_TABLE
104: , a6 OUT NOCOPY JTF_DATE_TABLE
105: , a7 OUT NOCOPY JTF_DATE_TABLE
106: ) as
107: ddindx binary_integer; indx binary_integer;

Line 110: a0 := JTF_NUMBER_TABLE();

106: ) as
107: ddindx binary_integer; indx binary_integer;
108: begin
109: if t is null or t.count = 0 then
110: a0 := JTF_NUMBER_TABLE();
111: a1 := JTF_VARCHAR2_TABLE_2000();
112: a2 := JTF_VARCHAR2_TABLE_300();
113: a3 := JTF_NUMBER_TABLE();
114: a4 := JTF_VARCHAR2_TABLE_100();

Line 113: a3 := JTF_NUMBER_TABLE();

109: if t is null or t.count = 0 then
110: a0 := JTF_NUMBER_TABLE();
111: a1 := JTF_VARCHAR2_TABLE_2000();
112: a2 := JTF_VARCHAR2_TABLE_300();
113: a3 := JTF_NUMBER_TABLE();
114: a4 := JTF_VARCHAR2_TABLE_100();
115: a5 := JTF_NUMBER_TABLE();
116: a6 := JTF_DATE_TABLE();
117: a7 := JTF_DATE_TABLE();

Line 115: a5 := JTF_NUMBER_TABLE();

111: a1 := JTF_VARCHAR2_TABLE_2000();
112: a2 := JTF_VARCHAR2_TABLE_300();
113: a3 := JTF_NUMBER_TABLE();
114: a4 := JTF_VARCHAR2_TABLE_100();
115: a5 := JTF_NUMBER_TABLE();
116: a6 := JTF_DATE_TABLE();
117: a7 := JTF_DATE_TABLE();
118: else
119: a0 := JTF_NUMBER_TABLE();

Line 119: a0 := JTF_NUMBER_TABLE();

115: a5 := JTF_NUMBER_TABLE();
116: a6 := JTF_DATE_TABLE();
117: a7 := JTF_DATE_TABLE();
118: else
119: a0 := JTF_NUMBER_TABLE();
120: a1 := JTF_VARCHAR2_TABLE_2000();
121: a2 := JTF_VARCHAR2_TABLE_300();
122: a3 := JTF_NUMBER_TABLE();
123: a4 := JTF_VARCHAR2_TABLE_100();

Line 122: a3 := JTF_NUMBER_TABLE();

118: else
119: a0 := JTF_NUMBER_TABLE();
120: a1 := JTF_VARCHAR2_TABLE_2000();
121: a2 := JTF_VARCHAR2_TABLE_300();
122: a3 := JTF_NUMBER_TABLE();
123: a4 := JTF_VARCHAR2_TABLE_100();
124: a5 := JTF_NUMBER_TABLE();
125: a6 := JTF_DATE_TABLE();
126: a7 := JTF_DATE_TABLE();

Line 124: a5 := JTF_NUMBER_TABLE();

120: a1 := JTF_VARCHAR2_TABLE_2000();
121: a2 := JTF_VARCHAR2_TABLE_300();
122: a3 := JTF_NUMBER_TABLE();
123: a4 := JTF_VARCHAR2_TABLE_100();
124: a5 := JTF_NUMBER_TABLE();
125: a6 := JTF_DATE_TABLE();
126: a7 := JTF_DATE_TABLE();
127: if t.count > 0 then
128: a0.extend(t.count);

Line 162: , p6_a0 OUT NOCOPY JTF_NUMBER_TABLE

158: , p_init_msg_list VARCHAR2
159: , x_msg_count OUT NOCOPY NUMBER
160: , x_msg_data OUT NOCOPY VARCHAR2
161: , x_return_status OUT NOCOPY VARCHAR2
162: , p6_a0 OUT NOCOPY JTF_NUMBER_TABLE
163: , p5_a0 NUMBER := 0-1962.0724
164: , p5_a1 NUMBER := 0-1962.0724
165: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a3 DATE := fnd_api.g_miss_date

Line 210: , p8_a0 OUT NOCOPY JTF_NUMBER_TABLE

206: , p_org_id NUMBER
207: , p_organization_id NUMBER
208: , p_product_item_id NUMBER
209: , x_return_status OUT NOCOPY VARCHAR2
210: , p8_a0 OUT NOCOPY JTF_NUMBER_TABLE
211: , p8_a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
212: , p8_a2 OUT NOCOPY JTF_VARCHAR2_TABLE_300
213: , p8_a3 OUT NOCOPY JTF_NUMBER_TABLE
214: , p8_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 213: , p8_a3 OUT NOCOPY JTF_NUMBER_TABLE

209: , x_return_status OUT NOCOPY VARCHAR2
210: , p8_a0 OUT NOCOPY JTF_NUMBER_TABLE
211: , p8_a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
212: , p8_a2 OUT NOCOPY JTF_VARCHAR2_TABLE_300
213: , p8_a3 OUT NOCOPY JTF_NUMBER_TABLE
214: , p8_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
215: , p8_a5 OUT NOCOPY JTF_NUMBER_TABLE
216: , p8_a6 OUT NOCOPY JTF_DATE_TABLE
217: , p8_a7 OUT NOCOPY JTF_DATE_TABLE

Line 215: , p8_a5 OUT NOCOPY JTF_NUMBER_TABLE

211: , p8_a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
212: , p8_a2 OUT NOCOPY JTF_VARCHAR2_TABLE_300
213: , p8_a3 OUT NOCOPY JTF_NUMBER_TABLE
214: , p8_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
215: , p8_a5 OUT NOCOPY JTF_NUMBER_TABLE
216: , p8_a6 OUT NOCOPY JTF_DATE_TABLE
217: , p8_a7 OUT NOCOPY JTF_DATE_TABLE
218: )
219: as

Line 260: x_duration_tbl OUT NOCOPY JTF_NUMBER_TABLE,

256: PROCEDURE GET_SERVICES (
257: x_item_number_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
258: x_item_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
259: x_start_date_tbl OUT NOCOPY JTF_DATE_TABLE,
260: x_duration_tbl OUT NOCOPY JTF_NUMBER_TABLE,
261: x_period_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
262: x_warranty_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
263: p_source IN VARCHAR2,
264: p_source_id IN NUMBER,

Line 388: x_duration_tbl := JTF_NUMBER_TABLE();

384:
385: x_item_number_tbl := JTF_VARCHAR2_TABLE_2000();
386: x_item_desc_tbl := JTF_VARCHAR2_TABLE_2000();
387: x_start_date_tbl := JTF_DATE_TABLE();
388: x_duration_tbl := JTF_NUMBER_TABLE();
389: x_period_code_tbl := JTF_VARCHAR2_TABLE_100();
390: x_warranty_flag_tbl := JTF_VARCHAR2_TABLE_100();
391:
392: IF (p_source ='INSTALL_BASE') THEN

Line 730: x_Inventory_organization_id OUT NOCOPY JTF_NUMBER_TABLE

726:
727: END is_service_available;
728:
729: procedure available_services(
730: x_Inventory_organization_id OUT NOCOPY JTF_NUMBER_TABLE
731: , x_Service_item_id OUT NOCOPY JTF_NUMBER_TABLE
732: , x_Concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_1000
733: , x_Description OUT NOCOPY JTF_VARCHAR2_TABLE_1000
734: , x_Primary_uom_code OUT NOCOPY JTF_VARCHAR2_TABLE_300

Line 731: , x_Service_item_id OUT NOCOPY JTF_NUMBER_TABLE

727: END is_service_available;
728:
729: procedure available_services(
730: x_Inventory_organization_id OUT NOCOPY JTF_NUMBER_TABLE
731: , x_Service_item_id OUT NOCOPY JTF_NUMBER_TABLE
732: , x_Concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_1000
733: , x_Description OUT NOCOPY JTF_VARCHAR2_TABLE_1000
734: , x_Primary_uom_code OUT NOCOPY JTF_VARCHAR2_TABLE_300
735: , x_Serviceable_product_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 737: , x_Bom_item_type OUT NOCOPY JTF_NUMBER_TABLE

733: , x_Description OUT NOCOPY JTF_VARCHAR2_TABLE_1000
734: , x_Primary_uom_code OUT NOCOPY JTF_VARCHAR2_TABLE_300
735: , x_Serviceable_product_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
736: , x_Service_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
737: , x_Bom_item_type OUT NOCOPY JTF_NUMBER_TABLE
738: , x_Item_type OUT NOCOPY JTF_VARCHAR2_TABLE_1000
739: , x_Service_duration OUT NOCOPY JTF_NUMBER_TABLE
740: , x_Service_duration_period_code OUT NOCOPY JTF_VARCHAR2_TABLE_1000
741: , x_Shippable_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 739: , x_Service_duration OUT NOCOPY JTF_NUMBER_TABLE

735: , x_Serviceable_product_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
736: , x_Service_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
737: , x_Bom_item_type OUT NOCOPY JTF_NUMBER_TABLE
738: , x_Item_type OUT NOCOPY JTF_VARCHAR2_TABLE_1000
739: , x_Service_duration OUT NOCOPY JTF_NUMBER_TABLE
740: , x_Service_duration_period_code OUT NOCOPY JTF_VARCHAR2_TABLE_1000
741: , x_Shippable_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
742: , x_Returnable_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
743: , p_api_version_number IN NUMBER

Line 846: x_Inventory_organization_id := JTF_NUMBER_TABLE();

842: raise FND_API.G_EXC_UNEXPECTED_ERROR;
843: END IF;
844:
845: -- initialize the record structures
846: x_Inventory_organization_id := JTF_NUMBER_TABLE();
847: x_Service_item_id := JTF_NUMBER_TABLE();
848: x_Concatenated_segments := JTF_VARCHAR2_TABLE_1000();
849: x_Description := JTF_VARCHAR2_TABLE_1000();
850: x_Primary_uom_code := JTF_VARCHAR2_TABLE_300();

Line 847: x_Service_item_id := JTF_NUMBER_TABLE();

843: END IF;
844:
845: -- initialize the record structures
846: x_Inventory_organization_id := JTF_NUMBER_TABLE();
847: x_Service_item_id := JTF_NUMBER_TABLE();
848: x_Concatenated_segments := JTF_VARCHAR2_TABLE_1000();
849: x_Description := JTF_VARCHAR2_TABLE_1000();
850: x_Primary_uom_code := JTF_VARCHAR2_TABLE_300();
851: x_Serviceable_product_flag := JTF_VARCHAR2_TABLE_100();

Line 853: x_Bom_item_type := JTF_NUMBER_TABLE();

849: x_Description := JTF_VARCHAR2_TABLE_1000();
850: x_Primary_uom_code := JTF_VARCHAR2_TABLE_300();
851: x_Serviceable_product_flag := JTF_VARCHAR2_TABLE_100();
852: x_Service_item_flag := JTF_VARCHAR2_TABLE_100();
853: x_Bom_item_type := JTF_NUMBER_TABLE();
854: x_Item_type := JTF_VARCHAR2_TABLE_1000();
855: x_Service_duration := JTF_NUMBER_TABLE();
856: x_Service_duration_period_code := JTF_VARCHAR2_TABLE_1000();
857: x_Shippable_item_flag := JTF_VARCHAR2_TABLE_100();

Line 855: x_Service_duration := JTF_NUMBER_TABLE();

851: x_Serviceable_product_flag := JTF_VARCHAR2_TABLE_100();
852: x_Service_item_flag := JTF_VARCHAR2_TABLE_100();
853: x_Bom_item_type := JTF_NUMBER_TABLE();
854: x_Item_type := JTF_VARCHAR2_TABLE_1000();
855: x_Service_duration := JTF_NUMBER_TABLE();
856: x_Service_duration_period_code := JTF_VARCHAR2_TABLE_1000();
857: x_Shippable_item_flag := JTF_VARCHAR2_TABLE_100();
858: x_Returnable_flag := JTF_VARCHAR2_TABLE_100();
859: