DBA Data[Home] [Help]

APPS.PER_SSL_BUS dependencies on STANDARD

Line 420: -- b) Exists in hr_standard_lookups for lookup_type 'SURVEY_JOB_NAME'.

416: --
417: -- Description
418: -- This Procedure is used to check that survey_job_name_code:
419: -- a) Is not null.
420: -- b) Exists in hr_standard_lookups for lookup_type 'SURVEY_JOB_NAME'.
421: -- c) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two
422: -- letters.
423: --
424: --

Line 438: -- exists in hr_standard_lookups and

434: --
435: -- Post Success
436: -- Processing continues If the survey_job_name_code
437: -- is not null
438: -- exists in hr_standard_lookups and
439: -- PSS.IDENTIFIER makes up its first two letters.
440: --
441: -- Post Failure
442: -- An application error is raised and processing is terminated

Line 444: -- If the survey_job_name_code does not exist in hr_standard_lookups.

440: --
441: -- Post Failure
442: -- An application error is raised and processing is terminated
443: -- If survey_job_name_code is null
444: -- If the survey_job_name_code does not exist in hr_standard_lookups.
445: -- or PSS.IDENTIFIER does not make up the first two letters of
446: -- survey_job_name_code.
447: --
448: -- Developer/Implementation Notes

Line 519: -- in hr_standard_lookups where the lookup_type is 'SURVEY_JOB_NAME'

515: --
516: hr_utility.set_location(l_proc, 20);
517: --
518: -- Check If the survey_job_name_code value exists
519: -- in hr_standard_lookups where the lookup_type is 'SURVEY_JOB_NAME'
520: --
521: If hr_api.not_exists_in_hr_lookups --fix for bug 7240498
522: (p_effective_date => p_effective_date
523: ,p_lookup_type => 'SURVEY_JOB_NAME'

Line 572: -- a) Exists in hr_standard_lookups for lookup_type 'SURVEY_REGION'.

568: -- ---------------------------------------------------------------
569: --
570: -- Description
571: -- This Procedure is used to check that survey_region_code:
572: -- a) Exists in hr_standard_lookups for lookup_type 'SURVEY_REGION'.
573: -- b) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two
574: -- letters
575: --
576: -- Pre Requisites

Line 588: -- exists in hr_standard_lookups and

584: -- not_exists_in_hrstanlookups)
585: --
586: -- Post Success
587: -- Processing continues If the survey_region_code
588: -- exists in hr_standard_lookups and
589: -- SSM.IDENTIFIER makes up its first two letters.
590: --
591: -- Post Failure
592: -- An application error is raised and processing is terminated

Line 593: -- If the survey_region_code does not exist in hr_standard_lookups.

589: -- SSM.IDENTIFIER makes up its first two letters.
590: --
591: -- Post Failure
592: -- An application error is raised and processing is terminated
593: -- If the survey_region_code does not exist in hr_standard_lookups.
594: -- or PSS.IDENTIFIER does not make up the first two letters of
595: -- survey_region_code.
596: --
597: -- Developer/Implementation Notes

Line 663: -- in hr_standard_lookups where the lookup_type is 'SURVEY_REGION'

659: --
660: hr_utility.set_location(l_proc, 20);
661: --
662: -- Check If the survey_region_code value exists
663: -- in hr_standard_lookups where the lookup_type is 'SURVEY_REGION'
664: --
665: If hr_api.not_exists_in_hrstanlookups
666: (p_effective_date => p_effective_date
667: ,p_lookup_type => 'SURVEY_REGION'

Line 718: -- a) Exists in hr_standard_lookups for lookup_type 'SURVEY_SENIORITY'.

714: -- ---------------------------------------------------------------
715: --
716: -- Description
717: -- This Procedure is used to check that survey_seniority_code:
718: -- a) Exists in hr_standard_lookups for lookup_type 'SURVEY_SENIORITY'.
719: -- b) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two
720: -- letters
721: --
722: -- Pre Requisites

Line 734: -- exists in hr_standard_lookups and

730: -- not_exists_in_hrstanlookups)
731: --
732: -- Post Success
733: -- Processing continues If the survey_seniority_code
734: -- exists in hr_standard_lookups and
735: -- PSS.IDENTIFIER makes up its first two letters.
736: --
737: -- Post Failure
738: -- An application error is raised and processing is terminated

Line 739: -- If the survey_seniority_code does not exist in hr_standard_lookups.

735: -- PSS.IDENTIFIER makes up its first two letters.
736: --
737: -- Post Failure
738: -- An application error is raised and processing is terminated
739: -- If the survey_seniority_code does not exist in hr_standard_lookups.
740: -- or PSS.IDENTIFIER does not make up the first two letters of
741: -- survey_seniority_code.
742: --
743: -- Developer/Implementation Notes

