APPS.IGS_CO_PROCESS dependencies on IGS_CO_MAPPING

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 151: FROM igs_co_mapping

147: WHERE group_id = cp_group_id AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);
148: */
149: CURSOR cur_c1 (cp_map_id NUMBER)IS
150: SELECT document_id
151: FROM igs_co_mapping
152: WHERE map_id = cp_map_id;
153: l_cur_c1 cur_c1%ROWTYPE;
154: l_list_id igs_co_mapping.map_id%TYPE;
155: /*

Line 154: l_list_id igs_co_mapping.map_id%TYPE;

150: SELECT document_id
151: FROM igs_co_mapping
152: WHERE map_id = cp_map_id;
153: l_cur_c1 cur_c1%ROWTYPE;
154: l_list_id igs_co_mapping.map_id%TYPE;
155: /*
156: CURSOR c_file_name IS
157: SELECT file_name
158: FROM igs_pe_persid_group_all

Line 454: FROM igs_co_mapping

450: (reverse chronological order - newest change first)
451: ***************************************************************/
452: CURSOR cur_c1 (cp_map_id NUMBER)IS
453: SELECT elapsed_days, repeat_times
454: FROM igs_co_mapping
455: WHERE map_id = TO_NUMBER(cp_map_id);
456: l_cur_c1 cur_c1%ROWTYPE;
457: BEGIN
458: OPEN cur_c1(p_map_id);

Line 778: CURSOR cur_c1 (cp_content_id igs_co_mapping.document_id%TYPE,

774: Modified the else condition to not to consider the Adhoc letters while binding the bind variables.
775: ssaleem 09-SEP-2004 3630073. Added p_org_unit_id as a new parameter
776: pacross 11-APR-2005 Implemented code for Correspondance preview and edit fucntionality
777: ***************************************************************/
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

Line 779: cp_map_code igs_co_mapping.map_code%TYPE,

775: ssaleem 09-SEP-2004 3630073. Added p_org_unit_id as a new parameter
776: pacross 11-APR-2005 Implemented code for Correspondance preview and edit fucntionality
777: ***************************************************************/
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

Line 780: cp_sys_ltr_code igs_co_mapping.sys_ltr_code%TYPE) IS

776: pacross 11-APR-2005 Implemented code for Correspondance preview and edit fucntionality
777: ***************************************************************/
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

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;