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 115.4 2002/12/10 11:18:10 hjonnala noship $ */
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: insert into HR_FORM_PROPERTIES (

Line 182: insert into HR_FORM_PROPERTIES (

178: cursor C is select ROWID from HR_FORM_PROPERTIES
179: where FORM_PROPERTY_ID = X_FORM_PROPERTY_ID
180: ;
181: begin
182: insert into HR_FORM_PROPERTIES (
183: INFORMATION30,
184: LAST_UPDATE_DATE,
185: LAST_UPDATED_BY,
186: LAST_UPDATE_LOGIN,

Line 351: from HR_FORM_PROPERTIES

347: INFORMATION13,
348: INFORMATION14,
349: INFORMATION15,
350: INFORMATION30
351: from HR_FORM_PROPERTIES
352: where FORM_PROPERTY_ID = X_FORM_PROPERTY_ID
353: for update of FORM_PROPERTY_ID nowait;
354: begin
355: for tlinfo in c1 loop

Line 478: update HR_FORM_PROPERTIES set

474: X_LAST_UPDATED_BY in NUMBER,
475: X_LAST_UPDATE_LOGIN in NUMBER
476: ) is
477: begin
478: update HR_FORM_PROPERTIES set
479: INFORMATION29 = X_INFORMATION29,
480: INFORMATION16 = X_INFORMATION16,
481: INFORMATION17 = X_INFORMATION17,
482: INFORMATION18 = X_INFORMATION18,

Line 528: delete from HR_FORM_PROPERTIES

524: procedure DELETE_ROW (
525: X_FORM_PROPERTY_ID in NUMBER
526: ) is
527: begin
528: delete from HR_FORM_PROPERTIES
529: where FORM_PROPERTY_ID = X_FORM_PROPERTY_ID;
530:
531: if (sql%notfound) then
532: raise no_data_found;

Line 630: from hr_form_properties

626: begin
627:
628: select form_property_id
629: into x_form_property_id
630: from hr_form_properties
631: where nvl(form_id,hr_api.g_number) = nvl(x_form_id,hr_api.g_number)
632: and nvl(application_id,hr_api.g_number) = nvl(x_application_id,hr_api.g_number)
633: and nvl(form_template_id,hr_api.g_number) = nvl(x_form_template_id,hr_api.g_number);
634:

Line 637: select hr_form_properties_s.nextval

633: and nvl(form_template_id,hr_api.g_number) = nvl(x_form_template_id,hr_api.g_number);
634:
635: exception
636: when no_data_found then
637: select hr_form_properties_s.nextval
638: into x_form_property_id
639: from dual;
640: end;
641:

Line 773: end HR_FORM_PROPERTIES_PKG;

769: X_LAST_UPDATED_BY,
770: X_LAST_UPDATE_LOGIN);
771: end;
772: end LOAD_ROW;
773: end HR_FORM_PROPERTIES_PKG;