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.PSB_HR_EXTRACT_DATA_PVT dependencies on PSB_ATTRIBUTE_VALUES

Line 3563: lr_attribute_value psb_attribute_values_i.attribute_value%TYPE;

3559: l_status varchar2(1);
3560: l_return_status varchar2(1);
3561: prev_attribute_id number := -1;
3562: --UTF8 changes for Bug No : 2615261
3563: lr_attribute_value psb_attribute_values_i.attribute_value%TYPE;
3564: lr_value_id number := '';
3565: lr_attribute_id number;
3566: l_attr_dummy number := 0;
3567: l_msg_count number;

Line 3585: from psb_attribute_values

3581: where attribute_type_id = l_attribute_type_id;
3582:
3583: Cursor C_Attribute is
3584: Select attribute_value_id
3585: from psb_attribute_values
3586: where attribute_id = lr_attribute_id
3587: and attribute_value = lr_attribute_value
3588: and data_extract_id = p_data_extract_id;
3589:

Line 3774: select psb_attribute_values_s.nextval into

3770: l_attr_dummy := 1;
3771: End Loop;
3772:
3773: if (l_attr_dummy = 0) then
3774: select psb_attribute_values_s.nextval into
3775: l_attribute_value_id from dual;
3776: end if;
3777:
3778:

Line 3779: INSERT INTO PSB_ATTRIBUTE_VALUES_I

