APPS.HR_FORM_PROPERTIES_PKG dependencies on HR_FORM_PROPERTIES

Line 1: package body HR_FORM_PROPERTIES_PKG as

1: package body HR_FORM_PROPERTIES_PKG as
2: /* $Header: hrfmplct.pkb 120.1 2011/04/28 11:57:22 sidsaxen ship $ */
3: -- -----------------------------------------------------------------------------
4: -- |-----------------------------< update_copies >-----------------------------|
5: -- -----------------------------------------------------------------------------

Line 49: from HR_FORM_PROPERTIES

45: X_LAST_UPDATE_LOGIN in NUMBER
46: ) is
47: cursor csr_original is
48: select *
49: from HR_FORM_PROPERTIES
50: where FORM_PROPERTY_ID = X_FORM_PROPERTY_ID;
51: l_original csr_original%rowtype;
52: cursor csr_copies is
53: select fmp.form_property_id

Line 54: from HR_FORM_PROPERTIES fmp

50: where FORM_PROPERTY_ID = X_FORM_PROPERTY_ID;
51: l_original csr_original%rowtype;
52: cursor csr_copies is
53: select fmp.form_property_id
54: from HR_FORM_PROPERTIES fmp
55: where fmp.FORM_TEMPLATE_ID in (select sft.FORM_TEMPLATE_ID_TO
56: from HR_SOURCE_FORM_TEMPLATES sft
57: start with sft.FORM_TEMPLATE_ID_FROM = X_FORM_TEMPLATE_ID
58: connect by sft.FORM_TEMPLATE_ID_FROM = prior sft.FORM_TEMPLATE_ID_TO);

Line 66: update HR_FORM_PROPERTIES set

62: fetch csr_original into l_original;
63: if csr_original%found then
64: close csr_original;
65: for l_copy in csr_copies loop
66: update HR_FORM_PROPERTIES set
67: HELP_TARGET = decode(nvl(HELP_TARGET,hr_api.g_varchar2),nvl(l_original.HELP_TARGET,hr_api.g_varchar2),X_HELP_TARGET,HELP_TARGET),
68: INFORMATION_CATEGORY = decode(nvl(INFORMATION_CATEGORY,hr_api.g_varchar2),nvl(l_original.INFORMATION_CATEGORY,hr_api.g_varchar2),X_INFORMATION_CATEGORY,INFORMATION_CATEGORY),
69: INFORMATION1 = decode(nvl(INFORMATION1 ,hr_api.g_varchar2),nvl(l_original.INFORMATION1 ,hr_api.g_varchar2),X_INFORMATION1 ,INFORMATION1 ),
70: INFORMATION2 = decode(nvl(INFORMATION2 ,hr_api.g_varchar2),nvl(l_original.INFORMATION2 ,hr_api.g_varchar2),X_INFORMATION2 ,INFORMATION2 ),

Line 178: cursor C is select ROWID from HR_FORM_PROPERTIES

174: X_LAST_UPDATE_DATE in DATE,
175: X_LAST_UPDATED_BY in NUMBER,
176: X_LAST_UPDATE_LOGIN in NUMBER
177: ) is
178: cursor C is select ROWID from HR_FORM_PROPERTIES
179: where FORM_PROPERTY_ID = X_FORM_PROPERTY_ID
180: ;
181: begin
182:

Line 190: p_entity_name => 'HR_FORM_PROPERTIES',

186: --
187:
188: BEGIN
189: PER_RIC_PKG.chk_integrity (
190: p_entity_name => 'HR_FORM_PROPERTIES',
191: p_ref_entity => 'HR_FORM_TEMPLATES_B',
192: p_ref_column_name => 'FORM_TEMPLATE_ID',
193: p_ref_col_value_number => X_FORM_TEMPLATE_ID,
194: p_ref_col_value_varchar => NULL,

Line 203: insert into HR_FORM_PROPERTIES (

199: --
200: -- Code Ends Here.
201: --
202:
203: insert into HR_FORM_PROPERTIES (
204: INFORMATION30,
205: LAST_UPDATE_DATE,
206: LAST_UPDATED_BY,
207: LAST_UPDATE_LOGIN,

Line 372: from HR_FORM_PROPERTIES

368: INFORMATION13,
369: INFORMATION14,
370: INFORMATION15,
371: INFORMATION30
372: from HR_FORM_PROPERTIES
373: where FORM_PROPERTY_ID = X_FORM_PROPERTY_ID
374: for update of FORM_PROPERTY_ID nowait;
375: begin
376: for tlinfo in c1 loop

Line 499: update HR_FORM_PROPERTIES set

495: X_LAST_UPDATED_BY in NUMBER,
496: X_LAST_UPDATE_LOGIN in NUMBER
497: ) is
498: begin
499: update HR_FORM_PROPERTIES set
500: INFORMATION29 = X_INFORMATION29,
501: INFORMATION16 = X_INFORMATION16,
502: INFORMATION17 = X_INFORMATION17,
503: INFORMATION18 = X_INFORMATION18,

Line 550: delete from HR_FORM_PROPERTIES

546: X_FORM_PROPERTY_ID in NUMBER
547: ) is
548: begin
549:
550: delete from HR_FORM_PROPERTIES
551: where FORM_PROPERTY_ID = X_FORM_PROPERTY_ID;
552:
553: if (sql%notfound) then
554: raise no_data_found;

Line 652: from hr_form_properties

648: begin
649:
650: select form_property_id
651: into x_form_property_id
652: from hr_form_properties
653: where nvl(form_id,hr_api.g_number) = nvl(x_form_id,hr_api.g_number)
654: and nvl(application_id,hr_api.g_number) = nvl(x_application_id,hr_api.g_number)
655: and nvl(form_template_id,hr_api.g_number) = nvl(x_form_template_id,hr_api.g_number);
656:

Line 659: select hr_form_properties_s.nextval

655: and nvl(form_template_id,hr_api.g_number) = nvl(x_form_template_id,hr_api.g_number);
656:
657: exception
658: when no_data_found then
659: select hr_form_properties_s.nextval
660: into x_form_property_id
661: from dual;
662: end;
663:

Line 795: end HR_FORM_PROPERTIES_PKG;

791: X_LAST_UPDATED_BY,
792: X_LAST_UPDATE_LOGIN);
793: end;
794: end LOAD_ROW;
795: end HR_FORM_PROPERTIES_PKG;