APPS.WSH_DEPARTURE_TEMPLATE_ROWS dependencies on WSH_DEPARTURE_TEMPLATES

Line 14: -- WSH_DEPARTURE_TEMPLATES table.

10: --
11: -- Description:
12: --
13: -- Called by the client to insert a row into the
14: -- WSH_DEPARTURE_TEMPLATES table.
15: --
16: -- ===========================================================================
17:
18: procedure insert_row(

Line 56: select wsh_departure_templates_s.nextval

52: X_last_update_login number)
53: is
54:
55: cursor id_sequence is
56: select wsh_departure_templates_s.nextval
57: from sys.dual;
58:
59: cursor row_id is
60: select rowid

Line 61: from wsh_departure_templates

57: from sys.dual;
58:
59: cursor row_id is
60: select rowid
61: from wsh_departure_templates
62: where departure_template_id = X_departure_template_id;
63:
64: begin
65:

Line 70: insert into wsh_departure_templates(

66: open id_sequence;
67: fetch id_sequence into X_departure_template_id;
68: close id_sequence;
69:
70: insert into wsh_departure_templates(
71:
72: departure_template_id,
73: name,
74: organization_id,

Line 171: -- WSH_DEPARTURE_TEMPLATES table.

167: --
168: -- Description:
169: --
170: -- Called by the client to lock a row into the
171: -- WSH_DEPARTURE_TEMPLATES table.
172: --
173: -- ===========================================================================
174:
175: procedure lock_row(

Line 210: from wsh_departure_templates

206: is
207:
208: cursor lock_record is
209: select *
210: from wsh_departure_templates
211: where rowid = X_rowid
212: for update nowait;
213:
214: rec_info lock_record%ROWTYPE;

Line 386: -- WSH_DEPARTURE_TEMPLATES table.

382: --
383: -- Description:
384: --
385: -- Called by the client to update a row into the
386: -- WSH_DEPARTURE_TEMPLATES table.
387: --
388: -- ===========================================================================
389:
390: procedure update_row(

Line 426: update wsh_departure_templates set

422: X_last_update_login number)
423: is
424: begin
425:
426: update wsh_departure_templates set
427:
428: departure_template_id = X_departure_template_id,
429: name = X_name,
430: organization_id = X_organization_id,

Line 483: -- WSH_DEPARTURE_TEMPLATES table.

479: --
480: -- Description:
481: --
482: -- Called by the client to delete a row into the
483: -- WSH_DEPARTURE_TEMPLATES table.
484: --
485: -- ===========================================================================
486:
487: procedure delete_row(X_rowid varchar2)

Line 491: delete from wsh_departure_templates

487: procedure delete_row(X_rowid varchar2)
488: is
489: begin
490:
491: delete from wsh_departure_templates
492: where rowid = X_rowid;
493:
494: if (SQL%NOTFOUND) then
495: raise NO_DATA_FOUND;