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 FND_VSET

Line 3545: kvset fnd_vset.valueset_r;

3541: l_kflex_value_set_id number;
3542: l_dflex_value_set_id number;
3543: l_context_column_name varchar2(30);
3544: l_desc_flex_context_code varchar2(30);
3545: kvset fnd_vset.valueset_r;
3546: kfmt fnd_vset.valueset_dr;
3547: kfound BOOLEAN;
3548: krow NUMBER;
3549: kvalue fnd_vset.value_dr;

Line 3546: kfmt fnd_vset.valueset_dr;

3542: l_dflex_value_set_id number;
3543: l_context_column_name varchar2(30);
3544: l_desc_flex_context_code varchar2(30);
3545: kvset fnd_vset.valueset_r;
3546: kfmt fnd_vset.valueset_dr;
3547: kfound BOOLEAN;
3548: krow NUMBER;
3549: kvalue fnd_vset.value_dr;
3550: dvset fnd_vset.valueset_r;

Line 3549: kvalue fnd_vset.value_dr;

3545: kvset fnd_vset.valueset_r;
3546: kfmt fnd_vset.valueset_dr;
3547: kfound BOOLEAN;
3548: krow NUMBER;
3549: kvalue fnd_vset.value_dr;
3550: dvset fnd_vset.valueset_r;
3551: dfmt fnd_vset.valueset_dr;
3552: dfound BOOLEAN;
3553: drow NUMBER;

Line 3550: dvset fnd_vset.valueset_r;

3546: kfmt fnd_vset.valueset_dr;
3547: kfound BOOLEAN;
3548: krow NUMBER;
3549: kvalue fnd_vset.value_dr;
3550: dvset fnd_vset.valueset_r;
3551: dfmt fnd_vset.valueset_dr;
3552: dfound BOOLEAN;
3553: drow NUMBER;
3554: dvalue fnd_vset.value_dr;

Line 3551: dfmt fnd_vset.valueset_dr;

3547: kfound BOOLEAN;
3548: krow NUMBER;
3549: kvalue fnd_vset.value_dr;
3550: dvset fnd_vset.valueset_r;
3551: dfmt fnd_vset.valueset_dr;
3552: dfound BOOLEAN;
3553: drow NUMBER;
3554: dvalue fnd_vset.value_dr;
3555: vdef_col1 varchar2(100);

Line 3554: dvalue fnd_vset.value_dr;

3550: dvset fnd_vset.valueset_r;
3551: dfmt fnd_vset.valueset_dr;
3552: dfound BOOLEAN;
3553: drow NUMBER;
3554: dvalue fnd_vset.value_dr;
3555: vdef_col1 varchar2(100);
3556: vdef_col2 number;
3557: vdef_col3 date;
3558: vdef_col varchar2(100);

Line 3754: fnd_vset.get_valueset(l_kflex_value_set_id, kvset, kfmt);

3750:
3751: End Loop;
3752:
3753: if (l_kflex_value_set_id is not null) then
3754: fnd_vset.get_valueset(l_kflex_value_set_id, kvset, kfmt);
3755:
3756: if (kvset.validation_type = 'N') then
3757: null;
3758: else

Line 3759: fnd_vset.get_value_init(kvset,TRUE);

3755:
3756: if (kvset.validation_type = 'N') then
3757: null;
3758: else
3759: fnd_vset.get_value_init(kvset,TRUE);
3760: fnd_vset.get_value(kvset, krow, kfound, kvalue);
3761: end if;
3762: WHILE(kfound) LOOP
3763: lr_attribute_id := attribute_rec.attribute_id;

Line 3760: fnd_vset.get_value(kvset, krow, kfound, kvalue);

3756: if (kvset.validation_type = 'N') then
3757: null;
3758: else
3759: fnd_vset.get_value_init(kvset,TRUE);
3760: fnd_vset.get_value(kvset, krow, kfound, kvalue);
3761: end if;
3762: WHILE(kfound) LOOP
3763: lr_attribute_id := attribute_rec.attribute_id;
3764: lr_attribute_value := kvalue.value;

Line 3803: fnd_vset.get_value(kvset, krow, kfound, kvalue);

3799: l_last_updated_by ,
3800: l_last_update_login ,
3801: l_created_by,
3802: l_creation_date);
3803: fnd_vset.get_value(kvset, krow, kfound, kvalue);
3804: END LOOP;
3805: fnd_vset.get_value_end(kvset);
3806: end if;
3807: elsif (attribute_rec.definition_type = 'DFF') then

Line 3805: fnd_vset.get_value_end(kvset);

3801: l_created_by,
3802: l_creation_date);
3803: fnd_vset.get_value(kvset, krow, kfound, kvalue);
3804: END LOOP;
3805: fnd_vset.get_value_end(kvset);
3806: end if;
3807: elsif (attribute_rec.definition_type = 'DFF') then
3808: /* Bug 4075170 Start */
3809: l_debug_info := 'Starting for attribute '||l_attribute_name

Line 3829: fnd_vset.get_valueset(l_dflex_value_set_id, dvset, dfmt);

3825:
3826: End Loop;
3827:
3828: if (l_dflex_value_set_id is not null) then
3829: fnd_vset.get_valueset(l_dflex_value_set_id, dvset, dfmt);
3830: if (dvset.validation_type = 'N') then
3831: null;
3832: else
3833: fnd_vset.get_value_init(dvset, TRUE);

Line 3833: fnd_vset.get_value_init(dvset, TRUE);

3829: fnd_vset.get_valueset(l_dflex_value_set_id, dvset, dfmt);
3830: if (dvset.validation_type = 'N') then
3831: null;
3832: else
3833: fnd_vset.get_value_init(dvset, TRUE);
3834: fnd_vset.get_value(dvset, drow, dfound, dvalue);
3835: end if;
3836: WHILE(dfound) LOOP
3837: lr_attribute_id := attribute_rec.attribute_id;

Line 3834: fnd_vset.get_value(dvset, drow, dfound, dvalue);

3830: if (dvset.validation_type = 'N') then
3831: null;
3832: else
3833: fnd_vset.get_value_init(dvset, TRUE);
3834: fnd_vset.get_value(dvset, drow, dfound, dvalue);
3835: end if;
3836: WHILE(dfound) LOOP
3837: lr_attribute_id := attribute_rec.attribute_id;
3838: lr_attribute_value := dvalue.value;

Line 3891: fnd_vset.get_value(dvset, drow, dfound, dvalue);

3887: l_last_updated_by ,
3888: l_last_update_login ,
3889: l_created_by,
3890: l_creation_date);
3891: fnd_vset.get_value(dvset, drow, dfound, dvalue);
3892: END LOOP;
3893: fnd_vset.get_value_end(dvset);
3894: end if;
3895:

Line 3893: fnd_vset.get_value_end(dvset);

3889: l_created_by,
3890: l_creation_date);
3891: fnd_vset.get_value(dvset, drow, dfound, dvalue);
3892: END LOOP;
3893: fnd_vset.get_value_end(dvset);
3894: end if;
3895:
3896: elsif (attribute_rec.definition_type = 'QC') then
3897: /* Bug 4075170 Start */