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 DBMS_SQL

Line 993: v_cursorid := dbms_sql.open_cursor;

989:
990: --hr_utility.set_location(' Attribute Struct '||
991: -- l_definition_structure,666);
992:
993: v_cursorid := dbms_sql.open_cursor;
994: if (l_definition_structure = 'Job Flexfield') then
995: l_sql_stmt := 'Select '||l_application_column_name||
996: ' From Per_jobs,per_job_definitions '||
997: ' Where per_jobs.job_id = '||p_job_id||

Line 1001: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);

997: ' Where per_jobs.job_id = '||p_job_id||
998: ' and per_jobs.job_definition_id = '||
999: ' per_job_definitions.job_definition_id';
1000:
1001: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
1002: dbms_sql.define_column(v_cursorid,1,v_segment,80);
1003: elsif (l_definition_structure = 'Position Flexfield') then
1004: if (p_position_id = FND_API.G_MISS_NUM) then
1005: l_select_tab := 'PQH_POSITION_TRANSACTIONS';

Line 1002: dbms_sql.define_column(v_cursorid,1,v_segment,80);

998: ' and per_jobs.job_definition_id = '||
999: ' per_job_definitions.job_definition_id';
1000:
1001: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
1002: dbms_sql.define_column(v_cursorid,1,v_segment,80);
1003: elsif (l_definition_structure = 'Position Flexfield') then
1004: if (p_position_id = FND_API.G_MISS_NUM) then
1005: l_select_tab := 'PQH_POSITION_TRANSACTIONS';
1006: l_select_key := 'POSITION_TRANSACTION_ID';

Line 1023: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);

1019: ' :v_param_value and '||
1020: l_select_tab||'.'||'position_definition_id = '||
1021: ' per_position_definitions.position_definition_id';
1022:
1023: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
1024: dbms_sql.bind_variable(v_cursorid,':v_param_value',l_param_value);
1025: /*For Bug No : 2991818 End*/
1026: dbms_sql.define_column(v_cursorid,1,v_segment,80);
1027:

Line 1024: dbms_sql.bind_variable(v_cursorid,':v_param_value',l_param_value);

1020: l_select_tab||'.'||'position_definition_id = '||
1021: ' per_position_definitions.position_definition_id';
1022:
1023: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
1024: dbms_sql.bind_variable(v_cursorid,':v_param_value',l_param_value);
1025: /*For Bug No : 2991818 End*/
1026: dbms_sql.define_column(v_cursorid,1,v_segment,80);
1027:
1028: elsif (l_definition_structure = 'Grade Flexfield') then

Line 1026: dbms_sql.define_column(v_cursorid,1,v_segment,80);

1022:
1023: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
1024: dbms_sql.bind_variable(v_cursorid,':v_param_value',l_param_value);
1025: /*For Bug No : 2991818 End*/
1026: dbms_sql.define_column(v_cursorid,1,v_segment,80);
1027:
1028: elsif (l_definition_structure = 'Grade Flexfield') then
1029: l_sql_stmt := 'Select '||l_application_column_name||
1030: ' From Per_grades,per_grade_definitions '||

Line 1034: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);

1030: ' From Per_grades,per_grade_definitions '||
1031: ' Where per_grades.grade_id = '||p_entry_grade_id||
1032: ' and per_grades.grade_definition_id = '||
1033: ' per_grade_definitions.grade_definition_id';
1034: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
1035: dbms_sql.define_column(v_cursorid,1,v_segment,80);
1036: end if;
1037: v_dummy := DBMS_SQL.EXECUTE(v_cursorid);
1038:

Line 1035: dbms_sql.define_column(v_cursorid,1,v_segment,80);

1031: ' Where per_grades.grade_id = '||p_entry_grade_id||
1032: ' and per_grades.grade_definition_id = '||
1033: ' per_grade_definitions.grade_definition_id';
1034: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
1035: dbms_sql.define_column(v_cursorid,1,v_segment,80);
1036: end if;
1037: v_dummy := DBMS_SQL.EXECUTE(v_cursorid);
1038:
1039: loop

Line 1037: v_dummy := DBMS_SQL.EXECUTE(v_cursorid);

