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_POPULATE_DATA_PVT dependencies on FND_FLEX_EXT

Line 1617: segs FND_FLEX_EXT.SegmentArray;

1613: l_date_end date;
1614: l_data_extract_id number ;
1615: l_set_of_books_id number;
1616: l_position_id_flex_num number;
1617: segs FND_FLEX_EXT.SegmentArray;
1618: isegs FND_FLEX_EXT.SegmentArray;
1619: l_init_index BINARY_INTEGER;
1620: l_pos_index BINARY_INTEGER;
1621: l_ccid number;

Line 1618: isegs FND_FLEX_EXT.SegmentArray;

1614: l_data_extract_id number ;
1615: l_set_of_books_id number;
1616: l_position_id_flex_num number;
1617: segs FND_FLEX_EXT.SegmentArray;
1618: isegs FND_FLEX_EXT.SegmentArray;
1619: l_init_index BINARY_INTEGER;
1620: l_pos_index BINARY_INTEGER;
1621: l_ccid number;
1622: l_position_id number;

Line 1631: possegs FND_FLEX_EXT.SegmentArray;

1627: l_pos_id_flex_num number;
1628: l_per_index BINARY_INTEGER;
1629: tf BOOLEAN;
1630: nsegs NUMBER;
1631: possegs FND_FLEX_EXT.SegmentArray;
1632: /*For Bug No : 2602027 End*/
1633:
1634: l_return_status varchar2(1);
1635: l_validity_date date := null;

Line 1701: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num,

1697: Loop
1698: l_pos_id_flex_num := C_flex_rec.position_structure;
1699: End Loop;
1700:
1701: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num,
1702: p_position_definition_id, nsegs, segs);
1703: if (tf = FALSE) then
1704: l_msg := FND_MESSAGE.Get;
1705: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');

Line 1962: if not fnd_flex_ext.Get_combination_id

1958:
1959: END LOOP; -- END LOOP ( C_flex_rec in C_flex )
1960:
1961: l_msg := null;
1962: if not fnd_flex_ext.Get_combination_id
1963: ( application_short_name => 'PSB',
1964: key_flex_code => 'BPS',
1965: structure_number => l_position_id_flex_num,
1966: validation_date => sysdate,

Line 1981: l_concat_pos_name := FND_FLEX_EXT.Get_Segs

1977: RAISE FND_API.G_EXC_ERROR;
1978: end if;
1979:
1980: l_concat_pos_name := null;
1981: l_concat_pos_name := FND_FLEX_EXT.Get_Segs
1982: ( application_short_name => 'PSB',
1983: key_flex_code => 'BPS',
1984: structure_number => l_position_id_flex_num,
1985: combination_id => l_ccid

Line 2177: segs FND_FLEX_EXT.SegmentArray;

2173: l_api_version CONSTANT NUMBER := 1.0 ;
2174: --
2175: l_data_extract_id number := 0;
2176: l_position_id_flex_num number;
2177: segs FND_FLEX_EXT.SegmentArray;
2178: l_init_index BINARY_INTEGER;
2179: l_ccid number;
2180: l_position_id number;
2181: -- de by org

Line 2231: possegs FND_FLEX_EXT.SegmentArray;

2227: l_per_index BINARY_INTEGER;
2228: l_pos_index BINARY_INTEGER;
2229: tf BOOLEAN;
2230: nsegs NUMBER;
2231: possegs FND_FLEX_EXT.SegmentArray;
2232: isegs FND_FLEX_EXT.SegmentArray;
2233: /*For Bug No : 2602027 End*/
2234:
2235: cursor c_ws_positions is

Line 2232: isegs FND_FLEX_EXT.SegmentArray;

2228: l_pos_index BINARY_INTEGER;
2229: tf BOOLEAN;
2230: nsegs NUMBER;
2231: possegs FND_FLEX_EXT.SegmentArray;
2232: isegs FND_FLEX_EXT.SegmentArray;
2233: /*For Bug No : 2602027 End*/
2234:
2235: cursor c_ws_positions is
2236: select wpl.position_line_id, wlp.worksheet_id

Line 2325: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, p_position_definition_id, nsegs, segs);

2321: Loop
2322: l_pos_id_flex_num := C_flex_rec.position_structure;
2323: End Loop;
2324:
2325: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, p_position_definition_id, nsegs, segs);
2326:
2327: if (tf = FALSE) then
2328: l_msg := FND_MESSAGE.Get;
2329: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');

Line 2588: if not fnd_flex_ext.Get_combination_id

