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.IGS_UC_RELEASE_TRANS_PKG dependencies on FND_DSQL

Line 99: --initialize fnd_dsql data-structures

95:
96: --========================================================================
97: -- START WHERE CLAUSE CONSTRUCTION
98: --========================================================================
99: --initialize fnd_dsql data-structures
100: fnd_dsql.init;
101:
102: --set the base UPDATE statement
103: fnd_dsql.add_text(' UPDATE IGS_UC_TRANSACTIONS UCTRANS SET UCTRANS.HOLD_FLAG = ''N'' ');

Line 100: fnd_dsql.init;

96: --========================================================================
97: -- START WHERE CLAUSE CONSTRUCTION
98: --========================================================================
99: --initialize fnd_dsql data-structures
100: fnd_dsql.init;
101:
102: --set the base UPDATE statement
103: fnd_dsql.add_text(' UPDATE IGS_UC_TRANSACTIONS UCTRANS SET UCTRANS.HOLD_FLAG = ''N'' ');
104: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_DATE = ');

Line 103: fnd_dsql.add_text(' UPDATE IGS_UC_TRANSACTIONS UCTRANS SET UCTRANS.HOLD_FLAG = ''N'' ');

99: --initialize fnd_dsql data-structures
100: fnd_dsql.init;
101:
102: --set the base UPDATE statement
103: fnd_dsql.add_text(' UPDATE IGS_UC_TRANSACTIONS UCTRANS SET UCTRANS.HOLD_FLAG = ''N'' ');
104: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_DATE = ');
105: fnd_dsql.add_bind(l_last_update_date);
106: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATED_BY = ');
107: fnd_dsql.add_bind(l_last_updated_by);

Line 104: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_DATE = ');

100: fnd_dsql.init;
101:
102: --set the base UPDATE statement
103: fnd_dsql.add_text(' UPDATE IGS_UC_TRANSACTIONS UCTRANS SET UCTRANS.HOLD_FLAG = ''N'' ');
104: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_DATE = ');
105: fnd_dsql.add_bind(l_last_update_date);
106: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATED_BY = ');
107: fnd_dsql.add_bind(l_last_updated_by);
108: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_LOGIN = ');

Line 105: fnd_dsql.add_bind(l_last_update_date);

101:
102: --set the base UPDATE statement
103: fnd_dsql.add_text(' UPDATE IGS_UC_TRANSACTIONS UCTRANS SET UCTRANS.HOLD_FLAG = ''N'' ');
104: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_DATE = ');
105: fnd_dsql.add_bind(l_last_update_date);
106: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATED_BY = ');
107: fnd_dsql.add_bind(l_last_updated_by);
108: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_LOGIN = ');
109: fnd_dsql.add_bind(l_last_update_login);

Line 106: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATED_BY = ');

102: --set the base UPDATE statement
103: fnd_dsql.add_text(' UPDATE IGS_UC_TRANSACTIONS UCTRANS SET UCTRANS.HOLD_FLAG = ''N'' ');
104: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_DATE = ');
105: fnd_dsql.add_bind(l_last_update_date);
106: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATED_BY = ');
107: fnd_dsql.add_bind(l_last_updated_by);
108: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_LOGIN = ');
109: fnd_dsql.add_bind(l_last_update_login);
110:

Line 107: fnd_dsql.add_bind(l_last_updated_by);

103: fnd_dsql.add_text(' UPDATE IGS_UC_TRANSACTIONS UCTRANS SET UCTRANS.HOLD_FLAG = ''N'' ');
104: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_DATE = ');
105: fnd_dsql.add_bind(l_last_update_date);
106: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATED_BY = ');
107: fnd_dsql.add_bind(l_last_updated_by);
108: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_LOGIN = ');
109: fnd_dsql.add_bind(l_last_update_login);
110:
111: --system code is a required parameter and only need to release transactions which

Line 108: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_LOGIN = ');

104: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_DATE = ');
105: fnd_dsql.add_bind(l_last_update_date);
106: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATED_BY = ');
107: fnd_dsql.add_bind(l_last_updated_by);
108: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_LOGIN = ');
109: fnd_dsql.add_bind(l_last_update_login);
110:
111: --system code is a required parameter and only need to release transactions which
112: --are currently on hold

