[Home] [Help]
586: 'WHERE person_id = :b_person_id '||
587: 'ORDER BY date_start asc';
588:
589:
590: --Standard Start of API SAVEPOINT
591: SAVEPOINT CREATE_EMPLOYEE_SP;
592:
593: l_return_status := fnd_api.g_ret_sts_success;
594:
1375: 'WHERE person_id = :b_person_id '||
1376: 'AND trunc(date_start) <= trunc(sysdate) '||
1377: 'ORDER BY period_of_placement_id desc';
1378:
1379: --Standard Start of API SAVEPOINT
1380: SAVEPOINT TERMINATE_EMPLOYEE_SP;
1381:
1382: l_return_status := fnd_api.g_ret_sts_success;
1383: l_count := 0;
2622: p_prefix =>l_debug_prefix,
2623: p_msg_level=>fnd_log.level_statement);
2624: END IF;
2625:
2626: --Standard Start of API SAVEPOINT
2627:
2628: SAVEPOINT UPDATE_EMPLOYEE_SP;
2629:
2630: l_return_status := fnd_api.g_ret_sts_success;
3669: l_active_days NUMBER;
3670:
3671: BEGIN
3672:
3673: --Standard Start of API SAVEPOINT
3674: SAVEPOINT TERMINATE_PARTNER_REL_SP;
3675:
3676: l_return_status := fnd_api.g_ret_sts_success;
3677: l_count := 0;
4177: l_count NUMBER;
4178:
4179: BEGIN
4180:
4181: --Standard Start of API SAVEPOINT
4182: SAVEPOINT TERMINATE_SUPPLIER_CONTACT_SP;
4183:
4184: l_return_status := fnd_api.g_ret_sts_success;
4185: l_count := 0;