APPS.PSB_POSITION_ATTRIBUTES_PVT dependencies on PSB_ATTRIBUTES_S

Line 286: UPDATE psb_attributes SET

282:
283: p_return_status := FND_API.G_RET_STS_SUCCESS;
284:
285: -- API body
286: UPDATE psb_attributes SET
287: ATTRIBUTE_ID = p_ATTRIBUTE_ID,
288: BUSINESS_GROUP_ID = p_BUSINESS_GROUP_ID ,
289: NAME = p_NAME ,
290: DISPLAY_IN_WORKSHEET = p_DISPLAY_IN_WORKSHEET,

Line 1024: l_sys_attribute_type psb_attributes.system_attribute_type%TYPE,

1020: Temp_Type VARCHAR2(30);
1021:
1022: /* bug start 3953023 */
1023: Type l_sys_attributes_rec_type IS RECORD (
1024: l_sys_attribute_type psb_attributes.system_attribute_type%TYPE,
1025: l_attribute_name psb_attributes.name%TYPE,
1026: l_display_worksheet psb_attributes.DISPLAY_IN_WORKSHEET%TYPE,
1027: l_display_seq psb_attributes.DISPLAY_SEQUENCE%TYPE,
1028: l_req_import_flg psb_attributes.REQUIRED_FOR_IMPORT_FLAG%TYPE,

Line 1205: (SELECT psb_attributes_s.nextval attribute_id

1201: END LOOP;
1202: END IF;
1203:
1204: FOR l_attribute_id_rec IN
1205: (SELECT psb_attributes_s.nextval attribute_id
1206: FROM dual)
1207: LOOP
1208: l_attribute_id := l_attribute_id_rec.attribute_id;
1209: END LOOP;

Line 1293: select psb_attributes_s.nextval

1289: End;
1290:
1291: if (nvl(Temp_Type,'NULL') <> 'JOB_CLASS') then
1292:
1293: select psb_attributes_s.nextval
1294: into Temp_ID
1295: from dual;
1296:
1297: INSERT INTO PSB_ATTRIBUTES (

Line 1398: select psb_attributes_s.nextval

1394: Temp_ID := NULL;
1395: End;
1396:
1397: if (nvl(Temp_Type, 'NULL') <> 'FTE') then
1398: select psb_attributes_s.nextval
1399: into Temp_ID
1400: from dual;
1401:
1402: INSERT INTO PSB_ATTRIBUTES (

Line 1527: select psb_attributes_s.nextval

1523: , last_update_login = null
1524: where attribute_id = c_org_rec.attribute_id;
1525: End Loop;
1526:
1527: select psb_attributes_s.nextval
1528: into Temp_ID
1529: from dual;
1530:
1531: INSERT INTO PSB_ATTRIBUTES (

Line 1633: select psb_attributes_s.nextval

1629: Temp_ID := NULL;
1630: End;
1631:
1632: if (nvl(Temp_Type, 'NULL') <> 'HIREDATE') then
1633: select psb_attributes_s.nextval
1634: into Temp_ID
1635: from dual;
1636:
1637:

Line 1735: select psb_attributes_s.nextval

1731: Temp_Type := '';
1732: End;
1733:
1734: if (nvl(Temp_Type, 'NULL') <> 'ADJUSTMENT_DATE') then
1735: select psb_attributes_s.nextval
1736: into Temp_ID
1737: from dual;
1738:
1739:

Line 1834: select psb_attributes_s.nextval

1830: Temp_ID := NULL;
1831: End;
1832:
1833: if (nvl(Temp_Type, 'NULL') <> 'DEFAULT_WEEKLY_HOURS') then
1834: select psb_attributes_s.nextval
1835: into Temp_ID
1836: from dual;
1837:
1838:

Line 2059: from PSB_ATTRIBUTES_TL B, FND_LANGUAGES L,PSB_ATTRIBUTES S

2055: B.CREATED_BY,
2056: B.CREATION_DATE,
2057: USERENV('LANG'),
2058: USERENV('LANG')
2059: from PSB_ATTRIBUTES_TL B, FND_LANGUAGES L,PSB_ATTRIBUTES S
2060: where L.INSTALLED_FLAG = 'B'
2061: and B.LANGUAGE = L.LANGUAGE_CODE
2062: and S.attribute_id=B.attribute_id
2063: and not exists