1 PACKAGE igs_ps_generic_pvt AS
2 /* $Header: IGSPS90S.pls 120.1 2005/09/08 14:44:51 appldev noship $ */
3
4
5 /***********************************************************************************************
6 Created By: Sanjeeb Rakshit
7 Date Created By: 25-May-2005
8 Purpose: A private API to import data from external system to OSS is declared along with
9 several PL-SQL table types to be used in the API.
10 Known limitations,enhancements,remarks:
11
12 Change History
13
14 Who When What
15
16 ***********************************************************************************************/
17
18
19 PROCEDURE psp_import (
20 p_api_version IN NUMBER,
21 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_count OUT NOCOPY NUMBER,
26 x_msg_data OUT NOCOPY VARCHAR2,
27 p_calling_context IN VARCHAR2,
28 p_usec_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_tbl_type,
29 p_usec_gs_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_gs_tbl_type,
30 p_uso_tbl IN OUT NOCOPY igs_ps_generic_pub.uso_tbl_type,
31 p_unit_ref_tbl IN OUT NOCOPY igs_ps_generic_pub.unit_ref_tbl_type,
32 p_uso_ins_tbl IN OUT NOCOPY igs_ps_generic_pub.uso_ins_tbl_type,
33 p_usec_occurs_facility_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_tbl_type,
34 p_usec_teach_resp_ovrd_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_tbl_type,
35 p_usec_notes_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_notes_tbl_type,
36 p_usec_assmnt_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_tbl_type,
37 p_usec_plus_hr_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_tbl_type,
38 p_usec_cat_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_cat_tbl_type,
39 p_usec_rule_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_rule_tbl_type,
40 p_usec_cross_group_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_tbl_type,
41 p_usec_meet_with_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_tbl_type,
42 p_usec_waitlist_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_tbl_type,
43 p_usec_res_seat_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_tbl_type,
44 p_usec_sp_fee_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_tbl_type,
45 p_usec_ret_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_ret_tbl_type,
46 p_usec_ret_dtl_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_tbl_type,
47 p_usec_enr_dead_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_tbl_type,
48 p_usec_enr_dis_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_tbl_type,
49 p_usec_teach_resp_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_tbl_type,
50 P_usec_ass_item_grp_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_tbl_type,
51 p_usec_status OUT NOCOPY VARCHAR2,
52 p_usec_gs_status OUT NOCOPY VARCHAR2,
53 p_uso_status OUT NOCOPY VARCHAR2,
54 p_uso_ins_status OUT NOCOPY VARCHAR2,
55 p_uso_facility_status OUT NOCOPY VARCHAR2,
56 p_unit_ref_status OUT NOCOPY VARCHAR2,
57 p_usec_teach_resp_ovrd_status OUT NOCOPY VARCHAR2,
58 p_usec_notes_status OUT NOCOPY VARCHAR2,
59 p_usec_assmnt_status OUT NOCOPY VARCHAR2,
60 p_usec_plus_hr_status OUT NOCOPY VARCHAR2,
61 p_usec_cat_status OUT NOCOPY VARCHAR2,
62 p_usec_rule_status OUT NOCOPY VARCHAR2,
63 p_usec_cross_group_status OUT NOCOPY VARCHAR2,
64 p_usec_meet_with_status OUT NOCOPY VARCHAR2,
65 p_usec_waitlist_status OUT NOCOPY VARCHAR2,
66 p_usec_res_seat_status OUT NOCOPY VARCHAR2,
67 p_usec_sp_fee_status OUT NOCOPY VARCHAR2,
68 p_usec_ret_status OUT NOCOPY VARCHAR2,
69 p_usec_ret_dtl_status OUT NOCOPY VARCHAR2,
70 p_usec_enr_dead_status OUT NOCOPY VARCHAR2,
71 p_usec_enr_dis_status OUT NOCOPY VARCHAR2,
72 p_usec_teach_resp_status OUT NOCOPY VARCHAR2,
73 P_usec_ass_item_grp_status OUT NOCOPY VARCHAR2 ) ;
74
75
76 END igs_ps_generic_pvt;