DBA Data[Home] [Help]

APPS.CZ_PB_MGR dependencies on CZ_SECURITY_PVT

Line 4807: l_locked_templates cz_security_pvt.number_type_tbl;

4803: rec_count NUMBER := 0;
4804: plsql_table_list cz_pb_mgr.col_plsql_table_list;
4805: failed_to_lock_template EXCEPTION;
4806: failed_to_unlock_template EXCEPTION;
4807: l_locked_templates cz_security_pvt.number_type_tbl;
4808: l_templates_to_lock cz_security_pvt.number_type_tbl;
4809: l_return_status VARCHAR2(1);
4810: l_msg_count NUMBER;
4811: l_msg_data VARCHAR2(2000);

Line 4808: l_templates_to_lock cz_security_pvt.number_type_tbl;

4804: plsql_table_list cz_pb_mgr.col_plsql_table_list;
4805: failed_to_lock_template EXCEPTION;
4806: failed_to_unlock_template EXCEPTION;
4807: l_locked_templates cz_security_pvt.number_type_tbl;
4808: l_templates_to_lock cz_security_pvt.number_type_tbl;
4809: l_return_status VARCHAR2(1);
4810: l_msg_count NUMBER;
4811: l_msg_data VARCHAR2(2000);
4812: l_msg_index NUMBER;

Line 4822: cz_security_pvt.lock_template(1.0

4818: LOOP
4819: l_templates_to_lock(l_templates_to_lock.COUNT + 1) := cz_pb_mgr.g_ui_templates_old_temp_id_ref(i);
4820: END LOOP;
4821:
4822: cz_security_pvt.lock_template(1.0
4823: ,l_templates_to_lock
4824: ,fnd_api.g_true
4825: ,fnd_api.g_true
4826: ,l_locked_templates

Line 4935: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);

4931: ----------end insert into cz_rp_entries----------------
4932: END IF;
4933: -- END IF;
4934:
4935: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);
4936:
4937: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
4938: THEN
4939: RAISE failed_to_unlock_template;

Line 4955: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);

4951: l_msg_index := l_msg_index + 1;
4952: l_msg_count := l_msg_count - 1;
4953: END LOOP;
4954:
4955: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);
4956: raise_application_error('-20020', 'FAILED_TO_LOCK_TEMPLATE');
4957: WHEN failed_to_unlock_template
4958: THEN
4959: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;

Line 4973: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);

4969:
4970: raise_application_error('-20030', 'FAILED_TO_UNLOCK_TEMPLATE');
4971: WHEN OTHERS
4972: THEN
4973: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);
4974: RAISE;
4975: END insert_ui_templates;
4976:
4977: --------------------------------------------------------------

Line 17489: l_locked_models cz_security_pvt.number_type_tbl;

17485: l_msg_data VARCHAR2(2000);
17486: l_msg_count NUMBER := 0;
17487: l_return_status VARCHAR2(1);
17488: l_lock_status VARCHAR2(1);
17489: l_locked_models cz_security_pvt.number_type_tbl;
17490: l_checkout_user cz_security_pvt.varchar_type_tbl;
17491: l_model_upto_date_status NUMBER;
17492: l_ui_upto_date_status NUMBER;
17493: l_model_upto_date_msg VARCHAR2(2000);

Line 17490: l_checkout_user cz_security_pvt.varchar_type_tbl;

17486: l_msg_count NUMBER := 0;
17487: l_return_status VARCHAR2(1);
17488: l_lock_status VARCHAR2(1);
17489: l_locked_models cz_security_pvt.number_type_tbl;
17490: l_checkout_user cz_security_pvt.varchar_type_tbl;
17491: l_model_upto_date_status NUMBER;
17492: l_ui_upto_date_status NUMBER;
17493: l_model_upto_date_msg VARCHAR2(2000);
17494: logic_gen_required CONSTANT NUMBER := 1;

