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.

[Home] [Help]

APPS.JTF_RS_CONC_RES_PUB dependencies on FND_PROFILE

Line 211: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;

207: IS
208:
209: /* Moved the initial assignment of below variables to inside begin */
210: set_err_var VARCHAR2(1);
211: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
212:
213: BEGIN
214:
215: set_err_var := 'N';

Line 216: l_prof_srp_num := FND_PROFILE.VALUE('JTF_RS_MODE_OF_SRP_NUM_CREATION');

212:
213: BEGIN
214:
215: set_err_var := 'N';
216: l_prof_srp_num := FND_PROFILE.VALUE('JTF_RS_MODE_OF_SRP_NUM_CREATION');
217: g_run_date := nvl(to_date(FND_PROFILE.VALUE('JTF_RS_SYNC_RUN_DATE'),'MM/DD/YYYY'),trunc(sysdate));
218:
219: SAVEPOINT CONC_EMPLOYEE_SP;
220:

Line 217: g_run_date := nvl(to_date(FND_PROFILE.VALUE('JTF_RS_SYNC_RUN_DATE'),'MM/DD/YYYY'),trunc(sysdate));

213: BEGIN
214:
215: set_err_var := 'N';
216: l_prof_srp_num := FND_PROFILE.VALUE('JTF_RS_MODE_OF_SRP_NUM_CREATION');
217: g_run_date := nvl(to_date(FND_PROFILE.VALUE('JTF_RS_SYNC_RUN_DATE'),'MM/DD/YYYY'),trunc(sysdate));
218:
219: SAVEPOINT CONC_EMPLOYEE_SP;
220:
221: -- Adding Code for Enh to Create Salesperson and Roles (Job-Role Map) Automatically

Line 322: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;

318: l_sales_credit_type oe_sales_credit_types.name%TYPE;
319: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;
320:
321: /* Moved the initial assignment of below variable to inside begin */
322: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
323: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;
324: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;
325:
326: r_return_status VARCHAR2(2);

Line 323: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;

319: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;
320:
321: /* Moved the initial assignment of below variable to inside begin */
322: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
323: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;
324: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;
325:
326: r_return_status VARCHAR2(2);
327: r_msg_count NUMBER;

Line 324: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;

320:
321: /* Moved the initial assignment of below variable to inside begin */
322: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
323: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;
324: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;
325:
326: r_return_status VARCHAR2(2);
327: r_msg_count NUMBER;
328: r_msg_data VARCHAR2(2000);

Line 580: l_prof_srp_num := FND_PROFILE.VALUE('JTF_RS_MODE_OF_SRP_NUM_CREATION');

576:
577: BEGIN
578:
579: l_sales_credit_type := P_SALES_CREDIT_TYPE;
580: l_prof_srp_num := FND_PROFILE.VALUE('JTF_RS_MODE_OF_SRP_NUM_CREATION');
581: l_prof_get_emp_org := FND_PROFILE.VALUE('JTF_RS_SYNC_EMP_BUSINESS_GROUP');
582: l_prof_org := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
583:
584: l_query := 'SELECT date_start, actual_termination_date '||

Line 581: l_prof_get_emp_org := FND_PROFILE.VALUE('JTF_RS_SYNC_EMP_BUSINESS_GROUP');

577: BEGIN
578:
579: l_sales_credit_type := P_SALES_CREDIT_TYPE;
580: l_prof_srp_num := FND_PROFILE.VALUE('JTF_RS_MODE_OF_SRP_NUM_CREATION');
581: l_prof_get_emp_org := FND_PROFILE.VALUE('JTF_RS_SYNC_EMP_BUSINESS_GROUP');
582: l_prof_org := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
583:
584: l_query := 'SELECT date_start, actual_termination_date '||
585: 'FROM per_periods_of_placement ' ||

Line 582: l_prof_org := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

578:
579: l_sales_credit_type := P_SALES_CREDIT_TYPE;
580: l_prof_srp_num := FND_PROFILE.VALUE('JTF_RS_MODE_OF_SRP_NUM_CREATION');
581: l_prof_get_emp_org := FND_PROFILE.VALUE('JTF_RS_SYNC_EMP_BUSINESS_GROUP');
582: l_prof_org := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
583:
584: l_query := 'SELECT date_start, actual_termination_date '||
585: 'FROM per_periods_of_placement ' ||
586: 'WHERE person_id = :b_person_id '||

Line 1385: FND_PROFILE.GET('JTF_RS_RESOURCE_ACTIVE_DAYS',l_active_days);

1381:
1382: l_return_status := fnd_api.g_ret_sts_success;
1383: l_count := 0;
1384:
1385: FND_PROFILE.GET('JTF_RS_RESOURCE_ACTIVE_DAYS',l_active_days);
1386:
1387: IF l_active_days IS NULL THEN
1388: l_active_days := 0;
1389: END IF;

Line 2632: FND_PROFILE.GET('JTF_RS_RESOURCE_ACTIVE_DAYS',l_active_days);

2628: SAVEPOINT UPDATE_EMPLOYEE_SP;
2629:
2630: l_return_status := fnd_api.g_ret_sts_success;
2631:
2632: FND_PROFILE.GET('JTF_RS_RESOURCE_ACTIVE_DAYS',l_active_days);
2633:
2634: FOR l_c_resource IN c_resource LOOP
2635: BEGIN
2636: SAVEPOINT update_resource_sp;

Line 3679: FND_PROFILE.GET('JTF_RS_RESOURCE_ACTIVE_DAYS',l_active_days);

3675:
3676: l_return_status := fnd_api.g_ret_sts_success;
3677: l_count := 0;
3678:
3679: FND_PROFILE.GET('JTF_RS_RESOURCE_ACTIVE_DAYS',l_active_days);
3680:
3681: IF l_active_days IS NULL THEN
3682: l_active_days := 0;
3683: END IF;

Line 4187: FND_PROFILE.GET('JTF_RS_RESOURCE_ACTIVE_DAYS',l_active_days);

4183:
4184: l_return_status := fnd_api.g_ret_sts_success;
4185: l_count := 0;
4186:
4187: FND_PROFILE.GET('JTF_RS_RESOURCE_ACTIVE_DAYS',l_active_days);
4188:
4189: IF l_active_days IS NULL THEN
4190: l_active_days := 0;
4191: END IF;