APPS.PAY_PUC_BUS dependencies on PAY_USER_COLUMNS

Line 35: , pay_user_columns puc

31: --
32: cursor csr_sec_grp is
33: select pbg.security_group_id
34: from per_business_groups pbg
35: , pay_user_columns puc
36: where puc.user_column_id = p_user_column_id
37: and pbg.business_group_id = puc.business_group_id;
38: --
39: -- Declare local variables

Line 99: , pay_user_columns puc

95: --
96: cursor csr_leg_code is
97: select pbg.legislation_code
98: from per_business_groups pbg
99: , pay_user_columns puc
100: where puc.user_column_id = p_user_column_id
101: and pbg.business_group_id (+) = puc.business_group_id;
102: --
103: -- Declare local variables

Line 267: (p_associated_column1 => 'PAY_USER_COLUMNS.LEGISLATION_CODE'

263: --
264: exception
265: when app_exception.application_exception then
266: if hr_multi_message.exception_add
267: (p_associated_column1 => 'PAY_USER_COLUMNS.LEGISLATION_CODE'
268: ) then
269: raise;
270: end if;
271: when others then

Line 321: -- with this PAY_USER_COLUMNS row.

317: end if;
318: close csr_user_table_id;
319: --
320: -- Confirm that the parent USER_TABLE's startup mode is compatible
321: -- with this PAY_USER_COLUMNS row.
322: --
323: if not pay_put_shd.chk_startup_mode_compatible
324: (p_parent_bgid => l_busgrpid
325: ,p_parent_legcode => l_legcode

Line 337: (p_associated_column1 => 'PAY_USER_COLUMNS.USER_TABLE_ID'

333: end if;
334: exception
335: when app_exception.application_exception then
336: if hr_multi_message.exception_add
337: (p_associated_column1 => 'PAY_USER_COLUMNS.USER_TABLE_ID'
338: ) then
339: raise;
340: end if;
341: when others then

Line 365: from pay_user_columns puc

361: (p_user_column_name in varchar2
362: ,p_user_table_id in number
363: ) is
364: select null
365: from pay_user_columns puc
366: where puc.user_table_id = p_user_table_id
367: and upper(puc.user_column_name) = p_user_column_name
368: and (p_business_group_id is null
369: or ( p_business_group_id is not null and p_business_group_id = puc.business_group_id )

Line 386: (p_check_column1 => 'PAY_USER_COLUMNS.USER_TABLE_ID'

382: l_name varchar2(200);
383: l_exists varchar2(1);
384: begin
385: if hr_multi_message.no_exclusive_error
386: (p_check_column1 => 'PAY_USER_COLUMNS.USER_TABLE_ID'
387: ,p_associated_column1 => 'PAY_USER_COLUMNS.USER_COLUMN_NAME'
388: ) and (
389: not pay_puc_shd.api_updating
390: (p_user_column_id => p_user_column_id

Line 387: ,p_associated_column1 => 'PAY_USER_COLUMNS.USER_COLUMN_NAME'

383: l_exists varchar2(1);
384: begin
385: if hr_multi_message.no_exclusive_error
386: (p_check_column1 => 'PAY_USER_COLUMNS.USER_TABLE_ID'
387: ,p_associated_column1 => 'PAY_USER_COLUMNS.USER_COLUMN_NAME'
388: ) and (
389: not pay_puc_shd.api_updating
390: (p_user_column_id => p_user_column_id
391: ,p_object_version_number => p_object_version_number

Line 419: (p_associated_column1 => 'PAY_USER_COLUMNS.USER_COLUMN_NAME'

415: end if;
416: exception
417: when app_exception.application_exception then
418: if hr_multi_message.exception_add
419: (p_associated_column1 => 'PAY_USER_COLUMNS.USER_COLUMN_NAME'
420: ) then
421: raise;
422: end if;
423: when others then

Line 507: -- PAY_USER_COLUMNS row. The formula is the parent.

503: end if;
504: close csr_formula_exists;
505: --
506: -- Confirm that formula's startup mode is compatible with this
507: -- PAY_USER_COLUMNS row. The formula is the parent.
508: --
509: if not pay_put_shd.chk_startup_mode_compatible
510: (p_parent_bgid => l_busgrpid
511: ,p_parent_legcode => l_legcode

Line 524: (p_associated_column1 => 'PAY_USER_COLUMNS.FORMULA_ID'

520: end if;
521: exception
522: when app_exception.application_exception then
523: if hr_multi_message.exception_add
524: (p_associated_column1 => 'PAY_USER_COLUMNS.FORMULA_ID'
525: ) then
526: raise;
527: end if;
528: when others then

Line 567: (p_associated_column1 => 'PAY_USER_COLUMNS.USER_COLUMN_ID'

563: close csr_values_exist;
564: exception
565: when app_exception.application_exception then
566: if hr_multi_message.exception_add
567: (p_associated_column1 => 'PAY_USER_COLUMNS.USER_COLUMN_ID'
568: ) then
569: raise;
570: end if;
571: when others then