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 7564: l_cur_handle := dbms_sql.open_cursor;

7560: x_return_status := FND_API.G_RET_STS_SUCCESS;
7561: return;
7562: end if;
7563: ----dbms_output.PUT_LINE('Crossed Second if of FTE Change...' || l_fte_value);
7564: l_cur_handle := dbms_sql.open_cursor;
7565:
7566: --Added assignment_type ='E' check for bug 2624259.
7567: dbms_sql.parse(l_cur_handle,'SELECT ' || l_fte_value || ' FROM per_assignments_f WHERE assignment_id = ' ||
7568: to_char(x_assignment_id) || ' and effective_start_date = (select max(effective_start_date)' ||

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

7563: ----dbms_output.PUT_LINE('Crossed Second if of FTE Change...' || l_fte_value);
7564: l_cur_handle := dbms_sql.open_cursor;
7565:
7566: --Added assignment_type ='E' check for bug 2624259.
7567: dbms_sql.parse(l_cur_handle,'SELECT ' || l_fte_value || ' FROM per_assignments_f WHERE assignment_id = ' ||
7568: to_char(x_assignment_id) || ' and effective_start_date = (select max(effective_start_date)' ||
7569: ' from per_assignments_f where assignment_id = ' || to_char(x_assignment_id) ||
7570: ' AND assignment_type = '||''''||'E'||'''' ||
7571: ' and effective_start_date < (select min(effective_start_date) from per_assignments_f ' ||

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

7573: ' AND assignment_type = '||''''||'E'||'''' ||
7574: ' and (( :g_start_date ' ||
7575: ' between effective_start_date and effective_end_date) or ( :g_end_date between ' ||
7576: ' effective_start_date and effective_end_date) or ( :g_start_date <= effective_start_date' ||
7577: ' and :g_end_date >= effective_end_date )) ))',dbms_sql.V7);
7578:
7579: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);
7580: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7581: dbms_sql.define_column(l_cur_handle,1,l_old_fte_temp,150);

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

7575: ' between effective_start_date and effective_end_date) or ( :g_end_date between ' ||
7576: ' effective_start_date and effective_end_date) or ( :g_start_date <= effective_start_date' ||
7577: ' and :g_end_date >= effective_end_date )) ))',dbms_sql.V7);
7578:
7579: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);
7580: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7581: dbms_sql.define_column(l_cur_handle,1,l_old_fte_temp,150);
7582: -- above added for bug fix 2023920
7583: --

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

7576: ' effective_start_date and effective_end_date) or ( :g_start_date <= effective_start_date' ||
7577: ' and :g_end_date >= effective_end_date )) ))',dbms_sql.V7);
7578:
7579: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);
7580: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7581: dbms_sql.define_column(l_cur_handle,1,l_old_fte_temp,150);
7582: -- above added for bug fix 2023920
7583: --
7584: l_total_rows := dbms_sql.execute_and_fetch(l_cur_handle);

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

7577: ' and :g_end_date >= effective_end_date )) ))',dbms_sql.V7);
7578:
7579: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);
7580: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7581: dbms_sql.define_column(l_cur_handle,1,l_old_fte_temp,150);
7582: -- above added for bug fix 2023920
7583: --
7584: l_total_rows := dbms_sql.execute_and_fetch(l_cur_handle);
7585: ----dbms_output.PUT_LINE('Crossed First dbms_sql.execute of FTE Change...');

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

7580: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7581: dbms_sql.define_column(l_cur_handle,1,l_old_fte_temp,150);
7582: -- above added for bug fix 2023920
7583: --
7584: l_total_rows := dbms_sql.execute_and_fetch(l_cur_handle);
7585: ----dbms_output.PUT_LINE('Crossed First dbms_sql.execute of FTE Change...');
7586:
7587: /*
7588: if NVL(l_total_rows,0) = 0 then

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

7581: dbms_sql.define_column(l_cur_handle,1,l_old_fte_temp,150);
7582: -- above added for bug fix 2023920
7583: --
7584: l_total_rows := dbms_sql.execute_and_fetch(l_cur_handle);
7585: ----dbms_output.PUT_LINE('Crossed First dbms_sql.execute of FTE Change...');
7586:
7587: /*
7588: if NVL(l_total_rows,0) = 0 then
7589: l_old_fte := 0;

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

7587: /*
7588: if NVL(l_total_rows,0) = 0 then
7589: l_old_fte := 0;
7590: else
7591: dbms_sql.column_value(l_cur_handle,1,l_old_fte);
7592: end if;
7593: Commenting out NOCOPY per bug fix 2023920
7594:
7595: */

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

