DBA Data[Home] [Help]

APPS.CZ_PB_MGR dependencies on CZ_DEVL_PROJECTS

Line 45: v_deep_project_name cz_devl_projects.NAME%TYPE;

41: v_target_ui_def_id cz_ui_defs.ui_def_id%TYPE;
42: v_ui_name cz_ui_defs.NAME%TYPE;
43: v_pb_run_id cz_xfr_run_infos.run_id%TYPE;
44: loguser cz_db_logs.loguser%TYPE;
45: v_deep_project_name cz_devl_projects.NAME%TYPE;
46: v_err_message cz_db_logs.MESSAGE%TYPE;
47: v_rp_folder_id cz_rp_entries.enclosing_folder%TYPE;
48: v_rp_name cz_rp_entries.NAME%TYPE;
49: v_rp_desc cz_rp_entries.description%TYPE;

Line 53: v_new_devl_id cz_devl_projects.devl_project_id%TYPE;

49: v_rp_desc cz_rp_entries.description%TYPE;
50: v_sql_err_msg cz_db_logs.MESSAGE%TYPE;
51: v_db_link cz_servers.fndnam_link_name%TYPE;
52: v_prev_remote_publication_id cz_model_publications.publication_id%TYPE;
53: v_new_devl_id cz_devl_projects.devl_project_id%TYPE;
54: new_ui_def_id cz_ui_defs.ui_def_id%TYPE;
55: sequence_no NUMBER := 0;
56: v_oraclesequenceincr PLS_INTEGER := 0.0;
57: msg_count PLS_INTEGER := 0.0;

Line 220: devl_project_id cz_devl_projects.DEVL_PROJECT_ID%TYPE,

216: new_property_num_value cz_psnode_propval_v.PROPERTY_NUM_VALUE%TYPE,
217: property_value cz_psnode_propval_v.PROPERTY_VALUE%TYPE,
218: item_type_id cz_psnode_propval_v.ITEM_TYPE_ID%TYPE,
219: valuesource cz_psnode_propval_v.VALUESOURCE%TYPE,
220: devl_project_id cz_devl_projects.DEVL_PROJECT_ID%TYPE,
221: def_num_value cz_psnode_propval_v.def_num_value%TYPE
222: );
223:
224: TYPE t_psnode_propval_table IS TABLE OF t_psnode_propval_rec

Line 519: l_devl_proj_product_key cz_devl_projects.product_key%TYPE;

515: l_bom_caption_rule NUMBER := 0;
516: l_nonbom_capt_rule_id NUMBER := 0;
517: l_devl_proj_inv_id NUMBER := 0;
518: l_devl_proj_org_id NUMBER := 0;
519: l_devl_proj_product_key cz_devl_projects.product_key%TYPE;
520: l_bom_caption_text_id cz_devl_projects.bom_caption_text_id%TYPE;
521: l_nonbom_caption_text_id cz_devl_projects.nonbom_caption_text_id%TYPE;
522: -----new tech stack arrays
523: v_templates_tobe_exported t_ref;

Line 520: l_bom_caption_text_id cz_devl_projects.bom_caption_text_id%TYPE;

516: l_nonbom_capt_rule_id NUMBER := 0;
517: l_devl_proj_inv_id NUMBER := 0;
518: l_devl_proj_org_id NUMBER := 0;
519: l_devl_proj_product_key cz_devl_projects.product_key%TYPE;
520: l_bom_caption_text_id cz_devl_projects.bom_caption_text_id%TYPE;
521: l_nonbom_caption_text_id cz_devl_projects.nonbom_caption_text_id%TYPE;
522: -----new tech stack arrays
523: v_templates_tobe_exported t_ref;
524: v_templates_not_exported t_ref;

Line 521: l_nonbom_caption_text_id cz_devl_projects.nonbom_caption_text_id%TYPE;

517: l_devl_proj_inv_id NUMBER := 0;
518: l_devl_proj_org_id NUMBER := 0;
519: l_devl_proj_product_key cz_devl_projects.product_key%TYPE;
520: l_bom_caption_text_id cz_devl_projects.bom_caption_text_id%TYPE;
521: l_nonbom_caption_text_id cz_devl_projects.nonbom_caption_text_id%TYPE;
522: -----new tech stack arrays
523: v_templates_tobe_exported t_ref;
524: v_templates_not_exported t_ref;
525: v_global_templs_ref t_ref;

Line 568: v_devl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;

564: CZ_FCE_FILES_SEQ CONSTANT PLS_INTEGER := 27;
565:
566: v_msg_tbl msg_text_list;
567: ----variables used for orig_sys_ref returned by bomsynch
568: v_devl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
569: v_it_masters_sys_ref VARCHAR2(255);
570: v_it_types_sys_ref VARCHAR2(255);
571: v_bomsynch_product_key cz_model_publications.product_key%TYPE;
572: v_bomsynch_org_id cz_model_publications.organization_id%TYPE;