Line 17530: cz_security_pvt.lock_model(1.0, p_model_id, fnd_api.g_true, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

17526: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SEQ_XFR');
17527: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.XFRINFO', SQLCODE);
17528: END;
17529:
17530: cz_security_pvt.lock_model(1.0, p_model_id, fnd_api.g_true, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
17531:
17532: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS)
17533: THEN
17534: l_msg_index := 1;

Line 18124: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

18120: DELETE FROM cz_pb_model_exports
18121: WHERE publication_id = v_pub_id;
18122: END IF;
18123:
18124: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
18125:
18126: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS)
18127: THEN
18128: l_msg_index := 1;

Line 18144: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

18140: WHEN failed_to_lock_model
18141: THEN
18142: x_run_id := cz_pb_mgr.v_pb_run_id;
18143: x_status := PUBLICATION_ERROR;
18144: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
18145: log_pb_trace;
18146: WHEN ui_not_uptodate THEN
18147: x_run_id := cz_pb_mgr.v_pb_run_id;
18148: x_status := PUBLICATION_ERROR;

Line 18149: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

18145: log_pb_trace;
18146: WHEN ui_not_uptodate THEN
18147: x_run_id := cz_pb_mgr.v_pb_run_id;
18148: x_status := PUBLICATION_ERROR;
18149: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
18150: log_pb_trace;
18151: WHEN OTHERS
18152: THEN
18153: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

Line 18153: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

18149: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
18150: log_pb_trace;
18151: WHEN OTHERS
18152: THEN
18153: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
18154: cz_pb_mgr.v_err_message := 'Fatal error during deep model copy of model: ' || cz_pb_mgr.v_root_model_id;
18155: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
18156: END;
18157:

Line 18865: l_locked_models cz_security_pvt.number_type_tbl;

18861: v_rp_entries_desc cz_rp_entries.description%TYPE;
18862: v_object_id cz_rp_entries.object_id%TYPE;
18863: v_rp_orig_sys_ref VARCHAR2(255);
18864: v_imp_ps_node_count PLS_INTEGER;
18865: l_locked_models cz_security_pvt.number_type_tbl;
18866: l_upto_date_status VARCHAR2(2000);
18867: l_msg_index NUMBER;
18868: v_max_rec_id NUMBER;
18869: l_message VARCHAR2(32000);

Line 19044: cz_security_pvt.lock_model(1.0

19040: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
19041: log_timing_message('end has_tobe_published');
19042: END IF;
19043:
19044: cz_security_pvt.lock_model(1.0
19045: ,cz_pb_mgr.v_root_model_id
19046: ,fnd_api.g_true
19047: ,fnd_api.g_true
19048: ,l_locked_models

Line 19565: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

19561: END IF; /* end if of (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR) */
19562:
19563: l_msg_count := 0;
19564: l_msg_index := 0;
19565: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19566:
19567: IF (l_lock_status <> 'S') THEN
19568: l_msg_index := 1;
19569:

Line 19586: /* cz_security_pvt.unlock_entity (cz_pb_mgr.v_root_model_id,

19582: END IF;
19583:
19584: x_run_id := cz_pb_mgr.v_pb_run_id;
19585: x_pb_status := cz_pb_mgr.v_status_code;
19586: /* cz_security_pvt.unlock_entity (cz_pb_mgr.v_root_model_id,
19587: cz_security_pvt.PUBLISH_MODEL_FUNCTION,
19588: l_locked_models,
19589: l_lock_status,
19590: l_msg_count,

Line 19587: cz_security_pvt.PUBLISH_MODEL_FUNCTION,

19583:
19584: x_run_id := cz_pb_mgr.v_pb_run_id;
19585: x_pb_status := cz_pb_mgr.v_status_code;
19586: /* cz_security_pvt.unlock_entity (cz_pb_mgr.v_root_model_id,
19587: cz_security_pvt.PUBLISH_MODEL_FUNCTION,
19588: l_locked_models,
19589: l_lock_status,
19590: l_msg_count,
19591: l_msg_data); */

Line 19631: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

19627: x_run_id := cz_pb_mgr.v_pb_run_id;
19628: cz_pb_mgr.global_export_retcode := 2;
19629: update_publication_status(publicationid, PUBLICATION_ERROR, empty_string);
19630: update_pup_status(publicationid);
19631: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19632: log_pb_trace;
19633: delete_session_parameters;
19634: WHEN not_global_template THEN
19635: x_pb_status := PUBLICATION_ERROR;