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 120.1 2011/04/28 12:04:07 sidsaxen ship $ */
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 213: FROM hr_canvas_properties

209: x_last_update_login IN NUMBER)
210: IS
211: CURSOR c IS
212: SELECT ROWID
213: FROM hr_canvas_properties
214: WHERE canvas_property_id = x_canvas_property_id;
215: BEGIN
216: --
217: -- Added the following code as a part of Zero Downtime Patching Project.

Line 222: p_entity_name => 'HR_CANVAS_PROPERTIES',

218: -- Code Starts Here.
219: --
220: BEGIN
221: per_ric_pkg.Chk_integrity (
222: p_entity_name => 'HR_CANVAS_PROPERTIES',
223: p_ref_entity_info => per_ric_pkg.ref_entity_tbl(per_ric_pkg.Ref_info_rec('HR_TEMPLATE_CANVASES_B',PER_RIC_PKG.column_info_tbl(
224: PER_RIC_PKG.Col_info_rec('TEMPLATE_CANVAS_ID', NULL,x_template_canvas_id, NULL))),
225: per_ric_pkg.Ref_info_rec('HR_FORM_CANVASES_B', PER_RIC_PKG.column_info_tbl(
226: PER_RIC_PKG.Col_info_rec('FORM_CANVAS_ID', NULL, x_form_canvas_id, NULL)))),

Line 233: INSERT INTO hr_canvas_properties

229:
230: --
231: -- Code Ends Here
232: --
233: INSERT INTO hr_canvas_properties
234: (information13,
235: information14,
236: information15,
237: information16,

Line 420: from HR_CANVAS_PROPERTIES

416: INFORMATION9,
417: INFORMATION10,
418: INFORMATION11,
419: INFORMATION12
420: from HR_CANVAS_PROPERTIES
421: where CANVAS_PROPERTY_ID = X_CANVAS_PROPERTY_ID
422: for update of CANVAS_PROPERTY_ID nowait;
423: begin
424: for tlinfo in c1 loop

Line 559: update HR_CANVAS_PROPERTIES set

555: X_LAST_UPDATED_BY in NUMBER,
556: X_LAST_UPDATE_LOGIN in NUMBER
557: ) is
558: begin
559: update HR_CANVAS_PROPERTIES set
560: INFORMATION13 = X_INFORMATION13,
561: INFORMATION14 = X_INFORMATION14,
562: INFORMATION15 = X_INFORMATION15,
563: INFORMATION16 = X_INFORMATION16,

Line 615: delete from HR_CANVAS_PROPERTIES

611: X_CANVAS_PROPERTY_ID in NUMBER
612: ) is
613: begin
614:
615: delete from HR_CANVAS_PROPERTIES
616: where CANVAS_PROPERTY_ID = X_CANVAS_PROPERTY_ID;
617: if (sql%notfound) then
618: raise no_data_found;
619: end if;

Line 734: from hr_canvas_properties

730:
731: begin
732: select canvas_property_id
733: into x_canvas_property_id
734: from hr_canvas_properties
735: where nvl(form_canvas_id,hr_api.g_number) = nvl(x_form_canvas_id,hr_api.g_number)
736: and nvl(template_canvas_id,hr_api.g_number) = nvl(x_template_canvas_id,hr_api.g_number);
737: exception
738: when no_data_found then

Line 739: select hr_canvas_properties_s.nextval

735: where nvl(form_canvas_id,hr_api.g_number) = nvl(x_form_canvas_id,hr_api.g_number)
736: and nvl(template_canvas_id,hr_api.g_number) = nvl(x_template_canvas_id,hr_api.g_number);
737: exception
738: when no_data_found then
739: select hr_canvas_properties_s.nextval
740: into x_canvas_property_id
741: from dual;
742: end;
743:

Line 887: end HR_CANVAS_PROPERTIES_PKG;

883: X_LAST_UPDATE_LOGIN);
884: end;
885: end LOAD_ROW;
886: --
887: end HR_CANVAS_PROPERTIES_PKG;