2584:
2585: END LOOP; -- END LOOP ( C_flex_rec in C_flex )
2586:
2587: l_msg := null;
2588: if not fnd_flex_ext.Get_combination_id
2589: ( application_short_name => 'PSB',
2590: key_flex_code => 'BPS',
2591: structure_number => l_position_id_flex_num,
2592: validation_date => sysdate,

Line 2606: l_concat_pos_name := FND_FLEX_EXT.Get_Segs

2602: RAISE FND_API.G_EXC_ERROR;
2603: end if;
2604:
2605: l_concat_pos_name := null;
2606: l_concat_pos_name := FND_FLEX_EXT.Get_Segs
2607: (application_short_name => 'PSB',
2608: key_flex_code => 'BPS',
2609: structure_number => l_position_id_flex_num,
2610: combination_id => l_ccid);

Line 2847: segs FND_FLEX_EXT.SegmentArray;

2843: l_data_extract_id number := 0;
2844: l_validity_date date := null;
2845: l_set_of_books_id NUMBER;
2846: l_position_id_flex_num number;
2847: segs FND_FLEX_EXT.SegmentArray;
2848: isegs FND_FLEX_EXT.SegmentArray;
2849: l_init_index BINARY_INTEGER;
2850: l_pos_index BINARY_INTEGER;
2851: l_ccid NUMBER;

Line 2848: isegs FND_FLEX_EXT.SegmentArray;

2844: l_validity_date date := null;
2845: l_set_of_books_id NUMBER;
2846: l_position_id_flex_num number;
2847: segs FND_FLEX_EXT.SegmentArray;
2848: isegs FND_FLEX_EXT.SegmentArray;
2849: l_init_index BINARY_INTEGER;
2850: l_pos_index BINARY_INTEGER;
2851: l_ccid NUMBER;
2852: l_position_id NUMBER;

Line 2861: possegs FND_FLEX_EXT.SegmentArray;

2857: l_pos_id_flex_num number;
2858: l_per_index BINARY_INTEGER;
2859: tf BOOLEAN;
2860: nsegs NUMBER;
2861: possegs FND_FLEX_EXT.SegmentArray;
2862: /*For Bug No : 2602027 End*/
2863:
2864: l_return_status varchar2(1);
2865: l_msg_count number;

Line 2967: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, p_position_definition_id, nsegs, segs);

2963: Loop
2964: l_pos_id_flex_num := C_flex_rec.position_structure;
2965: End Loop;
2966:
2967: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, p_position_definition_id, nsegs, segs);
2968: if (tf = FALSE) then
2969: l_msg := FND_MESSAGE.Get;
2970: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
2971: FND_MESSAGE.SET_TOKEN('POSITION_NAME',p_name );

Line 3226: if not fnd_flex_ext.Get_combination_id

3222:
3223: END LOOP; -- END LOOP ( C_flex_rec in C_flex )
3224:
3225: l_msg := null;
3226: if not fnd_flex_ext.Get_combination_id
3227: ( application_short_name => 'PSB',
3228: key_flex_code => 'BPS',
3229: structure_number => l_position_id_flex_num,
3230: validation_date => sysdate,

Line 3247: l_concat_pos_name := FND_FLEX_EXT.Get_Segs

3243: hr_utility.set_location('pos id flex num in '||
3244: l_position_id_flex_num || ' ccid ' || l_ccid ,9867);
3245:
3246: l_concat_pos_name := null;
3247: l_concat_pos_name := FND_FLEX_EXT.Get_Segs
3248: (application_short_name => 'PSB',
3249: key_flex_code => 'BPS',
3250: structure_number => l_position_id_flex_num,
3251: combination_id => l_ccid);

Line 3472: segs FND_FLEX_EXT.SegmentArray;

3468: l_position_id_flex_num number;
3469: l_concat_pos_name varchar2(240);
3470: l_init_index BINARY_INTEGER;
3471: l_ccid number;
3472: segs FND_FLEX_EXT.SegmentArray;
3473:
3474: /*For Bug No : 2602027 Start*/
3475: l_pos_id_flex_num number;
3476: l_per_index BINARY_INTEGER;

Line 3480: possegs FND_FLEX_EXT.SegmentArray;

3476: l_per_index BINARY_INTEGER;
3477: l_pos_index BINARY_INTEGER;
3478: tf BOOLEAN;
3479: nsegs NUMBER;
3480: possegs FND_FLEX_EXT.SegmentArray;
3481: isegs FND_FLEX_EXT.SegmentArray;
3482: /*For Bug No : 2602027 End*/
3483:
3484: Cursor C_pos_trx is

Line 3481: isegs FND_FLEX_EXT.SegmentArray;

3477: l_pos_index BINARY_INTEGER;
3478: tf BOOLEAN;
3479: nsegs NUMBER;
3480: possegs FND_FLEX_EXT.SegmentArray;
3481: isegs FND_FLEX_EXT.SegmentArray;
3482: /*For Bug No : 2602027 End*/
3483:
3484: Cursor C_pos_trx is
3485: Select *

Line 3599: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, p_position_definition_id, nsegs, segs);

