DBA Data[Home] [Help]

APPS.ASO_SERVICE_CONTRACTS_INT_W dependencies on JTF_NUMBER_TABLE

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

1: package aso_service_contracts_int_w as
2: /* $Header: asovqwss.pls 120.1 2005/06/29 12:44:40 appldev ship $ */
3: procedure rosetta_table_copy_in_p2(t OUT NOCOPY aso_service_contracts_int.order_service_tbl_type, a0 JTF_NUMBER_TABLE
4: );
5: procedure rosetta_table_copy_out_p2(t aso_service_contracts_int.order_service_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
6: );
7:

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

1: package aso_service_contracts_int_w as
2: /* $Header: asovqwss.pls 120.1 2005/06/29 12:44:40 appldev ship $ */
3: procedure rosetta_table_copy_in_p2(t OUT NOCOPY aso_service_contracts_int.order_service_tbl_type, a0 JTF_NUMBER_TABLE
4: );
5: procedure rosetta_table_copy_out_p2(t aso_service_contracts_int.order_service_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
6: );
7:
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

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

4: );
5: procedure rosetta_table_copy_out_p2(t aso_service_contracts_int.order_service_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
6: );
7:
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

Line 11: , a3 JTF_NUMBER_TABLE

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

Line 13: , a5 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: );
17: procedure rosetta_table_copy_out_p4(t aso_service_contracts_int.war_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

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

13: , a5 JTF_NUMBER_TABLE
14: , a6 JTF_DATE_TABLE
15: , a7 JTF_DATE_TABLE
16: );
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

Line 20: , a3 OUT NOCOPY JTF_NUMBER_TABLE

16: );
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

Line 22: , a5 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: );
26:

Line 32: , p6_a0 OUT NOCOPY JTF_NUMBER_TABLE

28: , p_init_msg_list VARCHAR2
29: , x_msg_count OUT NOCOPY NUMBER
30: , x_msg_data OUT NOCOPY VARCHAR2
31: , x_return_status OUT NOCOPY VARCHAR2
32: , p6_a0 OUT NOCOPY JTF_NUMBER_TABLE
33: , p5_a0 NUMBER := 0-1962.0724
34: , p5_a1 NUMBER := 0-1962.0724
35: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
36: , p5_a3 DATE := fnd_api.g_miss_date

Line 46: , p8_a0 OUT NOCOPY JTF_NUMBER_TABLE

42: , p_org_id NUMBER
43: , p_organization_id NUMBER
44: , p_product_item_id NUMBER
45: , x_return_status OUT NOCOPY VARCHAR2
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

Line 49: , p8_a3 OUT NOCOPY JTF_NUMBER_TABLE

45: , x_return_status OUT NOCOPY VARCHAR2
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

Line 51: , p8_a5 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: );
55:

Line 60: x_duration_tbl OUT NOCOPY JTF_NUMBER_TABLE,

56: procedure GET_SERVICES (
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,

Line 85: x_Inventory_organization_id OUT NOCOPY JTF_NUMBER_TABLE

81: , p_request_date IN Date
82: , X_Available_YN OUT NOCOPY /* file.sql.39 change */ varchar2);
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

Line 86: , x_Service_item_id OUT NOCOPY JTF_NUMBER_TABLE

82: , X_Available_YN OUT NOCOPY /* file.sql.39 change */ varchar2);
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

Line 92: , x_Bom_item_type OUT NOCOPY JTF_NUMBER_TABLE

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
96: , x_Shippable_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 94: , x_Service_duration OUT NOCOPY JTF_NUMBER_TABLE

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
98: , p_api_version_number IN NUMBER := 1.0