APPS.CZ_UIOA_PVT dependencies on CZ_SECURITY_PVT

Line 504: p_locked_entities_tbl OUT NOCOPY cz_security_pvt.number_type_tbl) IS

500: DEBUG('------------ End of '||p_prefix||' ----------------');
501: END dump_Error_Stack;
502:
503: PROCEDURE lock_Model(p_model_id IN NUMBER,
504: p_locked_entities_tbl OUT NOCOPY cz_security_pvt.number_type_tbl) IS
505: PRAGMA AUTONOMOUS_TRANSACTION;
506: l_lock_status VARCHAR2(255);
507: l_msg_count NUMBER;
508: l_msg_data VARCHAR2(4000);

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

507: l_msg_count NUMBER;
508: l_msg_data VARCHAR2(4000);
509: BEGIN
510:
511: cz_security_pvt.lock_model(1.0,p_model_id,FND_API.G_TRUE,FND_API.G_FALSE,
512: p_locked_entities_tbl,
513: l_lock_status,l_msg_count,l_msg_data);
514: COMMIT;
515: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

516: RAISE FAILED_TO_LOCK_MODEL;
517: END IF;
518: END lock_Model;
519:
520: PROCEDURE unlock_Model(p_locked_entities_tbl IN cz_security_pvt.number_type_tbl) IS
521: PRAGMA AUTONOMOUS_TRANSACTION;
522: l_lock_status VARCHAR2(255);
523: l_msg_count NUMBER;
524: l_msg_data VARCHAR2(4000);

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

522: l_lock_status VARCHAR2(255);
523: l_msg_count NUMBER;
524: l_msg_data VARCHAR2(4000);
525: BEGIN
526: cz_security_pvt.unlock_model(p_api_version => 1.0,
527: p_models_to_unlock => p_locked_entities_tbl,
528: p_commit_flag => FND_API.G_FALSE,
529: p_init_msg_list => FND_API.G_FALSE,
530: x_return_status => l_lock_status,

Line 585: l_templates_to_lock_tbl cz_security_pvt.number_type_tbl;

581: p_template_ui_def_id IN NUMBER DEFAULT NULL,
582: px_needs_to_be_unlocked OUT NOCOPY BOOLEAN) IS
583: PRAGMA AUTONOMOUS_TRANSACTION;
584:
585: l_templates_to_lock_tbl cz_security_pvt.number_type_tbl;
586: l_locked_templates_tbl cz_security_pvt.number_type_tbl;
587: l_seeded_flag CZ_UI_TEMPLATES.seeded_flag%TYPE;
588: l_lock_status VARCHAR2(255);
589: l_msg_count NUMBER;

Line 586: l_locked_templates_tbl cz_security_pvt.number_type_tbl;

582: px_needs_to_be_unlocked OUT NOCOPY BOOLEAN) IS
583: PRAGMA AUTONOMOUS_TRANSACTION;
584:
585: l_templates_to_lock_tbl cz_security_pvt.number_type_tbl;
586: l_locked_templates_tbl cz_security_pvt.number_type_tbl;
587: l_seeded_flag CZ_UI_TEMPLATES.seeded_flag%TYPE;
588: l_lock_status VARCHAR2(255);
589: l_msg_count NUMBER;
590: l_msg_data VARCHAR2(4000);

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

597: IF l_seeded_flag=G_YES_FLAG THEN
598: RETURN;
599: END IF;
600: l_templates_to_lock_tbl(1) := p_template_id;
601: cz_security_pvt.lock_template(p_api_version => 1.0,
602: p_templates_to_lock => l_templates_to_lock_tbl,
603: p_commit_flag => FND_API.G_FALSE,
604: p_init_msg_list => FND_API.G_FALSE,
605: x_locked_templates => l_locked_templates_tbl,

Line 626: l_templates_to_unlock_tbl cz_security_pvt.number_type_tbl;

622: PROCEDURE unlock_UI_Template(p_template_id IN NUMBER,
623: p_template_ui_def_id IN NUMBER DEFAULT NULL,
624: p_needs_to_be_unlocked IN BOOLEAN) IS
625: PRAGMA AUTONOMOUS_TRANSACTION;
626: l_templates_to_unlock_tbl cz_security_pvt.number_type_tbl;
627: l_lock_status VARCHAR2(255);
628: l_msg_count NUMBER;
629: l_msg_data VARCHAR2(4000);
630: BEGIN

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

630: BEGIN
631: IF (p_template_ui_def_id=G_GLOBAL_TEMPLATES_UI_DEF_ID OR
632: p_template_ui_def_id IS NULL) AND p_needs_to_be_unlocked THEN
633: l_templates_to_unlock_tbl(1) := p_template_id;
634: cz_security_pvt.unlock_template(p_api_version => 1.0,
635: p_templates_to_unlock => l_templates_to_unlock_tbl,
636: p_commit_flag => FND_API.G_FALSE,
637: p_init_msg_list => FND_API.G_FALSE,
638: x_return_status => l_lock_status,

Line 17214: l_locked_entities_tbl cz_security_pvt.number_type_tbl;

17210: -- main internal procedure to create/refresh UI
17211: --
17212: PROCEDURE construct_Single_UI(p_ui_def_id IN NUMBER,
17213: p_handling_mode IN VARCHAR2 DEFAULT NULL) IS
17214: l_locked_entities_tbl cz_security_pvt.number_type_tbl;
17215: l_templates_id_tbl number_tbl_type;
17216: BEGIN
17217:
17218: --

Line 17416: l_locked_models cz_security_pvt.number_type_tbl;

17412: x_msg_count OUT NOCOPY NUMBER,
17413: x_msg_data OUT NOCOPY VARCHAR2) IS
17414:
17415: l_ui_context CZ_UI_DEFS%ROWTYPE;
17416: l_locked_models cz_security_pvt.number_type_tbl;
17417:
17418: BEGIN
17419:
17420: --