Line 109: fnd_dsql.add_bind(l_last_update_login);

105: fnd_dsql.add_bind(l_last_update_date);
106: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATED_BY = ');
107: fnd_dsql.add_bind(l_last_updated_by);
108: fnd_dsql.add_text(' ,UCTRANS.LAST_UPDATE_LOGIN = ');
109: fnd_dsql.add_bind(l_last_update_login);
110:
111: --system code is a required parameter and only need to release transactions which
112: --are currently on hold
113: fnd_dsql.add_text(' WHERE HOLD_FLAG = ''Y'' AND UCTRANS.SYSTEM_CODE = ');

Line 113: fnd_dsql.add_text(' WHERE HOLD_FLAG = ''Y'' AND UCTRANS.SYSTEM_CODE = ');

109: fnd_dsql.add_bind(l_last_update_login);
110:
111: --system code is a required parameter and only need to release transactions which
112: --are currently on hold
113: fnd_dsql.add_text(' WHERE HOLD_FLAG = ''Y'' AND UCTRANS.SYSTEM_CODE = ');
114: fnd_dsql.add_bind(p_ucas_system_code);
115:
116: -- org_code
117: IF p_org_unit_code IS NOT NULL THEN

Line 114: fnd_dsql.add_bind(p_ucas_system_code);

110:
111: --system code is a required parameter and only need to release transactions which
112: --are currently on hold
113: fnd_dsql.add_text(' WHERE HOLD_FLAG = ''Y'' AND UCTRANS.SYSTEM_CODE = ');
114: fnd_dsql.add_bind(p_ucas_system_code);
115:
116: -- org_code
117: IF p_org_unit_code IS NOT NULL THEN
118: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_PS_VER PSVER, IGS_UC_APP_CHOICES APPCH WHERE APPCH.APP_NO = UCTRANS.APP_NO AND ');

Line 118: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_PS_VER PSVER, IGS_UC_APP_CHOICES APPCH WHERE APPCH.APP_NO = UCTRANS.APP_NO AND ');

114: fnd_dsql.add_bind(p_ucas_system_code);
115:
116: -- org_code
117: IF p_org_unit_code IS NOT NULL THEN
118: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_PS_VER PSVER, IGS_UC_APP_CHOICES APPCH WHERE APPCH.APP_NO = UCTRANS.APP_NO AND ');
119: fnd_dsql.add_text(' UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND PSVER.COURSE_CD = APPCH.OSS_PROGRAM_CODE AND ');
120: fnd_dsql.add_text(' PSVER.VERSION_NUMBER = APPCH.OSS_PROGRAM_VERSION AND PSVER.RESPONSIBLE_ORG_UNIT_CD = ');
121: fnd_dsql.add_bind(p_org_unit_code);
122: fnd_dsql.add_text(' )');

Line 119: fnd_dsql.add_text(' UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND PSVER.COURSE_CD = APPCH.OSS_PROGRAM_CODE AND ');

115:
116: -- org_code
117: IF p_org_unit_code IS NOT NULL THEN
118: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_PS_VER PSVER, IGS_UC_APP_CHOICES APPCH WHERE APPCH.APP_NO = UCTRANS.APP_NO AND ');
119: fnd_dsql.add_text(' UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND PSVER.COURSE_CD = APPCH.OSS_PROGRAM_CODE AND ');
120: fnd_dsql.add_text(' PSVER.VERSION_NUMBER = APPCH.OSS_PROGRAM_VERSION AND PSVER.RESPONSIBLE_ORG_UNIT_CD = ');
121: fnd_dsql.add_bind(p_org_unit_code);
122: fnd_dsql.add_text(' )');
123: END IF;

Line 120: fnd_dsql.add_text(' PSVER.VERSION_NUMBER = APPCH.OSS_PROGRAM_VERSION AND PSVER.RESPONSIBLE_ORG_UNIT_CD = ');

