[Home] [Help]
PACKAGE: APPS.JTF_IH_WRAP_UPS_SEED_PUB
Source
1 PACKAGE JTF_IH_WRAP_UPS_SEED_PUB AUTHID CURRENT_USER AS
2 /* $Header: JTFIHWPS.pls 120.2 2005/07/08 08:35:35 nchouras ship $ */
3
4 PROCEDURE insert_row(
5 x_rowid IN OUT NOCOPY VARCHAR2
6 , x_wrap_id NUMBER
7 , x_object_version_number NUMBER
8 , x_created_by NUMBER
9 , x_creation_date DATE
10 , x_last_updated_by NUMBER
11 , x_last_update_date DATE
12 , x_last_update_login NUMBER
13 , x_outcome_required VARCHAR2
14 , x_result_required VARCHAR2
15 , x_reason_required VARCHAR2
16 , x_result_id NUMBER
17 , x_reason_id NUMBER
18 , x_outcome_id NUMBER
19 , x_action_activity_id NUMBER
20 , x_object_id NUMBER
21 , x_object_type VARCHAR2
22 , x_source_code_id NUMBER
23 , x_source_code VARCHAR2
24 , x_start_date DATE DEFAULT NULL
25 , x_end_date DATE DEFAULT NULL
26 , x_wrap_up_level VARCHAR2
27 );
28
29 PROCEDURE delete_row(
30 x_wrap_id NUMBER
31 );
32
33 PROCEDURE update_row(
34 x_wrap_id NUMBER
35 , x_object_version_number NUMBER
36 , x_created_by NUMBER
37 , x_creation_date DATE
38 , x_last_updated_by NUMBER
39 , x_last_update_date DATE
40 , x_last_update_login NUMBER
41 , x_outcome_required VARCHAR2
42 , x_result_required VARCHAR2
43 , x_reason_required VARCHAR2
44 , x_result_id NUMBER
45 , x_reason_id NUMBER
46 , x_outcome_id NUMBER
47 , x_action_activity_id NUMBER
48 , x_object_id NUMBER
49 , x_object_type VARCHAR2
50 , x_source_code_id NUMBER
51 , x_source_code VARCHAR2
52 , x_start_date DATE DEFAULT NULL
53 , x_end_date DATE DEFAULT NULL
54 , x_wrap_up_level VARCHAR2
55 );
56
57 PROCEDURE lock_row(
58 x_rowid VARCHAR2
59 , x_wrap_id NUMBER
60 , x_object_version_number NUMBER
61 , x_created_by NUMBER
62 , x_creation_date DATE
63 , x_last_updated_by NUMBER
64 , x_last_update_date DATE
65 , x_last_update_login NUMBER
66 , x_outcome_required VARCHAR2
67 , x_result_required VARCHAR2
68 , x_reason_required VARCHAR2
69 , x_result_id NUMBER
70 , x_reason_id NUMBER
71 , x_outcome_id NUMBER
72 , x_action_activity_id NUMBER
73 , x_object_id NUMBER
74 , x_object_type VARCHAR2
75 , x_source_code_id NUMBER
76 , x_source_code VARCHAR2
77 );
78
79 PROCEDURE load_row(
80 x_wrap_id NUMBER
81 , x_object_version_number NUMBER
82 , x_outcome_required VARCHAR2
83 , x_result_required VARCHAR2
84 , x_reason_required VARCHAR2
85 , x_result_id NUMBER
86 , x_reason_id NUMBER
87 , x_outcome_id NUMBER
88 , x_action_activity_id NUMBER
89 , x_object_id NUMBER
90 , x_object_type VARCHAR2
91 , x_source_code_id NUMBER
92 , x_source_code VARCHAR2
93 , x_start_date DATE DEFAULT NULL
94 , x_end_date DATE DEFAULT NULL
95 , x_owner VARCHAR2
96 , x_wrap_up_level VARCHAR2
97 );
98
99 PROCEDURE load_seed_row(
100 x_wrap_id NUMBER
101 , x_object_version_number NUMBER
102 , x_outcome_required VARCHAR2
103 , x_result_required VARCHAR2
104 , x_reason_required VARCHAR2
105 , x_result_id NUMBER
106 , x_reason_id NUMBER
107 , x_outcome_id NUMBER
108 , x_action_activity_id NUMBER
109 , x_object_id NUMBER
110 , x_object_type VARCHAR2
111 , x_source_code_id NUMBER
112 , x_source_code VARCHAR2
113 , x_start_date DATE DEFAULT NULL
114 , x_end_date DATE DEFAULT NULL
115 , x_owner VARCHAR2
116 , x_wrap_up_level VARCHAR2
117 , x_upload_mode VARCHAR2
118 );
119
120 END JTF_IH_WRAP_UPS_SEED_PUB;