APPS.PQH_RTM_BUS dependencies on PQH_TEMPLATES

Line 111: from pqh_templates a

107: l_dummy varchar2(1);
108: --
109: cursor c1 is
110: select null
111: from pqh_templates a
112: where a.template_id = p_template_id;
113: --
114: Begin
115: --

Line 128: -- check if template_id value exists in pqh_templates table

124: <> nvl(pqh_rtm_shd.g_old_rec.template_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_template_id is not null then
127: --
128: -- check if template_id value exists in pqh_templates table
129: --
130: open c1;
131: --
132: fetch c1 into l_dummy;

Line 137: -- raise error as FK does not relate to PK in pqh_templates

133: if c1%notfound then
134: --
135: close c1;
136: --
137: -- raise error as FK does not relate to PK in pqh_templates
138: -- table.
139: --
140: pqh_rtm_shd.constraint_error('PQH_ROLE_TEMPLATES_FK3');
141: --

Line 476: from pqh_templates a

472: l_dummy varchar2(1);
473: --
474: cursor c1 is
475: select null
476: from pqh_templates a
477: where a.transaction_category_id=p_transaction_category_id
478: and a.template_id = p_template_id;
479: --
480: Begin

Line 497: -- check if transaction_category_id and template_id value exists in pqh_templates table

493: or not l_api_updating) and
494: (p_transaction_category_id is not null
495: or p_template_id is not null) then
496: --
497: -- check if transaction_category_id and template_id value exists in pqh_templates table
498: --
499: open c1;
500: --
501: fetch c1 into l_dummy;

Line 506: -- raise error as FK does not relate to PK in pqh_templates

502: if c1%notfound then
503: --
504: close c1;
505: --
506: -- raise error as FK does not relate to PK in pqh_templates
507: -- table.
508: --
509: pqh_rtm_shd.constraint_error('RTM_TCT_TEM_FK');
510: --