eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRBISORGPARAMS dependencies on HRI_ORG_PARAMS

Line 43: select hri_org_params_s.nextval

39: --
40: function GetNextOrgParamID
41: return Number is
42: cursor c_next is
43: select hri_org_params_s.nextval
44: from dual;
45:
46: l_org_param_id hri_org_params.org_param_id%TYPE;
47:

Line 46: l_org_param_id hri_org_params.org_param_id%TYPE;

42: cursor c_next is
43: select hri_org_params_s.nextval
44: from dual;
45:
46: l_org_param_id hri_org_params.org_param_id%TYPE;
47:
48: begin
49: open c_next;
50: fetch c_next into l_org_param_id;

Line 122: l_org_param_id hri_org_params.org_param_id%TYPE := null;

118: function GetOrgParamID
119: return Number is
120:
121: l_ost_id Number;
122: l_org_param_id hri_org_params.org_param_id%TYPE := null;
123:
124: begin
125:
126: -- Added by S.Bhattal, version 115.4, 01-OCT-1999

Line 169: from hri_org_params bop

165: , cp_org_id Number
166: , cp_orgprc Varchar2 )
167: is
168: select bop.org_param_id
169: from hri_org_params bop
170: where bop.organization_structure_id = cp_ost_id
171: and bop.organization_id = cp_org_id
172: and bop.organization_process = cp_orgprc;
173:

Line 178: l_org_param_id hri_org_params.org_param_id%TYPE := null;

174: l_ost_id Number := p_organization_structure_id;
175: l_org_id Number := p_organization_id;
176: l_orgprc Varchar2(4) := p_organization_process;
177:
178: l_org_param_id hri_org_params.org_param_id%TYPE := null;
179:
180: begin
181: if (l_org_id = -1)
182: then

Line 339: l_org_param_id hri_org_params.org_param_id%TYPE;

335: l_osv_id Number := GetOrgStructureVersionID (p_organization_structure_id);
336: l_org_id Number := p_organization_id;
337: l_orgprc Varchar2(4) := p_organization_process;
338: --
339: l_org_param_id hri_org_params.org_param_id%TYPE;
340: --
341: begin
342: --
343: --------------------------------------------------------------------

Line 346: -- sequence hri_org_params_s to be used as a primary key for the master

342: --
343: --------------------------------------------------------------------
344: --
345: -- This call to GetNextOrgParamID gets the next org param id from the
346: -- sequence hri_org_params_s to be used as a primary key for the master
347: -- table hri_org_params and part of primary key for the detail table
348: -- hri_org_param_list
349: --
350: --------------------------------------------------------------------

Line 347: -- table hri_org_params and part of primary key for the detail table

343: --------------------------------------------------------------------
344: --
345: -- This call to GetNextOrgParamID gets the next org param id from the
346: -- sequence hri_org_params_s to be used as a primary key for the master
347: -- table hri_org_params and part of primary key for the detail table
348: -- hri_org_param_list
349: --
350: --------------------------------------------------------------------
351: --

Line 356: -- Create the master record in hri_org_params

352: l_org_param_id := GetNextOrgParamID;
353: --
354: --------------------------------------------------------------------
355: --
356: -- Create the master record in hri_org_params
357: --
358: --------------------------------------------------------------------
359: --
360:

Line 366: insert into hri_org_params

362: /* added exception handler to write exception to conc. log file */
363:
364: begin
365:
366: insert into hri_org_params
367: ( org_param_id
368: , organization_structure_id
369: , organization_id
370: , organization_process )

Line 382: 'HrBisOrgParams - Failed on insert into hri_org_params table: ');

378: when others then
379: fnd_file.put_line(fnd_file.log,
380: '----------------------------------------------------------- ');
381: fnd_file.put_line(fnd_file.log,
382: 'HrBisOrgParams - Failed on insert into hri_org_params table: ');
383: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);
384: fnd_file.put_line(fnd_file.log,'org_param_id = '|| l_org_param_id);
385: fnd_file.put_line(fnd_file.log,'organization_structure_id = '
386: || p_organization_structure_id);

Line 481: -- procedure is to populate the hri_org_params and hri_org_param_list tables

