eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_CO_GEN_001 dependencies on IGS_CO_OU_CO_REF

Line 70: --IGS_CO_OU_CO_REF record based on passed parameters

66: p_other_reference IN VARCHAR2 )
67: RETURN NUMBER AS
68: BEGIN --corp_get_ocr_refnum
69: --This module retrieves the reference number for an
70: --IGS_CO_OU_CO_REF record based on passed parameters
71: DECLARE
72: v_ocr_cnt NUMBER(1) DEFAULT 0;
73: v_reference_number IGS_CO_OU_CO_REF.reference_number%TYPE;
74: CURSOR c_ocr IS

Line 73: v_reference_number IGS_CO_OU_CO_REF.reference_number%TYPE;

69: --This module retrieves the reference number for an
70: --IGS_CO_OU_CO_REF record based on passed parameters
71: DECLARE
72: v_ocr_cnt NUMBER(1) DEFAULT 0;
73: v_reference_number IGS_CO_OU_CO_REF.reference_number%TYPE;
74: CURSOR c_ocr IS
75: SELECT ocr.reference_number
76: FROM IGS_CO_OU_CO_REF ocr
77: WHERE ocr.S_OTHER_REFERENCE_TYPE = p_s_other_reference_type

Line 76: FROM IGS_CO_OU_CO_REF ocr

72: v_ocr_cnt NUMBER(1) DEFAULT 0;
73: v_reference_number IGS_CO_OU_CO_REF.reference_number%TYPE;
74: CURSOR c_ocr IS
75: SELECT ocr.reference_number
76: FROM IGS_CO_OU_CO_REF ocr
77: WHERE ocr.S_OTHER_REFERENCE_TYPE = p_s_other_reference_type
78: AND ocr.other_reference = p_other_reference;
79: BEGIN
80: --validate parameters