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.PSP_PAYTRN dependencies on DBMS_SQL

Line 7490: l_cur_handle := dbms_sql.open_cursor;

7486: x_return_status := FND_API.G_RET_STS_SUCCESS;
7487: return;
7488: end if;
7489: ----dbms_output.PUT_LINE('Crossed Second if of FTE Change...' || l_fte_value);
7490: l_cur_handle := dbms_sql.open_cursor;
7491:
7492: --Added assignment_type ='E' check for bug 2624259.
7493: dbms_sql.parse(l_cur_handle,'SELECT ' || l_fte_value || ' FROM per_assignments_f WHERE assignment_id = ' ||
7494: to_char(x_assignment_id) || ' and effective_start_date = (select max(effective_start_date)' ||

Line 7493: dbms_sql.parse(l_cur_handle,'SELECT ' || l_fte_value || ' FROM per_assignments_f WHERE assignment_id = ' ||

7489: ----dbms_output.PUT_LINE('Crossed Second if of FTE Change...' || l_fte_value);
7490: l_cur_handle := dbms_sql.open_cursor;
7491:
7492: --Added assignment_type ='E' check for bug 2624259.
7493: dbms_sql.parse(l_cur_handle,'SELECT ' || l_fte_value || ' FROM per_assignments_f WHERE assignment_id = ' ||
7494: to_char(x_assignment_id) || ' and effective_start_date = (select max(effective_start_date)' ||
7495: ' from per_assignments_f where assignment_id = ' || to_char(x_assignment_id) ||
7496: ' AND assignment_type = '||''''||'E'||'''' ||
7497: ' and effective_start_date < (select min(effective_start_date) from per_assignments_f ' ||

Line 7503: ' and :g_end_date >= effective_end_date )) ))',dbms_sql.V7);

7499: ' AND assignment_type = '||''''||'E'||'''' ||
7500: ' and (( :g_start_date ' ||
7501: ' between effective_start_date and effective_end_date) or ( :g_end_date between ' ||
7502: ' effective_start_date and effective_end_date) or ( :g_start_date <= effective_start_date' ||
7503: ' and :g_end_date >= effective_end_date )) ))',dbms_sql.V7);
7504:
7505: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);
7506: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7507: dbms_sql.define_column(l_cur_handle,1,l_old_fte_temp,150);

Line 7505: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);

7501: ' between effective_start_date and effective_end_date) or ( :g_end_date between ' ||
7502: ' effective_start_date and effective_end_date) or ( :g_start_date <= effective_start_date' ||
7503: ' and :g_end_date >= effective_end_date )) ))',dbms_sql.V7);
7504:
7505: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);
7506: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7507: dbms_sql.define_column(l_cur_handle,1,l_old_fte_temp,150);
7508: -- above added for bug fix 2023920
7509: --

Line 7506: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);

7502: ' effective_start_date and effective_end_date) or ( :g_start_date <= effective_start_date' ||
7503: ' and :g_end_date >= effective_end_date )) ))',dbms_sql.V7);
7504:
7505: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);
7506: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7507: dbms_sql.define_column(l_cur_handle,1,l_old_fte_temp,150);
7508: -- above added for bug fix 2023920
7509: --
7510: l_total_rows := dbms_sql.execute_and_fetch(l_cur_handle);

Line 7507: dbms_sql.define_column(l_cur_handle,1,l_old_fte_temp,150);

7503: ' and :g_end_date >= effective_end_date )) ))',dbms_sql.V7);
7504:
7505: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);
7506: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7507: dbms_sql.define_column(l_cur_handle,1,l_old_fte_temp,150);
7508: -- above added for bug fix 2023920
7509: --
7510: l_total_rows := dbms_sql.execute_and_fetch(l_cur_handle);
7511: ----dbms_output.PUT_LINE('Crossed First dbms_sql.execute of FTE Change...');

Line 7510: l_total_rows := dbms_sql.execute_and_fetch(l_cur_handle);

