APPS.PQH_RFT_SHD dependencies on PER_RIC_PKG

Line 333: PER_RIC_PKG.chk_integrity(

329: --
330: -- Added the following code as a part of Zero Downtime Patching Project.
331: -- Code Starts Here.
332: --
333: PER_RIC_PKG.chk_integrity(
334: p_entity_name=>'PQH_TEMPLATE_ATTRIBUTES',
335: p_ref_entity_info=>
336: PER_RIC_PKG.ref_entity_tbl(
337: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(

Line 336: PER_RIC_PKG.ref_entity_tbl(

332: --
333: PER_RIC_PKG.chk_integrity(
334: p_entity_name=>'PQH_TEMPLATE_ATTRIBUTES',
335: p_ref_entity_info=>
336: PER_RIC_PKG.ref_entity_tbl(
337: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_copied_attributes(cnt).attribute_id, NULL))),
339: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_template_id, NULL)))),

Line 337: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(

333: PER_RIC_PKG.chk_integrity(
334: p_entity_name=>'PQH_TEMPLATE_ATTRIBUTES',
335: p_ref_entity_info=>
336: PER_RIC_PKG.ref_entity_tbl(
337: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_copied_attributes(cnt).attribute_id, NULL))),
339: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_template_id, NULL)))),
341: p_ref_type=>'INS');

Line 338: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_copied_attributes(cnt).attribute_id, NULL))),

334: p_entity_name=>'PQH_TEMPLATE_ATTRIBUTES',
335: p_ref_entity_info=>
336: PER_RIC_PKG.ref_entity_tbl(
337: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_copied_attributes(cnt).attribute_id, NULL))),
339: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_template_id, NULL)))),
341: p_ref_type=>'INS');
342: --

Line 339: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(

335: p_ref_entity_info=>
336: PER_RIC_PKG.ref_entity_tbl(
337: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_copied_attributes(cnt).attribute_id, NULL))),
339: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_template_id, NULL)))),
341: p_ref_type=>'INS');
342: --
343: -- Code Ends Here

Line 340: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_template_id, NULL)))),

336: PER_RIC_PKG.ref_entity_tbl(
337: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_copied_attributes(cnt).attribute_id, NULL))),
339: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,p_template_id, NULL)))),
341: p_ref_type=>'INS');
342: --
343: -- Code Ends Here
344: --

Line 496: PER_RIC_PKG.chk_integrity(

492: and base_template_id = l_base_template_id;
493: else
494: close c_ref_templates;
495: --
496: PER_RIC_PKG.chk_integrity(
497: p_entity_name=>'PQH_REF_TEMPLATES',
498: p_ref_entity_info=>
499: PER_RIC_PKG.ref_entity_tbl(
500: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(

Line 499: PER_RIC_PKG.ref_entity_tbl(

495: --
496: PER_RIC_PKG.chk_integrity(
497: p_entity_name=>'PQH_REF_TEMPLATES',
498: p_ref_entity_info=>
499: PER_RIC_PKG.ref_entity_tbl(
500: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
501: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_PARENT_TEMPLATE_ID, NULL))),
502: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
503: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_BASE_TEMPLATE_ID, NULL)))),

Line 500: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(

496: PER_RIC_PKG.chk_integrity(
497: p_entity_name=>'PQH_REF_TEMPLATES',
498: p_ref_entity_info=>
499: PER_RIC_PKG.ref_entity_tbl(
500: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
501: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_PARENT_TEMPLATE_ID, NULL))),
502: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
503: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_BASE_TEMPLATE_ID, NULL)))),
504: p_ref_type=>'INS');

Line 501: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_PARENT_TEMPLATE_ID, NULL))),

497: p_entity_name=>'PQH_REF_TEMPLATES',
498: p_ref_entity_info=>
499: PER_RIC_PKG.ref_entity_tbl(
500: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
501: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_PARENT_TEMPLATE_ID, NULL))),
502: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
503: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_BASE_TEMPLATE_ID, NULL)))),
504: p_ref_type=>'INS');
505:

Line 502: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(

498: p_ref_entity_info=>
499: PER_RIC_PKG.ref_entity_tbl(
500: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
501: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_PARENT_TEMPLATE_ID, NULL))),
502: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
503: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_BASE_TEMPLATE_ID, NULL)))),
504: p_ref_type=>'INS');
505:
506: insert into pqh_ref_templates

Line 503: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_BASE_TEMPLATE_ID, NULL)))),

499: PER_RIC_PKG.ref_entity_tbl(
500: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
501: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_PARENT_TEMPLATE_ID, NULL))),
502: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
503: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_BASE_TEMPLATE_ID, NULL)))),
504: p_ref_type=>'INS');
505:
506: insert into pqh_ref_templates
507: (REF_TEMPLATE_ID, BASE_TEMPLATE_ID, PARENT_TEMPLATE_ID,