Line 809: -- in hr_standard_lookups where the lookup_type is 'SURVEY_SENIORITY'

805: --
806: hr_utility.set_location(l_proc, 20);
807: --
808: -- Check If the survey_seniority_code value exists
809: -- in hr_standard_lookups where the lookup_type is 'SURVEY_SENIORITY'
810: --
811: If hr_api.not_exists_in_hrstanlookups
812: (p_effective_date => p_effective_date
813: ,p_lookup_type => 'SURVEY_SENIORITY'

Line 863: -- a) Exists in hr_standard_lookups for lookup_type 'COMPANY_SIZE'.

859: -- ---------------------------------------------------------------
860: --
861: -- Description
862: -- This Procedure is used to check that company_size_code:
863: -- a) Exists in hr_standard_lookups for lookup_type 'COMPANY_SIZE'.
864: -- b) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two
865: -- letters
866: --
867: -- Pre Requisites

Line 879: -- exists in hr_standard_lookups and

875: -- not_exists_in_hrstanlookups)
876: --
877: -- Post Success
878: -- Processing continues If the company_size_code
879: -- exists in hr_standard_lookups and
880: -- PSS.IDENTIFIER makes up its first two letters.
881: --
882: -- Post Failure
883: -- An application error is raised and processing is terminated

Line 884: -- If the company_size_code does not exist in hr_standard_lookups.

880: -- PSS.IDENTIFIER makes up its first two letters.
881: --
882: -- Post Failure
883: -- An application error is raised and processing is terminated
884: -- If the company_size_code does not exist in hr_standard_lookups.
885: -- or PSS.IDENTIFIER does not make up the first two letters of
886: -- company_size_code.
887: --
888: -- Developer/Implementation Notes

Line 954: -- in hr_standard_lookups where the lookup_type is 'COMPANY_SIZE'

950: --
951: hr_utility.set_location(l_proc, 20);
952: --
953: -- Check If the company_size_code value exists
954: -- in hr_standard_lookups where the lookup_type is 'COMPANY_SIZE'
955: --
956: If hr_api.not_exists_in_hrstanlookups
957: (p_effective_date => p_effective_date
958: ,p_lookup_type => 'COMPANY_SIZE'

Line 1008: -- a) Exists in hr_standard_lookups for lookup_type 'INDUSTRY'.

1004: -- ---------------------------------------------------------------
1005: --
1006: -- Description
1007: -- This Procedure is used to check that industry_code:
1008: -- a) Exists in hr_standard_lookups for lookup_type 'INDUSTRY'.
1009: -- b) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two
1010: -- letters
1011: --
1012: -- Pre Requisites

Line 1020: -- hr_standard_lookups)

1016: -- object_version_number
1017: -- salary_survey_line_id
1018: -- industry_code.
1019: -- p_effective_date (used as parameter for not_exists in
1020: -- hr_standard_lookups)
1021: --
1022: -- Post Success
1023: -- Processing continues If the industry_code
1024: -- exists in hr_standard_lookups and

Line 1024: -- exists in hr_standard_lookups and

1020: -- hr_standard_lookups)
1021: --
1022: -- Post Success
1023: -- Processing continues If the industry_code
1024: -- exists in hr_standard_lookups and
1025: -- PSS.IDENTIFIER makes up its first two letters.
1026: --
1027: -- Post Failure
1028: -- An application error is raised and processing is terminated

Line 1029: -- If the industry_code does not exist in hr_standard_lookups.

1025: -- PSS.IDENTIFIER makes up its first two letters.
1026: --
1027: -- Post Failure
1028: -- An application error is raised and processing is terminated
1029: -- If the industry_code does not exist in hr_standard_lookups.
1030: -- or PSS.IDENTIFIER does not make up the first two letters of
1031: -- industry_code.
1032: --
1033: -- Developer/Implementation Notes

Line 1101: -- in hr_standard_lookups where the lookup_type is 'INDUSTRY'

1097: --
1098: hr_utility.set_location(l_proc, 20);
1099: --
1100: -- Check If the industry_code value exists
1101: -- in hr_standard_lookups where the lookup_type is 'INDUSTRY'
1102: --
1103: If hr_api.not_exists_in_hrstanlookups
1104: (p_effective_date => p_effective_date
1105: ,p_lookup_type => 'INDUSTRY'

Line 1157: -- a) Exists in hr_standard_lookups for lookup_type 'SURVEY_AGE'.

