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 PSB_ATTRIBUTE_VALUES

Line 757: lp_attribute_value psb_attribute_values.attribute_value%TYPE;

753: l_job_id_flex_num number;
754: l_application_column_name varchar2(30);
755: l_definition_type varchar2(30);
756: --UTF8 changes for Bug No : 2615261
757: lp_attribute_value psb_attribute_values.attribute_value%TYPE;
758: l_attribute_id number;
759: l_attribute_type_id number;
760: l_attribute_name varchar2(30);
761: l_attribute_value_id number;

Line 763: l_attribute_value psb_attribute_values.attribute_value%TYPE;

759: l_attribute_type_id number;
760: l_attribute_name varchar2(30);
761: l_attribute_value_id number;
762: --UTF8 changes for Bug No : 2615261
763: l_attribute_value psb_attribute_values.attribute_value%TYPE;
764: l_position_assignment_id number := 0;
765:
766: l_select_tab varchar2(30);
767: l_select_key varchar2(30);

Line 846: FROM psb_attribute_values

842: where organization_id = p_organization_id;
843:
844: Cursor C_pos_values is
845: Select attribute_value_id
846: FROM psb_attribute_values
847: WHERE attribute_id = l_attribute_id
848: AND decode(l_definition_type, 'DFF',hr_value_id,
849: attribute_value) = lp_attribute_value
850: AND data_extract_id = p_data_extract_id;

Line 1321: -- AND attribute_value FROM psb_attribute_values table.

1317:
1318: IF (l_value_table_flag = 'Y') THEN
1319:
1320: -- Find the attribute_value_id based on the current attribute_name
1321: -- AND attribute_value FROM psb_attribute_values table.
1322:
1323: FOR C_pos_value_rec in C_pos_values
1324: LOOP
1325: l_attribute_value_id := C_pos_value_rec.attribute_value_id;

Line 1335: -- Insert the new value in PSB_ATTRIBUTE_VALUES

1331: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1332: l_creation_date := sysDATE;
1333: l_created_by := FND_GLOBAL.USER_ID;
1334:
1335: -- Insert the new value in PSB_ATTRIBUTE_VALUES
1336: select psb_attribute_values_s.nextval into
1337: l_attribute_value_id from dual;
1338:
1339: PSB_ATTRIBUTE_VALUES_PVT.INSERT_ROW

Line 1336: select psb_attribute_values_s.nextval into

1332: l_creation_date := sysDATE;
1333: l_created_by := FND_GLOBAL.USER_ID;
1334:
1335: -- Insert the new value in PSB_ATTRIBUTE_VALUES
1336: select psb_attribute_values_s.nextval into
1337: l_attribute_value_id from dual;
1338:
1339: PSB_ATTRIBUTE_VALUES_PVT.INSERT_ROW
1340: ( p_api_version => 1.0,

Line 1339: PSB_ATTRIBUTE_VALUES_PVT.INSERT_ROW

1335: -- Insert the new value in PSB_ATTRIBUTE_VALUES
1336: select psb_attribute_values_s.nextval into
1337: l_attribute_value_id from dual;
1338:
1339: PSB_ATTRIBUTE_VALUES_PVT.INSERT_ROW
1340: ( p_api_version => 1.0,
1341: p_init_msg_lISt => NULL,
1342: p_commit => NULL,
1343: p_validation_level => NULL,

Line 8487: lr_attribute_value psb_attribute_values.attribute_value%TYPE;

8483: l_msg_data varchar2(2000);
8484: l_status varchar2(1);
8485: lr_attribute_id number;
8486: --UTF8 changes for Bug No : 2615261
8487: lr_attribute_value psb_attribute_values.attribute_value%TYPE;
8488: l_attr_dummy number := 1;
8489: l_attribute_name varchar2(30);
8490: --UTF8 changes for Bug No : 2615261
8491: l_attribute_value psb_attribute_values.attribute_value%TYPE;

Line 8491: l_attribute_value psb_attribute_values.attribute_value%TYPE;

8487: lr_attribute_value psb_attribute_values.attribute_value%TYPE;
8488: l_attr_dummy number := 1;
8489: l_attribute_name varchar2(30);
8490: --UTF8 changes for Bug No : 2615261
8491: l_attribute_value psb_attribute_values.attribute_value%TYPE;
8492: l_attribute_value_id NUMBER;
8493: l_restart_attribute_value_id number := 0;
8494: l_fin_attribute_value_id number := 0;
8495: l_attr_val_ctr number := 0;

Line 8503: FROM psb_attribute_values_i b, psb_attributes_vl a

8499:
8500: Cursor C_Attrval IS
8501: Select b.attribute_value_id,b.attribute_id,
8502: a.name, b.attribute_value,b.description,b.value_id
8503: FROM psb_attribute_values_i b, psb_attributes_vl a
8504: WHERE data_extract_id = p_data_extract_id
8505: AND b.attribute_id = a.attribute_id
8506: AND b.attribute_value_id > l_restart_attribute_value_id
8507: order by b.attribute_value_id;

Line 8511: FROM psb_attribute_values

8507: order by b.attribute_value_id;
8508:
8509: Cursor C_ref_attr IS
8510: Select attribute_value_id
8511: FROM psb_attribute_values
8512: WHERE attribute_id = lr_attribute_id
8513: AND attribute_value = lr_attribute_value
8514: AND data_extract_id = p_data_extract_id;
8515:

Line 8552: p_process => 'PSB Attribute Values',

8548: p_return_status => l_return_status,
8549: p_msg_count => l_msg_count,
8550: p_msg_data => l_msg_data,
8551: p_data_extract_id => p_data_extract_id,
8552: p_process => 'PSB Attribute Values',
8553: p_status => l_status,
8554: p_restart_id => l_restart_attribute_value_id
8555: );
8556:

Line 8580: PSB_ATTRIBUTE_VALUES_PVT.UPDATE_ROW

8576:
8577: FOR C_ref_attr_rec in C_ref_attr
8578: LOOP
8579: l_attr_dummy := 1;
8580: PSB_ATTRIBUTE_VALUES_PVT.UPDATE_ROW
8581: ( p_api_version => 1.0,
8582: p_init_msg_lISt => NULL,
8583: p_commit => NULL,
8584: p_validation_level => NULL,

Line 8650: PSB_ATTRIBUTE_VALUES_PVT.UPDATE_ROW

8646: l_attribute_value_id := c_ref_attr_rec.attribute_value_id;
8647: END LOOP;
8648:
8649: IF l_attribute_value_id IS NOT NULL THEN
8650: PSB_ATTRIBUTE_VALUES_PVT.UPDATE_ROW
8651: ( p_api_version => 1.0,
8652: p_init_msg_lISt => NULL,
8653: p_commit => NULL,
8654: p_validation_level => NULL,

Line 8702: PSB_ATTRIBUTE_VALUES_PVT.INSERT_ROW

8698: );
8699:
8700: ELSE
8701:
8702: PSB_ATTRIBUTE_VALUES_PVT.INSERT_ROW
8703: ( p_api_version => 1.0,
8704: p_init_msg_lISt => NULL,
8705: p_commit => NULL,
8706: p_validation_level => NULL,

Line 8766: p_process => 'PSB Attribute Values',

8762: p_msg_count => l_msg_count,
8763: p_msg_data => l_msg_data,
8764: p_data_extract_id => p_data_extract_id,
8765: p_extract_method => p_extract_method,
8766: p_process => 'PSB Attribute Values',
8767: p_restart_id => C_Attribute_Rec.attribute_value_id
8768: );
8769:
8770: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 8787: p_process => 'PSB Attribute Values',

8783: p_msg_count => l_msg_count,
8784: p_msg_data => l_msg_data,
8785: p_data_extract_id => p_data_extract_id,
8786: p_extract_method => p_extract_method,
8787: p_process => 'PSB Attribute Values',
8788: p_restart_id => l_fin_attribute_value_id
8789: );
8790:
8791: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 8802: p_process => 'PSB Attribute Values'

8798: p_msg_count => l_msg_count,
8799: p_msg_data => l_msg_data,
8800: p_data_extract_id => p_data_extract_id,
8801: p_extract_method => p_extract_method,
8802: p_process => 'PSB Attribute Values'
8803: );
8804:
8805: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8806: RAISE FND_API.G_EXC_ERROR;

