48: --
49: Begin
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: PER_RIC_PKG.chk_integrity(
53: p_entity_name=>'PQH_TEMPLATES',
54: p_ref_entity_info =>
55: PER_RIC_PKG.ref_entity_tbl(
56: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
51: --
52: PER_RIC_PKG.chk_integrity(
53: p_entity_name=>'PQH_TEMPLATES',
54: p_ref_entity_info =>
55: PER_RIC_PKG.ref_entity_tbl(
56: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
57: PER_RIC_PKG.col_info_rec('BASE_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
58: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
59: PER_RIC_PKG.col_info_rec('PARENT_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
52: PER_RIC_PKG.chk_integrity(
53: p_entity_name=>'PQH_TEMPLATES',
54: p_ref_entity_info =>
55: PER_RIC_PKG.ref_entity_tbl(
56: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
57: PER_RIC_PKG.col_info_rec('BASE_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
58: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
59: PER_RIC_PKG.col_info_rec('PARENT_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES', PER_RIC_PKG.column_info_tbl(
53: p_entity_name=>'PQH_TEMPLATES',
54: p_ref_entity_info =>
55: PER_RIC_PKG.ref_entity_tbl(
56: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
57: PER_RIC_PKG.col_info_rec('BASE_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
58: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
59: PER_RIC_PKG.col_info_rec('PARENT_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES', PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL))),
54: p_ref_entity_info =>
55: PER_RIC_PKG.ref_entity_tbl(
56: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
57: PER_RIC_PKG.col_info_rec('BASE_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
58: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
59: PER_RIC_PKG.col_info_rec('PARENT_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES', PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
55: PER_RIC_PKG.ref_entity_tbl(
56: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
57: PER_RIC_PKG.col_info_rec('BASE_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
58: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
59: PER_RIC_PKG.col_info_rec('PARENT_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES', PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL)))),
56: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
57: PER_RIC_PKG.col_info_rec('BASE_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
58: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
59: PER_RIC_PKG.col_info_rec('PARENT_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES', PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL)))),
64: p_ref_type=>'DEL');
57: PER_RIC_PKG.col_info_rec('BASE_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
58: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
59: PER_RIC_PKG.col_info_rec('PARENT_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES', PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL)))),
64: p_ref_type=>'DEL');
65: --
58: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(
59: PER_RIC_PKG.col_info_rec('PARENT_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES', PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL)))),
64: p_ref_type=>'DEL');
65: --
66: -- Delete the pqh_templates row.
59: PER_RIC_PKG.col_info_rec('PARENT_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),
60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES', PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL)))),
64: p_ref_type=>'DEL');
65: --
66: -- Delete the pqh_templates row.
67: --