7506: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7507: dbms_sql.define_column(l_cur_handle,1,l_old_fte_temp,150);
7508: -- above added for bug fix 2023920
7509: --
7510: l_total_rows := dbms_sql.execute_and_fetch(l_cur_handle);
7511: ----dbms_output.PUT_LINE('Crossed First dbms_sql.execute of FTE Change...');
7512:
7513: /*
7514: if NVL(l_total_rows,0) = 0 then

Line 7511: ----dbms_output.PUT_LINE('Crossed First dbms_sql.execute of FTE Change...');

7507: dbms_sql.define_column(l_cur_handle,1,l_old_fte_temp,150);
7508: -- above added for bug fix 2023920
7509: --
7510: l_total_rows := dbms_sql.execute_and_fetch(l_cur_handle);
7511: ----dbms_output.PUT_LINE('Crossed First dbms_sql.execute of FTE Change...');
7512:
7513: /*
7514: if NVL(l_total_rows,0) = 0 then
7515: l_old_fte := 0;

Line 7517: dbms_sql.column_value(l_cur_handle,1,l_old_fte);

7513: /*
7514: if NVL(l_total_rows,0) = 0 then
7515: l_old_fte := 0;
7516: else
7517: dbms_sql.column_value(l_cur_handle,1,l_old_fte);
7518: end if;
7519: Commenting out NOCOPY per bug fix 2023920
7520:
7521: */

Line 7522: dbms_sql.column_value(l_cur_handle,1,l_old_fte_temp); -- added new for bug fix 2022500

7518: end if;
7519: Commenting out NOCOPY per bug fix 2023920
7520:
7521: */
7522: dbms_sql.column_value(l_cur_handle,1,l_old_fte_temp); -- added new for bug fix 2022500
7523: l_old_fte:= to_number(nvl(l_old_fte_temp,0)); -- 2023920
7524:
7525: l_old_fte:=nvl(l_old_fte_temp,0); -- 2023920
7526:

Line 7527: dbms_sql.close_cursor(l_cur_handle);

7523: l_old_fte:= to_number(nvl(l_old_fte_temp,0)); -- 2023920
7524:
7525: l_old_fte:=nvl(l_old_fte_temp,0); -- 2023920
7526:
7527: dbms_sql.close_cursor(l_cur_handle);
7528:
7529:
7530:
7531: --

Line 7533: l_cur_handle := dbms_sql.open_cursor;

7529:
7530:
7531: --
7532:
7533: l_cur_handle := dbms_sql.open_cursor;
7534:
7535: --Added assignment_type ='E' for bug 2624259.
7536: dbms_sql.parse(l_cur_handle,'SELECT effective_start_date, effective_end_date, ' || l_fte_value ||
7537: ' FROM per_assignments_f WHERE assignment_id = ' || to_char(x_assignment_id) ||

Line 7536: dbms_sql.parse(l_cur_handle,'SELECT effective_start_date, effective_end_date, ' || l_fte_value ||

7532:
7533: l_cur_handle := dbms_sql.open_cursor;
7534:
7535: --Added assignment_type ='E' for bug 2624259.
7536: dbms_sql.parse(l_cur_handle,'SELECT effective_start_date, effective_end_date, ' || l_fte_value ||
7537: ' FROM per_assignments_f WHERE assignment_id = ' || to_char(x_assignment_id) ||
7538: ' AND assignment_type = '||''''||'E'||'''' ||
7539: ' and (:g_start_date between effective_start_date and effective_end_date or ' ||
7540: ':g_end_date between effective_start_date and effective_end_date or (:g_start_date ' ||

Line 7542: ' effective_start_date ',dbms_sql.V7);

7538: ' AND assignment_type = '||''''||'E'||'''' ||
7539: ' and (:g_start_date between effective_start_date and effective_end_date or ' ||
7540: ':g_end_date between effective_start_date and effective_end_date or (:g_start_date ' ||
7541: ' <= effective_start_date and :g_end_date >= effective_end_date )) order by ' ||
7542: ' effective_start_date ',dbms_sql.V7);
7543:
7544: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);
7545: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7546: --

