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.ARP_AAH_PKG dependencies on DBMS_SQL

Line 43: | dbms_sql.bind_variable |

39: | |
40: | SCOPE - PRIVATE |
41: | |
42: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
43: | dbms_sql.bind_variable |
44: | arp_util.debug |
45: | |
46: | ARGUMENTS : IN: |
47: | p_update_cursor - ID of the update cursor |

Line 74: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',

70: /*------------------+
71: | Dummy constants |
72: +------------------*/
73:
74: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
75: AR_TEXT_DUMMY);
76:
77: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
78: AR_NUMBER_DUMMY);

Line 77: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',

73:
74: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
75: AR_TEXT_DUMMY);
76:
77: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
78: AR_NUMBER_DUMMY);
79:
80: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
81: AR_DATE_DUMMY);

Line 80: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',

76:
77: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
78: AR_NUMBER_DUMMY);
79:
80: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
81: AR_DATE_DUMMY);
82:
83: /*------------------+
84: | WHO variables |

Line 87: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',

83: /*------------------+
84: | WHO variables |
85: +------------------*/
86:
87: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
88: pg_user_id);
89:
90: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
91: pg_login_id);

Line 90: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',

86:
87: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
88: pg_user_id);
89:
90: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
91: pg_login_id);
92:
93: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
94: pg_conc_login_id);

Line 93: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',

89:
90: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
91: pg_login_id);
92:
93: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
94: pg_conc_login_id);
95:
96:
97: /*----------------------------------------------+

Line 102: dbms_sql.bind_variable(p_update_cursor, ':approval_action_history_id',

98: | Bind variables for all columns in the table |
99: +----------------------------------------------*/
100:
101:
102: dbms_sql.bind_variable(p_update_cursor, ':approval_action_history_id',
103: p_aah_rec.approval_action_history_id);
104:
105: dbms_sql.bind_variable(p_update_cursor, ':approval_action_history_id',
106: p_aah_rec.approval_action_history_id);

Line 105: dbms_sql.bind_variable(p_update_cursor, ':approval_action_history_id',

101:
102: dbms_sql.bind_variable(p_update_cursor, ':approval_action_history_id',
103: p_aah_rec.approval_action_history_id);
104:
105: dbms_sql.bind_variable(p_update_cursor, ':approval_action_history_id',
106: p_aah_rec.approval_action_history_id);
107:
108: dbms_sql.bind_variable(p_update_cursor, ':action_name',
109: p_aah_rec.action_name);

Line 108: dbms_sql.bind_variable(p_update_cursor, ':action_name',

104:
105: dbms_sql.bind_variable(p_update_cursor, ':approval_action_history_id',
106: p_aah_rec.approval_action_history_id);
107:
108: dbms_sql.bind_variable(p_update_cursor, ':action_name',
109: p_aah_rec.action_name);
110:
111: dbms_sql.bind_variable(p_update_cursor, ':adjustment_id',
112: p_aah_rec.adjustment_id);

Line 111: dbms_sql.bind_variable(p_update_cursor, ':adjustment_id',

107:
108: dbms_sql.bind_variable(p_update_cursor, ':action_name',
109: p_aah_rec.action_name);
110:
111: dbms_sql.bind_variable(p_update_cursor, ':adjustment_id',
112: p_aah_rec.adjustment_id);
113:
114: dbms_sql.bind_variable(p_update_cursor, ':action_date',
115: p_aah_rec.action_date);

Line 114: dbms_sql.bind_variable(p_update_cursor, ':action_date',

110:
111: dbms_sql.bind_variable(p_update_cursor, ':adjustment_id',
112: p_aah_rec.adjustment_id);
113:
114: dbms_sql.bind_variable(p_update_cursor, ':action_date',
115: p_aah_rec.action_date);
116:
117: dbms_sql.bind_variable(p_update_cursor, ':comments',
118: p_aah_rec.comments);

Line 117: dbms_sql.bind_variable(p_update_cursor, ':comments',

113:
114: dbms_sql.bind_variable(p_update_cursor, ':action_date',
115: p_aah_rec.action_date);
116:
117: dbms_sql.bind_variable(p_update_cursor, ':comments',
118: p_aah_rec.comments);
119:
120: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
121: p_aah_rec.attribute_category);

Line 120: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',

116:
117: dbms_sql.bind_variable(p_update_cursor, ':comments',
118: p_aah_rec.comments);
119:
120: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
121: p_aah_rec.attribute_category);
122:
123: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
124: p_aah_rec.attribute1);

Line 123: dbms_sql.bind_variable(p_update_cursor, ':attribute1',

119:
120: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
121: p_aah_rec.attribute_category);
122:
123: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
124: p_aah_rec.attribute1);
125:
126: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
127: p_aah_rec.attribute2);

