APPS.ASO_SERVICE_CONTRACTS_INT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 12: , a4 JTF_VARCHAR2_TABLE_100

8: procedure rosetta_table_copy_in_p4(t OUT NOCOPY aso_service_contracts_int.war_tbl_type, a0 JTF_NUMBER_TABLE
9: , a1 JTF_VARCHAR2_TABLE_2000
10: , a2 JTF_VARCHAR2_TABLE_300
11: , a3 JTF_NUMBER_TABLE
12: , a4 JTF_VARCHAR2_TABLE_100
13: , a5 JTF_NUMBER_TABLE
14: , a6 JTF_DATE_TABLE
15: , a7 JTF_DATE_TABLE
16: );

Line 21: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100

17: procedure rosetta_table_copy_out_p4(t aso_service_contracts_int.war_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
18: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
19: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_300
20: , a3 OUT NOCOPY JTF_NUMBER_TABLE
21: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
22: , a5 OUT NOCOPY JTF_NUMBER_TABLE
23: , a6 OUT NOCOPY JTF_DATE_TABLE
24: , a7 OUT NOCOPY JTF_DATE_TABLE
25: );

Line 50: , p8_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100

46: , p8_a0 OUT NOCOPY JTF_NUMBER_TABLE
47: , p8_a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
48: , p8_a2 OUT NOCOPY JTF_VARCHAR2_TABLE_300
49: , p8_a3 OUT NOCOPY JTF_NUMBER_TABLE
50: , p8_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
51: , p8_a5 OUT NOCOPY JTF_NUMBER_TABLE
52: , p8_a6 OUT NOCOPY JTF_DATE_TABLE
53: , p8_a7 OUT NOCOPY JTF_DATE_TABLE
54: );

Line 61: x_period_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

57: x_item_number_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
58: x_item_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
59: x_start_date_tbl OUT NOCOPY JTF_DATE_TABLE,
60: x_duration_tbl OUT NOCOPY JTF_NUMBER_TABLE,
61: x_period_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
62: x_warranty_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
63: p_source IN VARCHAR2,
64: p_source_id IN NUMBER,
65: p_api_version_number IN NUMBER,

Line 62: x_warranty_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

58: x_item_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
59: x_start_date_tbl OUT NOCOPY JTF_DATE_TABLE,
60: x_duration_tbl OUT NOCOPY JTF_NUMBER_TABLE,
61: x_period_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
62: x_warranty_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
63: p_source IN VARCHAR2,
64: p_source_id IN NUMBER,
65: p_api_version_number IN NUMBER,
66: p_init_msg_list IN VARCHAR2,

Line 87: , x_Concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_1000

