DBA Data[Home] [Help]

APPS.PQH_RST_INS dependencies on PER_RIC_PKG

Line 59: PER_RIC_PKG.chk_integrity (

55: --
56: -- Added the following code as a part of Zero Downtime Patching Project.
57: -- Code Starts Here.
58: --
59: PER_RIC_PKG.chk_integrity (
60: p_entity_name=>'PQH_RULE_SETS',
61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(

Line 62: PER_RIC_PKG.ref_entity_tbl(

58: --
59: PER_RIC_PKG.chk_integrity (
60: p_entity_name=>'PQH_RULE_SETS',
61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('BUSINESS_GROUP_ID',NULL,p_rec.business_group_id, NULL))),

Line 63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(

59: PER_RIC_PKG.chk_integrity (
60: p_entity_name=>'PQH_RULE_SETS',
61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('BUSINESS_GROUP_ID',NULL,p_rec.business_group_id, NULL))),
67: PER_RIC_PKG.ref_info_rec('PER_ORGANIZATION_STRUCTURES',PER_RIC_PKG.column_info_tbl(

Line 64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),

60: p_entity_name=>'PQH_RULE_SETS',
61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('BUSINESS_GROUP_ID',NULL,p_rec.business_group_id, NULL))),
67: PER_RIC_PKG.ref_info_rec('PER_ORGANIZATION_STRUCTURES',PER_RIC_PKG.column_info_tbl(
68: PER_RIC_PKG.col_info_rec('ORGANIZATION_STRUCTURE_ID',NULL,p_rec.organization_structure_id, NULL)))),

Line 65: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(

61: p_ref_entity_info=>
62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('BUSINESS_GROUP_ID',NULL,p_rec.business_group_id, NULL))),
67: PER_RIC_PKG.ref_info_rec('PER_ORGANIZATION_STRUCTURES',PER_RIC_PKG.column_info_tbl(
68: PER_RIC_PKG.col_info_rec('ORGANIZATION_STRUCTURE_ID',NULL,p_rec.organization_structure_id, NULL)))),
69: p_ref_type=>'INS');

Line 66: PER_RIC_PKG.col_info_rec('BUSINESS_GROUP_ID',NULL,p_rec.business_group_id, NULL))),

62: PER_RIC_PKG.ref_entity_tbl(
63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('BUSINESS_GROUP_ID',NULL,p_rec.business_group_id, NULL))),
67: PER_RIC_PKG.ref_info_rec('PER_ORGANIZATION_STRUCTURES',PER_RIC_PKG.column_info_tbl(
68: PER_RIC_PKG.col_info_rec('ORGANIZATION_STRUCTURE_ID',NULL,p_rec.organization_structure_id, NULL)))),
69: p_ref_type=>'INS');
70: --

Line 67: PER_RIC_PKG.ref_info_rec('PER_ORGANIZATION_STRUCTURES',PER_RIC_PKG.column_info_tbl(

63: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('BUSINESS_GROUP_ID',NULL,p_rec.business_group_id, NULL))),
67: PER_RIC_PKG.ref_info_rec('PER_ORGANIZATION_STRUCTURES',PER_RIC_PKG.column_info_tbl(
68: PER_RIC_PKG.col_info_rec('ORGANIZATION_STRUCTURE_ID',NULL,p_rec.organization_structure_id, NULL)))),
69: p_ref_type=>'INS');
70: --
71: -- Code Ends Here

Line 68: PER_RIC_PKG.col_info_rec('ORGANIZATION_STRUCTURE_ID',NULL,p_rec.organization_structure_id, NULL)))),

64: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,p_rec.organization_id, NULL))),
65: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS',PER_RIC_PKG.column_info_tbl(
66: PER_RIC_PKG.col_info_rec('BUSINESS_GROUP_ID',NULL,p_rec.business_group_id, NULL))),
67: PER_RIC_PKG.ref_info_rec('PER_ORGANIZATION_STRUCTURES',PER_RIC_PKG.column_info_tbl(
68: PER_RIC_PKG.col_info_rec('ORGANIZATION_STRUCTURE_ID',NULL,p_rec.organization_structure_id, NULL)))),
69: p_ref_type=>'INS');
70: --
71: -- Code Ends Here
72: --