Line 126: dbms_sql.bind_variable(p_update_cursor, ':attribute2',

122:
123: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
124: p_aah_rec.attribute1);
125:
126: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
127: p_aah_rec.attribute2);
128:
129: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
130: p_aah_rec.attribute3);

Line 129: dbms_sql.bind_variable(p_update_cursor, ':attribute3',

125:
126: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
127: p_aah_rec.attribute2);
128:
129: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
130: p_aah_rec.attribute3);
131:
132: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
133: p_aah_rec.attribute4);

Line 132: dbms_sql.bind_variable(p_update_cursor, ':attribute4',

128:
129: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
130: p_aah_rec.attribute3);
131:
132: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
133: p_aah_rec.attribute4);
134:
135: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
136: p_aah_rec.attribute5);

Line 135: dbms_sql.bind_variable(p_update_cursor, ':attribute5',

131:
132: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
133: p_aah_rec.attribute4);
134:
135: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
136: p_aah_rec.attribute5);
137:
138: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
139: p_aah_rec.attribute6);

Line 138: dbms_sql.bind_variable(p_update_cursor, ':attribute6',

134:
135: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
136: p_aah_rec.attribute5);
137:
138: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
139: p_aah_rec.attribute6);
140:
141: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
142: p_aah_rec.attribute7);

Line 141: dbms_sql.bind_variable(p_update_cursor, ':attribute7',

137:
138: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
139: p_aah_rec.attribute6);
140:
141: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
142: p_aah_rec.attribute7);
143:
144: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
145: p_aah_rec.attribute8);

Line 144: dbms_sql.bind_variable(p_update_cursor, ':attribute8',

140:
141: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
142: p_aah_rec.attribute7);
143:
144: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
145: p_aah_rec.attribute8);
146:
147: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
148: p_aah_rec.attribute9);

Line 147: dbms_sql.bind_variable(p_update_cursor, ':attribute9',

143:
144: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
145: p_aah_rec.attribute8);
146:
147: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
148: p_aah_rec.attribute9);
149:
150: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
151: p_aah_rec.attribute10);

Line 150: dbms_sql.bind_variable(p_update_cursor, ':attribute10',

146:
147: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
148: p_aah_rec.attribute9);
149:
150: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
151: p_aah_rec.attribute10);
152:
153: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
154: p_aah_rec.attribute11);

Line 153: dbms_sql.bind_variable(p_update_cursor, ':attribute11',

149:
150: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
151: p_aah_rec.attribute10);
152:
153: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
154: p_aah_rec.attribute11);
155:
156: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
157: p_aah_rec.attribute12);

Line 156: dbms_sql.bind_variable(p_update_cursor, ':attribute12',

152:
153: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
154: p_aah_rec.attribute11);
155:
156: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
157: p_aah_rec.attribute12);
158:
159: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
160: p_aah_rec.attribute13);

Line 159: dbms_sql.bind_variable(p_update_cursor, ':attribute13',

155:
156: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
157: p_aah_rec.attribute12);
158:
159: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
160: p_aah_rec.attribute13);
161:
162: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
163: p_aah_rec.attribute14);

Line 162: dbms_sql.bind_variable(p_update_cursor, ':attribute14',

158:
159: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
160: p_aah_rec.attribute13);
161:
162: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
163: p_aah_rec.attribute14);
164:
165: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
166: p_aah_rec.attribute15);

Line 165: dbms_sql.bind_variable(p_update_cursor, ':attribute15',

161:
162: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
163: p_aah_rec.attribute14);
164:
165: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
166: p_aah_rec.attribute15);
167:
168: dbms_sql.bind_variable(p_update_cursor, ':created_by',
169: p_aah_rec.created_by);

Line 168: dbms_sql.bind_variable(p_update_cursor, ':created_by',

164:
165: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
166: p_aah_rec.attribute15);
167:
168: dbms_sql.bind_variable(p_update_cursor, ':created_by',
169: p_aah_rec.created_by);
170:
171: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
172: p_aah_rec.creation_date);