1033: ' per_grade_definitions.grade_definition_id';
1034: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
1035: dbms_sql.define_column(v_cursorid,1,v_segment,80);
1036: end if;
1037: v_dummy := DBMS_SQL.EXECUTE(v_cursorid);
1038:
1039: loop
1040: v_segment := '';
1041: if DBMS_SQL.FETCH_ROWS(v_cursorid) = 0 then

Line 1041: if DBMS_SQL.FETCH_ROWS(v_cursorid) = 0 then

1037: v_dummy := DBMS_SQL.EXECUTE(v_cursorid);
1038:
1039: loop
1040: v_segment := '';
1041: if DBMS_SQL.FETCH_ROWS(v_cursorid) = 0 then
1042: exit;
1043: end if;
1044: dbms_sql.column_value(v_cursorid,1,v_segment);
1045: lp_attribute_value := v_segment;

Line 1044: dbms_sql.column_value(v_cursorid,1,v_segment);

1040: v_segment := '';
1041: if DBMS_SQL.FETCH_ROWS(v_cursorid) = 0 then
1042: exit;
1043: end if;
1044: dbms_sql.column_value(v_cursorid,1,v_segment);
1045: lp_attribute_value := v_segment;
1046: end loop;
1047:
1048: --hr_utility.set_location('Attribute Success'||lp_attribute_value,666);

Line 1068: if (dbms_sql.IS_OPEN(v_dcursorid)) then

1064: l_select_key := 'POSITION_ID';
1065: l_param_value := p_position_id;
1066: end if;
1067:
1068: if (dbms_sql.IS_OPEN(v_dcursorid)) then
1069: dbms_sql.close_cursor(v_dcursorid);
1070: end if;
1071:
1072: For C_dff_rec in C_dff_33

Line 1069: dbms_sql.close_cursor(v_dcursorid);

1065: l_param_value := p_position_id;
1066: end if;
1067:
1068: if (dbms_sql.IS_OPEN(v_dcursorid)) then
1069: dbms_sql.close_cursor(v_dcursorid);
1070: end if;
1071:
1072: For C_dff_rec in C_dff_33
1073: Loop

Line 1091: v_dcursorid := dbms_sql.open_cursor;

1087: - instr(Attr_type_rec.select_table,' ',1) + 1)))
1088: into l_alias1
1089: from dual;
1090: end;
1091: v_dcursorid := dbms_sql.open_cursor;
1092: /* For Bug No. 2991818 Start */
1093: d_sql_stmt := 'Select '||l_alias1||'.'
1094: ||l_application_column_name||
1095: ' From '||l_select_tab||' '||

Line 1104: dbms_sql.parse(v_dcursorid,d_sql_stmt,dbms_sql.v7);

1100: if (Attr_type_rec.select_where is not null) then
1101: d_sql_stmt := d_sql_stmt||' and '||Attr_type_rec.select_where;
1102: end if;
1103:
1104: dbms_sql.parse(v_dcursorid,d_sql_stmt,dbms_sql.v7);
1105: dbms_sql.bind_variable(v_dcursorid,':v_param_value',
1106: l_param_value);
1107: /*For Bug No : 2991818 End*/
1108: dbms_sql.define_column(v_dcursorid,1,v_dsegment,80);