7592: end if;
7593: Commenting out NOCOPY per bug fix 2023920
7594:
7595: */
7596: dbms_sql.column_value(l_cur_handle,1,l_old_fte_temp); -- added new for bug fix 2022500
7597: l_old_fte:= to_number(nvl(l_old_fte_temp,0)); -- 2023920
7598:
7599: l_old_fte:=nvl(l_old_fte_temp,0); -- 2023920
7600:

Line 7601: dbms_sql.close_cursor(l_cur_handle);

7597: l_old_fte:= to_number(nvl(l_old_fte_temp,0)); -- 2023920
7598:
7599: l_old_fte:=nvl(l_old_fte_temp,0); -- 2023920
7600:
7601: dbms_sql.close_cursor(l_cur_handle);
7602:
7603:
7604:
7605: --

Line 7607: l_cur_handle := dbms_sql.open_cursor;

7603:
7604:
7605: --
7606:
7607: l_cur_handle := dbms_sql.open_cursor;
7608:
7609: --Added assignment_type ='E' for bug 2624259.
7610: dbms_sql.parse(l_cur_handle,'SELECT effective_start_date, effective_end_date, ' || l_fte_value ||
7611: ' FROM per_assignments_f WHERE assignment_id = ' || to_char(x_assignment_id) ||

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

7606:
7607: l_cur_handle := dbms_sql.open_cursor;
7608:
7609: --Added assignment_type ='E' for bug 2624259.
7610: dbms_sql.parse(l_cur_handle,'SELECT effective_start_date, effective_end_date, ' || l_fte_value ||
7611: ' FROM per_assignments_f WHERE assignment_id = ' || to_char(x_assignment_id) ||
7612: ' AND assignment_type = '||''''||'E'||'''' ||
7613: ' and (:g_start_date between effective_start_date and effective_end_date or ' ||
7614: ':g_end_date between effective_start_date and effective_end_date or (:g_start_date ' ||

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

7612: ' AND assignment_type = '||''''||'E'||'''' ||
7613: ' and (:g_start_date between effective_start_date and effective_end_date or ' ||
7614: ':g_end_date between effective_start_date and effective_end_date or (:g_start_date ' ||
7615: ' <= effective_start_date and :g_end_date >= effective_end_date )) order by ' ||
7616: ' effective_start_date ',dbms_sql.V7);
7617:
7618: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);
7619: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7620: --

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

7614: ':g_end_date between effective_start_date and effective_end_date or (:g_start_date ' ||
7615: ' <= effective_start_date and :g_end_date >= effective_end_date )) order by ' ||
7616: ' effective_start_date ',dbms_sql.V7);
7617:
7618: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);
7619: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7620: --
7621: /* new added to define columns for above cursor 2023920*/
7622:

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

7615: ' <= effective_start_date and :g_end_date >= effective_end_date )) order by ' ||
7616: ' effective_start_date ',dbms_sql.V7);
7617:
7618: dbms_sql.bind_variable(l_cur_handle,'g_start_date', g_start_date);
7619: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7620: --
7621: /* new added to define columns for above cursor 2023920*/
7622:
7623: dbms_sql.define_column(l_cur_handle, 1, l_current_Start_date);

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

7619: dbms_sql.bind_variable(l_cur_handle,'g_end_date', g_end_date);
7620: --
7621: /* new added to define columns for above cursor 2023920*/
7622:
7623: dbms_sql.define_column(l_cur_handle, 1, l_current_Start_date);
7624: dbms_sql.define_column(l_cur_handle, 2, l_current_end_date);
7625: dbms_sql.define_column(l_cur_handle, 3, l_new_fte_temp,150);
7626:
7627: l_total_rows := dbms_sql.execute(l_cur_handle);

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

