[Home] [Help]
3559: l_status varchar2(1);
3560: l_return_status varchar2(1);
3561: prev_attribute_id number := -1;
3562: --UTF8 changes for Bug No : 2615261
3563: lr_attribute_value psb_attribute_values_i.attribute_value%TYPE;
3564: lr_value_id number := '';
3565: lr_attribute_id number;
3566: l_attr_dummy number := 0;
3567: l_msg_count number;
3775: l_attribute_value_id from dual;
3776: end if;
3777:
3778:
3779: INSERT INTO PSB_ATTRIBUTE_VALUES_I
3780: (
3781: ATTRIBUTE_VALUE_ID ,
3782: ATTRIBUTE_ID ,
3783: ATTRIBUTE_VALUE ,
3855: ||', Atrribute Data Type '||l_data_type
3856: ||', Atrribute Value '||dvalue.value;
3857: /* Bug 4075170 End */
3858:
3859: INSERT INTO PSB_ATTRIBUTE_VALUES_I
3860: (
3861: ATTRIBUTE_VALUE_ID ,
3862: ATTRIBUTE_ID ,
3863: ATTRIBUTE_VALUE ,
3949: RAISE_APPLICATION_ERROR(-20001,l_message_text);
3950: end;
3951: end if;
3952:
3953: INSERT INTO PSB_ATTRIBUTE_VALUES_I
3954: (
3955: ATTRIBUTE_VALUE_ID ,
3956: ATTRIBUTE_ID ,
3957: ATTRIBUTE_VALUE ,
4067: select psb_attribute_values_s.nextval into
4068: l_attribute_value_id from dual;
4069: end if;
4070:
4071: INSERT INTO PSB_ATTRIBUTE_VALUES_I
4072: (
4073: ATTRIBUTE_VALUE_ID ,
4074: ATTRIBUTE_ID ,
4075: ATTRIBUTE_VALUE ,
4148: select psb_attribute_values_s.nextval into
4149: l_attribute_value_id from dual;
4150: end if;
4151:
4152: INSERT INTO PSB_ATTRIBUTE_VALUES_I
4153: (
4154: ATTRIBUTE_VALUE_ID ,
4155: ATTRIBUTE_ID ,
4156: ATTRIBUTE_VALUE ,
4195: select psb_attribute_values_s.nextval into
4196: l_attribute_value_id from dual;
4197: end if;
4198:
4199: INSERT INTO PSB_ATTRIBUTE_VALUES_I
4200: (
4201: ATTRIBUTE_VALUE_ID ,
4202: ATTRIBUTE_ID ,
4203: ATTRIBUTE_VALUE ,