Line 7544: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);

7540: ':g_end_date between effective_start_date and effective_end_date or (:g_start_date ' ||
7541: ' <= effective_start_date and :g_end_date >= effective_end_date )) order by ' ||
7542: ' effective_start_date ',dbms_sql.V7);
7543:
7544: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);
7545: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7546: --
7547: /* new added to define columns for above cursor 2023920*/
7548:

Line 7545: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);

7541: ' <= effective_start_date and :g_end_date >= effective_end_date )) order by ' ||
7542: ' effective_start_date ',dbms_sql.V7);
7543:
7544: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);
7545: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7546: --
7547: /* new added to define columns for above cursor 2023920*/
7548:
7549: dbms_sql.define_column(l_cur_handle, 1, l_current_Start_date);

Line 7549: dbms_sql.define_column(l_cur_handle, 1, l_current_Start_date);

7545: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7546: --
7547: /* new added to define columns for above cursor 2023920*/
7548:
7549: dbms_sql.define_column(l_cur_handle, 1, l_current_Start_date);
7550: dbms_sql.define_column(l_cur_handle, 2, l_current_end_date);
7551: dbms_sql.define_column(l_cur_handle, 3, l_new_fte_temp,150);
7552:
7553: l_total_rows := dbms_sql.execute(l_cur_handle);

Line 7550: dbms_sql.define_column(l_cur_handle, 2, l_current_end_date);

7546: --
7547: /* new added to define columns for above cursor 2023920*/
7548:
7549: dbms_sql.define_column(l_cur_handle, 1, l_current_Start_date);
7550: dbms_sql.define_column(l_cur_handle, 2, l_current_end_date);
7551: dbms_sql.define_column(l_cur_handle, 3, l_new_fte_temp,150);
7552:
7553: l_total_rows := dbms_sql.execute(l_cur_handle);
7554: /*

Line 7551: dbms_sql.define_column(l_cur_handle, 3, l_new_fte_temp,150);

7547: /* new added to define columns for above cursor 2023920*/
7548:
7549: dbms_sql.define_column(l_cur_handle, 1, l_current_Start_date);
7550: dbms_sql.define_column(l_cur_handle, 2, l_current_end_date);
7551: dbms_sql.define_column(l_cur_handle, 3, l_new_fte_temp,150);
7552:
7553: l_total_rows := dbms_sql.execute(l_cur_handle);
7554: /*
7555:

Line 7553: l_total_rows := dbms_sql.execute(l_cur_handle);

7549: dbms_sql.define_column(l_cur_handle, 1, l_current_Start_date);
7550: dbms_sql.define_column(l_cur_handle, 2, l_current_end_date);
7551: dbms_sql.define_column(l_cur_handle, 3, l_new_fte_temp,150);
7552:
7553: l_total_rows := dbms_sql.execute(l_cur_handle);
7554: /*
7555:
7556: Not Required -- Commented out NOCOPY per bug fix 2023920
7557:

Line 7559: ----dbms_output.PUT_LINE('Crossed First dbms_sql.execute of FTE Change...');

7555:
7556: Not Required -- Commented out NOCOPY per bug fix 2023920
7557:
7558:
7559: ----dbms_output.PUT_LINE('Crossed First dbms_sql.execute of FTE Change...');
7560:
7561: if NVL(l_total_rows,0) = 0 then
7562: l_old_fte := 0;
7563: else

Line 7564: dbms_sql.column_value(l_cur_handle,1,l_old_fte);

7560:
7561: if NVL(l_total_rows,0) = 0 then
7562: l_old_fte := 0;
7563: else
7564: dbms_sql.column_value(l_cur_handle,1,l_old_fte);
7565: end if;
7566:
7567: dbms_sql.close_cursor(l_cur_handle);
7568: */