116: -- org_code
117: IF p_org_unit_code IS NOT NULL THEN
118: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_PS_VER PSVER, IGS_UC_APP_CHOICES APPCH WHERE APPCH.APP_NO = UCTRANS.APP_NO AND ');
119: fnd_dsql.add_text(' UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND PSVER.COURSE_CD = APPCH.OSS_PROGRAM_CODE AND ');
120: fnd_dsql.add_text(' PSVER.VERSION_NUMBER = APPCH.OSS_PROGRAM_VERSION AND PSVER.RESPONSIBLE_ORG_UNIT_CD = ');
121: fnd_dsql.add_bind(p_org_unit_code);
122: fnd_dsql.add_text(' )');
123: END IF;
124:

Line 121: fnd_dsql.add_bind(p_org_unit_code);

117: IF p_org_unit_code IS NOT NULL THEN
118: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_PS_VER PSVER, IGS_UC_APP_CHOICES APPCH WHERE APPCH.APP_NO = UCTRANS.APP_NO AND ');
119: fnd_dsql.add_text(' UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND PSVER.COURSE_CD = APPCH.OSS_PROGRAM_CODE AND ');
120: fnd_dsql.add_text(' PSVER.VERSION_NUMBER = APPCH.OSS_PROGRAM_VERSION AND PSVER.RESPONSIBLE_ORG_UNIT_CD = ');
121: fnd_dsql.add_bind(p_org_unit_code);
122: fnd_dsql.add_text(' )');
123: END IF;
124:
125: -- Program search

Line 122: fnd_dsql.add_text(' )');

118: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_PS_VER PSVER, IGS_UC_APP_CHOICES APPCH WHERE APPCH.APP_NO = UCTRANS.APP_NO AND ');
119: fnd_dsql.add_text(' UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND PSVER.COURSE_CD = APPCH.OSS_PROGRAM_CODE AND ');
120: fnd_dsql.add_text(' PSVER.VERSION_NUMBER = APPCH.OSS_PROGRAM_VERSION AND PSVER.RESPONSIBLE_ORG_UNIT_CD = ');
121: fnd_dsql.add_bind(p_org_unit_code);
122: fnd_dsql.add_text(' )');
123: END IF;
124:
125: -- Program search
126: IF p_ucas_program_code IS NOT NULL THEN

Line 127: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');

123: END IF;
124:
125: -- Program search
126: IF p_ucas_program_code IS NOT NULL THEN
127: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
128: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.UCAS_PROGRAM_CODE = ');
129: fnd_dsql.add_bind(p_ucas_program_code);
130: fnd_dsql.add_text(' )');
131: END IF;

Line 128: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.UCAS_PROGRAM_CODE = ');

124:
125: -- Program search
126: IF p_ucas_program_code IS NOT NULL THEN
127: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
128: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.UCAS_PROGRAM_CODE = ');
129: fnd_dsql.add_bind(p_ucas_program_code);
130: fnd_dsql.add_text(' )');
131: END IF;
132:

Line 129: fnd_dsql.add_bind(p_ucas_program_code);

125: -- Program search
126: IF p_ucas_program_code IS NOT NULL THEN
127: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
128: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.UCAS_PROGRAM_CODE = ');
129: fnd_dsql.add_bind(p_ucas_program_code);
130: fnd_dsql.add_text(' )');
131: END IF;
132:
133: -- Campus search

Line 130: fnd_dsql.add_text(' )');

126: IF p_ucas_program_code IS NOT NULL THEN
127: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
128: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.UCAS_PROGRAM_CODE = ');
129: fnd_dsql.add_bind(p_ucas_program_code);
130: fnd_dsql.add_text(' )');
131: END IF;
132:
133: -- Campus search
134: IF p_ucas_campus IS NOT NULL THEN

Line 135: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');

131: END IF;
132:
133: -- Campus search
134: IF p_ucas_campus IS NOT NULL THEN
135: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
136: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.CAMPUS = ');
137: fnd_dsql.add_bind(p_ucas_campus);
138: fnd_dsql.add_text(' )');
139: END IF;

Line 136: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.CAMPUS = ');

