DBA Data[Home] [Help]

APPS.PQH_TEM_DEL dependencies on PER_RIC_PKG

Line 52: PER_RIC_PKG.chk_integrity(

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(

Line 55: PER_RIC_PKG.ref_entity_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))),

Line 56: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(

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(

Line 57: PER_RIC_PKG.col_info_rec('BASE_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),

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))),

Line 58: PER_RIC_PKG.ref_info_rec('PQH_REF_TEMPLATES',PER_RIC_PKG.column_info_tbl(

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(

Line 59: PER_RIC_PKG.col_info_rec('PARENT_TEMPLATE_ID', NULL,p_rec.template_id, NULL))),

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)))),

Line 60: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES', PER_RIC_PKG.column_info_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)))),
64: p_ref_type=>'DEL');

Line 61: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL))),

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: --

Line 62: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(

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.

Line 63: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_rec.template_id,NULL)))),

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: --