APPS.CZ_UIOA_PVT dependencies on CZ_SECURITY_PVT

Line 498: p_locked_entities_tbl OUT NOCOPY cz_security_pvt.number_type_tbl) IS

494: DEBUG('------------ End of '||p_prefix||' ----------------');
495: END dump_Error_Stack;
496:
497: PROCEDURE lock_Model(p_model_id IN NUMBER,
498: p_locked_entities_tbl OUT NOCOPY cz_security_pvt.number_type_tbl) IS
499: PRAGMA AUTONOMOUS_TRANSACTION;
500: l_lock_status VARCHAR2(255);
501: l_msg_count NUMBER;
502: l_msg_data VARCHAR2(4000);

Line 505: cz_security_pvt.lock_model(1.0,p_model_id,FND_API.G_TRUE,FND_API.G_FALSE,

501: l_msg_count NUMBER;
502: l_msg_data VARCHAR2(4000);
503: BEGIN
504:
505: cz_security_pvt.lock_model(1.0,p_model_id,FND_API.G_TRUE,FND_API.G_FALSE,
506: p_locked_entities_tbl,
507: l_lock_status,l_msg_count,l_msg_data);
508: COMMIT;
509: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 514: PROCEDURE unlock_Model(p_locked_entities_tbl IN cz_security_pvt.number_type_tbl) IS

510: RAISE FAILED_TO_LOCK_MODEL;
511: END IF;
512: END lock_Model;
513:
514: PROCEDURE unlock_Model(p_locked_entities_tbl IN cz_security_pvt.number_type_tbl) IS
515: PRAGMA AUTONOMOUS_TRANSACTION;
516: l_lock_status VARCHAR2(255);
517: l_msg_count NUMBER;
518: l_msg_data VARCHAR2(4000);

Line 520: cz_security_pvt.unlock_model(p_api_version => 1.0,

516: l_lock_status VARCHAR2(255);
517: l_msg_count NUMBER;
518: l_msg_data VARCHAR2(4000);
519: BEGIN
520: cz_security_pvt.unlock_model(p_api_version => 1.0,
521: p_models_to_unlock => p_locked_entities_tbl,
522: p_commit_flag => FND_API.G_FALSE,
523: p_init_msg_list => FND_API.G_FALSE,
524: x_return_status => l_lock_status,

Line 579: l_templates_to_lock_tbl cz_security_pvt.number_type_tbl;

575: p_template_ui_def_id IN NUMBER DEFAULT NULL,
576: px_needs_to_be_unlocked OUT NOCOPY BOOLEAN) IS
577: PRAGMA AUTONOMOUS_TRANSACTION;
578:
579: l_templates_to_lock_tbl cz_security_pvt.number_type_tbl;
580: l_locked_templates_tbl cz_security_pvt.number_type_tbl;
581: l_seeded_flag CZ_UI_TEMPLATES.seeded_flag%TYPE;
582: l_lock_status VARCHAR2(255);
583: l_msg_count NUMBER;

Line 580: l_locked_templates_tbl cz_security_pvt.number_type_tbl;

576: px_needs_to_be_unlocked OUT NOCOPY BOOLEAN) IS
577: PRAGMA AUTONOMOUS_TRANSACTION;
578:
579: l_templates_to_lock_tbl cz_security_pvt.number_type_tbl;
580: l_locked_templates_tbl cz_security_pvt.number_type_tbl;
581: l_seeded_flag CZ_UI_TEMPLATES.seeded_flag%TYPE;
582: l_lock_status VARCHAR2(255);
583: l_msg_count NUMBER;
584: l_msg_data VARCHAR2(4000);

Line 595: cz_security_pvt.lock_template(p_api_version => 1.0,

591: IF l_seeded_flag=G_YES_FLAG THEN
592: RETURN;
593: END IF;
594: l_templates_to_lock_tbl(1) := p_template_id;
595: cz_security_pvt.lock_template(p_api_version => 1.0,
596: p_templates_to_lock => l_templates_to_lock_tbl,
597: p_commit_flag => FND_API.G_FALSE,
598: p_init_msg_list => FND_API.G_FALSE,
599: x_locked_templates => l_locked_templates_tbl,

Line 620: l_templates_to_unlock_tbl cz_security_pvt.number_type_tbl;

616: PROCEDURE unlock_UI_Template(p_template_id IN NUMBER,
617: p_template_ui_def_id IN NUMBER DEFAULT NULL,
618: p_needs_to_be_unlocked IN BOOLEAN) IS
619: PRAGMA AUTONOMOUS_TRANSACTION;
620: l_templates_to_unlock_tbl cz_security_pvt.number_type_tbl;
621: l_lock_status VARCHAR2(255);
622: l_msg_count NUMBER;
623: l_msg_data VARCHAR2(4000);
624: BEGIN

Line 628: cz_security_pvt.unlock_template(p_api_version => 1.0,

624: BEGIN
625: IF (p_template_ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID OR
626: p_template_ui_def_id IS NULL) AND p_needs_to_be_unlocked THEN
627: l_templates_to_unlock_tbl(1) := p_template_id;
628: cz_security_pvt.unlock_template(p_api_version => 1.0,
629: p_templates_to_unlock => l_templates_to_unlock_tbl,
630: p_commit_flag => FND_API.G_FALSE,
631: p_init_msg_list => FND_API.G_FALSE,
632: x_return_status => l_lock_status,

Line 16502: l_locked_entities_tbl cz_security_pvt.number_type_tbl;

16498: -- main internal procedure to create/refresh UI
16499: --
16500: PROCEDURE construct_Single_UI(p_ui_def_id IN NUMBER,
16501: p_handling_mode IN VARCHAR2 DEFAULT NULL) IS
16502: l_locked_entities_tbl cz_security_pvt.number_type_tbl;
16503: l_templates_id_tbl number_tbl_type;
16504: BEGIN
16505:
16506: --

Line 16704: l_locked_models cz_security_pvt.number_type_tbl;

16700: x_msg_count OUT NOCOPY NUMBER,
16701: x_msg_data OUT NOCOPY VARCHAR2) IS
16702:
16703: l_ui_context CZ_UI_DEFS%ROWTYPE;
16704: l_locked_models cz_security_pvt.number_type_tbl;
16705:
16706: BEGIN
16707:
16708: --