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.JTF_RS_CONC_RES_PUB dependencies on FND_PROFILE

Line 153: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;

149: IS
150:
151: /* Moved the initial assignment of below variables to inside begin */
152: set_err_var VARCHAR2(1);
153: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
154:
155: BEGIN
156:
157: set_err_var := 'N';

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

154:
155: BEGIN
156:
157: set_err_var := 'N';
158: l_prof_srp_num := FND_PROFILE.VALUE('JTF_RS_MODE_OF_SRP_NUM_CREATION');
159: g_run_date := nvl(to_date(FND_PROFILE.VALUE('JTF_RS_SYNC_RUN_DATE'),'MM/DD/YYYY'),trunc(sysdate));
160:
161: SAVEPOINT CONC_EMPLOYEE_SP;
162:

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

155: BEGIN
156:
157: set_err_var := 'N';
158: l_prof_srp_num := FND_PROFILE.VALUE('JTF_RS_MODE_OF_SRP_NUM_CREATION');
159: g_run_date := nvl(to_date(FND_PROFILE.VALUE('JTF_RS_SYNC_RUN_DATE'),'MM/DD/YYYY'),trunc(sysdate));
160:
161: SAVEPOINT CONC_EMPLOYEE_SP;
162:
163: -- Adding Code for Enh to Create Salesperson and Roles (Job-Role Map) Automatically

Line 264: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;

260: l_sales_credit_type oe_sales_credit_types.name%TYPE;
261: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;
262:
263: /* Moved the initial assignment of below variable to inside begin */
264: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
265: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;
266: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;
267:
268: r_return_status VARCHAR2(2);

Line 265: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;

261: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;
262:
263: /* Moved the initial assignment of below variable to inside begin */
264: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
265: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;
266: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;
267:
268: r_return_status VARCHAR2(2);
269: r_msg_count NUMBER;

Line 266: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;

262:
263: /* Moved the initial assignment of below variable to inside begin */
264: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
265: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;
266: l_prof_org fnd_profile_option_values.profile_option_value%TYPE;
267:
268: r_return_status VARCHAR2(2);
269: r_msg_count NUMBER;
270: r_msg_data VARCHAR2(2000);

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

518:
519: BEGIN
520:
521: l_sales_credit_type := P_SALES_CREDIT_TYPE;
522: l_prof_srp_num := FND_PROFILE.VALUE('JTF_RS_MODE_OF_SRP_NUM_CREATION');
523: l_prof_get_emp_org := FND_PROFILE.VALUE('JTF_RS_SYNC_EMP_BUSINESS_GROUP');
524: l_prof_org := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
525:
526: l_query := 'SELECT date_start, actual_termination_date '||

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

519: BEGIN
520:
521: l_sales_credit_type := P_SALES_CREDIT_TYPE;
522: l_prof_srp_num := FND_PROFILE.VALUE('JTF_RS_MODE_OF_SRP_NUM_CREATION');
523: l_prof_get_emp_org := FND_PROFILE.VALUE('JTF_RS_SYNC_EMP_BUSINESS_GROUP');
524: l_prof_org := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
525:
526: l_query := 'SELECT date_start, actual_termination_date '||
527: 'FROM per_periods_of_placement ' ||

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

520:
521: l_sales_credit_type := P_SALES_CREDIT_TYPE;
522: l_prof_srp_num := FND_PROFILE.VALUE('JTF_RS_MODE_OF_SRP_NUM_CREATION');
523: l_prof_get_emp_org := FND_PROFILE.VALUE('JTF_RS_SYNC_EMP_BUSINESS_GROUP');
524: l_prof_org := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
525:
526: l_query := 'SELECT date_start, actual_termination_date '||
527: 'FROM per_periods_of_placement ' ||
528: 'WHERE person_id = :b_person_id '||

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

1323:
1324: l_return_status := fnd_api.g_ret_sts_success;
1325: l_count := 0;
1326:
1327: FND_PROFILE.GET('JTF_RS_RESOURCE_ACTIVE_DAYS',l_active_days);
1328:
1329: IF l_active_days IS NULL THEN
1330: l_active_days := 0;
1331: END IF;

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

2191: SAVEPOINT UPDATE_EMPLOYEE_SP;
2192:
2193: l_return_status := fnd_api.g_ret_sts_success;
2194:
2195: FND_PROFILE.GET('JTF_RS_RESOURCE_ACTIVE_DAYS',l_active_days);
2196:
2197: FOR l_c_resource IN c_resource LOOP
2198: BEGIN
2199: SAVEPOINT update_resource_sp;

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

3224:
3225: l_return_status := fnd_api.g_ret_sts_success;
3226: l_count := 0;
3227:
3228: FND_PROFILE.GET('JTF_RS_RESOURCE_ACTIVE_DAYS',l_active_days);
3229:
3230: IF l_active_days IS NULL THEN
3231: l_active_days := 0;
3232: END IF;

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

3734:
3735: l_return_status := fnd_api.g_ret_sts_success;
3736: l_count := 0;
3737:
3738: FND_PROFILE.GET('JTF_RS_RESOURCE_ACTIVE_DAYS',l_active_days);
3739:
3740: IF l_active_days IS NULL THEN
3741: l_active_days := 0;
3742: END IF;