DBA Data[Home] [Help]

APPS.PQH_TCA_INS dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 61: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',

57: -- Code Starts Here.
58: --
59:
60: PER_RIC_PKG.chk_integrity (
61: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
62: p_ref_entity_info=>
63: PER_RIC_PKG.ref_entity_tbl(
64: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,p_rec.transaction_table_route_id, NULL))),

Line 75: -- Insert the row into: pqh_txn_category_attributes

71: --
72: -- Code Ends Here
73: --
74: --
75: -- Insert the row into: pqh_txn_category_attributes
76: --
77: insert into pqh_txn_category_attributes
78: ( txn_category_attribute_id,
79: attribute_id,

Line 77: insert into pqh_txn_category_attributes

73: --
74: --
75: -- Insert the row into: pqh_txn_category_attributes
76: --
77: insert into pqh_txn_category_attributes
78: ( txn_category_attribute_id,
79: attribute_id,
80: transaction_category_id,
81: value_set_id,

Line 168: Cursor C_Sel1 is select pqh_txn_category_attributes_s.nextval from sys.dual;

164: Procedure pre_insert(p_rec in out nocopy pqh_tca_shd.g_rec_type) is
165: --
166: l_proc varchar2(72) := g_package||'pre_insert';
167: --
168: Cursor C_Sel1 is select pqh_txn_category_attributes_s.nextval from sys.dual;
169: --
170: Begin
171: hr_utility.set_location('Entering:'||l_proc, 5);
172: --

Line 251: (p_module_name => 'pqh_txn_category_attributes'

247: --
248: when hr_api.cannot_find_prog_unit then
249: --
250: hr_api.cannot_find_prog_unit_error
251: (p_module_name => 'pqh_txn_category_attributes'
252: ,p_hook_type => 'AI');
253: --
254: end;
255: --