132:
133: -- Campus search
134: IF p_ucas_campus IS NOT NULL THEN
135: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
136: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.CAMPUS = ');
137: fnd_dsql.add_bind(p_ucas_campus);
138: fnd_dsql.add_text(' )');
139: END IF;
140:

Line 137: fnd_dsql.add_bind(p_ucas_campus);

133: -- Campus search
134: IF p_ucas_campus IS NOT NULL THEN
135: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
136: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.CAMPUS = ');
137: fnd_dsql.add_bind(p_ucas_campus);
138: fnd_dsql.add_text(' )');
139: END IF;
140:
141: -- Entry Point search

Line 138: fnd_dsql.add_text(' )');

134: IF p_ucas_campus IS NOT NULL THEN
135: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
136: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.CAMPUS = ');
137: fnd_dsql.add_bind(p_ucas_campus);
138: fnd_dsql.add_text(' )');
139: END IF;
140:
141: -- Entry Point search
142: IF p_ucas_entry_point IS NOT NULL THEN

Line 143: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');

139: END IF;
140:
141: -- Entry Point search
142: IF p_ucas_entry_point IS NOT NULL THEN
143: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
144: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.POINT_OF_ENTRY = ');
145: fnd_dsql.add_bind(p_ucas_entry_point);
146: fnd_dsql.add_text(' )');
147: END IF;

Line 144: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.POINT_OF_ENTRY = ');

140:
141: -- Entry Point search
142: IF p_ucas_entry_point IS NOT NULL THEN
143: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
144: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.POINT_OF_ENTRY = ');
145: fnd_dsql.add_bind(p_ucas_entry_point);
146: fnd_dsql.add_text(' )');
147: END IF;
148:

Line 145: fnd_dsql.add_bind(p_ucas_entry_point);

141: -- Entry Point search
142: IF p_ucas_entry_point IS NOT NULL THEN
143: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
144: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.POINT_OF_ENTRY = ');
145: fnd_dsql.add_bind(p_ucas_entry_point);
146: fnd_dsql.add_text(' )');
147: END IF;
148:
149: -- Entry month search

Line 146: fnd_dsql.add_text(' )');

142: IF p_ucas_entry_point IS NOT NULL THEN
143: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
144: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.POINT_OF_ENTRY = ');
145: fnd_dsql.add_bind(p_ucas_entry_point);
146: fnd_dsql.add_text(' )');
147: END IF;
148:
149: -- Entry month search
150: IF p_ucas_entry_month IS NOT NULL THEN

Line 151: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');

147: END IF;
148:
149: -- Entry month search
150: IF p_ucas_entry_month IS NOT NULL THEN
151: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
152: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.ENTRY_MONTH = ');
153: fnd_dsql.add_bind(p_ucas_entry_month);
154: fnd_dsql.add_text(' )');
155: END IF;

Line 152: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.ENTRY_MONTH = ');

148:
149: -- Entry month search
150: IF p_ucas_entry_month IS NOT NULL THEN
151: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
152: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.ENTRY_MONTH = ');
153: fnd_dsql.add_bind(p_ucas_entry_month);
154: fnd_dsql.add_text(' )');
155: END IF;
156:

Line 153: fnd_dsql.add_bind(p_ucas_entry_month);

149: -- Entry month search
150: IF p_ucas_entry_month IS NOT NULL THEN
151: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
152: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.ENTRY_MONTH = ');
153: fnd_dsql.add_bind(p_ucas_entry_month);
154: fnd_dsql.add_text(' )');
155: END IF;
156:
157: -- Entry Year search

Line 154: fnd_dsql.add_text(' )');

150: IF p_ucas_entry_month IS NOT NULL THEN
151: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
152: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.ENTRY_MONTH = ');
153: fnd_dsql.add_bind(p_ucas_entry_month);
154: fnd_dsql.add_text(' )');
155: END IF;
156:
157: -- Entry Year search
158: IF p_ucas_entry_year IS NOT NULL THEN

Line 159: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');