Line 171: dbms_sql.bind_variable(p_update_cursor, ':creation_date',

167:
168: dbms_sql.bind_variable(p_update_cursor, ':created_by',
169: p_aah_rec.created_by);
170:
171: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
172: p_aah_rec.creation_date);
173:
174: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
175: p_aah_rec.last_updated_by);

Line 174: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',

170:
171: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
172: p_aah_rec.creation_date);
173:
174: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
175: p_aah_rec.last_updated_by);
176:
177: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
178: p_aah_rec.last_update_date);

Line 177: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',

173:
174: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
175: p_aah_rec.last_updated_by);
176:
177: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
178: p_aah_rec.last_update_date);
179:
180: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
181: p_aah_rec.last_update_login);

Line 180: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',

176:
177: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
178: p_aah_rec.last_update_date);
179:
180: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
181: p_aah_rec.last_update_login);
182:
183:
184:

Line 361: | dbms_sql.open_cursor |

357: | SCOPE - PRIVATE |
358: | |
359: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
360: | arp_util.debug |
361: | dbms_sql.open_cursor |
362: | dbms_sql.parse |
363: | dbms_sql.execute |
364: | dbms_sql.close_cursor |
365: | |

Line 362: | dbms_sql.parse |

358: | |
359: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
360: | arp_util.debug |
361: | dbms_sql.open_cursor |
362: | dbms_sql.parse |
363: | dbms_sql.execute |
364: | dbms_sql.close_cursor |
365: | |
366: | ARGUMENTS : IN: |

Line 363: | dbms_sql.execute |

359: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
360: | arp_util.debug |
361: | dbms_sql.open_cursor |
362: | dbms_sql.parse |
363: | dbms_sql.execute |
364: | dbms_sql.close_cursor |
365: | |
366: | ARGUMENTS : IN: |
367: | p_update_cursor - identifies the cursor to use |

Line 364: | dbms_sql.close_cursor |

360: | arp_util.debug |
361: | dbms_sql.open_cursor |
362: | dbms_sql.parse |
363: | dbms_sql.execute |
364: | dbms_sql.close_cursor |
365: | |
366: | ARGUMENTS : IN: |
367: | p_update_cursor - identifies the cursor to use |
368: | p_where_clause - identifies which rows to update |

Line 404: p_update_cursor := dbms_sql.open_cursor;

400:
401: if (p_update_cursor is null)
402: then
403:
404: p_update_cursor := dbms_sql.open_cursor;
405:
406: /*---------------------------------+
407: | Construct the update statement |
408: +---------------------------------*/

Line 418: dbms_sql.parse(p_update_cursor,

414: /*-----------------------------------------------+
415: | Parse, bind, execute and close the statement |
416: +-----------------------------------------------*/
417:
418: dbms_sql.parse(p_update_cursor,
419: l_update_statement,
420: dbms_sql.v7);
421:
422: end if;

Line 420: dbms_sql.v7);

416: +-----------------------------------------------*/
417:
418: dbms_sql.parse(p_update_cursor,
419: l_update_statement,
420: dbms_sql.v7);
421:
422: end if;
423:
424: arp_aah_pkg.bind_aah_variables(p_update_cursor, p_aah_rec);

Line 430: dbms_sql.bind_variable(p_update_cursor, ':where_1',

426: /*-----------------------------------------+
427: | Bind the variables in the where clause |
428: +-----------------------------------------*/
429:
430: dbms_sql.bind_variable(p_update_cursor, ':where_1',
431: p_where1);
432:
433: l_count := dbms_sql.execute(p_update_cursor);
434:

Line 433: l_count := dbms_sql.execute(p_update_cursor);

429:
430: dbms_sql.bind_variable(p_update_cursor, ':where_1',
431: p_where1);
432:
433: l_count := dbms_sql.execute(p_update_cursor);
434:
435: arp_util.debug( to_char(l_count) || ' rows updated');
436:
437:

Line 454: to_char(dbms_sql.last_error_position));

450: WHEN OTHERS THEN
451: arp_util.debug('EXCEPTION: arp_aah_pkg.generic_update()');
452: arp_util.debug(l_update_statement);
453: arp_util.debug('Error at character: ' ||
454: to_char(dbms_sql.last_error_position));
455: RAISE;
456: END;
457:
458: /*===========================================================================+