APPS.PQH_CTL_BUS dependencies on PQH_CTL_SHD

Line 47: l_api_updating := pqh_ctl_shd.api_updating

43: Begin
44: --
45: hr_utility.set_location('Entering:'||l_proc, 5);
46: --
47: l_api_updating := pqh_ctl_shd.api_updating
48: (p_transaction_category_id => p_transaction_category_id,
49: p_language => p_language);
50: --
51: if (l_api_updating

Line 53: <> pqh_ctl_shd.g_old_rec.transaction_category_id) then

49: p_language => p_language);
50: --
51: if (l_api_updating
52: and nvl(p_transaction_category_id,hr_api.g_number)
53: <> pqh_ctl_shd.g_old_rec.transaction_category_id) then
54: --
55: -- raise error as PK has changed
56: --
57: pqh_ctl_shd.constraint_error('PQH_TXN_CATEGORIES_TL_PK');

Line 57: pqh_ctl_shd.constraint_error('PQH_TXN_CATEGORIES_TL_PK');

53: <> pqh_ctl_shd.g_old_rec.transaction_category_id) then
54: --
55: -- raise error as PK has changed
56: --
57: pqh_ctl_shd.constraint_error('PQH_TXN_CATEGORIES_TL_PK');
58: --
59: elsif not l_api_updating then
60: --
61: -- check if PK is null

Line 67: pqh_ctl_shd.constraint_error('PQH_TXN_CATEGORIES_TL_PK');

63: if p_transaction_category_id is not null then
64: --
65: -- raise error as PK is not null
66: --
67: pqh_ctl_shd.constraint_error('PQH_TXN_CATEGORIES_TL_PK');
68: --
69: end if;
70: --
71: end if;

Line 80: Procedure insert_validate(p_rec in pqh_ctl_shd.g_rec_type) is

76: --
77: -- ----------------------------------------------------------------------------
78: -- |---------------------------< insert_validate >----------------------------|
79: -- ----------------------------------------------------------------------------
80: Procedure insert_validate(p_rec in pqh_ctl_shd.g_rec_type) is
81: --
82: l_proc varchar2(72) := g_package||'insert_validate';
83: --
84: Begin

Line 101: Procedure update_validate(p_rec in pqh_ctl_shd.g_rec_type) is

97: --
98: -- ----------------------------------------------------------------------------
99: -- |---------------------------< update_validate >----------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure update_validate(p_rec in pqh_ctl_shd.g_rec_type) is
102: --
103: l_proc varchar2(72) := g_package||'update_validate';
104: --
105: Begin

Line 122: Procedure delete_validate(p_rec in pqh_ctl_shd.g_rec_type) is

118: --
119: -- ----------------------------------------------------------------------------
120: -- |---------------------------< delete_validate >----------------------------|
121: -- ----------------------------------------------------------------------------
122: Procedure delete_validate(p_rec in pqh_ctl_shd.g_rec_type) is
123: --
124: l_proc varchar2(72) := g_package||'delete_validate';
125: --
126: Begin