[Home] [Help]
1240: l_option_flag := l_pay_element_rec.option_flag;
1241:
1242: SELECT psb_pay_elements_s.NEXTVAL
1243: INTO l_pay_element_id
1244: FROM DUAL;
1245:
1246: PSB_PAY_ELEMENTS_PVT.INSERT_ROW
1247: ( p_api_version => 1.0,
1248: p_init_msg_list => null,
1312: l_pay_element_options_rec.pay_element_option_id;
1313:
1314: SELECT psb_pay_element_options_s.NEXTVAL
1315: INTO l_pay_element_option_id
1316: FROM DUAL;
1317:
1318: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW
1319: ( p_api_version => 1.0,
1320: p_init_msg_list => null,
1351: Loop
1352:
1353: SELECT psb_pay_element_rates_s.NEXTVAL
1354: INTO l_pay_element_rate_id
1355: FROM DUAL;
1356:
1357: PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW
1358: ( p_api_version => 1.0,
1359: p_init_msg_list => null,
1403: Loop
1404:
1405: SELECT psb_pay_element_rates_s.NEXTVAL
1406: INTO l_pay_element_rate_id
1407: FROM DUAL;
1408:
1409: PSB_PAY_ELEMENT_RATES_PVT.INSERT_ROW
1410: ( p_api_version => 1.0,
1411: p_init_msg_list => null,
1458: l_source_set_group_id := l_set_groups_rec.position_set_group_id;
1459:
1460: SELECT psb_element_pos_set_groups_s.NEXTVAL
1461: INTO l_position_set_group_id
1462: FROM DUAL;
1463:
1464: PSB_ELEMENT_POS_SET_GROUPS_PVT.Insert_Row
1465: ( p_api_version => 1.0,
1466: p_init_msg_list => FND_API.G_FALSE,
1497: For l_account_distr_rec in l_account_distr_csr
1498: Loop
1499: SELECT psb_pay_element_distribution_s.NEXTVAL INTO
1500: l_distribution_id
1501: FROM DUAL;
1502:
1503: if ((l_account_distr_rec.distribution_set_id <>
1504: prev_distribution_set_id)
1505: or (prev_distribution_set_id = -1)) then
1504: prev_distribution_set_id)
1505: or (prev_distribution_set_id = -1)) then
1506: SELECT psb_element_distribution_set_s.NEXTVAL INTO
1507: l_distribution_set_id
1508: FROM DUAL;
1509: end if;
1510:
1511: PSB_ELE_DISTRIBUTIONS_I_PVT.Insert_Row
1512: ( p_api_version => 1.0,