155: END IF;
156:
157: -- Entry Year search
158: IF p_ucas_entry_year IS NOT NULL THEN
159: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
160: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.ENTRY_YEAR = ');
161: fnd_dsql.add_bind(p_ucas_entry_year);
162: fnd_dsql.add_text(' )');
163: END IF;

Line 160: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.ENTRY_YEAR = ');

156:
157: -- Entry Year search
158: IF p_ucas_entry_year IS NOT NULL THEN
159: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
160: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.ENTRY_YEAR = ');
161: fnd_dsql.add_bind(p_ucas_entry_year);
162: fnd_dsql.add_text(' )');
163: END IF;
164:

Line 161: fnd_dsql.add_bind(p_ucas_entry_year);

157: -- Entry Year search
158: IF p_ucas_entry_year IS NOT NULL THEN
159: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
160: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.ENTRY_YEAR = ');
161: fnd_dsql.add_bind(p_ucas_entry_year);
162: fnd_dsql.add_text(' )');
163: END IF;
164:
165:

Line 162: fnd_dsql.add_text(' )');

158: IF p_ucas_entry_year IS NOT NULL THEN
159: fnd_dsql.add_text(' AND EXISTS (SELECT 1 FROM IGS_UC_APP_CHOICES APPCH WHERE UCTRANS.APP_NO = APPCH.APP_NO AND UCTRANS.CHOICE_NO = APPCH.CHOICE_NO AND ');
160: fnd_dsql.add_text(' UCTRANS.UCAS_CYCLE = APPCH.UCAS_CYCLE AND APPCH.ENTRY_YEAR = ');
161: fnd_dsql.add_bind(p_ucas_entry_year);
162: fnd_dsql.add_text(' )');
163: END IF;
164:
165:
166:

Line 169: fnd_dsql.add_text(' AND UCTRANS.TRANSACTION_TYPE = ');

165:
166:
167: -- Transaction type
168: IF p_ucas_trans_type IS NOT NULL THEN
169: fnd_dsql.add_text(' AND UCTRANS.TRANSACTION_TYPE = ');
170: fnd_dsql.add_bind(p_ucas_trans_type);
171: END IF;
172:
173: -- Decision

Line 170: fnd_dsql.add_bind(p_ucas_trans_type);

166:
167: -- Transaction type
168: IF p_ucas_trans_type IS NOT NULL THEN
169: fnd_dsql.add_text(' AND UCTRANS.TRANSACTION_TYPE = ');
170: fnd_dsql.add_bind(p_ucas_trans_type);
171: END IF;
172:
173: -- Decision
174: IF p_ucas_decision_code IS NOT NULL THEN

Line 175: fnd_dsql.add_text(' AND UCTRANS.DECISION = ');

171: END IF;
172:
173: -- Decision
174: IF p_ucas_decision_code IS NOT NULL THEN
175: fnd_dsql.add_text(' AND UCTRANS.DECISION = ');
176: fnd_dsql.add_bind(p_ucas_decision_code);
177: END IF;
178:
179: -- Creation dates search

Line 176: fnd_dsql.add_bind(p_ucas_decision_code);

172:
173: -- Decision
174: IF p_ucas_decision_code IS NOT NULL THEN
175: fnd_dsql.add_text(' AND UCTRANS.DECISION = ');
176: fnd_dsql.add_bind(p_ucas_decision_code);
177: END IF;
178:
179: -- Creation dates search
180: IF p_trans_creation_dt_from IS NOT NULL THEN

Line 181: fnd_dsql.add_text(' AND UCTRANS.CREATION_DATE >= ');

177: END IF;
178:
179: -- Creation dates search
180: IF p_trans_creation_dt_from IS NOT NULL THEN
181: fnd_dsql.add_text(' AND UCTRANS.CREATION_DATE >= ');
182: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_creation_dt_from));
183: END IF;
184:
185: IF p_trans_creation_dt_to IS NOT NULL THEN

Line 182: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_creation_dt_from));

