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_VARCHAR2_TABLE_100

Line 69: , a4 JTF_VARCHAR2_TABLE_100

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
73: ) as

Line 102: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100

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
106: ) as

Line 114: a4 := JTF_VARCHAR2_TABLE_100();

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();
118: else

Line 123: a4 := JTF_VARCHAR2_TABLE_100();

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();
127: if t.count > 0 then

Line 214: , p8_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100

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
218: )

Line 261: x_period_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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,
265: p_api_version_number IN NUMBER,

Line 262: x_warranty_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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,
265: p_api_version_number IN NUMBER,
266: p_init_msg_list IN VARCHAR2,

Line 389: x_period_code_tbl := JTF_VARCHAR2_TABLE_100();

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
393:

Line 390: x_warranty_flag_tbl := JTF_VARCHAR2_TABLE_100();

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
393:
394: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 732: , x_Concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_1000

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
736: , x_Service_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 733: , x_Description OUT NOCOPY JTF_VARCHAR2_TABLE_1000

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
736: , x_Service_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
737: , x_Bom_item_type OUT NOCOPY JTF_NUMBER_TABLE

Line 735: , x_Serviceable_product_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

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
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

Line 736: , x_Service_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

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
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

Line 738: , x_Item_type 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
742: , x_Returnable_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 740: , x_Service_duration_period_code OUT NOCOPY JTF_VARCHAR2_TABLE_1000

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
744: , p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 741: , x_Shippable_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
744: , p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR
745: , p_commit IN VARCHAR2:= FND_API.g_false

Line 742: , x_Returnable_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

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
744: , p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR
745: , p_commit IN VARCHAR2:= FND_API.g_false
746: , p_search_input IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 848: x_Concatenated_segments := JTF_VARCHAR2_TABLE_1000();

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();
852: x_Service_item_flag := JTF_VARCHAR2_TABLE_100();

Line 849: x_Description := JTF_VARCHAR2_TABLE_1000();

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();
852: x_Service_item_flag := JTF_VARCHAR2_TABLE_100();
853: x_Bom_item_type := JTF_NUMBER_TABLE();

Line 851: x_Serviceable_product_flag := JTF_VARCHAR2_TABLE_100();

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();
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();

Line 852: x_Service_item_flag := JTF_VARCHAR2_TABLE_100();

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();
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();

Line 854: x_Item_type := 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();
858: x_Returnable_flag := JTF_VARCHAR2_TABLE_100();

Line 856: x_Service_duration_period_code := JTF_VARCHAR2_TABLE_1000();

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:
860: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 857: x_Shippable_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:
860: IF aso_debug_pub.g_debug_flag = 'Y' THEN
861: aso_debug_pub.ADD ( 'Number of Records Returned from OKC API : '|| to_char(l_orderable_service_tbl.count) , 1 , 'Y' );

Line 858: x_Returnable_flag := JTF_VARCHAR2_TABLE_100();

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:
860: IF aso_debug_pub.g_debug_flag = 'Y' THEN
861: aso_debug_pub.ADD ( 'Number of Records Returned from OKC API : '|| to_char(l_orderable_service_tbl.count) , 1 , 'Y' );
862: END IF;