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_POSITION_CONTROL_PVT dependencies on PSB_ATTRIBUTE_VALUES

Line 295: select PSB_ATTRIBUTE_VALUES_S.NEXTVAL seq

291:
292: l_return_status VARCHAR2(1);
293:
294: cursor c_attrval_seq is
295: select PSB_ATTRIBUTE_VALUES_S.NEXTVAL seq
296: from dual;
297:
298: cursor c_attrval is
299: select *

Line 300: from PSB_ATTRIBUTE_VALUES a

296: from dual;
297:
298: cursor c_attrval is
299: select *
300: from PSB_ATTRIBUTE_VALUES a
301: where data_extract_id = p_source_data_extract_id
302: and exists
303: (select 1 from PSB_ATTRIBUTES_VL b
304: where b.attribute_id = a.attribute_id

Line 310: from PSB_ATTRIBUTE_VALUES

306: and attribute_value is not null;
307:
308: cursor c_attrval_exists (attrid NUMBER, attrval VARCHAR2) is
309: select attribute_value_id
310: from PSB_ATTRIBUTE_VALUES
311: where attribute_value = attrval
312: and attribute_id = attrid
313: and data_extract_id = p_target_data_extract_id;
314:

Line 337: PSB_ATTRIBUTE_VALUES_PVT.Insert_Row

333: for c_attrval_seq_rec in c_attrval_seq loop
334: l_attribute_value_id := c_attrval_seq_rec.seq;
335: end loop;
336:
337: PSB_ATTRIBUTE_VALUES_PVT.Insert_Row
338: (p_api_version => 1.0,
339: p_return_status => l_return_status,
340: p_msg_count => l_msg_count,
341: p_msg_data => l_msg_data,

Line 395: PSB_ATTRIBUTE_VALUES_PVT.Update_Row

391: else
392: /* Added the else part on 07/26/01. If the attribute value already exists
393: then update the with the current value. Changes done by Siva */
394: begin
395: PSB_ATTRIBUTE_VALUES_PVT.Update_Row
396: (p_api_version => 1.0,
397: p_init_msg_list => null,
398: p_commit => null,
399: p_validation_level => null,

Line 591: from PSB_ATTRIBUTE_VALUES a,

587: and line_sequence_id = lineseqid;
588:
589: cursor c_re_attrval (attrvalid NUMBER) is
590: select a.attribute_value_id
591: from PSB_ATTRIBUTE_VALUES a,
592: PSB_ATTRIBUTE_VALUES b
593: where a.data_extract_id = p_target_data_extract_id
594: and a.attribute_value = b.attribute_value
595: and a.attribute_id = b.attribute_id -- added for Bug#4262388

Line 592: PSB_ATTRIBUTE_VALUES b

588:
589: cursor c_re_attrval (attrvalid NUMBER) is
590: select a.attribute_value_id
591: from PSB_ATTRIBUTE_VALUES a,
592: PSB_ATTRIBUTE_VALUES b
593: where a.data_extract_id = p_target_data_extract_id
594: and a.attribute_value = b.attribute_value
595: and a.attribute_id = b.attribute_id -- added for Bug#4262388
596: and b.attribute_value_id = attrvalid;

Line 3062: TYPE attr_value IS TABLE OF PSB_ATTRIBUTE_VALUES.ATTRIBUTE_VALUE%TYPE;

3058: l_position_ctr NUMBER := 0;
3059:
3060: /*For Bug No : 2434152 Start*/
3061: TYPE num20_arr IS TABLE OF NUMBER(20);
3062: TYPE attr_value IS TABLE OF PSB_ATTRIBUTE_VALUES.ATTRIBUTE_VALUE%TYPE;
3063: TYPE date_arr IS TABLE OF DATE;
3064:
3065: TYPE attr_val_rec IS RECORD (attribute_id num20_arr, attribute_value_id num20_arr,attribute_value attr_value,effective_start_date date_arr,effective_end_date date_arr);
3066: l_attr_val attr_val_rec;

Line 3120: PSB_ATTRIBUTE_VALUES patv

3116: pas.effective_start_date,
3117: pas.effective_end_date
3118: from PSB_POSITION_ASSIGNMENTS pas,
3119: PSB_ATTRIBUTES pat,
3120: PSB_ATTRIBUTE_VALUES patv
3121: where pas.position_id = positionid
3122: and pas.assignment_type = 'ATTRIBUTE'
3123: and ((pas.worksheet_id = p_worksheet_id)
3124: or (worksheet_id is null

Line 3135: from PSB_ATTRIBUTE_VALUES a,

3131: and pas.attribute_value_id = patv.attribute_value_id(+);
3132:
3133: cursor c_re_attrval (attrvalid NUMBER) is
3134: select a.attribute_value_id
3135: from PSB_ATTRIBUTE_VALUES a,
3136: PSB_ATTRIBUTE_VALUES b
3137: where a.data_extract_id = p_target_data_extract_id
3138: and a.attribute_value = b.attribute_value
3139: and a.attribute_id = b.attribute_id -- added for Bug#4262388

Line 3136: PSB_ATTRIBUTE_VALUES b

3132:
3133: cursor c_re_attrval (attrvalid NUMBER) is
3134: select a.attribute_value_id
3135: from PSB_ATTRIBUTE_VALUES a,
3136: PSB_ATTRIBUTE_VALUES b
3137: where a.data_extract_id = p_target_data_extract_id
3138: and a.attribute_value = b.attribute_value
3139: and a.attribute_id = b.attribute_id -- added for Bug#4262388
3140: and b.attribute_value_id = attrvalid;

Line 10908: psb_attribute_values c

10904: cursor c_job(positionid NUMBER) is
10905: select a.attribute_id, a.attribute_value_id, c.attribute_value , hr_value_id
10906: from psb_position_assignments a,
10907: psb_attributes b,
10908: psb_attribute_values c
10909: where a.position_id = positionid
10910: and a.data_extract_id = p_system_data_extract_id -- system_data_extract_id
10911: and a.attribute_id = b.attribute_id
10912: and b.system_attribute_type = 'JOB_CLASS'

Line 10920: psb_attribute_values c

10916: cursor c_org(positionid NUMBER) is
10917: select a.attribute_id, a.attribute_value_id, c.attribute_value , hr_value_id
10918: from psb_position_assignments a,
10919: psb_attributes b,
10920: psb_attribute_values c
10921: where a.position_id = positionid
10922: and a.data_extract_id = p_system_data_extract_id -- system_data_extract_id
10923: and a.attribute_id = b.attribute_id
10924: and b.system_attribute_type = 'ORG'

Line 11991: from psb_attribute_values

11987: begin
11988:
11989: select count(*)
11990: into l_syscount
11991: from psb_attribute_values
11992: where attribute_id = l_sysorg_id;
11993:
11994: select count(*)
11995: into l_usrcount

Line 11996: from psb_attribute_values

11992: where attribute_id = l_sysorg_id;
11993:
11994: select count(*)
11995: into l_usrcount
11996: from psb_attribute_values
11997: where attribute_id = p_attribute_id;
11998:
11999: if l_syscount >= l_usrcount then
12000: begin

Line 12003: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES');

11999: if l_syscount >= l_usrcount then
12000: begin
12001:
12002: /* Number of system org attribute records more than user defined org attribute records */
12003: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES');
12004: Update psb_attribute_values
12005: set attribute_id = l_sysorg_id
12006: where attribute_id = p_attribute_id;
12007:

Line 12004: Update psb_attribute_values

12000: begin
12001:
12002: /* Number of system org attribute records more than user defined org attribute records */
12003: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES');
12004: Update psb_attribute_values
12005: set attribute_id = l_sysorg_id
12006: where attribute_id = p_attribute_id;
12007:
12008: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES_I');

Line 12008: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES_I');

12004: Update psb_attribute_values
12005: set attribute_id = l_sysorg_id
12006: where attribute_id = p_attribute_id;
12007:
12008: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES_I');
12009: Update psb_attribute_values_i
12010: set attribute_id = l_sysorg_id
12011: where attribute_id = p_attribute_id;
12012:

Line 12009: Update psb_attribute_values_i

12005: set attribute_id = l_sysorg_id
12006: where attribute_id = p_attribute_id;
12007:
12008: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES_I');
12009: Update psb_attribute_values_i
12010: set attribute_id = l_sysorg_id
12011: where attribute_id = p_attribute_id;
12012:
12013: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ACCOUNT_POSITION_SET_LINES');

Line 12049: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES');

12045: else
12046: begin
12047:
12048: /* Number of system org attribute records less than user defined org attribute records */
12049: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES');
12050: Update psb_attribute_values
12051: set attribute_id = p_attribute_id
12052: where attribute_id = l_sysorg_id;
12053:

Line 12050: Update psb_attribute_values

12046: begin
12047:
12048: /* Number of system org attribute records less than user defined org attribute records */
12049: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES');
12050: Update psb_attribute_values
12051: set attribute_id = p_attribute_id
12052: where attribute_id = l_sysorg_id;
12053:
12054: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES_I');

Line 12054: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES_I');

12050: Update psb_attribute_values
12051: set attribute_id = p_attribute_id
12052: where attribute_id = l_sysorg_id;
12053:
12054: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES_I');
12055: Update psb_attribute_values_i
12056: set attribute_id = p_attribute_id
12057: where attribute_id = l_sysorg_id;
12058:

Line 12055: Update psb_attribute_values_i

12051: set attribute_id = p_attribute_id
12052: where attribute_id = l_sysorg_id;
12053:
12054: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ATTRIBUTE_VALUES_I');
12055: Update psb_attribute_values_i
12056: set attribute_id = p_attribute_id
12057: where attribute_id = l_sysorg_id;
12058:
12059: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ACCOUNT_POSITION_SET_LINES');

Line 12550: from PSB_ATTRIBUTE_VALUES a,

12546: where line_sequence_id = lineseqid;
12547:
12548: cursor c_re_attrval (attrvalid NUMBER) is
12549: select a.attribute_value_id
12550: from PSB_ATTRIBUTE_VALUES a,
12551: PSB_ATTRIBUTE_VALUES b
12552: where a.data_extract_id = p_target_data_extract_id
12553: and a.attribute_value = b.attribute_value
12554: and a.attribute_id = b.attribute_id -- added for Bug#4262388

Line 12551: PSB_ATTRIBUTE_VALUES b

12547:
12548: cursor c_re_attrval (attrvalid NUMBER) is
12549: select a.attribute_value_id
12550: from PSB_ATTRIBUTE_VALUES a,
12551: PSB_ATTRIBUTE_VALUES b
12552: where a.data_extract_id = p_target_data_extract_id
12553: and a.attribute_value = b.attribute_value
12554: and a.attribute_id = b.attribute_id -- added for Bug#4262388
12555: and b.attribute_value_id = attrvalid;

Line 12565: from PSB_ATTRIBUTE_VALUES

12561: and account_position_set_id = possetid;
12562:
12563: cursor c_possetlineval_exists (lineseqid NUMBER, attr_val_id NUMBER) is
12564: select attribute_value_id
12565: from PSB_ATTRIBUTE_VALUES
12566: where attribute_value_id = attr_val_id
12567: and attribute_value in
12568: (select a.attribute_value
12569: from PSB_ATTRIBUTE_VALUES a,

Line 12569: from PSB_ATTRIBUTE_VALUES a,

12565: from PSB_ATTRIBUTE_VALUES
12566: where attribute_value_id = attr_val_id
12567: and attribute_value in
12568: (select a.attribute_value
12569: from PSB_ATTRIBUTE_VALUES a,
12570: PSB_POSITION_SET_LINE_VALUES b
12571: where a.attribute_value_id = b.attribute_value_id
12572: and b.line_sequence_id = lineseqid);
12573: