DBA Data[Home] [Help]

APPS.HR_TEMPLATE_ITEMS_PKG dependencies on PER_RIC_PKG

Line 46: PER_RIC_PKG.chk_integrity (

42: -- Code Starts Here.
43: --
44:
45: BEGIN
46: PER_RIC_PKG.chk_integrity (
47: p_entity_name => 'HR_TEMPLATE_ITEMS_B',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),

Line 48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(

44:
45: BEGIN
46: PER_RIC_PKG.chk_integrity (
47: p_entity_name => 'HR_TEMPLATE_ITEMS_B',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
52: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL)))

Line 49: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_B', PER_RIC_PKG.column_info_tbl(

45: BEGIN
46: PER_RIC_PKG.chk_integrity (
47: p_entity_name => 'HR_TEMPLATE_ITEMS_B',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
52: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL)))
53: ),

Line 50: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),

46: PER_RIC_PKG.chk_integrity (
47: p_entity_name => 'HR_TEMPLATE_ITEMS_B',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
52: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL)))
53: ),
54: p_ref_type => 'INS');

Line 51: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

47: p_entity_name => 'HR_TEMPLATE_ITEMS_B',
48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
52: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL)))
53: ),
54: p_ref_type => 'INS');
55:

Line 52: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL)))

48: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
49: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_B', PER_RIC_PKG.column_info_tbl(
50: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
51: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
52: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL)))
53: ),
54: p_ref_type => 'INS');
55:
56: END;

Line 153: PER_RIC_PKG.chk_integrity (

149: -- Code Starts Here.
150: --
151:
152: BEGIN
153: PER_RIC_PKG.chk_integrity (
154: p_entity_name => 'HR_TEMPLATE_ITEMS_B',
155: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
156: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
157: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),

Line 155: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(

151:
152: BEGIN
153: PER_RIC_PKG.chk_integrity (
154: p_entity_name => 'HR_TEMPLATE_ITEMS_B',
155: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
156: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
157: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
158: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
159: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),

Line 156: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(

152: BEGIN
153: PER_RIC_PKG.chk_integrity (
154: p_entity_name => 'HR_TEMPLATE_ITEMS_B',
155: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
156: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
157: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
158: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
159: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
160: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_TAB_PAGES', PER_RIC_PKG.column_info_tbl(

Line 157: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),

153: PER_RIC_PKG.chk_integrity (
154: p_entity_name => 'HR_TEMPLATE_ITEMS_B',
155: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
156: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
157: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
158: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
159: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
160: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_TAB_PAGES', PER_RIC_PKG.column_info_tbl(
161: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL)))

Line 158: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(

154: p_entity_name => 'HR_TEMPLATE_ITEMS_B',
155: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
156: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
157: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
158: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
159: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
160: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_TAB_PAGES', PER_RIC_PKG.column_info_tbl(
161: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL)))
162: ),

Line 159: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),

155: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
156: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
157: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
158: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
159: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
160: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_TAB_PAGES', PER_RIC_PKG.column_info_tbl(
161: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL)))
162: ),
163: p_ref_type => 'DEL');

Line 160: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_TAB_PAGES', PER_RIC_PKG.column_info_tbl(

156: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
157: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
158: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
159: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
160: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_TAB_PAGES', PER_RIC_PKG.column_info_tbl(
161: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL)))
162: ),
163: p_ref_type => 'DEL');
164:

Line 161: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL)))

157: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
158: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(
159: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
160: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_TAB_PAGES', PER_RIC_PKG.column_info_tbl(
161: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL)))
162: ),
163: p_ref_type => 'DEL');
164:
165: END;