DBA Data[Home] [Help]

APPS.IGS_CO_PROCESS dependencies on IGS_CO_MAPPING_V

Line 66: FROM igs_co_mapping_v

62: (reverse chronological order - newest change first)
63: ***************************************************************/
64: CURSOR cur_c1 (cp_map_id NUMBER)IS
65: SELECT document_id, sys_ltr_code, doc_code , version_id
66: FROM igs_co_mapping_v
67: WHERE map_id = cp_map_id;
68: l_cur_c1 cur_c1%ROWTYPE;
69: BEGIN
70: OPEN cur_c1(p_map_id);

Line 782: FROM igs_co_mapping_v

778: CURSOR cur_c1 (cp_content_id igs_co_mapping.document_id%TYPE,
779: cp_map_code igs_co_mapping.map_code%TYPE,
780: cp_sys_ltr_code igs_co_mapping.sys_ltr_code%TYPE) IS
781: SELECT map_description, version_id, citem_ver_id
782: FROM igs_co_mapping_v
783: WHERE document_id = cp_content_id
784: AND map_code = cp_map_code
785: AND sys_ltr_code = cp_sys_ltr_code
786: AND enable_flag ='Y';

Line 790: l_doc_desc igs_co_mapping_v.name%TYPE;

786: AND enable_flag ='Y';
787:
788: l_cur_c1 cur_c1%ROWTYPE;
789:
790: l_doc_desc igs_co_mapping_v.name%TYPE;
791: l_msg_count NUMBER;
792: l_msg_data VARCHAR2(2000);
793: l_content_xml VARCHAR2(5000);
794: l_varchar_tbl_bind_var jtf_fm_request_grp.g_varchar_tbl_type;