2: /* $Header: jtfprefabpos.pls 120.4 2005/10/28 01:24:01 emekala ship $ */
3:
4: PROCEDURE INSERT_POLICY(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8:
9: p_policy_id OUT NOCOPY jtf_prefab_policies_b.policy_id%TYPE,
10: p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
3:
4: PROCEDURE INSERT_POLICY(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8:
9: p_policy_id OUT NOCOPY jtf_prefab_policies_b.policy_id%TYPE,
10: p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
11: p_priority IN jtf_prefab_policies_b.priority%TYPE,
30: );
31:
32: PROCEDURE UPDATE_POLICY(
33: p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36:
37: p_policy_id IN jtf_prefab_policies_b.policy_id%TYPE,
38: p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
31:
32: PROCEDURE UPDATE_POLICY(
33: p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36:
37: p_policy_id IN jtf_prefab_policies_b.policy_id%TYPE,
38: p_policy_name IN jtf_prefab_policies_b.policy_name%TYPE,
39: p_priority IN jtf_prefab_policies_b.priority%TYPE,
58: );
59:
60: procedure DELETE_POLICY(
61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63: p_commit IN VARCHAR2 := FND_API.G_FALSE,
64:
65: p_policy_id IN jtf_prefab_policies_b.policy_id%TYPE,
66:
59:
60: procedure DELETE_POLICY(
61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63: p_commit IN VARCHAR2 := FND_API.G_FALSE,
64:
65: p_policy_id IN jtf_prefab_policies_b.policy_id%TYPE,
66:
67: p_object_version_number IN jtf_prefab_policies_b.object_version_number%TYPE,
72: );
73:
74: PROCEDURE INSERT_UR_POLICY(
75: p_api_version IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77: p_commit IN VARCHAR2 := FND_API.G_FALSE,
78:
79: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
80: p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,
73:
74: PROCEDURE INSERT_UR_POLICY(
75: p_api_version IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77: p_commit IN VARCHAR2 := FND_API.G_FALSE,
78:
79: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
80: p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,
81: p_userresp_type IN jtf_prefab_ur_policies.userresp_type%TYPE,
88: );
89:
90: PROCEDURE DELETE_UR_POLICY (
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE,
94:
95: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
96: p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,
89:
90: PROCEDURE DELETE_UR_POLICY (
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE,
94:
95: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
96: p_userresp_id IN jtf_prefab_ur_policies.userresp_id%TYPE,
97: p_userresp_type IN jtf_prefab_ur_policies.userresp_type%TYPE,
104: );
105:
106: PROCEDURE DELETE_UR_POLICY (
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110:
111: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
112:
105:
106: PROCEDURE DELETE_UR_POLICY (
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110:
111: p_policy_id IN jtf_prefab_ur_policies.policy_id%TYPE,
112:
113: p_object_version_number IN jtf_prefab_ur_policies.object_version_number%TYPE,
118: );
119:
120: PROCEDURE CONFIGURE_SYS_POLICY (
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124:
125: p_start_flag IN jtf_prefab_sys_policies.start_flag%TYPE,
126: p_cpu IN jtf_prefab_sys_policies.cpu%TYPE,
119:
120: PROCEDURE CONFIGURE_SYS_POLICY (
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124:
125: p_start_flag IN jtf_prefab_sys_policies.start_flag%TYPE,
126: p_cpu IN jtf_prefab_sys_policies.cpu%TYPE,
127: p_memory IN jtf_prefab_sys_policies.memory%TYPE,
140: );
141:
142: PROCEDURE INSERT_WSH_POLICY(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146:
147: p_wsh_po_id OUT NOCOPY jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
148: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
141:
142: PROCEDURE INSERT_WSH_POLICY(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146:
147: p_wsh_po_id OUT NOCOPY jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
148: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
149: p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
161: );
162:
163: PROCEDURE UPDATE_WSH_POLICY(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166: p_commit IN VARCHAR2 := FND_API.G_FALSE,
167:
168: p_wsh_po_id IN jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
169: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
162:
163: PROCEDURE UPDATE_WSH_POLICY(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166: p_commit IN VARCHAR2 := FND_API.G_FALSE,
167:
168: p_wsh_po_id IN jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
169: p_hostname IN jtf_prefab_wsh_poes_b.hostname%TYPE,
170: p_description IN jtf_prefab_wsh_poes_tl.description%TYPE,
182: );
183:
184: procedure DELETE_WSH_POLICY(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
187: p_commit IN VARCHAR2 := FND_API.G_FALSE,
188:
189: p_wsh_po_id IN jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
190:
183:
184: procedure DELETE_WSH_POLICY(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
187: p_commit IN VARCHAR2 := FND_API.G_FALSE,
188:
189: p_wsh_po_id IN jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
190:
191: p_object_version_number IN jtf_prefab_wsh_poes_b.object_version_number%TYPE,
196: );
197:
198: PROCEDURE INSERT_WSHP_POLICY(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202:
203: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
204: p_port IN jtf_prefab_wshp_policies.port%TYPE,
197:
198: PROCEDURE INSERT_WSHP_POLICY(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202:
203: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
204: p_port IN jtf_prefab_wshp_policies.port%TYPE,
205:
211: );
212:
213: PROCEDURE DELETE_WSHP_POLICY (
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217:
218: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
219: p_port IN jtf_prefab_wshp_policies.port%TYPE,
212:
213: PROCEDURE DELETE_WSHP_POLICY (
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE,
217:
218: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
219: p_port IN jtf_prefab_wshp_policies.port%TYPE,
220:
226: );
227:
228: PROCEDURE DELETE_WSHP_POLICY (
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232:
233: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
234:
227:
228: PROCEDURE DELETE_WSHP_POLICY (
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232:
233: p_wsh_po_id IN jtf_prefab_wshp_policies.wsh_po_id%TYPE,
234:
235: p_object_version_number IN jtf_prefab_wshp_policies.object_version_number%TYPE,