3775: l_attribute_value_id from dual;
3776: end if;
3777:
3778:
3779: INSERT INTO PSB_ATTRIBUTE_VALUES_I
3780: (
3781: ATTRIBUTE_VALUE_ID ,
3782: ATTRIBUTE_ID ,
3783: ATTRIBUTE_VALUE ,

Line 3848: select psb_attribute_values_s.nextval into

3844: l_attr_dummy := 1;
3845: End Loop;
3846:
3847: if (l_attr_dummy = 0) then
3848: select psb_attribute_values_s.nextval into
3849: l_attribute_value_id from dual;
3850: end if;
3851:
3852: /* Bug 4075170 Start */

Line 3859: INSERT INTO PSB_ATTRIBUTE_VALUES_I

3855: ||', Atrribute Data Type '||l_data_type
3856: ||', Atrribute Value '||dvalue.value;
3857: /* Bug 4075170 End */
3858:
3859: INSERT INTO PSB_ATTRIBUTE_VALUES_I
3860: (
3861: ATTRIBUTE_VALUE_ID ,
3862: ATTRIBUTE_ID ,
3863: ATTRIBUTE_VALUE ,

Line 3927: select psb_attribute_values_s.nextval into

3923: l_attr_dummy := 1;
3924: End Loop;
3925:
3926: if (l_attr_dummy = 0) then
3927: select psb_attribute_values_s.nextval into
3928: l_attribute_value_id from dual;
3929: end if;
3930:
3931: /* Bug 4075170 Start */

Line 3953: INSERT INTO PSB_ATTRIBUTE_VALUES_I

3949: RAISE_APPLICATION_ERROR(-20001,l_message_text);
3950: end;
3951: end if;
3952:
3953: INSERT INTO PSB_ATTRIBUTE_VALUES_I
3954: (
3955: ATTRIBUTE_VALUE_ID ,
3956: ATTRIBUTE_ID ,
3957: ATTRIBUTE_VALUE ,

Line 4067: select psb_attribute_values_s.nextval into

4063: l_attr_dummy := 1;
4064: End Loop;
4065:
4066: if (l_attr_dummy = 0) then
4067: select psb_attribute_values_s.nextval into
4068: l_attribute_value_id from dual;
4069: end if;
4070:
4071: INSERT INTO PSB_ATTRIBUTE_VALUES_I

Line 4071: INSERT INTO PSB_ATTRIBUTE_VALUES_I

4067: select psb_attribute_values_s.nextval into
4068: l_attribute_value_id from dual;
4069: end if;
4070:
4071: INSERT INTO PSB_ATTRIBUTE_VALUES_I
4072: (
4073: ATTRIBUTE_VALUE_ID ,
4074: ATTRIBUTE_ID ,
4075: ATTRIBUTE_VALUE ,

Line 4148: select psb_attribute_values_s.nextval into

4144: l_attr_dummy := 1;
4145: End Loop;
4146:
4147: if (l_attr_dummy = 0) then
4148: select psb_attribute_values_s.nextval into
4149: l_attribute_value_id from dual;
4150: end if;
4151:
4152: INSERT INTO PSB_ATTRIBUTE_VALUES_I

Line 4152: INSERT INTO PSB_ATTRIBUTE_VALUES_I

4148: select psb_attribute_values_s.nextval into
4149: l_attribute_value_id from dual;
4150: end if;
4151:
4152: INSERT INTO PSB_ATTRIBUTE_VALUES_I
4153: (
4154: ATTRIBUTE_VALUE_ID ,
4155: ATTRIBUTE_ID ,
4156: ATTRIBUTE_VALUE ,

Line 4195: select psb_attribute_values_s.nextval into

4191: l_attr_dummy := 1;
4192: End Loop;
4193:
4194: if (l_attr_dummy = 0) then
4195: select psb_attribute_values_s.nextval into
4196: l_attribute_value_id from dual;
4197: end if;
4198:
4199: INSERT INTO PSB_ATTRIBUTE_VALUES_I

Line 4199: INSERT INTO PSB_ATTRIBUTE_VALUES_I

4195: select psb_attribute_values_s.nextval into
4196: l_attribute_value_id from dual;
4197: end if;
4198:
4199: INSERT INTO PSB_ATTRIBUTE_VALUES_I
4200: (
4201: ATTRIBUTE_VALUE_ID ,
4202: ATTRIBUTE_ID ,
4203: ATTRIBUTE_VALUE ,

Line 6562: elsif (p_process = 'PSB Attribute Values') then

6558: else
6559: l_status := l_sp16_status;
6560: l_restart_id := l_attribute26;
6561: end if;
6562: elsif (p_process = 'PSB Attribute Values') then
6563: if (l_sp5_status <> 'C') then
6564: l_status := 'D';
6565: else
6566: l_status := l_sp17_status;

Line 6713: elsif (p_process = 'PSB Attribute Values') then

6709: elsif (p_process = 'PSB Employees') then
6710: l_attribute25 := p_restart_id;
6711: elsif (p_process = 'PSB Costing') then
6712: l_attribute26 := p_restart_id;
6713: elsif (p_process = 'PSB Attribute Values') then
6714: l_attribute27 := p_restart_id;
6715: elsif (p_process = 'PSB Position Assignments') then
6716: l_attribute28 := p_restart_id;
6717: elsif (p_process = 'PSB Apply Defaults') then

Line 6790: attribute27 = decode(p_process,'PSB Attribute Values',l_attribute27,attribute27),

6786: attribute23 = decode(p_process,'PSB Positions',l_attribute23,attribute23),
6787: attribute24 = decode(p_process,'PSB Elements',l_attribute24,attribute24),
6788: attribute25 = decode(p_process,'PSB Employees',l_attribute25,attribute25),
6789: attribute26 = decode(p_process,'PSB Costing',l_attribute26,attribute26),
6790: attribute27 = decode(p_process,'PSB Attribute Values',l_attribute27,attribute27),
6791: attribute28 = decode(p_process,'PSB Position Assignments',l_attribute28,attribute28),
6792: attribute29 = decode(p_process,'PSB Apply Defaults',l_attribute29,attribute29)
6793: where rowid = l_rowid;
6794:

Line 6958: elsif (p_process = 'PSB Attribute Values') then

6954: elsif (p_process = 'PSB Employees') then
6955: l_sp15_status := 'C';
6956: elsif (p_process = 'PSB Costing') then
6957: l_sp16_status := 'C';
6958: elsif (p_process = 'PSB Attribute Values') then
6959: l_sp17_status := 'C';
6960: elsif (p_process = 'PSB Position Assignments') then
6961: l_sp18_status := 'C';
6962: elsif (p_process = 'PSB Apply Defaults') then

Line 7066: sp17_status = decode(p_process,'PSB Attribute Values','C',sp17_status),

7062: sp13_status = decode(p_process,'PSB Positions','C',sp13_status),
7063: sp14_status = decode(p_process,'PSB Elements','C',sp14_status),
7064: sp15_status = decode(p_process,'PSB Employees','C',sp15_status),
7065: sp16_status = decode(p_process,'PSB Costing','C',sp16_status),
7066: sp17_status = decode(p_process,'PSB Attribute Values','C',sp17_status),
7067: sp18_status = decode(p_process,'PSB Position Assignments','C',sp18_status),
7068: sp19_status = decode(p_process,'PSB Apply Defaults','C',sp19_status),
7069: attribute2 = l_last_update_date
7070: where process_type = 'HR DATA EXTRACT'