7620: --
7621: /* new added to define columns for above cursor 2023920*/
7622:
7623: dbms_sql.define_column(l_cur_handle, 1, l_current_Start_date);
7624: dbms_sql.define_column(l_cur_handle, 2, l_current_end_date);
7625: dbms_sql.define_column(l_cur_handle, 3, l_new_fte_temp,150);
7626:
7627: l_total_rows := dbms_sql.execute(l_cur_handle);
7628: /*

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

7621: /* new added to define columns for above cursor 2023920*/
7622:
7623: dbms_sql.define_column(l_cur_handle, 1, l_current_Start_date);
7624: dbms_sql.define_column(l_cur_handle, 2, l_current_end_date);
7625: dbms_sql.define_column(l_cur_handle, 3, l_new_fte_temp,150);
7626:
7627: l_total_rows := dbms_sql.execute(l_cur_handle);
7628: /*
7629:

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

7623: dbms_sql.define_column(l_cur_handle, 1, l_current_Start_date);
7624: dbms_sql.define_column(l_cur_handle, 2, l_current_end_date);
7625: dbms_sql.define_column(l_cur_handle, 3, l_new_fte_temp,150);
7626:
7627: l_total_rows := dbms_sql.execute(l_cur_handle);
7628: /*
7629:
7630: Not Required -- Commented out NOCOPY per bug fix 2023920
7631:

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

7629:
7630: Not Required -- Commented out NOCOPY per bug fix 2023920
7631:
7632:
7633: ----dbms_output.PUT_LINE('Crossed First dbms_sql.execute of FTE Change...');
7634:
7635: if NVL(l_total_rows,0) = 0 then
7636: l_old_fte := 0;
7637: else

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

7634:
7635: if NVL(l_total_rows,0) = 0 then
7636: l_old_fte := 0;
7637: else
7638: dbms_sql.column_value(l_cur_handle,1,l_old_fte);
7639: end if;
7640:
7641: dbms_sql.close_cursor(l_cur_handle);
7642: */

Line 7641: dbms_sql.close_cursor(l_cur_handle);

7637: else
7638: dbms_sql.column_value(l_cur_handle,1,l_old_fte);
7639: end if;
7640:
7641: dbms_sql.close_cursor(l_cur_handle);
7642: */
7643: --
7644: while dbms_sql.fetch_rows(l_cur_handle) > 0
7645: LOOP

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

7640:
7641: dbms_sql.close_cursor(l_cur_handle);
7642: */
7643: --
7644: while dbms_sql.fetch_rows(l_cur_handle) > 0
7645: LOOP
7646: ----dbms_output.PUT_LINE('Entered into fetch LOOP of FTE Change...');
7647: dbms_sql.column_value(l_cur_handle,1,l_current_start_date);
7648: dbms_sql.column_value(l_cur_handle,2,l_current_end_date);

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

7643: --
7644: while dbms_sql.fetch_rows(l_cur_handle) > 0
7645: LOOP
7646: ----dbms_output.PUT_LINE('Entered into fetch LOOP of FTE Change...');
7647: dbms_sql.column_value(l_cur_handle,1,l_current_start_date);
7648: dbms_sql.column_value(l_cur_handle,2,l_current_end_date);
7649: dbms_sql.column_value(l_cur_handle,3,l_new_fte_temp); -- new added 2023920
7650: l_new_fte:=to_number(nvl(l_new_fte_temp,0)); -- 2023920
7651: /*

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

7644: while dbms_sql.fetch_rows(l_cur_handle) > 0
7645: LOOP
7646: ----dbms_output.PUT_LINE('Entered into fetch LOOP of FTE Change...');
7647: dbms_sql.column_value(l_cur_handle,1,l_current_start_date);
7648: dbms_sql.column_value(l_cur_handle,2,l_current_end_date);
7649: dbms_sql.column_value(l_cur_handle,3,l_new_fte_temp); -- new added 2023920
7650: l_new_fte:=to_number(nvl(l_new_fte_temp,0)); -- 2023920
7651: /*
7652: if NVL(l_old_fte,0) = 0 o

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

7645: LOOP
7646: ----dbms_output.PUT_LINE('Entered into fetch LOOP of FTE Change...');
7647: dbms_sql.column_value(l_cur_handle,1,l_current_start_date);
7648: dbms_sql.column_value(l_cur_handle,2,l_current_end_date);
7649: dbms_sql.column_value(l_cur_handle,3,l_new_fte_temp); -- new added 2023920
7650: l_new_fte:=to_number(nvl(l_new_fte_temp,0)); -- 2023920
7651: /*
7652: if NVL(l_old_fte,0) = 0 o
7653: commented out NOCOPY as part of bug fix 2023920

Line 8164: dbms_sql.close_cursor(l_cur_handle);

8160: end;
8161: end if;
8162:
8163: END LOOP;
8164: dbms_sql.close_cursor(l_cur_handle);
8165: x_return_status := FND_API.G_RET_STS_SUCCESS;
8166: hr_utility.trace(' Leaving CREATE_SLINE_FTE_CHANGE');
8167: EXCEPTION
8168: WHEN OTHERS then

Line 8171: dbms_sql.close_cursor(l_cur_handle);

8167: EXCEPTION
8168: WHEN OTHERS then
8169: fnd_msg_pub.add_exc_msg('PSP_PAYTRN','CREATE_SLINE_FTE_CHANGE');
8170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8171: dbms_sql.close_cursor(l_cur_handle);
8172:
8173: end create_sline_fte_change;
8174:
8175: --------------------------------CREATE_SLINE_BUDGET_CHANGE--------------