Line 7567: dbms_sql.close_cursor(l_cur_handle);

7563: else
7564: dbms_sql.column_value(l_cur_handle,1,l_old_fte);
7565: end if;
7566:
7567: dbms_sql.close_cursor(l_cur_handle);
7568: */
7569: --
7570: while dbms_sql.fetch_rows(l_cur_handle) > 0
7571: LOOP

Line 7570: while dbms_sql.fetch_rows(l_cur_handle) > 0

7566:
7567: dbms_sql.close_cursor(l_cur_handle);
7568: */
7569: --
7570: while dbms_sql.fetch_rows(l_cur_handle) > 0
7571: LOOP
7572: ----dbms_output.PUT_LINE('Entered into fetch LOOP of FTE Change...');
7573: dbms_sql.column_value(l_cur_handle,1,l_current_start_date);
7574: dbms_sql.column_value(l_cur_handle,2,l_current_end_date);

Line 7573: dbms_sql.column_value(l_cur_handle,1,l_current_start_date);

7569: --
7570: while dbms_sql.fetch_rows(l_cur_handle) > 0
7571: LOOP
7572: ----dbms_output.PUT_LINE('Entered into fetch LOOP of FTE Change...');
7573: dbms_sql.column_value(l_cur_handle,1,l_current_start_date);
7574: dbms_sql.column_value(l_cur_handle,2,l_current_end_date);
7575: dbms_sql.column_value(l_cur_handle,3,l_new_fte_temp); -- new added 2023920
7576: l_new_fte:=to_number(nvl(l_new_fte_temp,0)); -- 2023920
7577: /*

Line 7574: dbms_sql.column_value(l_cur_handle,2,l_current_end_date);

7570: while dbms_sql.fetch_rows(l_cur_handle) > 0
7571: LOOP
7572: ----dbms_output.PUT_LINE('Entered into fetch LOOP of FTE Change...');
7573: dbms_sql.column_value(l_cur_handle,1,l_current_start_date);
7574: dbms_sql.column_value(l_cur_handle,2,l_current_end_date);
7575: dbms_sql.column_value(l_cur_handle,3,l_new_fte_temp); -- new added 2023920
7576: l_new_fte:=to_number(nvl(l_new_fte_temp,0)); -- 2023920
7577: /*
7578: if NVL(l_old_fte,0) = 0 o

Line 7575: dbms_sql.column_value(l_cur_handle,3,l_new_fte_temp); -- new added 2023920

7571: LOOP
7572: ----dbms_output.PUT_LINE('Entered into fetch LOOP of FTE Change...');
7573: dbms_sql.column_value(l_cur_handle,1,l_current_start_date);
7574: dbms_sql.column_value(l_cur_handle,2,l_current_end_date);
7575: dbms_sql.column_value(l_cur_handle,3,l_new_fte_temp); -- new added 2023920
7576: l_new_fte:=to_number(nvl(l_new_fte_temp,0)); -- 2023920
7577: /*
7578: if NVL(l_old_fte,0) = 0 o
7579: commented out NOCOPY as part of bug fix 2023920

Line 8090: dbms_sql.close_cursor(l_cur_handle);

8086: end;
8087: end if;
8088:
8089: END LOOP;
8090: dbms_sql.close_cursor(l_cur_handle);
8091: x_return_status := FND_API.G_RET_STS_SUCCESS;
8092: hr_utility.trace(' Leaving CREATE_SLINE_FTE_CHANGE');
8093: EXCEPTION
8094: WHEN OTHERS then

Line 8097: dbms_sql.close_cursor(l_cur_handle);

8093: EXCEPTION
8094: WHEN OTHERS then
8095: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_FTE_CHANGE');
8096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8097: dbms_sql.close_cursor(l_cur_handle);
8098:
8099: end create_sline_fte_change;
8100:
8101: --------------------------------CREATE_SLINE_BUDGET_CHANGE--------------