DBA Data[Home] [Help]

APPS.CZ_PB_MGR dependencies on CZ_SIGNATURE_ARGUMENTS

Line 5427: FROM cz_signature_arguments

5423: FOR j IN cz_pb_mgr.v_sig_old_ref.FIRST .. cz_pb_mgr.v_sig_old_ref.LAST
5424: LOOP
5425: SELECT argument_signature_id, datatype_signature_id, argument_index
5426: BULK COLLECT INTO l_arg_sig_tbl, l_data_sig_tbl, l_arg_ind_tbl
5427: FROM cz_signature_arguments
5428: WHERE cz_signature_arguments.argument_signature_id = cz_pb_mgr.v_sig_old_ref(j)
5429: AND cz_signature_arguments.deleted_flag = record_not_deleted
5430: AND cz_signature_arguments.seeded_flag <> seed_data;
5431:

Line 5428: WHERE cz_signature_arguments.argument_signature_id = cz_pb_mgr.v_sig_old_ref(j)

5424: LOOP
5425: SELECT argument_signature_id, datatype_signature_id, argument_index
5426: BULK COLLECT INTO l_arg_sig_tbl, l_data_sig_tbl, l_arg_ind_tbl
5427: FROM cz_signature_arguments
5428: WHERE cz_signature_arguments.argument_signature_id = cz_pb_mgr.v_sig_old_ref(j)
5429: AND cz_signature_arguments.deleted_flag = record_not_deleted
5430: AND cz_signature_arguments.seeded_flag <> seed_data;
5431:
5432: IF (l_arg_sig_tbl.COUNT > 0)

Line 5429: AND cz_signature_arguments.deleted_flag = record_not_deleted

5425: SELECT argument_signature_id, datatype_signature_id, argument_index
5426: BULK COLLECT INTO l_arg_sig_tbl, l_data_sig_tbl, l_arg_ind_tbl
5427: FROM cz_signature_arguments
5428: WHERE cz_signature_arguments.argument_signature_id = cz_pb_mgr.v_sig_old_ref(j)
5429: AND cz_signature_arguments.deleted_flag = record_not_deleted
5430: AND cz_signature_arguments.seeded_flag <> seed_data;
5431:
5432: IF (l_arg_sig_tbl.COUNT > 0)
5433: THEN

Line 5430: AND cz_signature_arguments.seeded_flag <> seed_data;

5426: BULK COLLECT INTO l_arg_sig_tbl, l_data_sig_tbl, l_arg_ind_tbl
5427: FROM cz_signature_arguments
5428: WHERE cz_signature_arguments.argument_signature_id = cz_pb_mgr.v_sig_old_ref(j)
5429: AND cz_signature_arguments.deleted_flag = record_not_deleted
5430: AND cz_signature_arguments.seeded_flag <> seed_data;
5431:
5432: IF (l_arg_sig_tbl.COUNT > 0)
5433: THEN
5434: FOR k IN l_arg_sig_tbl.FIRST .. l_arg_sig_tbl.LAST

Line 5446: resolve_ids(cz_pb_mgr.v_arg_sig_old_tbl,cz_pb_mgr.v_arg_sig_tbl, cz_pb_mgr.v_sig_idx_ref, 'arg sig ids cz signature arguments');

5442: END IF;
5443: END LOOP;
5444:
5445: ----resolve ids
5446: resolve_ids(cz_pb_mgr.v_arg_sig_old_tbl,cz_pb_mgr.v_arg_sig_tbl, cz_pb_mgr.v_sig_idx_ref, 'arg sig ids cz signature arguments');
5447: resolve_ids(cz_pb_mgr.v_data_sig_tbl, cz_pb_mgr.v_sig_idx_ref, 'data sig ids cz signature arguments', ENTITY_TYPE_SIGNATURE);
5448: plsql_table_list.DELETE;
5449: rec_count := 1;
5450: plsql_table_list(rec_count).col_name := 'argument_signature_id';

Line 5447: resolve_ids(cz_pb_mgr.v_data_sig_tbl, cz_pb_mgr.v_sig_idx_ref, 'data sig ids cz signature arguments', ENTITY_TYPE_SIGNATURE);

5443: END LOOP;
5444:
5445: ----resolve ids
5446: resolve_ids(cz_pb_mgr.v_arg_sig_old_tbl,cz_pb_mgr.v_arg_sig_tbl, cz_pb_mgr.v_sig_idx_ref, 'arg sig ids cz signature arguments');
5447: resolve_ids(cz_pb_mgr.v_data_sig_tbl, cz_pb_mgr.v_sig_idx_ref, 'data sig ids cz signature arguments', ENTITY_TYPE_SIGNATURE);
5448: plsql_table_list.DELETE;
5449: rec_count := 1;
5450: plsql_table_list(rec_count).col_name := 'argument_signature_id';
5451: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_arg_sig_tbl';

Line 5458: insert_into_table('cz_signature_arguments'

5454: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_data_sig_tbl';
5455: rec_count := rec_count + 1;
5456: plsql_table_list(rec_count).col_name := 'argument_index';
5457: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_arg_ind_old_tbl';
5458: insert_into_table('cz_signature_arguments'
5459: ,'argument_signature_id'
5460: ,'argument_index'
5461: ,cz_pb_mgr.v_db_link
5462: ,plsql_table_list

Line 6515: delete_from_table('cz_signature_arguments','argument_signature_id','argument_index',v_database_link,'cz_pb_mgr.v_arg_sig_tbl','cz_pb_mgr.v_arg_ind_old_tbl',cz_pb_mgr.v_arg_sig_tbl);

6511: 'cz_pb_mgr.g_REF_TEMPLATE_ID_ref','cz_pb_mgr.g_REF_TEMPL_UI_ref',cz_pb_mgr.g_TEMPLATE_ID_ref);
6512: delete_from_table('cz_ui_actions','ui_def_id','ui_action_id',v_database_link,'cz_pb_mgr.g_ui_actns_ui_uidef_ref','cz_pb_mgr.g_ui_actns_ui_act_id_ref',cz_pb_mgr.g_ui_actns_ui_uidef_ref);
6513: delete_from_table('cz_ui_images','ui_def_id','image_usage_code','entity_code',v_database_link,'cz_pb_mgr.l_ui_images_ui_ref','cz_pb_mgr.l_ui_images_usg_tbl','cz_pb_mgr.l_ui_images_enty_tbl',cz_pb_mgr.l_ui_images_ui_ref);
6514: delete_from_table('cz_signatures','signature_id',v_database_link,'cz_pb_mgr.v_sig_new_ref',cz_pb_mgr.v_sig_new_ref);
6515: delete_from_table('cz_signature_arguments','argument_signature_id','argument_index',v_database_link,'cz_pb_mgr.v_arg_sig_tbl','cz_pb_mgr.v_arg_ind_old_tbl',cz_pb_mgr.v_arg_sig_tbl);
6516: delete_from_table('cz_func_comp_specs','func_comp_id',v_database_link,'cz_pb_mgr.v_cz_func_comp_new_ref',cz_pb_mgr.v_cz_func_comp_new_ref);
6517: delete_from_table('cz_populators','populator_id',v_database_link,'cz_pb_mgr.v_populators_new_id_ref',cz_pb_mgr.v_populators_new_id_ref);
6518: delete_from_table('cz_filter_sets','filter_set_id',v_database_link,'cz_pb_mgr.v_filter_sets_new_id_ref',cz_pb_mgr.v_filter_sets_new_id_ref);
6519: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.g_archives_new_ref',cz_pb_mgr.g_archives_new_ref);