APPS.PQH_RCT_BUS dependencies on PQH_TRANSACTION_CATEGORIES

Line 114: from pqh_transaction_categories a

110: l_dummy varchar2(1);
111: --
112: cursor c1 is
113: select null
114: from pqh_transaction_categories a
115: where a.transaction_category_id = p_transaction_category_id;
116: --
117: Begin
118: --

Line 131: -- pqh_transaction_categories table

127: = nvl(pqh_rct_shd.g_old_rec.transaction_category_id,hr_api.g_number)
128: or not l_api_updating) then
129: --
130: -- check if transaction_category_id value exists in
131: -- pqh_transaction_categories table
132: --
133: open c1;
134: --
135: fetch c1 into l_dummy;

Line 141: -- pqh_transaction_categories table.

137: --
138: close c1;
139: --
140: -- raise error as FK does not relate to PK in
141: -- pqh_transaction_categories table.
142: --
143: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK2');
144: --
145: end if;

Line 423: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;

419: --
420: l_proc varchar2(72) := g_package||'chk_ins_upd_routing_category';
421: l_api_updating boolean;
422: l_dummy varchar2(1);
423: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;
424: --
425: cursor c1 is
426: select nvl(freeze_status_cd,hr_api.g_varchar2)
427: from pqh_transaction_categories a

Line 427: from pqh_transaction_categories a

423: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;
424: --
425: cursor c1 is
426: select nvl(freeze_status_cd,hr_api.g_varchar2)
427: from pqh_transaction_categories a
428: where a.transaction_category_id = p_transaction_category_id;
429: --
430: Begin
431: --

Line 461: -- pqh_transaction_categories table.

457: --
458: close c1;
459: --
460: -- raise error as FK does not relate to PK in
461: -- pqh_transaction_categories table.
462: --
463: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK2');
464: --
465: end if;

Line 560: l_member_cd pqh_transaction_categories.member_cd%type;

556: p_object_version_number in number) as
557: --
558: l_proc varchar2(72) := g_package||'chk_list_id';
559: l_api_updating boolean;
560: l_member_cd pqh_transaction_categories.member_cd%type;
561: l_dummy varchar2(1);
562: --
563: Cursor c1 is
564: select a.member_cd

Line 565: from pqh_transaction_categories a

561: l_dummy varchar2(1);
562: --
563: Cursor c1 is
564: select a.member_cd
565: from pqh_transaction_categories a
566: where a.transaction_category_id = p_transaction_category_id;
567:
568: Cursor c2 is
569: select null

Line 1237: From pqh_transaction_categories

1233: sql_stmt varchar2(1000);
1234: --
1235: Cursor csr_routing_type is
1236: Select member_cd
1237: From pqh_transaction_categories
1238: Where transaction_category_id = p_transaction_category_id;
1239: --
1240: --
1241: l_routing_type pqh_transaction_categories.member_cd%type;

Line 1241: l_routing_type pqh_transaction_categories.member_cd%type;

1237: From pqh_transaction_categories
1238: Where transaction_category_id = p_transaction_category_id;
1239: --
1240: --
1241: l_routing_type pqh_transaction_categories.member_cd%type;
1242: --
1243: l_prev_routing_cat pqh_routing_categories.routing_category_id%type;
1244: l_prev_range_name pqh_attribute_ranges.range_name%type;
1245: l_prev_list_name varchar2(250);

Line 1415: (p_transaction_category_id in pqh_transaction_categories.transaction_category_id%type,

1411: --
1412: ------------------------------------------------------------------------------
1413: --
1414: Function chk_if_routing_cat_exists
1415: (p_transaction_category_id in pqh_transaction_categories.transaction_category_id%type,
1416: p_routing_type in pqh_transaction_categories.member_cd%type)
1417: --
1418: RETURN BOOLEAN is
1419: --

Line 1416: p_routing_type in pqh_transaction_categories.member_cd%type)

1412: ------------------------------------------------------------------------------
1413: --
1414: Function chk_if_routing_cat_exists
1415: (p_transaction_category_id in pqh_transaction_categories.transaction_category_id%type,
1416: p_routing_type in pqh_transaction_categories.member_cd%type)
1417: --
1418: RETURN BOOLEAN is
1419: --
1420: -- Declare cursors and local variables