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.

APPS.IGW_EXP_CATEGORIES_PKG dependencies on IGW_SECURITY

Line 50: decode(igw_security.gms_enabled, 'N', X_DESCRIPTION, null),

46: LAST_UPDATED_BY,
47: LAST_UPDATE_LOGIN
48: ) values (
49: X_EXPENDITURE_CATEGORY,
50: decode(igw_security.gms_enabled, 'N', X_DESCRIPTION, null),
51: X_BUDGET_CATEGORY_CODE,
52: X_PERSONNEL_ATTACHED_FLAG,
53: decode(igw_security.gms_enabled, 'N', X_START_DATE_ACTIVE, null),
54: decode(igw_security.gms_enabled, 'N', X_END_DATE_ACTIVE, null),

Line 53: decode(igw_security.gms_enabled, 'N', X_START_DATE_ACTIVE, null),

49: X_EXPENDITURE_CATEGORY,
50: decode(igw_security.gms_enabled, 'N', X_DESCRIPTION, null),
51: X_BUDGET_CATEGORY_CODE,
52: X_PERSONNEL_ATTACHED_FLAG,
53: decode(igw_security.gms_enabled, 'N', X_START_DATE_ACTIVE, null),
54: decode(igw_security.gms_enabled, 'N', X_END_DATE_ACTIVE, null),
55: X_LAST_UPDATE_DATE,
56: X_LAST_UPDATED_BY,
57: X_LAST_UPDATE_DATE,

Line 54: decode(igw_security.gms_enabled, 'N', X_END_DATE_ACTIVE, null),

50: decode(igw_security.gms_enabled, 'N', X_DESCRIPTION, null),
51: X_BUDGET_CATEGORY_CODE,
52: X_PERSONNEL_ATTACHED_FLAG,
53: decode(igw_security.gms_enabled, 'N', X_START_DATE_ACTIVE, null),
54: decode(igw_security.gms_enabled, 'N', X_END_DATE_ACTIVE, null),
55: X_LAST_UPDATE_DATE,
56: X_LAST_UPDATED_BY,
57: X_LAST_UPDATE_DATE,
58: X_LAST_UPDATED_BY,

Line 101: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)) OR (igw_security.gms_enabled = 'Y'))

97:
98: if (
99: (tlinfo.EXPENDITURE_CATEGORY = X_EXPENDITURE_CATEGORY)
100: AND ((tlinfo.DESCRIPTION = X_DESCRIPTION)
101: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)) OR (igw_security.gms_enabled = 'Y'))
102: AND (tlinfo.BUDGET_CATEGORY_CODE = X_BUDGET_CATEGORY_CODE)
103: AND (tlinfo.PERSONNEL_ATTACHED_FLAG = X_PERSONNEL_ATTACHED_FLAG)
104: AND ((tlinfo.START_DATE_ACTIVE = X_START_DATE_ACTIVE)
105: OR ((tlinfo.START_DATE_ACTIVE is null) AND (X_START_DATE_ACTIVE is null)) OR (igw_security.gms_enabled = 'Y'))

Line 105: OR ((tlinfo.START_DATE_ACTIVE is null) AND (X_START_DATE_ACTIVE is null)) OR (igw_security.gms_enabled = 'Y'))

101: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)) OR (igw_security.gms_enabled = 'Y'))
102: AND (tlinfo.BUDGET_CATEGORY_CODE = X_BUDGET_CATEGORY_CODE)
103: AND (tlinfo.PERSONNEL_ATTACHED_FLAG = X_PERSONNEL_ATTACHED_FLAG)
104: AND ((tlinfo.START_DATE_ACTIVE = X_START_DATE_ACTIVE)
105: OR ((tlinfo.START_DATE_ACTIVE is null) AND (X_START_DATE_ACTIVE is null)) OR (igw_security.gms_enabled = 'Y'))
106: AND ((tlinfo.END_DATE_ACTIVE = X_END_DATE_ACTIVE)
107: OR ((tlinfo.END_DATE_ACTIVE is null) AND (X_END_DATE_ACTIVE is null)) OR (igw_security.gms_enabled = 'Y'))
108: ) then
109: null;

Line 107: OR ((tlinfo.END_DATE_ACTIVE is null) AND (X_END_DATE_ACTIVE is null)) OR (igw_security.gms_enabled = 'Y'))

103: AND (tlinfo.PERSONNEL_ATTACHED_FLAG = X_PERSONNEL_ATTACHED_FLAG)
104: AND ((tlinfo.START_DATE_ACTIVE = X_START_DATE_ACTIVE)
105: OR ((tlinfo.START_DATE_ACTIVE is null) AND (X_START_DATE_ACTIVE is null)) OR (igw_security.gms_enabled = 'Y'))
106: AND ((tlinfo.END_DATE_ACTIVE = X_END_DATE_ACTIVE)
107: OR ((tlinfo.END_DATE_ACTIVE is null) AND (X_END_DATE_ACTIVE is null)) OR (igw_security.gms_enabled = 'Y'))
108: ) then
109: null;
110: else
111: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

Line 150: DESCRIPTION = decode(igw_security.gms_enabled, 'N', X_DESCRIPTION, null),

146: app_exception.raise_exception;
147: end if;
148: update IGW_EXPENDITURE_CATEGORIES set
149: EXPENDITURE_CATEGORY = X_EXPENDITURE_CATEGORY,
150: DESCRIPTION = decode(igw_security.gms_enabled, 'N', X_DESCRIPTION, null),
151: BUDGET_CATEGORY_CODE = X_BUDGET_CATEGORY_CODE,
152: PERSONNEL_ATTACHED_FLAG = X_PERSONNEL_ATTACHED_FLAG,
153: START_DATE_ACTIVE = decode(igw_security.gms_enabled, 'N', X_START_DATE_ACTIVE, null),
154: END_DATE_ACTIVE = decode(igw_security.gms_enabled, 'N', X_END_DATE_ACTIVE, null),

Line 153: START_DATE_ACTIVE = decode(igw_security.gms_enabled, 'N', X_START_DATE_ACTIVE, null),

149: EXPENDITURE_CATEGORY = X_EXPENDITURE_CATEGORY,
150: DESCRIPTION = decode(igw_security.gms_enabled, 'N', X_DESCRIPTION, null),
151: BUDGET_CATEGORY_CODE = X_BUDGET_CATEGORY_CODE,
152: PERSONNEL_ATTACHED_FLAG = X_PERSONNEL_ATTACHED_FLAG,
153: START_DATE_ACTIVE = decode(igw_security.gms_enabled, 'N', X_START_DATE_ACTIVE, null),
154: END_DATE_ACTIVE = decode(igw_security.gms_enabled, 'N', X_END_DATE_ACTIVE, null),
155: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
156: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
157: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 154: END_DATE_ACTIVE = decode(igw_security.gms_enabled, 'N', X_END_DATE_ACTIVE, null),

150: DESCRIPTION = decode(igw_security.gms_enabled, 'N', X_DESCRIPTION, null),
151: BUDGET_CATEGORY_CODE = X_BUDGET_CATEGORY_CODE,
152: PERSONNEL_ATTACHED_FLAG = X_PERSONNEL_ATTACHED_FLAG,
153: START_DATE_ACTIVE = decode(igw_security.gms_enabled, 'N', X_START_DATE_ACTIVE, null),
154: END_DATE_ACTIVE = decode(igw_security.gms_enabled, 'N', X_END_DATE_ACTIVE, null),
155: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
156: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
157: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
158: where ROWID = X_ROWID