178:
179: -- Creation dates search
180: IF p_trans_creation_dt_from IS NOT NULL THEN
181: fnd_dsql.add_text(' AND UCTRANS.CREATION_DATE >= ');
182: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_creation_dt_from));
183: END IF;
184:
185: IF p_trans_creation_dt_to IS NOT NULL THEN
186: fnd_dsql.add_text(' AND UCTRANS.CREATION_DATE <= ');

Line 186: fnd_dsql.add_text(' AND UCTRANS.CREATION_DATE <= ');

182: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_creation_dt_from));
183: END IF;
184:
185: IF p_trans_creation_dt_to IS NOT NULL THEN
186: fnd_dsql.add_text(' AND UCTRANS.CREATION_DATE <= ');
187: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_creation_dt_to));
188: END IF;
189:
190: -- Transmission dates search

Line 187: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_creation_dt_to));

183: END IF;
184:
185: IF p_trans_creation_dt_to IS NOT NULL THEN
186: fnd_dsql.add_text(' AND UCTRANS.CREATION_DATE <= ');
187: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_creation_dt_to));
188: END IF;
189:
190: -- Transmission dates search
191: IF p_trans_transmit_dt_from IS NOT NULL THEN

Line 192: fnd_dsql.add_text(' AND UCTRANS.DATETIMESTAMP >= ');

188: END IF;
189:
190: -- Transmission dates search
191: IF p_trans_transmit_dt_from IS NOT NULL THEN
192: fnd_dsql.add_text(' AND UCTRANS.DATETIMESTAMP >= ');
193: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_transmit_dt_from));
194: END IF;
195:
196: IF p_trans_transmit_dt_to IS NOT NULL THEN

Line 193: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_transmit_dt_from));

189:
190: -- Transmission dates search
191: IF p_trans_transmit_dt_from IS NOT NULL THEN
192: fnd_dsql.add_text(' AND UCTRANS.DATETIMESTAMP >= ');
193: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_transmit_dt_from));
194: END IF;
195:
196: IF p_trans_transmit_dt_to IS NOT NULL THEN
197: fnd_dsql.add_text(' AND UCTRANS.DATETIMESTAMP <= ');

Line 197: fnd_dsql.add_text(' AND UCTRANS.DATETIMESTAMP <= ');

193: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_transmit_dt_from));
194: END IF;
195:
196: IF p_trans_transmit_dt_to IS NOT NULL THEN
197: fnd_dsql.add_text(' AND UCTRANS.DATETIMESTAMP <= ');
198: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_transmit_dt_to));
199: END IF;
200:
201:

Line 198: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_transmit_dt_to));

194: END IF;
195:
196: IF p_trans_transmit_dt_to IS NOT NULL THEN
197: fnd_dsql.add_text(' AND UCTRANS.DATETIMESTAMP <= ');
198: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_transmit_dt_to));
199: END IF;
200:
201:
202: l_update_stmt := fnd_dsql.get_text(FALSE);

Line 202: l_update_stmt := fnd_dsql.get_text(FALSE);

198: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_transmit_dt_to));
199: END IF;
200:
201:
202: l_update_stmt := fnd_dsql.get_text(FALSE);
203:
204: -- log the UPDATE DML statement using the fnd logging framework
205: IF (fnd_log.level_statement >= l_debug_level ) THEN
206: fnd_log.string( fnd_log.level_statement, 'igs.plsql.ucas.release_transactions.update_dml', l_update_stmt);

Line 210: fnd_dsql.set_cursor(l_cursor_id);

206: fnd_log.string( fnd_log.level_statement, 'igs.plsql.ucas.release_transactions.update_dml', l_update_stmt);
207: END IF;
208:
209: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
210: fnd_dsql.set_cursor(l_cursor_id);
211:
212: DBMS_SQL.parse(l_cursor_id, l_update_stmt, dbms_sql.native);
213: fnd_dsql.do_binds;
214:

Line 213: fnd_dsql.do_binds;

209: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
210: fnd_dsql.set_cursor(l_cursor_id);
211:
212: DBMS_SQL.parse(l_cursor_id, l_update_stmt, dbms_sql.native);
213: fnd_dsql.do_binds;
214:
215: l_updated_rows := dbms_sql.EXECUTE(l_cursor_id);
216:
217: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);