DBA Data[Home] [Help]

APPS.CZ_POPULATORS_PKG dependencies on CZ_SECURITY_PVT

Line 182: p_locked_entities OUT NOCOPY cz_security_pvt.number_type_tbl) IS

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

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

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

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

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

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

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

Line 445: l_locked_entities_tbl cz_security_pvt.number_type_tbl;

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

Line 1008: l_locked_entities_tbl cz_security_pvt.number_type_tbl;

1004: p_err OUT NOCOPY INTEGER,
1005: p_init_fnd_stack IN VARCHAR2 DEFAULT NULL) IS
1006:
1007: l_model_id NUMBER;
1008: l_locked_entities_tbl cz_security_pvt.number_type_tbl;
1009: l_has_priveleges VARCHAR2(255);
1010: l_msg_data VARCHAR2(32000);
1011: l_lock_status VARCHAR2(255);
1012: l_return_status VARCHAR2(255);

Line 1370: l_locked_entities_tbl cz_security_pvt.number_type_tbl;

1366: p_err OUT NOCOPY INTEGER,
1367: p_init_fnd_stack IN VARCHAR2 DEFAULT NULL) IS
1368:
1369: l_model_id NUMBER;
1370: l_locked_entities_tbl cz_security_pvt.number_type_tbl;
1371: l_has_priveleges VARCHAR2(255);
1372: l_msg_data VARCHAR2(32000);
1373: l_lock_status VARCHAR2(255);
1374: l_return_status VARCHAR2(255);

Line 1516: l_locked_entities_tbl cz_security_pvt.number_type_tbl;

1512: p_handle_broken IN VARCHAR2,
1513: p_err OUT NOCOPY INTEGER,
1514: p_init_fnd_stack IN VARCHAR2 DEFAULT NULL) IS
1515:
1516: l_locked_entities_tbl cz_security_pvt.number_type_tbl;
1517: l_has_priveleges VARCHAR2(255);
1518: l_msg_data VARCHAR2(32000);
1519: l_lock_status VARCHAR2(255);
1520: l_return_status VARCHAR2(255);