DBA Data[Home] [Help]

APPS.HR_TEMPLATE_ITEM_CONTEXTS_PKG dependencies on HR_ITEM_CONTEXTS

Line 52: PER_RIC_PKG.ref_info_rec('HR_ITEM_CONTEXTS', PER_RIC_PKG.column_info_tbl(

48: p_entity_name => 'HR_TEMPLATE_ITEM_CONTEXTS_B',
49: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
50: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
51: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
52: PER_RIC_PKG.ref_info_rec('HR_ITEM_CONTEXTS', PER_RIC_PKG.column_info_tbl(
53: PER_RIC_PKG.col_info_rec('ITEM_CONTEXT_ID',NULL,X_ITEM_CONTEXT_ID,NULL)))
54: ),
55: p_ref_type => 'INS');
56:

Line 285: from hr_item_contexts hic

281: and hft.template_name = x_template_name;
282:
283: select item_context_id
284: into x_item_context_id
285: from hr_item_contexts hic
286: ,fnd_id_flex_structures fifs
287: where nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
288: and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
289: and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)