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.PQP_UPDATE_WORK_PATTERN_TABLE dependencies on PAY_USER_COLUMN_INSTANCES

Line 167: FROM pay_user_column_instances_f puci

163: ,p_business_group_id IN NUMBER
164: ) IS
165: SELECT puci.effective_start_date effective_start_date
166: ,puci.effective_end_date effective_end_date
167: FROM pay_user_column_instances_f puci
168: WHERE ( puci.business_group_id = p_business_group_id
169: OR puci.legislation_code = g_legislation_code )
170: AND puci.user_column_id = p_user_column_id
171: AND puci.user_row_id = p_user_row_id ;

Line 376: -- in the table pay_user_column_instances_f.

372: debug('total_working_days_defined:'||l_row_values(3));
373: END IF ;
374:
375: -- update/insert value for seeded rows one by one
376: -- in the table pay_user_column_instances_f.
377:
378: -- If the value for the said column already exists and
379: -- the user has not updated the row manually, then
380: -- update the value, else leave it as it is.

Line 382: -- insert a new row in the table pay_user_column_instances_f.

378: -- If the value for the said column already exists and
379: -- the user has not updated the row manually, then
380: -- update the value, else leave it as it is.
381: -- but if the value does not exists for the column,
382: -- insert a new row in the table pay_user_column_instances_f.
383:
384: -- if user has explicitly given the name of the WP, update the row
385: -- even if it is updated by user manually.
386:

Line 486: l_user_column_instance_id pay_user_column_instances_f.user_column_instance_id%TYPE ;

482:
483:
484: l_value NUMBER ;
485: l_row_id VARCHAR2(200) ;
486: l_user_column_instance_id pay_user_column_instances_f.user_column_instance_id%TYPE ;
487: idx NUMBER := 1 ; --index for the rows
488:
489: l_proc_step NUMBER(20,10);
490: l_proc_name VARCHAR2(200) := g_package_name||

Line 647: -- insert a new row in the table pay_user_column_instances_f.

643: -- else if the user has not updated the row manually, then
644: -- update the row, else leave it as it is.
645:
646: -- but if the value does not exists for the column,
647: -- insert a new row in the table pay_user_column_instances_f.
648:
649: PROCEDURE update_insert_row(
650: p_user_column_id IN NUMBER
651: ,p_user_row_id IN NUMBER

Line 660: l_value pay_user_column_instances.value%TYPE ;

656: ,p_value_to_update IN NUMBER
657: ,p_overwrite_if_exists IN VARCHAR2
658: )IS
659:
660: l_value pay_user_column_instances.value%TYPE ;
661: l_row_id VARCHAR2(200) ;
662: l_column_instances_id pay_user_column_instances_f.
663: user_column_instance_id%TYPE ;
664: l_return_row_id VARCHAR2(200) ;

Line 662: l_column_instances_id pay_user_column_instances_f.

658: )IS
659:
660: l_value pay_user_column_instances.value%TYPE ;
661: l_row_id VARCHAR2(200) ;
662: l_column_instances_id pay_user_column_instances_f.
663: user_column_instance_id%TYPE ;
664: l_return_row_id VARCHAR2(200) ;
665: l_proc_step NUMBER(20,10);
666: l_proc_name VARCHAR2(200):=g_package_name||'update_insert_row';

Line 715: --Insert new Row in the table pay_user_column_instances_f

711: debug(l_proc_name,l_proc_step) ;
712: debug('Row is not Defined') ;
713: END IF ;
714:
715: --Insert new Row in the table pay_user_column_instances_f
716: pay_user_column_instances_pkg.insert_row(
717: p_rowid => l_return_row_id --IN OUT
718: ,p_user_column_instance_id => l_column_instances_id --IN OUT
719: ,p_effective_start_date => p_row_effective_start_date

Line 716: pay_user_column_instances_pkg.insert_row(

712: debug('Row is not Defined') ;
713: END IF ;
714:
715: --Insert new Row in the table pay_user_column_instances_f
716: pay_user_column_instances_pkg.insert_row(
717: p_rowid => l_return_row_id --IN OUT
718: ,p_user_column_instance_id => l_column_instances_id --IN OUT
719: ,p_effective_start_date => p_row_effective_start_date
720: ,p_effective_end_date => p_row_effective_end_date

Line 756: -- Call method from pay_user_column_instances_pkg Package to updaet the row.

752: debug(l_proc_name,l_proc_step) ;
753: debug(' Row is defined, p_value_to_updat:'||p_value_to_update);
754: END IF ;
755:
756: -- Call method from pay_user_column_instances_pkg Package to updaet the row.
757: pay_user_column_instances_pkg.update_row(
758: p_rowid => l_row_id
759: ,p_user_column_instance_id => l_column_instances_id
760: ,p_effective_start_date => p_row_effective_start_date -- changed from l_effective_start_date for BUG :4078709

Line 757: pay_user_column_instances_pkg.update_row(

753: debug(' Row is defined, p_value_to_updat:'||p_value_to_update);
754: END IF ;
755:
756: -- Call method from pay_user_column_instances_pkg Package to updaet the row.
757: pay_user_column_instances_pkg.update_row(
758: p_rowid => l_row_id
759: ,p_user_column_instance_id => l_column_instances_id
760: ,p_effective_start_date => p_row_effective_start_date -- changed from l_effective_start_date for BUG :4078709
761: ,p_effective_end_date => p_row_effective_end_date -- changed from l_effective_end_date for BUG :4078709