1: package aso_service_contracts_int_w AUTHID CURRENT_USER 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:
1: package aso_service_contracts_int_w AUTHID CURRENT_USER 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
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
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
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
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
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
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:
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
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
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
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:
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,
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
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
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
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