1153: -- ---------------------------------------------------------------
1154: --
1155: -- Description
1156: -- This Procedure is used to check that survey_age_code:
1157: -- a) Exists in hr_standard_lookups for lookup_type 'SURVEY_AGE'.
1158: -- b) Contains PER_SALARY_SURVEYS.IDENTIFIER as its first two
1159: -- letters
1160: --
1161: -- Pre Requisites

Line 1169: -- hr_standard_lookups)

1165: -- object_version_number
1166: -- salary_survey_line_id
1167: -- survey_age_code.
1168: -- p_effective_date (used as parameter for not_exists in
1169: -- hr_standard_lookups)
1170: --
1171: -- Post Success
1172: -- Processing continues If the survey_age_code
1173: -- exists in hr_standard_lookups and

Line 1173: -- exists in hr_standard_lookups and

1169: -- hr_standard_lookups)
1170: --
1171: -- Post Success
1172: -- Processing continues If the survey_age_code
1173: -- exists in hr_standard_lookups and
1174: -- PSS.IDENTIFIER makes up its first two letters.
1175: --
1176: -- Post Failure
1177: -- An application error is raised and processing is terminated

Line 1178: -- If the survey_age_code does not exist in hr_standard_lookups.

1174: -- PSS.IDENTIFIER makes up its first two letters.
1175: --
1176: -- Post Failure
1177: -- An application error is raised and processing is terminated
1178: -- If the survey_age_code does not exist in hr_standard_lookups.
1179: -- or PSS.IDENTIFIER does not make up the first two letters of
1180: -- survey_age_code.
1181: --
1182: -- Developer/Implementation Notes

Line 1250: -- in hr_standard_lookups where the lookup_type is 'SURVEY_AGE'

1246: --
1247: hr_utility.set_location(l_proc, 20);
1248: --
1249: -- Check If the survey_age_code value exists
1250: -- in hr_standard_lookups where the lookup_type is 'SURVEY_AGE'
1251: --
1252: If hr_api.not_exists_in_hrstanlookups
1253: (p_effective_date => p_effective_date
1254: ,p_lookup_type => 'SURVEY_AGE'

Line 1305: -- a) Exists in hr_standard_lookups for lookup_type 'STOCK_DISPLAY_TYPE'.

1301: -- -------------------------------------------------------------------------------
1302: --
1303: -- Description
1304: -- This Procedure is used to check that stock_display_type_code:
1305: -- a) Exists in hr_standard_lookups for lookup_type 'STOCK_DISPLAY_TYPE'.
1306: --
1307: -- Pre Requisites
1308: -- None.
1309: --

Line 1319: -- exists in hr_standard_lookups.

1315: -- not_exists_in_hrstanlookups)
1316: --
1317: -- Post Success
1318: -- Processing continues If the stock_display_type_code
1319: -- exists in hr_standard_lookups.
1320: --
1321: -- Post Failure
1322: -- An application error is raised and processing is terminated
1323: -- If the stock_display_type_code does not exist in hr_standard_lookups.

Line 1323: -- If the stock_display_type_code does not exist in hr_standard_lookups.

1319: -- exists in hr_standard_lookups.
1320: --
1321: -- Post Failure
1322: -- An application error is raised and processing is terminated
1323: -- If the stock_display_type_code does not exist in hr_standard_lookups.
1324: --
1325: -- Developer/Implementation Notes
1326: -- None.
1327: --

Line 1385: -- in hr_standard_lookups where the lookup_type is 'STOCK_DISPLAY_TYPE'

1381: --
1382: hr_utility.set_location(l_proc, 20);
1383: --
1384: -- Check If the stock_display_type_code value exists
1385: -- in hr_standard_lookups where the lookup_type is 'STOCK_DISPLAY_TYPE'
1386: --
1387: If hr_api.not_exists_in_hrstanlookups
1388: (p_effective_date => p_effective_date
1389: ,p_lookup_type => 'STOCK_DISPLAY_TYPE'

Line 1881: -- exists in hr_standard_lookups and is not null.

1877: -- p_effective_date
1878: --
1879: -- Post Success
1880: -- Processing continues if the currency_code
1881: -- exists in hr_standard_lookups and is not null.
1882: --
1883: -- Post Failure
1884: -- An application error is raised and processing is terminated
1885: -- if the currency_code does not exist in hr_standard_lookups or is null.

Line 1885: -- if the currency_code does not exist in hr_standard_lookups or is null.

1881: -- exists in hr_standard_lookups and is not null.
1882: --
1883: -- Post Failure
1884: -- An application error is raised and processing is terminated
1885: -- if the currency_code does not exist in hr_standard_lookups or is null.
1886: --
1887: -- Developer/Implementation Notes
1888: -- None.
1889: --