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.PAY_PUR_BUS dependencies on PAY_USER_TABLES

Line 226: ( p_user_table_id in PAY_USER_TABLES.USER_TABLE_ID%TYPE )

222: -- |----------------------< return_user_key_units >-------------------------|
223: -- ----------------------------------------------------------------------------
224: --
225: function return_user_key_units
226: ( p_user_table_id in PAY_USER_TABLES.USER_TABLE_ID%TYPE )
227: return varchar2 is
228: --
229: cursor csr_user_key_units
230: is

Line 232: from pay_user_tables put

228: --
229: cursor csr_user_key_units
230: is
231: select user_key_units
232: from pay_user_tables put
233: where put.user_table_id = p_user_table_id ;
234:
235: l_proc varchar2(100) := g_package || 'return_user_key_units';
236: --

Line 279: ( p_user_table_id in PAY_USER_TABLES.USER_TABLE_ID%TYPE )

275: -- |----------------------< return_range_or_match >--------------------------|
276: -- ----------------------------------------------------------------------------
277: --
278: function return_range_or_match
279: ( p_user_table_id in PAY_USER_TABLES.USER_TABLE_ID%TYPE )
280: return varchar2 is
281: --
282: cursor csr_range_or_match
283: is

Line 285: from pay_user_tables put

281: --
282: cursor csr_range_or_match
283: is
284: select range_or_match
285: from pay_user_tables put
286: where put.user_table_id = p_user_table_id ;
287:
288: l_proc varchar2(100) := g_package || 'return_range_or_match';
289: --

Line 331: -- Validates that the user_table_id exists in pay_user_tables

327: -- |--------------------------< chk_user_table_id >---------------------------|
328: -- ----------------------------------------------------------------------------
329: --
330: -- Description:
331: -- Validates that the user_table_id exists in pay_user_tables
332: --
333: -- Pre-Requisites:
334: -- None
335: --

Line 362: from pay_user_tables put

358: ) is
359: --
360: cursor csr_user_table_id is
361: select put.legislation_code , put.business_group_id
362: from pay_user_tables put
363: where put.user_table_id = p_user_table_id ;
364: --
365: l_busgrpid PAY_USER_ROWS_F.BUSINESS_GROUP_ID%TYPE;
366: l_legcode PAY_USER_ROWS_F.LEGISLATION_CODE%TYPE;

Line 437: -- p_format_code - This relates to user_key_units column in pay_user_tables

433: --
434: -- In Parameters:
435: -- p_value - This relates to the row_low_range_or_name or row_high_range
436: -- columns in pay_user_rows_f table
437: -- p_format_code - This relates to user_key_units column in pay_user_tables
438: --
439: -- Post Success:
440: -- Processing continues if p_value is valid.
441: --

Line 508: -- 3. Is in the format as specified by user_key_units in pay_user_tables

504: -- Description:
505: -- Validates that the row_low_range_or_name
506: -- 1. Is Mandatory.
507: -- 2. Is Numeric if range match is used.
508: -- 3. Is in the format as specified by user_key_units in pay_user_tables
509: -- (Conditional)
510: -- 4. Is Unique. (Conditional)
511: --
512: -- Pre-Requisites:

Line 582: l_range_or_match PAY_USER_TABLES.RANGE_OR_MATCH%TYPE;

578: usr.effective_end_date >= p_validation_start_date );
579:
580:
581: l_proc varchar2(100) := g_package || 'chk_row_low_range_or_name';
582: l_range_or_match PAY_USER_TABLES.RANGE_OR_MATCH%TYPE;
583: l_user_key_units PAY_USER_TABLES.USER_KEY_UNITS%TYPE;
584: l_exists varchar2(1);
585: l_result boolean;
586: l_prod_status varchar2(1);

Line 583: l_user_key_units PAY_USER_TABLES.USER_KEY_UNITS%TYPE;

579:
580:
581: l_proc varchar2(100) := g_package || 'chk_row_low_range_or_name';
582: l_range_or_match PAY_USER_TABLES.RANGE_OR_MATCH%TYPE;
583: l_user_key_units PAY_USER_TABLES.USER_KEY_UNITS%TYPE;
584: l_exists varchar2(1);
585: l_result boolean;
586: l_prod_status varchar2(1);
587: l_ghr_installed varchar2(1);

Line 740: l_range_or_match PAY_USER_TABLES.RANGE_OR_MATCH%TYPE;

736: ,p_effective_date in date
737: ) is
738: --
739: l_proc varchar2(100) := g_package || 'chk_row_high_range';
740: l_range_or_match PAY_USER_TABLES.RANGE_OR_MATCH%TYPE;
741: l_user_key_units PAY_USER_TABLES.USER_KEY_UNITS%TYPE;
742: l_exists varchar2(1);
743: l_result boolean;
744: --

Line 741: l_user_key_units PAY_USER_TABLES.USER_KEY_UNITS%TYPE;

737: ) is
738: --
739: l_proc varchar2(100) := g_package || 'chk_row_high_range';
740: l_range_or_match PAY_USER_TABLES.RANGE_OR_MATCH%TYPE;
741: l_user_key_units PAY_USER_TABLES.USER_KEY_UNITS%TYPE;
742: l_exists varchar2(1);
743: l_result boolean;
744: --
745: begin

Line 890: l_range_or_match PAY_USER_TABLES.RANGE_OR_MATCH%TYPE;

886: and ( usr.effective_start_date <= p_validation_end_date and
887: usr.effective_end_date >= p_validation_start_date );
888:
889: l_proc varchar2(100) := g_package || 'chk_range';
890: l_range_or_match PAY_USER_TABLES.RANGE_OR_MATCH%TYPE;
891: l_user_key_units PAY_USER_TABLES.USER_KEY_UNITS%TYPE;
892: l_exists varchar2(1);
893: l_result boolean;
894: l_prod_status varchar2(1);

Line 891: l_user_key_units PAY_USER_TABLES.USER_KEY_UNITS%TYPE;

887: usr.effective_end_date >= p_validation_start_date );
888:
889: l_proc varchar2(100) := g_package || 'chk_range';
890: l_range_or_match PAY_USER_TABLES.RANGE_OR_MATCH%TYPE;
891: l_user_key_units PAY_USER_TABLES.USER_KEY_UNITS%TYPE;
892: l_exists varchar2(1);
893: l_result boolean;
894: l_prod_status varchar2(1);
895: l_ghr_installed varchar2(1);

Line 1165: l_range_or_match PAY_USER_TABLES.RANGE_OR_MATCH%TYPE;

1161:
1162: l_exists varchar2(1);
1163: l_proc varchar2(100) := g_package || 'chk_delete';
1164: l_result boolean;
1165: l_range_or_match PAY_USER_TABLES.RANGE_OR_MATCH%TYPE;
1166: l_prod_status varchar2(1);
1167: l_ghr_installed varchar2(1);
1168: l_industry varchar2(1);
1169: l_oracle_scheema varchar2(30);