APPS.HR_CANVAS_PROPERTIES_PKG dependencies on HR_CANVAS_PROPERTIES

Line 1: package body HR_CANVAS_PROPERTIES_PKG as

1: package body HR_CANVAS_PROPERTIES_PKG as
2: /* $Header: hrcnplct.pkb 115.4 2002/12/09 16:29:30 hjonnala noship $ */
3: -- -----------------------------------------------------------------------------
4: -- |-----------------------------< update_copies >-----------------------------|
5: -- -----------------------------------------------------------------------------

Line 52: from HR_CANVAS_PROPERTIES

48: X_LAST_UPDATE_LOGIN in NUMBER
49: ) is
50: cursor csr_original is
51: select *
52: from HR_CANVAS_PROPERTIES
53: where CANVAS_PROPERTY_ID = X_CANVAS_PROPERTY_ID;
54: l_original csr_original%rowtype;
55: cursor csr_copies is
56: select cnp.canvas_property_id

Line 57: from HR_CANVAS_PROPERTIES cnp

53: where CANVAS_PROPERTY_ID = X_CANVAS_PROPERTY_ID;
54: l_original csr_original%rowtype;
55: cursor csr_copies is
56: select cnp.canvas_property_id
57: from HR_CANVAS_PROPERTIES cnp
58: ,HR_TEMPLATE_CANVASES_B tcn
59: ,HR_TEMPLATE_WINDOWS_B twn
60: ,HR_TEMPLATE_CANVASES_B tco
61: where cnp.TEMPLATE_CANVAS_ID = tcn.TEMPLATE_CANVAS_ID

Line 78: update HR_CANVAS_PROPERTIES set

74: fetch csr_original into l_original;
75: if csr_original%found then
76: close csr_original;
77: for l_copy in csr_copies loop
78: update HR_CANVAS_PROPERTIES set
79: HEIGHT = decode(nvl(HEIGHT,hr_api.g_number),nvl(l_original.HEIGHT,hr_api.g_number),X_HEIGHT,HEIGHT),
80: VISIBLE = decode(nvl(VISIBLE,hr_api.g_number),nvl(l_original.VISIBLE,hr_api.g_number),X_VISIBLE,VISIBLE),
81: WIDTH = decode(nvl(WIDTH,hr_api.g_number),nvl(l_original.WIDTH,hr_api.g_number),X_WIDTH,WIDTH),
82: X_POSITION = decode(nvl(X_POSITION,hr_api.g_number),nvl(l_original.X_POSITION,hr_api.g_number),X_X_POSITION,X_POSITION),

Line 212: cursor C is select ROWID from HR_CANVAS_PROPERTIES

208: X_LAST_UPDATE_DATE in DATE,
209: X_LAST_UPDATED_BY in NUMBER,
210: X_LAST_UPDATE_LOGIN in NUMBER
211: ) is
212: cursor C is select ROWID from HR_CANVAS_PROPERTIES
213: where CANVAS_PROPERTY_ID = X_CANVAS_PROPERTY_ID
214: ;
215:
216: begin

Line 217: insert into HR_CANVAS_PROPERTIES (

213: where CANVAS_PROPERTY_ID = X_CANVAS_PROPERTY_ID
214: ;
215:
216: begin
217: insert into HR_CANVAS_PROPERTIES (
218: INFORMATION13,
219: INFORMATION14,
220: INFORMATION15,
221: INFORMATION16,

Line 399: from HR_CANVAS_PROPERTIES

395: INFORMATION9,
396: INFORMATION10,
397: INFORMATION11,
398: INFORMATION12
399: from HR_CANVAS_PROPERTIES
400: where CANVAS_PROPERTY_ID = X_CANVAS_PROPERTY_ID
401: for update of CANVAS_PROPERTY_ID nowait;
402: begin
403: for tlinfo in c1 loop

Line 538: update HR_CANVAS_PROPERTIES set

534: X_LAST_UPDATED_BY in NUMBER,
535: X_LAST_UPDATE_LOGIN in NUMBER
536: ) is
537: begin
538: update HR_CANVAS_PROPERTIES set
539: INFORMATION13 = X_INFORMATION13,
540: INFORMATION14 = X_INFORMATION14,
541: INFORMATION15 = X_INFORMATION15,
542: INFORMATION16 = X_INFORMATION16,

Line 593: delete from HR_CANVAS_PROPERTIES

589: procedure DELETE_ROW (
590: X_CANVAS_PROPERTY_ID in NUMBER
591: ) is
592: begin
593: delete from HR_CANVAS_PROPERTIES
594: where CANVAS_PROPERTY_ID = X_CANVAS_PROPERTY_ID;
595: if (sql%notfound) then
596: raise no_data_found;
597: end if;

Line 712: from hr_canvas_properties

708:
709: begin
710: select canvas_property_id
711: into x_canvas_property_id
712: from hr_canvas_properties
713: where nvl(form_canvas_id,hr_api.g_number) = nvl(x_form_canvas_id,hr_api.g_number)
714: and nvl(template_canvas_id,hr_api.g_number) = nvl(x_template_canvas_id,hr_api.g_number);
715: exception
716: when no_data_found then

Line 717: select hr_canvas_properties_s.nextval

713: where nvl(form_canvas_id,hr_api.g_number) = nvl(x_form_canvas_id,hr_api.g_number)
714: and nvl(template_canvas_id,hr_api.g_number) = nvl(x_template_canvas_id,hr_api.g_number);
715: exception
716: when no_data_found then
717: select hr_canvas_properties_s.nextval
718: into x_canvas_property_id
719: from dual;
720: end;
721:

Line 865: end HR_CANVAS_PROPERTIES_PKG;

861: X_LAST_UPDATE_LOGIN);
862: end;
863: end LOAD_ROW;
864: --
865: end HR_CANVAS_PROPERTIES_PKG;