52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55:
56: PER_RIC_PKG.chk_integrity(
57: p_entity_name=>'PQH_REF_TEMPLATES',
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
55:
56: PER_RIC_PKG.chk_integrity(
57: p_entity_name=>'PQH_REF_TEMPLATES',
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.parent_template_id, NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.base_template_id, NULL)))),
56: PER_RIC_PKG.chk_integrity(
57: p_entity_name=>'PQH_REF_TEMPLATES',
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.parent_template_id, NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.base_template_id, NULL)))),
64: p_ref_type=>'INS');
57: p_entity_name=>'PQH_REF_TEMPLATES',
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.parent_template_id, NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.base_template_id, NULL)))),
64: p_ref_type=>'INS');
65: --
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.parent_template_id, NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.base_template_id, NULL)))),
64: p_ref_type=>'INS');
65: --
66: -- Insert the row into: pqh_ref_templates
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.parent_template_id, NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.base_template_id, NULL)))),
64: p_ref_type=>'INS');
65: --
66: -- Insert the row into: pqh_ref_templates
67: --