APPS.WSH_DELIVERY_TEMPLATE_ROWS dependencies on WSH_DELIVERY_TEMPLATES

Line 14: -- WSH_DELIVERY_TEMPLATES table.

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

Line 85: select wsh_delivery_templates_s.nextval

81:
82: X_dummy varchar2(18);
83:
84: cursor id_sequence is
85: select wsh_delivery_templates_s.nextval
86: from sys.dual;
87:
88: cursor row_id is
89: select rowid

Line 90: from wsh_delivery_templates

86: from sys.dual;
87:
88: cursor row_id is
89: select rowid
90: from wsh_delivery_templates
91: where delivery_template_id = X_delivery_template_id;
92:
93: begin
94:

Line 107: insert into wsh_delivery_templates(

103: open id_sequence;
104: fetch id_sequence into X_delivery_template_id;
105: close id_sequence;
106:
107: insert into wsh_delivery_templates(
108:
109: delivery_template_id,
110: name,
111: organization_id,

Line 224: -- WSH_DELIVERY_TEMPLATES table.

220: --
221: -- Description:
222: --
223: -- Called by the client to lock a row into the
224: -- WSH_DELIVERY_TEMPLATES table.
225: --
226: -- ===========================================================================
227:
228: procedure lock_row(

Line 290: from wsh_delivery_templates

286: is
287:
288: cursor lock_record is
289: select *
290: from wsh_delivery_templates
291: where rowid = X_rowid
292: for update nowait;
293:
294: rec_info lock_record%ROWTYPE;

Line 595: -- WSH_DELIVERY_TEMPLATES table.

591: --
592: -- Description:
593: --
594: -- Called by the client to update a row into the
595: -- WSH_DELIVERY_TEMPLATES table.
596: --
597: -- ===========================================================================
598:
599: procedure update_row(

Line 671: update wsh_delivery_templates set

667: where departure_template_id = X_planned_dep_template_id
668: for update nowait;
669: end if;
670:
671: update wsh_delivery_templates set
672:
673: delivery_template_id = X_delivery_template_id,
674: name = X_name,
675: organization_id = X_organization_id,

Line 759: -- WSH_DELIVERY_TEMPLATES table.

755: --
756: -- Description:
757: --
758: -- Called by the client to delete a row into the
759: -- WSH_DELIVERY_TEMPLATES table.
760: --
761: -- ===========================================================================
762:
763: procedure delete_row(X_rowid varchar2)

Line 767: delete from wsh_delivery_templates

763: procedure delete_row(X_rowid varchar2)
764: is
765: begin
766:
767: delete from wsh_delivery_templates
768: where rowid = X_rowid;
769:
770: if (SQL%NOTFOUND) then
771: raise NO_DATA_FOUND;