Line 9015: lp_attribute_value psb_attribute_values.attribute_value%TYPE;

9011: l_msg_data varchar2(2000);
9012: l_position_assignment_id number;
9013: lp_attribute_name varchar2(30);
9014: --UTF8 changes for Bug No : 2615261
9015: lp_attribute_value psb_attribute_values.attribute_value%TYPE;
9016: lp_position_id number;
9017: l_attribute_id number;
9018: l_attribute_value_id number;
9019: --UTF8 changes for Bug No : 2615261

Line 9020: l_attribute_value psb_attribute_values.attribute_value%TYPE;

9016: lp_position_id number;
9017: l_attribute_id number;
9018: l_attribute_value_id number;
9019: --UTF8 changes for Bug No : 2615261
9020: l_attribute_value psb_attribute_values.attribute_value%TYPE;
9021: lr_attribute_id number;
9022: lr_attribute_value_id number;
9023: --UTF8 changes for Bug No : 2615261
9024: lr_attribute_value psb_attribute_values.attribute_value%TYPE;

Line 9024: lr_attribute_value psb_attribute_values.attribute_value%TYPE;

9020: l_attribute_value psb_attribute_values.attribute_value%TYPE;
9021: lr_attribute_id number;
9022: lr_attribute_value_id number;
9023: --UTF8 changes for Bug No : 2615261
9024: lr_attribute_value psb_attribute_values.attribute_value%TYPE;
9025: lr_position_id number;
9026: lm_position_assignment_id number;
9027: lr_max_dummy number := 0;
9028: lp_max_flag varchar2(1);

Line 9056: FROM psb_attribute_values

9052: WHERE set_of_books_id = p_set_of_books_id;
9053:
9054: Cursor C_pos_values IS
9055: Select attribute_value_id
9056: FROM psb_attribute_values
9057: WHERE attribute_id = l_attribute_id
9058: AND decode(l_definition_type, 'DFF',hr_value_id,
9059: attribute_value) = lp_attribute_value
9060: AND data_extract_id = p_data_extract_id;

Line 9275: -- AND attribute_value FROM psb_attribute_values table.

9271:
9272: IF (l_value_table_flag = 'Y') THEN
9273:
9274: -- Find the attribute_value_id based on the current attribute_name
9275: -- AND attribute_value FROM psb_attribute_values table.
9276: FOR C_pos_value_rec in C_pos_values
9277: LOOP
9278: l_attribute_value_id := C_pos_value_rec.attribute_value_id;
9279: END LOOP;