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_QP_FORM_PRICING_ATTR dependencies on FND_VSET

Line 2544: Vset FND_VSET.valueset_r;

2540: ,p_attribute_val_col_name IN VARCHAR2 := NULL
2541: ,p_comparison_operator_code IN VARCHAR2 := NULL
2542: ) RETURN VARCHAR2 IS
2543:
2544: Vset FND_VSET.valueset_r;
2545: Fmt FND_VSET.valueset_dr;
2546:
2547: Found BOOLEAN;
2548: Row NUMBER;

Line 2545: Fmt FND_VSET.valueset_dr;

2541: ,p_comparison_operator_code IN VARCHAR2 := NULL
2542: ) RETURN VARCHAR2 IS
2543:
2544: Vset FND_VSET.valueset_r;
2545: Fmt FND_VSET.valueset_dr;
2546:
2547: Found BOOLEAN;
2548: Row NUMBER;
2549: Value FND_VSET.value_dr;

Line 2549: Value FND_VSET.value_dr;

2545: Fmt FND_VSET.valueset_dr;
2546:
2547: Found BOOLEAN;
2548: Row NUMBER;
2549: Value FND_VSET.value_dr;
2550:
2551:
2552:
2553: x_Format_Type Varchar2(1);

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

2596:
2597:
2598: IF x_Validation_Type = 'I' Then
2599:
2600: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
2601: FND_VSET.get_value_init(Vset,TRUE);
2602: FND_VSET.get_value(Vset,Row,Found,Value);
2603:
2604:

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

2597:
2598: IF x_Validation_Type = 'I' Then
2599:
2600: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
2601: FND_VSET.get_value_init(Vset,TRUE);
2602: FND_VSET.get_value(Vset,Row,Found,Value);
2603:
2604:
2605: IF Fmt.Has_Id Then --id is defined.Hence compare for id

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

2598: IF x_Validation_Type = 'I' Then
2599:
2600: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
2601: FND_VSET.get_value_init(Vset,TRUE);
2602: FND_VSET.get_value(Vset,Row,Found,Value);
2603:
2604:
2605: IF Fmt.Has_Id Then --id is defined.Hence compare for id
2606:

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

2612: x_attr_value_code := Value.value;
2613: Value_Valid_In_Valueset := TRUE;
2614: EXIT;
2615: End If;
2616: FND_VSET.get_value(Vset,Row,Found,Value);
2617:
2618: End Loop;
2619: Else -- id not defined.Hence compare for value
2620:

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

2625: x_attr_value_code := l_attr_value;
2626: Value_Valid_In_Valueset := TRUE;
2627: EXIT;
2628: End If;
2629: FND_VSET.get_value(Vset,Row,Found,Value);
2630:
2631: End Loop;
2632:
2633: End If; ---end of Fmt.Has_Id

Line 2636: FND_VSET.get_value_end(Vset);

2632:
2633: End If; ---end of Fmt.Has_Id
2634:
2635:
2636: FND_VSET.get_value_end(Vset);
2637:
2638: ELSIF x_Validation_Type = 'F' THEN
2639:
2640: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);

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

2636: FND_VSET.get_value_end(Vset);
2637:
2638: ELSIF x_Validation_Type = 'F' THEN
2639:
2640: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
2641:
2642: IF (QP_UTIL.value_exists_in_table(Vset.table_info,
2643: l_attr_value,l_id,l_value)) THEN
2644:

Line 2687: Vset FND_VSET.valueset_r;

2683: ,p_segment_name IN VARCHAR2
2684: ,p_attr_value_To IN VARCHAR2
2685: ) RETURN VARCHAR2 IS
2686:
2687: Vset FND_VSET.valueset_r;
2688: Fmt FND_VSET.valueset_dr;
2689:
2690: Found BOOLEAN;
2691: Row NUMBER;

Line 2688: Fmt FND_VSET.valueset_dr;

2684: ,p_attr_value_To IN VARCHAR2
2685: ) RETURN VARCHAR2 IS
2686:
2687: Vset FND_VSET.valueset_r;
2688: Fmt FND_VSET.valueset_dr;
2689:
2690: Found BOOLEAN;
2691: Row NUMBER;
2692: Value FND_VSET.value_dr;

Line 2692: Value FND_VSET.value_dr;

2688: Fmt FND_VSET.valueset_dr;
2689:
2690: Found BOOLEAN;
2691: Row NUMBER;
2692: Value FND_VSET.value_dr;
2693:
2694:
2695:
2696: x_Format_Type Varchar2(1);

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

2708: p_Segment_Name,x_Vsid,
2709: x_Format_Type, x_Validation_Type);
2710: /*
2711: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
2712: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
2713: FND_VSET.get_value_init(Vset,TRUE);
2714: FND_VSET.get_value(Vset,Row,Found,Value);
2715:
2716: While(Found) Loop

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

2709: x_Format_Type, x_Validation_Type);
2710: /*
2711: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
2712: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
2713: FND_VSET.get_value_init(Vset,TRUE);
2714: FND_VSET.get_value(Vset,Row,Found,Value);
2715:
2716: While(Found) Loop
2717:

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

2710: /*
2711: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
2712: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
2713: FND_VSET.get_value_init(Vset,TRUE);
2714: FND_VSET.get_value(Vset,Row,Found,Value);
2715:
2716: While(Found) Loop
2717:
2718: --fnd_message.debug(Value.value);

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

2723:
2724: x_attr_value_code := Value.Meaning;
2725: EXIT;
2726: End If;
2727: FND_VSET.get_value(Vset,Row,Found,Value);
2728:
2729: End Loop;
2730: FND_VSET.get_value_end(Vset);
2731: ELSE

Line 2730: FND_VSET.get_value_end(Vset);

2726: End If;
2727: FND_VSET.get_value(Vset,Row,Found,Value);
2728:
2729: End Loop;
2730: FND_VSET.get_value_end(Vset);
2731: ELSE
2732:
2733: x_attr_value_code := p_attr_value_to;
2734: END IF;