83:
84: procedure available_services(
85: x_Inventory_organization_id OUT NOCOPY JTF_NUMBER_TABLE
86: , x_Service_item_id OUT NOCOPY JTF_NUMBER_TABLE
87: , x_Concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_1000
88: , x_Description OUT NOCOPY JTF_VARCHAR2_TABLE_1000
89: , x_Primary_uom_code OUT NOCOPY JTF_VARCHAR2_TABLE_300
90: , x_Serviceable_product_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
91: , x_Service_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 88: , x_Description OUT NOCOPY JTF_VARCHAR2_TABLE_1000

84: procedure available_services(
85: x_Inventory_organization_id OUT NOCOPY JTF_NUMBER_TABLE
86: , x_Service_item_id OUT NOCOPY JTF_NUMBER_TABLE
87: , x_Concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_1000
88: , x_Description OUT NOCOPY JTF_VARCHAR2_TABLE_1000
89: , x_Primary_uom_code OUT NOCOPY JTF_VARCHAR2_TABLE_300
90: , x_Serviceable_product_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
91: , x_Service_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
92: , x_Bom_item_type OUT NOCOPY JTF_NUMBER_TABLE

Line 90: , x_Serviceable_product_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

86: , x_Service_item_id OUT NOCOPY JTF_NUMBER_TABLE
87: , x_Concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_1000
88: , x_Description OUT NOCOPY JTF_VARCHAR2_TABLE_1000
89: , x_Primary_uom_code OUT NOCOPY JTF_VARCHAR2_TABLE_300
90: , x_Serviceable_product_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
91: , x_Service_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
92: , x_Bom_item_type OUT NOCOPY JTF_NUMBER_TABLE
93: , x_Item_type OUT NOCOPY JTF_VARCHAR2_TABLE_1000
94: , x_Service_duration OUT NOCOPY JTF_NUMBER_TABLE

Line 91: , x_Service_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

87: , x_Concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_1000
88: , x_Description OUT NOCOPY JTF_VARCHAR2_TABLE_1000
89: , x_Primary_uom_code OUT NOCOPY JTF_VARCHAR2_TABLE_300
90: , x_Serviceable_product_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
91: , x_Service_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
92: , x_Bom_item_type OUT NOCOPY JTF_NUMBER_TABLE
93: , x_Item_type OUT NOCOPY JTF_VARCHAR2_TABLE_1000
94: , x_Service_duration OUT NOCOPY JTF_NUMBER_TABLE
95: , x_Service_duration_period_code OUT NOCOPY JTF_VARCHAR2_TABLE_1000

Line 93: , x_Item_type OUT NOCOPY JTF_VARCHAR2_TABLE_1000

89: , x_Primary_uom_code OUT NOCOPY JTF_VARCHAR2_TABLE_300
90: , x_Serviceable_product_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
91: , x_Service_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
92: , x_Bom_item_type OUT NOCOPY JTF_NUMBER_TABLE
93: , x_Item_type OUT NOCOPY JTF_VARCHAR2_TABLE_1000
94: , x_Service_duration OUT NOCOPY JTF_NUMBER_TABLE
95: , x_Service_duration_period_code OUT NOCOPY JTF_VARCHAR2_TABLE_1000
96: , x_Shippable_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
97: , x_Returnable_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 95: , x_Service_duration_period_code OUT NOCOPY JTF_VARCHAR2_TABLE_1000

91: , x_Service_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
92: , x_Bom_item_type OUT NOCOPY JTF_NUMBER_TABLE
93: , x_Item_type OUT NOCOPY JTF_VARCHAR2_TABLE_1000
94: , x_Service_duration OUT NOCOPY JTF_NUMBER_TABLE
95: , x_Service_duration_period_code OUT NOCOPY JTF_VARCHAR2_TABLE_1000
96: , x_Shippable_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
97: , x_Returnable_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , p_api_version_number IN NUMBER := 1.0
99: , p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 96: , x_Shippable_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

92: , x_Bom_item_type OUT NOCOPY JTF_NUMBER_TABLE
93: , x_Item_type OUT NOCOPY JTF_VARCHAR2_TABLE_1000
94: , x_Service_duration OUT NOCOPY JTF_NUMBER_TABLE
95: , x_Service_duration_period_code OUT NOCOPY JTF_VARCHAR2_TABLE_1000
96: , x_Shippable_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
97: , x_Returnable_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , p_api_version_number IN NUMBER := 1.0
99: , p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR
100: , p_commit IN VARCHAR2:= FND_API.g_false

Line 97: , x_Returnable_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

93: , x_Item_type OUT NOCOPY JTF_VARCHAR2_TABLE_1000
94: , x_Service_duration OUT NOCOPY JTF_NUMBER_TABLE
95: , x_Service_duration_period_code OUT NOCOPY JTF_VARCHAR2_TABLE_1000
96: , x_Shippable_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
97: , x_Returnable_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , p_api_version_number IN NUMBER := 1.0
99: , p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR
100: , p_commit IN VARCHAR2:= FND_API.g_false
101: , p_search_input IN VARCHAR2 := FND_API.G_MISS_CHAR