[Home] [Help]
486: end if;
487:
488: if (l_pay_element_id is null) then
489: Select psb_pay_elements_s.nextval INTO l_pay_element_id
490: FROM dual;
491:
492: PSB_PAY_ELEMENTS_PVT.INSERT_ROW
493: ( p_api_version => 1.0,
494: p_init_msg_lISt => NULL,
554: l_created_by := FND_GLOBAL.USER_ID; */
555:
556: Select psb_pay_element_options_s.nextval
557: INTO l_pay_element_option_id
558: FROM dual;
559:
560: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW
561: ( p_api_version => 1.0,
562: p_init_msg_list => NULL,
583:
584:
585: Select psb_pay_element_rates_s.nextval
586: INTO l_pay_element_rate_id
587: FROM dual;
588:
589: For C_Currency_Rec in C_Currency
590: Loop
591: l_currency_code := C_Currency_Rec.currency_code;
1085: instr(Attr_type_rec.select_table,' ',1),
1086: length(Attr_type_rec.select_table)
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||'.'
1152: instr(Attr_type_rec.select_table,' ',1),
1153: length(Attr_type_rec.select_table)
1154: - instr(Attr_type_rec.select_table,' ',1) + 1)))
1155: into l_alias1
1156: from dual;
1157: end;
1158:
1159:
1160: v_qcursorid := dbms_sql.open_cursor;
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)
1224: - instr(Attr_type_rec.select_table,' ',1) + 1))) into l_alias1
1225: from dual;
1226: End;
1227:
1228: /*For Bug No : 2991818 Start*/
1229: o_sql_stmt := 'Select '||
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,
1341: p_init_msg_lISt => NULL,
1992: End loop;
1993:
1994: -- Create new position in PSB
1995: SELECT psb_positions_s.nextval INTO l_position_id
1996: FROM dual;
1997:
1998: PSB_POSITIONS_PVT.INSERT_ROW
1999: (
2000: p_api_version => 1.0,
2183: l_concat_pos_name varchar2(240);
2184:
2185: Cursor C_trn_exist is
2186: Select 'Position Transaction Exists in PSB'
2187: from dual
2188: where exists
2189: (Select 1
2190: from psb_positions
2191: where transaction_id = p_position_transaction_id);
3261: End loop;
3262:
3263: -- Create new position in PSB
3264: select psb_positions_s.nextval INTO l_position_id
3265: from dual;
3266:
3267: hr_utility.set_location('l_position_id '||l_position_id ,9833);
3268: hr_utility.set_location('l_data_extract_id '||l_data_extract_id, 9833);
3269: hr_utility.set_location('l_ccid '||l_ccid ,9833);
6601: /* Bug 3417868 Start */
6602: ELSIF l_position_i_cache(i).update_insert_flag = 'I' THEN
6603: /* Bug 3417868 End */
6604: SELECT psb_positions_s.nextval INTO l_position_id
6605: FROM dual;
6606:
6607: -- bug 4551061 added the in parameter p_availability_status
6608: PSB_POSITIONS_PVT.INSERT_ROW
6609: (
7319: -- Create a pay element.
7320: IF (ln_pay_element_id = 0) THEN
7321:
7322: Select psb_pay_elements_s.nextval INTO ln_pay_element_id
7323: FROM dual;
7324:
7325: PSB_PAY_ELEMENTS_PVT.INSERT_ROW
7326: ( p_api_version => 1.0,
7327: p_init_msg_lISt => NULL,
7594: --
7595: IF (l_extract_method = 'CREATE' or l_employee_dummy = 0) THEN
7596:
7597: Select psb_employees_s.nextval INTO l_employee_id
7598: FROM dual;
7599:
7600: /*For Bug No : 2594575 Start*/
7601: --Stop extracting secured data of employee
7602: --Removed the columns in psb_employees table
8157:
8158: IF (l_option_dummy = 0) THEN
8159: Select psb_pay_element_options_s.nextval
8160: INTO l_pay_element_option_id
8161: FROM dual;
8162:
8163: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW
8164: ( p_api_version => 1.0,
8165: p_init_msg_lISt => NULL,
8218: or (prev_rate_or_payscale_id = -1)) THEN
8219:
8220: Select psb_pay_elements_s.nextval
8221: INTO l_pay_element_id
8222: FROM dual;
8223:
8224: PSB_PAY_ELEMENTS_PVT.INSERT_ROW
8225: ( p_api_version => 1.0,
8226: p_init_msg_lISt => NULL,
8276: END IF;
8277:
8278: Select psb_pay_element_options_s.nextval
8279: INTO l_pay_element_option_id
8280: FROM dual;
8281:
8282: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW
8283: ( p_api_version => 1.0,
8284: p_init_msg_lISt => NULL,
8305:
8306:
8307: Select psb_pay_element_rates_s.nextval
8308: INTO l_pay_element_rate_id
8309: FROM dual;
8310:
8311: PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW
8312: ( p_api_version => 1.0,
8313: p_init_msg_lISt => NULL,