3595: Loop
3596: l_pos_id_flex_num := C_flex_rec.position_structure;
3597: End Loop;
3598:
3599: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, p_position_definition_id, nsegs, segs);
3600: if (tf = FALSE) then
3601: l_msg := FND_MESSAGE.Get;
3602: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
3603: FND_MESSAGE.SET_TOKEN('POSITION_NAME',p_name );

Line 3861: if not fnd_flex_ext.Get_combination_id

3857: END LOOP; -- END LOOP ( C_flex_rec in C_flex )
3858:
3859: l_msg := null;
3860:
3861: if not fnd_flex_ext.Get_combination_id
3862: ( application_short_name => 'PSB',
3863: key_flex_code => 'BPS',
3864: structure_number => l_position_id_flex_num,
3865: validation_date => sysdate,

Line 3882: l_concat_pos_name := FND_FLEX_EXT.Get_Segs

3878: hr_utility.set_location('pos id flex num in '||
3879: l_position_id_flex_num || ' ccid ' || l_ccid ,9867);
3880:
3881: l_concat_pos_name := null;
3882: l_concat_pos_name := FND_FLEX_EXT.Get_Segs
3883: (application_short_name => 'PSB',
3884: key_flex_code => 'BPS',
3885: structure_number => l_position_id_flex_num,
3886: combination_id => l_ccid);

Line 4476: l_ccid_val FND_FLEX_EXT.SegmentArray;

4472: TYPE l_elemlink_tbl_type IS TABLE OF l_elemlink_rec_type
4473: INDEX BY BINARY_INTEGER;
4474: --
4475: l_element_link l_elemlink_tbl_type;
4476: l_ccid_val FND_FLEX_EXT.SegmentArray;
4477: l_ccid NUMBER;
4478: l_init_index BINARY_INTEGER;
4479: l_assign_index BINARY_INTEGER;
4480: l_segment_index BINARY_INTEGER;

Line 5428: IF NOT FND_FLEX_EXT.Get_Combination_ID

5424: l_position_name := Pos_Name_Rec.name;
5425: END LOOP;
5426: END IF;
5427:
5428: IF NOT FND_FLEX_EXT.Get_Combination_ID
5429: ( application_short_name => 'SQLGL',
5430: key_flex_code => 'GL#',
5431: structure_number => l_flex_code,
5432: validation_date => sysdate,

Line 5580: segs FND_FLEX_EXT.SegmentArray;

5576: l_last_updated_by number;
5577: l_last_update_login number;
5578: l_creation_date DATE;
5579: l_created_BY number;
5580: segs FND_FLEX_EXT.SegmentArray;
5581: tf boolean;
5582: l_ccid NUMBER;
5583: l_id_flex_num NUMBER;
5584: l_concat_pos_name varchar2(240);

Line 6298: IF NOT FND_FLEX_EXT.Get_Combination_ID

6294: END IF;
6295:
6296: END LOOP; -- END LOOP ( C_flex_rec in C_flex )
6297:
6298: IF NOT FND_FLEX_EXT.Get_Combination_ID
6299: ( application_short_name => 'PSB',
6300: key_flex_code => 'BPS',
6301: structure_number => l_position_i_cache(i).id_flex_num,
6302: validation_date => SYSDATE,

Line 6353: l_concat_pos_name := FND_FLEX_EXT.Get_Segs

6349: END IF;
6350: /* For Bug No: 3066598 End */
6351: l_concat_pos_name := NULL;
6352:
6353: l_concat_pos_name := FND_FLEX_EXT.Get_Segs
6354: (application_short_name => 'PSB',
6355: key_flex_code => 'BPS',
6356: structure_number => l_position_i_cache(i).id_flex_num,
6357: combination_id => l_ccid);

Line 6716: END IF; -- IF NOT FND_FLEX_EXT.Get_Combination_ID

6712: END IF; -- l_vacant_position_flag = 'Y'
6713: prev_hr_position_id := l_position_i_cache(i).hr_position_id;
6714: --
6715: END IF; -- l_position_i_cache(i).update_insert_flag = 'U'
6716: END IF; -- IF NOT FND_FLEX_EXT.Get_Combination_ID
6717:
6718: END LOOP; -- FOR i in 1..l_position_i_cache.count
6719: END IF; -- IF (l_last_hr_position_id <> l_pos_record.hr_position_id
6720: