eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PRICE_LIST_LINE_UTIL dependencies on FND_VSET

Line 4086: Vset FND_VSET.valueset_r;

4082: ,p_segment_name IN VARCHAR2
4083: ,p_attr_value IN VARCHAR2
4084: ) RETURN VARCHAR2 IS
4085:
4086: Vset FND_VSET.valueset_r;
4087: Fmt FND_VSET.valueset_dr;
4088:
4089: Found BOOLEAN;
4090: Row NUMBER;

Line 4087: Fmt FND_VSET.valueset_dr;

4083: ,p_attr_value IN VARCHAR2
4084: ) RETURN VARCHAR2 IS
4085:
4086: Vset FND_VSET.valueset_r;
4087: Fmt FND_VSET.valueset_dr;
4088:
4089: Found BOOLEAN;
4090: Row NUMBER;
4091: Value FND_VSET.value_dr;

Line 4091: Value FND_VSET.value_dr;

4087: Fmt FND_VSET.valueset_dr;
4088:
4089: Found BOOLEAN;
4090: Row NUMBER;
4091: Value FND_VSET.value_dr;
4092:
4093:
4094:
4095: x_Format_Type Varchar2(1);

Line 4115: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);

4111: --fnd_message.show;
4112:
4113: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
4114: IF x_Validation_Type = 'I' THEN --Added for 2332139
4115: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
4116: FND_VSET.get_value_init(Vset,TRUE);
4117: FND_VSET.get_value(Vset,Row,Found,Value);
4118:
4119: IF Fmt.Has_Id Then --id is defined.Hence compare for id

Line 4116: FND_VSET.get_value_init(Vset,TRUE);

4112:
4113: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
4114: IF x_Validation_Type = 'I' THEN --Added for 2332139
4115: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
4116: FND_VSET.get_value_init(Vset,TRUE);
4117: FND_VSET.get_value(Vset,Row,Found,Value);
4118:
4119: IF Fmt.Has_Id Then --id is defined.Hence compare for id
4120:

Line 4117: FND_VSET.get_value(Vset,Row,Found,Value);

4113: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
4114: IF x_Validation_Type = 'I' THEN --Added for 2332139
4115: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
4116: FND_VSET.get_value_init(Vset,TRUE);
4117: FND_VSET.get_value(Vset,Row,Found,Value);
4118:
4119: IF Fmt.Has_Id Then --id is defined.Hence compare for id
4120:
4121: While(Found) Loop

Line 4132: FND_VSET.get_value(Vset,Row,Found,Value);

4128:
4129: x_attr_value_code := Value.Value;
4130: RETURN x_attr_value_code;
4131: End If;
4132: FND_VSET.get_value(Vset,Row,Found,Value);
4133:
4134: End Loop;
4135:
4136: Else

Line 4149: FND_VSET.get_value(Vset,Row,Found,Value);

4145:
4146: x_attr_value_code := p_attr_value;
4147: RETURN x_attr_value_code;
4148: End If;
4149: FND_VSET.get_value(Vset,Row,Found,Value);
4150:
4151: End Loop;
4152:
4153: End If; -- end of Fmt.Has_Id

Line 4155: FND_VSET.get_value_end(Vset);

4151: End Loop;
4152:
4153: End If; -- end of Fmt.Has_Id
4154:
4155: FND_VSET.get_value_end(Vset);
4156:
4157: /* Added for 2332139 */
4158:
4159: ELSIF x_Validation_Type='F' THEN

Line 4160: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);

4156:
4157: /* Added for 2332139 */
4158:
4159: ELSIF x_Validation_Type='F' THEN
4160: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
4161:
4162: IF (QP_UTIL.value_exists_in_table(Vset.table_info,
4163: p_attr_value,l_id,l_value)) THEN
4164: