APPS.IGIDOSL dependencies on IGI_DOS_DOC_TYPES

Line 666: l_dossier_id igi_dos_doc_types.dossier_id%TYPE

662: := Wf_Engine.GetItemAttrNumber (itemtype => itemtype,
663: itemkey => itemkey,
664: aname => 'POS_STRUCTURE_ELEMENT_ID');
665:
666: l_dossier_id igi_dos_doc_types.dossier_id%TYPE
667: :=Wf_Engine.GetItemAttrNumber (itemtype => ItemType,
668: itemkey => ItemKey,
669: aname => 'DOSSIER_ID');
670:

Line 736: CURSOR c_pos_hier (p_dossier_id igi_dos_doc_types.dossier_id%TYPE)

732: /*********************************************/
733: /* FETCH position hierarchy for dossier type */
734: /*********************************************/
735:
736: CURSOR c_pos_hier (p_dossier_id igi_dos_doc_types.dossier_id%TYPE)
737: IS
738: SELECT hierarchy_id
739: FROM igi_dos_doc_types
740: WHERE dossier_id = p_dossier_id;

Line 739: FROM igi_dos_doc_types

735:
736: CURSOR c_pos_hier (p_dossier_id igi_dos_doc_types.dossier_id%TYPE)
737: IS
738: SELECT hierarchy_id
739: FROM igi_dos_doc_types
740: WHERE dossier_id = p_dossier_id;
741:
742: /***********************************************/
743: /* FETCH current version of position hierarchy */

Line 746: CURSOR c_pos_hier_ver(p_hierarchy_id igi_dos_doc_types.hierarchy_id%TYPE,

742: /***********************************************/
743: /* FETCH current version of position hierarchy */
744: /***********************************************/
745:
746: CURSOR c_pos_hier_ver(p_hierarchy_id igi_dos_doc_types.hierarchy_id%TYPE,
747: p_business_group_id hr_all_positions_f.business_group_id%TYPE)
748: IS
749: SELECT pos_structure_version_id
750: FROM per_pos_structure_versions

Line 1358: FROM igi_dos_doc_types dtype,

1354: /* =============== END DEBUG LOG ================== */
1355:
1356: SELECT dtype.sob_id
1357: INTO l_sob_id
1358: FROM igi_dos_doc_types dtype,
1359: igi_dos_trx_headers thead
1360: WHERE thead.dossier_id = dtype.dossier_id
1361: AND thead.trx_number = l_dossier_num;
1362:

Line 2127: FROM IGI_DOS_DOC_TYPES dtype,

2123: END IF;
2124:
2125: SELECT dtype.SOB_ID
2126: INTO l_sob_id
2127: FROM IGI_DOS_DOC_TYPES dtype,
2128: igi_dos_trx_headers thead
2129: WHERE thead.dossier_id = dtype.dossier_id
2130: and thead.trx_number = l_trx_number;
2131:

Line 2545: FROM IGI_DOS_DOC_TYPES dtype,

2541: /* =============== END DEBUG LOG ================== */
2542: --bug 9075812
2543: SELECT dtype.SOB_ID
2544: INTO g_sob_id
2545: FROM IGI_DOS_DOC_TYPES dtype,
2546: igi_dos_trx_headers thead
2547: WHERE thead.dossier_id = dtype.dossier_id
2548: and thead.trx_number = l_dossier_num;
2549: /* =============== START DEBUG LOG ================ */

Line 3065: l_dossier_id igi_dos_doc_types.dossier_id%TYPE :=

3061: Wf_Engine.GetItemAttrText (itemtype => ItemType,
3062: itemkey => ItemKey,
3063: aname => 'ORGANIZATION_ID');
3064:
3065: l_dossier_id igi_dos_doc_types.dossier_id%TYPE :=
3066: Wf_Engine.GetItemAttrNumber (itemtype => ItemType,
3067: itemkey => ItemKey,
3068: aname => 'DOSSIER_ID');
3069:

Line 3080: CURSOR c_pos_hier (p_dossier_id igi_dos_doc_types.dossier_id%TYPE) IS

3076: l_pos_structure_element_id
3077: per_pos_structure_elements.pos_structure_element_id%TYPE;
3078:
3079: -- Cursor to FETCH position hierarchy
3080: CURSOR c_pos_hier (p_dossier_id igi_dos_doc_types.dossier_id%TYPE) IS
3081: SELECT hierarchy_id
3082: FROM igi_dos_doc_types
3083: WHERE dossier_id = p_dossier_id;
3084:

Line 3082: FROM igi_dos_doc_types

3078:
3079: -- Cursor to FETCH position hierarchy
3080: CURSOR c_pos_hier (p_dossier_id igi_dos_doc_types.dossier_id%TYPE) IS
3081: SELECT hierarchy_id
3082: FROM igi_dos_doc_types
3083: WHERE dossier_id = p_dossier_id;
3084:
3085: -- Cursor to FETCH current version of position hierarchy
3086: CURSOR c_pos_hier_ver

Line 3087: (p_hierarchy_id igi_dos_doc_types.hierarchy_id%TYPE,

3083: WHERE dossier_id = p_dossier_id;
3084:
3085: -- Cursor to FETCH current version of position hierarchy
3086: CURSOR c_pos_hier_ver
3087: (p_hierarchy_id igi_dos_doc_types.hierarchy_id%TYPE,
3088: p_business_group_id hr_all_positions_f.business_group_id%TYPE) IS
3089: SELECT pos_structure_version_id
3090: FROM per_pos_structure_versions
3091: WHERE position_structure_id = p_hierarchy_id