Line 1105: dbms_sql.bind_variable(v_dcursorid,':v_param_value',

1101: d_sql_stmt := d_sql_stmt||' and '||Attr_type_rec.select_where;
1102: end if;
1103:
1104: dbms_sql.parse(v_dcursorid,d_sql_stmt,dbms_sql.v7);
1105: dbms_sql.bind_variable(v_dcursorid,':v_param_value',
1106: l_param_value);
1107: /*For Bug No : 2991818 End*/
1108: dbms_sql.define_column(v_dcursorid,1,v_dsegment,80);
1109:

Line 1108: dbms_sql.define_column(v_dcursorid,1,v_dsegment,80);

1104: dbms_sql.parse(v_dcursorid,d_sql_stmt,dbms_sql.v7);
1105: dbms_sql.bind_variable(v_dcursorid,':v_param_value',
1106: l_param_value);
1107: /*For Bug No : 2991818 End*/
1108: dbms_sql.define_column(v_dcursorid,1,v_dsegment,80);
1109:
1110:
1111: v_ddummy := DBMS_SQL.EXECUTE(v_dcursorid);
1112:

Line 1111: v_ddummy := DBMS_SQL.EXECUTE(v_dcursorid);

1107: /*For Bug No : 2991818 End*/
1108: dbms_sql.define_column(v_dcursorid,1,v_dsegment,80);
1109:
1110:
1111: v_ddummy := DBMS_SQL.EXECUTE(v_dcursorid);
1112:
1113: loop
1114:
1115: if DBMS_SQL.FETCH_ROWS(v_dcursorid) = 0 then

Line 1115: if DBMS_SQL.FETCH_ROWS(v_dcursorid) = 0 then

1111: v_ddummy := DBMS_SQL.EXECUTE(v_dcursorid);
1112:
1113: loop
1114:
1115: if DBMS_SQL.FETCH_ROWS(v_dcursorid) = 0 then
1116: exit;
1117: end if;
1118:
1119: dbms_sql.column_value(v_dcursorid,1,v_dsegment);

Line 1119: dbms_sql.column_value(v_dcursorid,1,v_dsegment);

1115: if DBMS_SQL.FETCH_ROWS(v_dcursorid) = 0 then
1116: exit;
1117: end if;
1118:
1119: dbms_sql.column_value(v_dcursorid,1,v_dsegment);
1120: lp_attribute_value := v_dsegment;
1121: end loop;
1122:
1123: end if;

Line 1144: if dbms_sql.is_open(v_qcursorid) then

1140: l_select_key := 'POSITION_ID';
1141: l_param_value := p_position_id;
1142: end if;
1143:
1144: if dbms_sql.is_open(v_qcursorid) then
1145: dbms_sql.close_cursor(v_qcursorid);
1146: end if;
1147:
1148: l_lookup_type := Attr_type_rec.name;

Line 1145: dbms_sql.close_cursor(v_qcursorid);

1141: l_param_value := p_position_id;
1142: end if;
1143:
1144: if dbms_sql.is_open(v_qcursorid) then
1145: dbms_sql.close_cursor(v_qcursorid);
1146: end if;
1147:
1148: l_lookup_type := Attr_type_rec.name;
1149:

Line 1160: v_qcursorid := dbms_sql.open_cursor;

1156: from dual;
1157: end;
1158:
1159:
1160: v_qcursorid := dbms_sql.open_cursor;
1161: /* For Bug No. 2991818 Start */
1162: q_sql_stmt := 'Select a.meaning '||
1163: ' From Fnd_Common_lookups a , '||
1164: l_select_tab||' '||l_alias1||

Line 1176: dbms_sql.parse(v_qcursorid,q_sql_stmt,dbms_sql.v7);

1172: if (Attr_type_rec.select_where is not null) then
1173: q_sql_stmt := q_sql_stmt||' and '||Attr_type_rec.select_where;
1174: end if;
1175:
1176: dbms_sql.parse(v_qcursorid,q_sql_stmt,dbms_sql.v7);
1177: dbms_sql.bind_variable(v_qcursorid,':v_param_value',l_param_value);
1178: /*For Bug No : 2991818 End*/
1179: dbms_sql.define_column(v_qcursorid,1,v_qsegment,80);
1180:

Line 1177: dbms_sql.bind_variable(v_qcursorid,':v_param_value',l_param_value);

1173: q_sql_stmt := q_sql_stmt||' and '||Attr_type_rec.select_where;
1174: end if;
1175:
1176: dbms_sql.parse(v_qcursorid,q_sql_stmt,dbms_sql.v7);
1177: dbms_sql.bind_variable(v_qcursorid,':v_param_value',l_param_value);
1178: /*For Bug No : 2991818 End*/
1179: dbms_sql.define_column(v_qcursorid,1,v_qsegment,80);
1180:
1181: v_qdummy := DBMS_SQL.EXECUTE(v_qcursorid);

Line 1179: dbms_sql.define_column(v_qcursorid,1,v_qsegment,80);

1175:
1176: dbms_sql.parse(v_qcursorid,q_sql_stmt,dbms_sql.v7);
1177: dbms_sql.bind_variable(v_qcursorid,':v_param_value',l_param_value);
1178: /*For Bug No : 2991818 End*/
1179: dbms_sql.define_column(v_qcursorid,1,v_qsegment,80);
1180:
1181: v_qdummy := DBMS_SQL.EXECUTE(v_qcursorid);
1182:
1183: loop

Line 1181: v_qdummy := DBMS_SQL.EXECUTE(v_qcursorid);

1177: dbms_sql.bind_variable(v_qcursorid,':v_param_value',l_param_value);
1178: /*For Bug No : 2991818 End*/
1179: dbms_sql.define_column(v_qcursorid,1,v_qsegment,80);
1180:
1181: v_qdummy := DBMS_SQL.EXECUTE(v_qcursorid);
1182:
1183: loop
1184:
1185: if DBMS_SQL.FETCH_ROWS(v_qcursorid) = 0 then

Line 1185: if DBMS_SQL.FETCH_ROWS(v_qcursorid) = 0 then

1181: v_qdummy := DBMS_SQL.EXECUTE(v_qcursorid);
1182:
1183: loop
1184:
1185: if DBMS_SQL.FETCH_ROWS(v_qcursorid) = 0 then
1186: exit;
1187: end if;
1188:
1189: dbms_sql.column_value(v_qcursorid,1,v_qsegment);

Line 1189: dbms_sql.column_value(v_qcursorid,1,v_qsegment);

1185: if DBMS_SQL.FETCH_ROWS(v_qcursorid) = 0 then
1186: exit;
1187: end if;
1188:
1189: dbms_sql.column_value(v_qcursorid,1,v_qsegment);
1190: lp_attribute_value := v_qsegment;
1191: end loop;
1192:
1193: end if;

Line 1215: if dbms_sql.is_open(v_ocursorid) then

1211: l_select_key := 'POSITION_ID';
1212: l_param_value := p_position_id;
1213: end if;
1214:
1215: if dbms_sql.is_open(v_ocursorid) then
1216: dbms_sql.close_cursor(v_ocursorid);
1217: end if;
1218:
1219: v_ocursorid := dbms_sql.open_cursor;

Line 1216: dbms_sql.close_cursor(v_ocursorid);

1212: l_param_value := p_position_id;
1213: end if;
1214:
1215: if dbms_sql.is_open(v_ocursorid) then
1216: dbms_sql.close_cursor(v_ocursorid);
1217: end if;
1218:
1219: v_ocursorid := dbms_sql.open_cursor;
1220: Begin

Line 1219: v_ocursorid := dbms_sql.open_cursor;

1215: if dbms_sql.is_open(v_ocursorid) then
1216: dbms_sql.close_cursor(v_ocursorid);
1217: end if;
1218:
1219: v_ocursorid := dbms_sql.open_cursor;
1220: Begin
1221: Select ltrim(rtrim(substr(Attr_type_rec.select_table,
1222: instr(Attr_type_rec.select_table,' ',1),
1223: length(Attr_type_rec.select_table)

Line 1239: dbms_sql.parse(v_ocursorid,o_sql_stmt,dbms_sql.v7);

1235: if (Attr_type_rec.select_where is not null) then
1236: o_sql_stmt := o_sql_stmt||' and '||Attr_type_rec.select_where;
1237: end if;
1238:
1239: dbms_sql.parse(v_ocursorid,o_sql_stmt,dbms_sql.v7);
1240: dbms_sql.bind_variable(v_ocursorid,':v_param_value',l_param_value);
1241: /*For Bug No : 2991818 End*/
1242:
1243: if (C_Attribute_Rec.data_type = 'D') then

Line 1240: dbms_sql.bind_variable(v_ocursorid,':v_param_value',l_param_value);

1236: o_sql_stmt := o_sql_stmt||' and '||Attr_type_rec.select_where;
1237: end if;
1238:
1239: dbms_sql.parse(v_ocursorid,o_sql_stmt,dbms_sql.v7);
1240: dbms_sql.bind_variable(v_ocursorid,':v_param_value',l_param_value);
1241: /*For Bug No : 2991818 End*/
1242:
1243: if (C_Attribute_Rec.data_type = 'D') then
1244: dbms_sql.define_column(v_ocursorid,1,v_odate);

Line 1244: dbms_sql.define_column(v_ocursorid,1,v_odate);

1240: dbms_sql.bind_variable(v_ocursorid,':v_param_value',l_param_value);
1241: /*For Bug No : 2991818 End*/
1242:
1243: if (C_Attribute_Rec.data_type = 'D') then
1244: dbms_sql.define_column(v_ocursorid,1,v_odate);
1245: elsif (C_Attribute_Rec.data_type = 'N') then
1246: dbms_sql.define_column(v_ocursorid,1,v_onumber);
1247: elsif (C_Attribute_Rec.data_type = 'C') then
1248: dbms_sql.define_column(v_ocursorid,1,v_osegment,80);

Line 1246: dbms_sql.define_column(v_ocursorid,1,v_onumber);

1242:
1243: if (C_Attribute_Rec.data_type = 'D') then
1244: dbms_sql.define_column(v_ocursorid,1,v_odate);
1245: elsif (C_Attribute_Rec.data_type = 'N') then
1246: dbms_sql.define_column(v_ocursorid,1,v_onumber);
1247: elsif (C_Attribute_Rec.data_type = 'C') then
1248: dbms_sql.define_column(v_ocursorid,1,v_osegment,80);
1249: end if;
1250:

Line 1248: dbms_sql.define_column(v_ocursorid,1,v_osegment,80);

1244: dbms_sql.define_column(v_ocursorid,1,v_odate);
1245: elsif (C_Attribute_Rec.data_type = 'N') then
1246: dbms_sql.define_column(v_ocursorid,1,v_onumber);
1247: elsif (C_Attribute_Rec.data_type = 'C') then
1248: dbms_sql.define_column(v_ocursorid,1,v_osegment,80);
1249: end if;
1250:
1251: v_odummy := DBMS_SQL.EXECUTE(v_ocursorid);
1252:

Line 1251: v_odummy := DBMS_SQL.EXECUTE(v_ocursorid);

1247: elsif (C_Attribute_Rec.data_type = 'C') then
1248: dbms_sql.define_column(v_ocursorid,1,v_osegment,80);
1249: end if;
1250:
1251: v_odummy := DBMS_SQL.EXECUTE(v_ocursorid);
1252:
1253: loop
1254:
1255: if DBMS_SQL.FETCH_ROWS(v_ocursorid) = 0 then

Line 1255: if DBMS_SQL.FETCH_ROWS(v_ocursorid) = 0 then

1251: v_odummy := DBMS_SQL.EXECUTE(v_ocursorid);
1252:
1253: loop
1254:
1255: if DBMS_SQL.FETCH_ROWS(v_ocursorid) = 0 then
1256: exit;
1257: end if;
1258:
1259: if (C_Attribute_Rec.data_type = 'D') then

Line 1261: dbms_sql.column_value(v_ocursorid,1,v_odate);

1257: end if;
1258:
1259: if (C_Attribute_Rec.data_type = 'D') then
1260: begin
1261: dbms_sql.column_value(v_ocursorid,1,v_odate);
1262: v_osegment := fnd_date.date_to_canonical(v_odate);
1263: exception
1264: when OTHERS then -- Bug #4658351: Changed VALUE_ERROR to OTHERS
1265:

Line 1275: dbms_sql.column_value(v_ocursorid,1,v_onumber);

1271:
1272: end;
1273: elsif (C_Attribute_Rec.data_type = 'N') then
1274: begin
1275: dbms_sql.column_value(v_ocursorid,1,v_onumber);
1276: v_osegment := fnd_number.number_to_canonical(v_onumber);
1277: exception
1278: when INVALID_NUMBER then
1279:

Line 1289: dbms_sql.column_value(v_ocursorid,1,v_osegment);

1285:
1286: end;
1287:
1288: elsif (C_Attribute_Rec.data_type = 'C') then
1289: dbms_sql.column_value(v_ocursorid,1,v_osegment);
1290: end if;
1291: lp_attribute_value := v_osegment;
1292: end loop;
1293: end if;