APPS.PQH_TEM_BUS dependencies on PQH_ATTRIBUTES

Line 336: from pqh_template_attributes tat, pqh_attributes att

332: where a.territory_code = p_legislation_code;
333: --
334: cursor c2(p_template_id number) is
335: select legislation_code
336: from pqh_template_attributes tat, pqh_attributes att
337: where tat.template_id = p_template_id
338: and tat.attribute_id= att.attribute_id
339: and att.legislation_code is not null;
340: --

Line 1125: (master_attribute_id pqh_attributes.master_attribute_id%type,

1121: Procedure chk_master_child_attributes(p_transaction_category_id IN number,
1122: p_template_id IN number) is
1123: --
1124: type master_child is record
1125: (master_attribute_id pqh_attributes.master_attribute_id%type,
1126: attribute_id pqh_attributes.attribute_id%type,
1127: attribute_name pqh_attributes.attribute_name%type,
1128: tat_attribute_id pqh_template_attributes.attribute_id%type,
1129: view_flag pqh_template_attributes.view_flag%type,

Line 1126: attribute_id pqh_attributes.attribute_id%type,

1122: p_template_id IN number) is
1123: --
1124: type master_child is record
1125: (master_attribute_id pqh_attributes.master_attribute_id%type,
1126: attribute_id pqh_attributes.attribute_id%type,
1127: attribute_name pqh_attributes.attribute_name%type,
1128: tat_attribute_id pqh_template_attributes.attribute_id%type,
1129: view_flag pqh_template_attributes.view_flag%type,
1130: edit_flag pqh_template_attributes.edit_flag%type);

Line 1127: attribute_name pqh_attributes.attribute_name%type,

1123: --
1124: type master_child is record
1125: (master_attribute_id pqh_attributes.master_attribute_id%type,
1126: attribute_id pqh_attributes.attribute_id%type,
1127: attribute_name pqh_attributes.attribute_name%type,
1128: tat_attribute_id pqh_template_attributes.attribute_id%type,
1129: view_flag pqh_template_attributes.view_flag%type,
1130: edit_flag pqh_template_attributes.edit_flag%type);
1131: --

Line 1138: From pqh_txn_category_attributes tca,pqh_attributes_vl att,

1134: Cursor c1 is
1135: Select nvl(att.master_attribute_id,att.attribute_id),
1136: tca.attribute_id,rtrim(att.attribute_name),nvl(tat.attribute_id,-1),
1137: nvl(tat.view_flag,'N') , nvl(tat.edit_flag,'N')
1138: From pqh_txn_category_attributes tca,pqh_attributes_vl att,
1139: pqh_template_attributes tat
1140: Where tca.transaction_category_id = p_transaction_category_id
1141: AND tca.attribute_id = att.attribute_id
1142: AND att.attribute_id = tat.attribute_id(+)

Line 1148: from pqh_attributes_vl

1144: Order by 1,2;
1145: --
1146: Cursor csr_master_attr(p_attribute_id in number) is
1147: Select rtrim(attribute_name)
1148: from pqh_attributes_vl
1149: Where attribute_id = p_attribute_id;
1150: --
1151: --
1152: -- Declaring local variables.

Line 1163: master_id pqh_attributes.attribute_id%type := -1;

1159: match number(5) := 0;
1160: no_match number(5) := 0;
1161: master_attached varchar2(1) := 'Y';
1162: --
1163: master_id pqh_attributes.attribute_id%type := -1;
1164: l_master_attribute_name pqh_attributes.attribute_name%type := NULL;
1165: master_view_flag pqh_template_attributes.view_flag%type := 'N';
1166: master_edit_flag pqh_template_attributes.edit_flag%type := 'N';
1167: --

Line 1164: l_master_attribute_name pqh_attributes.attribute_name%type := NULL;

1160: no_match number(5) := 0;
1161: master_attached varchar2(1) := 'Y';
1162: --
1163: master_id pqh_attributes.attribute_id%type := -1;
1164: l_master_attribute_name pqh_attributes.attribute_name%type := NULL;
1165: master_view_flag pqh_template_attributes.view_flag%type := 'N';
1166: master_edit_flag pqh_template_attributes.edit_flag%type := 'N';
1167: --
1168: check_reqd_flag varchar2(1) := 'N';