477: --
478: -- This procedure is the main entry point to this package. This procedure
479: -- will need to be called by the concurrent manager on a regular basis or
480: -- every time the organisation hierarchy is changed. The purpose of this
481: -- procedure is to populate the hri_org_params and hri_org_param_list tables
482: -- which are used in many HRMS BIS reports to select organisation
483: -- hierarchies.
484: --
485: --------------------------------------------------------------------------

Line 546: -- delete from hri_org_params;

542: -- delete from hri_org_param_list;
543: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_ORG_PARAM_LIST';
544: EXECUTE IMMEDIATE(l_sql_stmt);
545: --
546: -- delete from hri_org_params;
547: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_ORG_PARAMS';
548: EXECUTE IMMEDIATE(l_sql_stmt);
549: --
550: END IF;

Line 547: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_ORG_PARAMS';

543: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_ORG_PARAM_LIST';
544: EXECUTE IMMEDIATE(l_sql_stmt);
545: --
546: -- delete from hri_org_params;
547: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_ORG_PARAMS';
548: EXECUTE IMMEDIATE(l_sql_stmt);
549: --
550: END IF;
551: --

Line 573: -- hri_org_params

569: loop
570: --
571: -- The following calls to LoadOrgHierarchy are to populate the tables:
572: -- hri_org_param_list
573: -- hri_org_params
574: -- For each row returned by the c_elements cursor a call is made to the
575: -- LoadOrgHierarchy procedure for each different type of organization
576: -- process (SINR, ISNR, SIRO, ISRO).
577: -- These process types are described below.

Line 601: -- hri_org_params:

597: -- This should result in something like the following records being
598: -- inserted into our org tables (N.B. These are not supposed to be
599: -- exact records as I am using letters in place of numbers):
600: --
601: -- hri_org_params:
602: -- +-------------+-------------------------+---------------+---------+
603: -- |ORG_PARAM_ID |ORGANIZATION_STRUCTURE_ID|ORGANIZATION_ID| PROCESS |
604: -- +-------------+-------------------------+---------------+---------+
605: -- |33 (for e.g.)|3(for e.g.) | A | SINR |

Line 631: -- hri_org_params:

627: -- This should result in something like the following records being
628: -- inserted into our org tables (N.B. These are not supposed to be exact
629: -- records as I am using letters in place of numbers):
630: --
631: -- hri_org_params:
632: -- +-------------+-------------------------+---------------+---------+
633: -- |ORG_PARAM_ID |ORGANIZATION_STRUCTURE_ID|ORGANIZATION_ID| PROCESS |
634: -- +-------------+-------------------------+---------------+---------+
635: -- |34 (for e.g.)|3(for e.g.) | A | ISNR |

Line 670: -- hri_org_params:

666: -- This should result in something like the following records being
667: -- inserted into our org tables (N.B. These are not supposed to be exact
668: -- records as I am using letters in place of numbers):
669: --
670: -- hri_org_params:
671: -- +-------------+-------------------------+---------------+---------+
672: -- |ORG_PARAM_ID |ORGANIZATION_STRUCTURE_ID|ORGANIZATION_ID| PROCESS |
673: -- +-------------+-------------------------+---------------+---------+
674: -- |35 (for e.g.)|3(for e.g.) | A | ISNR |

Line 713: -- hri_org_params:

709: -- This should result in something like the following records being
710: -- inserted into our org tables (N.B. These are not supposed to be exact
711: -- records as I am using letters in place of numbers):
712: --
713: -- hri_org_params:
714: -- +-------------+-------------------------+---------------+---------+
715: -- |ORG_PARAM_ID |ORGANIZATION_STRUCTURE_ID|ORGANIZATION_ID| PROCESS |
716: -- +-------------+-------------------------+---------------+---------+
717: -- |35 (for e.g.)|3(for e.g.) | A | ISNR |

Line 789: delete from hri_org_params;

785: retcode := sqlcode;
786: --
787: delete from hri_org_param_list;
788: --
789: delete from hri_org_params;
790: --
791: fnd_file.put_line(fnd_file.log,sqlerrm||' '||sqlcode);
792: --
793: end LoadAllHierarchies;