APPS.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_ATTRIBUTE_VALUES

Line 109: select PSB_ATTRIBUTE_VALUES_S.NEXTVAL seq

105: select PSB_ATTRIBUTES_S.NEXTVAL seq
106: from dual;
107:
108: cursor c_attrval_seq is
109: select PSB_ATTRIBUTE_VALUES_S.NEXTVAL seq
110: from dual;
111:
112: cursor c_attr is
113: select *

Line 125: from PSB_ATTRIBUTE_VALUES

121: and business_group_id = g_global_business_group_id;
122:
123: cursor c_attrval (attrid NUMBER) is
124: select *
125: from PSB_ATTRIBUTE_VALUES
126: where attribute_id = attrid
127: and data_extract_id = p_local_data_extract_id;
128:
129: cursor c_attrval_exists (attrid NUMBER, attrval VARCHAR2) is

Line 131: from PSB_ATTRIBUTE_VALUES

127: and data_extract_id = p_local_data_extract_id;
128:
129: cursor c_attrval_exists (attrid NUMBER, attrval VARCHAR2) is
130: select attribute_value_id
131: from PSB_ATTRIBUTE_VALUES
132: where attribute_value = attrval
133: and attribute_id = attrid
134: and data_extract_id = g_global_data_extract_id;
135:

Line 202: PSB_ATTRIBUTE_VALUES_PVT.Insert_Row

198: for c_attrval_seq_rec in c_attrval_seq loop
199: l_attribute_value_id := c_attrval_seq_rec.seq;
200: end loop;
201:
202: PSB_ATTRIBUTE_VALUES_PVT.Insert_Row
203: (p_api_version => 1.0,
204: p_return_status => l_return_status,
205: p_msg_count => l_msg_count,
206: p_msg_data => l_msg_data,

Line 282: PSB_ATTRIBUTE_VALUES_PVT.Insert_Row

278: for c_attrval_seq_rec in c_attrval_seq loop
279: l_attribute_value_id := c_attrval_seq_rec.seq;
280: end loop;
281:
282: PSB_ATTRIBUTE_VALUES_PVT.Insert_Row
283: (p_api_version => 1.0,
284: p_return_status => l_return_status,
285: p_msg_count => l_msg_count,
286: p_msg_data => l_msg_data,

Line 482: from PSB_ATTRIBUTE_VALUES a,

478: and b.attribute_id = attrid;
479:
480: cursor c_re_attrval (attrvalid NUMBER) is
481: select a.attribute_value_id
482: from PSB_ATTRIBUTE_VALUES a,
483: PSB_ATTRIBUTE_VALUES b
484: where a.data_extract_id = g_global_data_extract_id
485: and a.attribute_value = b.attribute_value
486: and a.attribute_id = b.attribute_id -- added this for Bug #4262388

Line 483: PSB_ATTRIBUTE_VALUES b

479:
480: cursor c_re_attrval (attrvalid NUMBER) is
481: select a.attribute_value_id
482: from PSB_ATTRIBUTE_VALUES a,
483: PSB_ATTRIBUTE_VALUES b
484: where a.data_extract_id = g_global_data_extract_id
485: and a.attribute_value = b.attribute_value
486: and a.attribute_id = b.attribute_id -- added this for Bug #4262388
487: and b.attribute_value_id = attrvalid;

Line 1468: from PSB_ATTRIBUTE_VALUES a,

1464: and b.attribute_id = attrid;
1465:
1466: cursor c_re_attrval (attrvalid NUMBER) is
1467: select a.attribute_value_id
1468: from PSB_ATTRIBUTE_VALUES a,
1469: PSB_ATTRIBUTE_VALUES b
1470: where a.data_extract_id = g_global_data_extract_id
1471: and a.attribute_value = b.attribute_value
1472: and a.attribute_id = b.attribute_id -- added this for Bug #4262388

Line 1469: PSB_ATTRIBUTE_VALUES b

1465:
1466: cursor c_re_attrval (attrvalid NUMBER) is
1467: select a.attribute_value_id
1468: from PSB_ATTRIBUTE_VALUES a,
1469: PSB_ATTRIBUTE_VALUES b
1470: where a.data_extract_id = g_global_data_extract_id
1471: and a.attribute_value = b.attribute_value
1472: and a.attribute_id = b.attribute_id -- added this for Bug #4262388
1473: and b.attribute_value_id = attrvalid;