APPS.PQH_CTL_UPD dependencies on PQH_TRANSACTION_CATEGORIES

Line 57: -- Update the pqh_transaction_categories_tl Row

53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: --
56: --
57: -- Update the pqh_transaction_categories_tl Row
58: --
59: update pqh_transaction_categories_tl
60: set
61: transaction_category_id = p_rec.transaction_category_id,

Line 59: update pqh_transaction_categories_tl

55: --
56: --
57: -- Update the pqh_transaction_categories_tl Row
58: --
59: update pqh_transaction_categories_tl
60: set
61: transaction_category_id = p_rec.transaction_category_id,
62: name = p_rec.name,
63: language = p_rec.language,

Line 190: (p_module_name => 'pqh_transaction_categories_tl'

186: --
187: when hr_api.cannot_find_prog_unit then
188: --
189: hr_api.cannot_find_prog_unit_error
190: (p_module_name => 'pqh_transaction_categories_tl'
191: ,p_hook_type => 'AU');
192: --
193: end;
194: --

Line 363: from pqh_transaction_categories_tl ctl

359: p_name in varchar2 ) is
360: --
361: cursor csr_upd_langs is
362: select ctl.language
363: from pqh_transaction_categories_tl ctl
364: where ctl.transaction_category_id = p_transaction_category_id
365: AND p_language_code in (ctl.language,ctl.source_lang);
366: --
367: l_proc varchar2(72) := g_package||'upd_tl';

Line 396: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;

392: p_short_name in varchar2,
393: p_name in varchar2,
394: p_owner in varchar2) is
395: --
396: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;
397: --
398: --
399: l_created_by pqh_transaction_categories.created_by%TYPE;
400: l_last_updated_by pqh_transaction_categories.last_updated_by%TYPE;

Line 399: l_created_by pqh_transaction_categories.created_by%TYPE;

395: --
396: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;
397: --
398: --
399: l_created_by pqh_transaction_categories.created_by%TYPE;
400: l_last_updated_by pqh_transaction_categories.last_updated_by%TYPE;
401: l_creation_date pqh_transaction_categories.creation_date%TYPE;
402: l_last_update_date pqh_transaction_categories.last_update_date%TYPE;
403: l_last_update_login pqh_transaction_categories.last_update_login%TYPE;

Line 400: l_last_updated_by pqh_transaction_categories.last_updated_by%TYPE;

396: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;
397: --
398: --
399: l_created_by pqh_transaction_categories.created_by%TYPE;
400: l_last_updated_by pqh_transaction_categories.last_updated_by%TYPE;
401: l_creation_date pqh_transaction_categories.creation_date%TYPE;
402: l_last_update_date pqh_transaction_categories.last_update_date%TYPE;
403: l_last_update_login pqh_transaction_categories.last_update_login%TYPE;
404: --

Line 401: l_creation_date pqh_transaction_categories.creation_date%TYPE;

397: --
398: --
399: l_created_by pqh_transaction_categories.created_by%TYPE;
400: l_last_updated_by pqh_transaction_categories.last_updated_by%TYPE;
401: l_creation_date pqh_transaction_categories.creation_date%TYPE;
402: l_last_update_date pqh_transaction_categories.last_update_date%TYPE;
403: l_last_update_login pqh_transaction_categories.last_update_login%TYPE;
404: --
405: --

Line 402: l_last_update_date pqh_transaction_categories.last_update_date%TYPE;

398: --
399: l_created_by pqh_transaction_categories.created_by%TYPE;
400: l_last_updated_by pqh_transaction_categories.last_updated_by%TYPE;
401: l_creation_date pqh_transaction_categories.creation_date%TYPE;
402: l_last_update_date pqh_transaction_categories.last_update_date%TYPE;
403: l_last_update_login pqh_transaction_categories.last_update_login%TYPE;
404: --
405: --
406: Cursor c1 is

Line 403: l_last_update_login pqh_transaction_categories.last_update_login%TYPE;

399: l_created_by pqh_transaction_categories.created_by%TYPE;
400: l_last_updated_by pqh_transaction_categories.last_updated_by%TYPE;
401: l_creation_date pqh_transaction_categories.creation_date%TYPE;
402: l_last_update_date pqh_transaction_categories.last_update_date%TYPE;
403: l_last_update_login pqh_transaction_categories.last_update_login%TYPE;
404: --
405: --
406: Cursor c1 is
407: Select transaction_category_id

Line 408: From pqh_transaction_categories_vl

404: --
405: --
406: Cursor c1 is
407: Select transaction_category_id
408: From pqh_transaction_categories_vl
409: Where short_name = p_short_name;
410: --
411: begin
412: --

Line 438: update pqh_transaction_categories_tl

434: l_last_update_date := sysdate;
435: l_last_update_login := 0;
436:
437: --
438: update pqh_transaction_categories_tl
439: set name = p_name ,
440: last_updated_by = l_last_updated_by,
441: last_update_date = l_last_update_date,
442: last_update_login = l_last_update_login,