DBA Data[Home] [Help]

APPS.CZ_POPULATORS_PKG dependencies on CZ_SECURITY_PVT

Line 179: p_locked_entities OUT NOCOPY cz_security_pvt.number_type_tbl) IS

175: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
176: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
177:
178: PROCEDURE lock_Model(p_model_id IN NUMBER,
179: p_locked_entities OUT NOCOPY cz_security_pvt.number_type_tbl) IS
180: PRAGMA AUTONOMOUS_TRANSACTION;
181: l_lock_status VARCHAR2(255);
182: l_msg_count NUMBER;
183: l_msg_index NUMBER;

Line 186: cz_security_pvt.lock_model(1.0, p_model_id,FND_API.G_FALSE,FND_API.G_FALSE,

182: l_msg_count NUMBER;
183: l_msg_index NUMBER;
184: l_msg_data VARCHAR2(4000);
185: BEGIN
186: cz_security_pvt.lock_model(1.0, p_model_id,FND_API.G_FALSE,FND_API.G_FALSE,
187: p_locked_entities,
188: l_lock_status,l_msg_count,l_msg_data);
189: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS) THEN
190: ROLLBACK;

Line 211: p_locked_entities IN OUT NOCOPY cz_security_pvt.number_type_tbl) IS

207: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
208: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
209:
210: PROCEDURE unlock_Model(p_model_id IN NUMBER,
211: p_locked_entities IN OUT NOCOPY cz_security_pvt.number_type_tbl) IS
212: PRAGMA AUTONOMOUS_TRANSACTION;
213: l_lock_status VARCHAR2(255);
214: l_msg_count NUMBER;
215: l_msg_data VARCHAR2(4000);

Line 217: cz_security_pvt.unlock_model(1.0, FND_API.G_FALSE,

213: l_lock_status VARCHAR2(255);
214: l_msg_count NUMBER;
215: l_msg_data VARCHAR2(4000);
216: BEGIN
217: cz_security_pvt.unlock_model(1.0, FND_API.G_FALSE,
218: p_locked_entities,l_lock_status,
219: l_msg_count,l_msg_data);
220: COMMIT;
221: END unlock_Model;

Line 442: l_locked_entities_tbl cz_security_pvt.number_type_tbl;

438: p_err OUT NOCOPY INTEGER,
439: p_init_fnd_stack IN VARCHAR2 DEFAULT NULL) IS
440:
441: l_model_id NUMBER;
442: l_locked_entities_tbl cz_security_pvt.number_type_tbl;
443: l_has_priveleges VARCHAR2(255);
444: l_msg_data VARCHAR2(32000);
445: l_lock_status VARCHAR2(255);
446: l_return_status VARCHAR2(255);

Line 997: l_locked_entities_tbl cz_security_pvt.number_type_tbl;

993: p_err OUT NOCOPY INTEGER,
994: p_init_fnd_stack IN VARCHAR2 DEFAULT NULL) IS
995:
996: l_model_id NUMBER;
997: l_locked_entities_tbl cz_security_pvt.number_type_tbl;
998: l_has_priveleges VARCHAR2(255);
999: l_msg_data VARCHAR2(32000);
1000: l_lock_status VARCHAR2(255);
1001: l_return_status VARCHAR2(255);

Line 1344: l_locked_entities_tbl cz_security_pvt.number_type_tbl;

1340: p_err OUT NOCOPY INTEGER,
1341: p_init_fnd_stack IN VARCHAR2 DEFAULT NULL) IS
1342:
1343: l_model_id NUMBER;
1344: l_locked_entities_tbl cz_security_pvt.number_type_tbl;
1345: l_has_priveleges VARCHAR2(255);
1346: l_msg_data VARCHAR2(32000);
1347: l_lock_status VARCHAR2(255);
1348: l_return_status VARCHAR2(255);

Line 1490: l_locked_entities_tbl cz_security_pvt.number_type_tbl;

1486: p_handle_broken IN VARCHAR2,
1487: p_err OUT NOCOPY INTEGER,
1488: p_init_fnd_stack IN VARCHAR2 DEFAULT NULL) IS
1489:
1490: l_locked_entities_tbl cz_security_pvt.number_type_tbl;
1491: l_has_priveleges VARCHAR2(255);
1492: l_msg_data VARCHAR2(32000);
1493: l_lock_status VARCHAR2(255);
1494: l_return_status VARCHAR2(255);