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_UTIL dependencies on QP_UTIL

Line 1: PACKAGE BODY QP_UTIL AS

1: PACKAGE BODY QP_UTIL AS
2: /* $Header: QPXUTILB.pls 120.14.12000000.2 2007/06/11 05:20:23 jisingh ship $ */
3: --===========================================================================
4: -- This script defines a procedure 'GEt_Context_Attribute.
5: -- Input to this procedure is attribute code as defined in

Line 2: /* $Header: QPXUTILB.pls 120.14.12000000.2 2007/06/11 05:20:23 jisingh ship $ */

1: PACKAGE BODY QP_UTIL AS
2: /* $Header: QPXUTILB.pls 120.14.12000000.2 2007/06/11 05:20:23 jisingh ship $ */
3: --===========================================================================
4: -- This script defines a procedure 'GEt_Context_Attribute.
5: -- Input to this procedure is attribute code as defined in
6: -- harcode list file and output will be context and attribute name.

Line 75: QP_UTIL.get_item_cat_info(

71: l_item_name VARCHAR2(1000);
72: l_item_desc VARCHAR2(5000);
73: l_is_valid BOOLEAN;
74: BEGIN
75: QP_UTIL.get_item_cat_info(
76: p_item_id,
77: fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'),
78: fnd_profile.value('QP_SOURCE_SYSTEM_CODE'),
79: l_item_name,

Line 531: QP_UTIL.Get_Context_Type(p_flexfield_name, p_context,

527: BEGIN
528:
529: IF Attrmgr_Installed = 'Y' THEN
530:
531: QP_UTIL.Get_Context_Type(p_flexfield_name, p_context,
532: l_context_type, l_error_code);
533:
534: IF l_error_code = 0 THEN --success
535:

Line 2289: QP_UTIL.Get_Context_Type(p_flexfield_name, p_context,

2285: BEGIN
2286:
2287: IF Attrmgr_Installed = 'Y' THEN
2288:
2289: QP_UTIL.Get_Context_Type(p_flexfield_name, p_context,
2290: l_context_type, l_error_code);
2291:
2292: IF l_error_code = 0 THEN
2293:

Line 2347: QP_UTIL.VALIDATE_QP_FLEXFIELD(FLEXFIELD_NAME =>'QP_ATTR_DEFNS_PRICING'

2343: L_ERROR_CODE NUMBER := 0;
2344:
2345: BEGIN
2346:
2347: QP_UTIL.VALIDATE_QP_FLEXFIELD(FLEXFIELD_NAME =>'QP_ATTR_DEFNS_PRICING'
2348: ,CONTEXT =>PRIC_ATTRIBUTE_CONTEXT
2349: ,ATTRIBUTE =>PRIC_ATTRIBUTE
2350: ,VALUE =>PRIC_ATTR_VALUE
2351: ,APPLICATION_SHORT_NAME => 'QP'

Line 2384: QP_UTIL.VALIDATE_QP_FLEXFIELD(FLEXFIELD_NAME =>'QP_ATTR_DEFNS_QUALIFIER'

2380: L_ERROR_CODE NUMBER := 0;
2381:
2382: BEGIN
2383:
2384: QP_UTIL.VALIDATE_QP_FLEXFIELD(FLEXFIELD_NAME =>'QP_ATTR_DEFNS_QUALIFIER'
2385: ,CONTEXT =>QUAL_ATTRIBUTE_CONTEXT
2386: ,ATTRIBUTE =>QUAL_ATTRIBUTE
2387: ,VALUE =>QUAL_ATTR_VALUE
2388: ,APPLICATION_SHORT_NAME => 'QP'

Line 3367: qp_util.get_valueset_id(p_FlexField_Name,p_Context_Name,

3363:
3364: BEGIN
3365:
3366:
3367: qp_util.get_valueset_id(p_FlexField_Name,p_Context_Name,
3368: p_Segment_Name,x_Vsid,
3369: x_Format_Type, x_Validation_Type);
3370:
3371:

Line 3439: IF (QP_UTIL.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value,l_meaning)) THEN

3435: --dbms_output.put_line('validation type = F');
3436:
3437: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3438:
3439: IF (QP_UTIL.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value,l_meaning)) THEN
3440:
3441:
3442: IF Fmt.Has_Id Then --id is defined.Hence compare for id
3443: --dbms_output.put_line('ID is defined');

Line 3528: -- call api qp_util.get_valueset_id as qp_util.get_valueset_id_r does not look into attribute management schema

3524: l_value VARCHAR2(240);
3525:
3526: BEGIN
3527: -- bug 3531203 - POST: QUALIFIER DESCRIPTION ON PRICE LIST MAINTENANCE PAGE SHOWS INTERNAL IDS
3528: -- call api qp_util.get_valueset_id as qp_util.get_valueset_id_r does not look into attribute management schema
3529:
3530: /*qp_util.get_valueset_id_r(p_FlexField_Name,p_Context_Name,
3531: p_Segment_Name,x_Vsid,
3532: x_Format_Type, x_Validation_Type);*/

Line 3530: /*qp_util.get_valueset_id_r(p_FlexField_Name,p_Context_Name,

3526: BEGIN
3527: -- bug 3531203 - POST: QUALIFIER DESCRIPTION ON PRICE LIST MAINTENANCE PAGE SHOWS INTERNAL IDS
3528: -- call api qp_util.get_valueset_id as qp_util.get_valueset_id_r does not look into attribute management schema
3529:
3530: /*qp_util.get_valueset_id_r(p_FlexField_Name,p_Context_Name,
3531: p_Segment_Name,x_Vsid,
3532: x_Format_Type, x_Validation_Type);*/
3533:
3534: Get_Attribute_Code(p_FlexField_Name,p_Context_Name, p_Segment_Name,

Line 3538: qp_util.get_valueset_id(p_FlexField_Name,p_Context_Name,

3534: Get_Attribute_Code(p_FlexField_Name,p_Context_Name, p_Segment_Name,
3535: l_attribute_code,
3536: l_segment_name);
3537:
3538: qp_util.get_valueset_id(p_FlexField_Name,p_Context_Name,
3539: l_Segment_Name,x_Vsid,
3540: x_Format_Type, x_Validation_Type);
3541:
3542: l_attr_value := get_num_date_from_canonical(x_format_type,p_attr_value);

Line 3598: IF (QP_UTIL.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value)) THEN

3594: ELSIF X_Validation_type = 'F' THEN
3595:
3596: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3597:
3598: IF (QP_UTIL.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value)) THEN
3599:
3600:
3601: IF Fmt.Has_Id Then --id is defined.Hence compare for id
3602: If l_attr_value = l_id Then

Line 4056: IF qp_util.attrmgr_installed = 'Y' then

4052: end if;
4053:
4054: fnd_profile.get('QP_SOURCE_SYSTEM_CODE', l_profile_source_system_code);
4055:
4056: IF qp_util.attrmgr_installed = 'Y' then
4057: fnd_profile.get('QP_PRICING_TRANSACTION_ENTITY', l_profile_pte_code);
4058: if (((l_pte_code <> l_profile_pte_code) or
4059: (l_source_system_code <> l_profile_source_system_code)
4060: )

Line 4157: QP_UTIL.Get_Context_Type(p_flexfield_name, p_context_name,

4153: IF l_pte_code IS NULL THEN
4154: l_pte_code := 'ORDFUL';
4155: END IF;
4156:
4157: QP_UTIL.Get_Context_Type(p_flexfield_name, p_context_name,
4158: l_context_type, l_error_code);
4159: IF l_error_code = 0 THEN
4160:
4161: OPEN attribute_cur(l_context_type, p_context_name,

Line 4361: l_qp_status := QP_UTIL.Get_QP_Status;

4357: l_pte_code := 'ORDFUL';
4358: END IF;
4359:
4360: --Get QP Install Status
4361: l_qp_status := QP_UTIL.Get_QP_Status;
4362:
4363: FOR l_rec IN context_cur(l_pte_code, l_qp_status, p_limits,
4364: p_list_line_type_code)
4365: LOOP

Line 4632: l_qp_status := QP_UTIL.Get_QP_Status;

4628: l_pte_code := 'ORDFUL';
4629: END IF;
4630:
4631: --Get QP Install Status
4632: l_qp_status := QP_UTIL.Get_QP_Status;
4633:
4634: FOR l_rec IN attribute_cur(p_context_type,
4635: p_context_code, l_pte_code)
4636: LOOP

Line 5021: oe_debug_pub.add('no data found exception in qp_util.Get_Item_Validation_Org');

5017:
5018: return l_inv_org_id;
5019: EXCEPTION
5020: when no_data_found then
5021: oe_debug_pub.add('no data found exception in qp_util.Get_Item_Validation_Org');
5022: --fix for bug 4776045
5023: -- G_ORGANIZATION_ID := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5024: -- return G_ORGANIZATION_ID;
5025: return null;

Line 5028: oe_debug_pub.add('others exception in qp_util.Get_Item_Validation_Org, error is ' || SQLERRM);

5024: -- return G_ORGANIZATION_ID;
5025: return null;
5026:
5027: when others then
5028: oe_debug_pub.add('others exception in qp_util.Get_Item_Validation_Org, error is ' || SQLERRM);
5029: --fix for bug 4776045
5030: -- G_ORGANIZATION_ID := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5031: -- return G_ORGANIZATION_ID;
5032: return null;

Line 5193: END QP_UTIL;

5189: WHEN OTHERS THEN
5190: null;
5191: END Validate_Item;
5192:
5193: END QP_UTIL;