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.19 2012/03/19 09:06:56 jputta 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.19 2012/03/19 09:06:56 jputta ship $ */

1: PACKAGE BODY QP_UTIL AS
2: /* $Header: QPXUTILB.pls 120.19 2012/03/19 09:06:56 jputta 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 2302: QP_UTIL.Get_Context_Type(p_flexfield_name, p_context,

2298: BEGIN
2299:
2300: IF Attrmgr_Installed = 'Y' THEN
2301:
2302: QP_UTIL.Get_Context_Type(p_flexfield_name, p_context,
2303: l_context_type, l_error_code);
2304:
2305: IF l_error_code = 0 THEN
2306:

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

2356: L_ERROR_CODE NUMBER := 0;
2357:
2358: BEGIN
2359:
2360: QP_UTIL.VALIDATE_QP_FLEXFIELD(FLEXFIELD_NAME =>'QP_ATTR_DEFNS_PRICING'
2361: ,CONTEXT =>PRIC_ATTRIBUTE_CONTEXT
2362: ,ATTRIBUTE =>PRIC_ATTRIBUTE
2363: ,VALUE =>PRIC_ATTR_VALUE
2364: ,APPLICATION_SHORT_NAME => 'QP'

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

2393: L_ERROR_CODE NUMBER := 0;
2394:
2395: BEGIN
2396:
2397: QP_UTIL.VALIDATE_QP_FLEXFIELD(FLEXFIELD_NAME =>'QP_ATTR_DEFNS_QUALIFIER'
2398: ,CONTEXT =>QUAL_ATTRIBUTE_CONTEXT
2399: ,ATTRIBUTE =>QUAL_ATTRIBUTE
2400: ,VALUE =>QUAL_ATTR_VALUE
2401: ,APPLICATION_SHORT_NAME => 'QP'

Line 3380: qp_util.get_valueset_id(p_FlexField_Name,p_Context_Name,

3376:
3377: BEGIN
3378:
3379:
3380: qp_util.get_valueset_id(p_FlexField_Name,p_Context_Name,
3381: p_Segment_Name,x_Vsid,
3382: x_Format_Type, x_Validation_Type);
3383:
3384:

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

3448: --dbms_output.put_line('validation type = F');
3449:
3450: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3451:
3452: IF (QP_UTIL.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value,l_meaning)) THEN
3453:
3454:
3455: IF Fmt.Has_Id Then --id is defined.Hence compare for id
3456: --dbms_output.put_line('ID is defined');

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

3537: l_value VARCHAR2(240);
3538:
3539: BEGIN
3540: -- bug 3531203 - POST: QUALIFIER DESCRIPTION ON PRICE LIST MAINTENANCE PAGE SHOWS INTERNAL IDS
3541: -- call api qp_util.get_valueset_id as qp_util.get_valueset_id_r does not look into attribute management schema
3542:
3543: /*qp_util.get_valueset_id_r(p_FlexField_Name,p_Context_Name,
3544: p_Segment_Name,x_Vsid,
3545: x_Format_Type, x_Validation_Type);*/

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

3539: BEGIN
3540: -- bug 3531203 - POST: QUALIFIER DESCRIPTION ON PRICE LIST MAINTENANCE PAGE SHOWS INTERNAL IDS
3541: -- call api qp_util.get_valueset_id as qp_util.get_valueset_id_r does not look into attribute management schema
3542:
3543: /*qp_util.get_valueset_id_r(p_FlexField_Name,p_Context_Name,
3544: p_Segment_Name,x_Vsid,
3545: x_Format_Type, x_Validation_Type);*/
3546:
3547: Get_Attribute_Code(p_FlexField_Name,p_Context_Name, p_Segment_Name,

Line 3551: qp_util.get_valueset_id(p_FlexField_Name,p_Context_Name,

3547: Get_Attribute_Code(p_FlexField_Name,p_Context_Name, p_Segment_Name,
3548: l_attribute_code,
3549: l_segment_name);
3550:
3551: qp_util.get_valueset_id(p_FlexField_Name,p_Context_Name,
3552: l_Segment_Name,x_Vsid,
3553: x_Format_Type, x_Validation_Type);
3554:
3555: l_attr_value := get_num_date_from_canonical(x_format_type,p_attr_value);

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

3607: ELSIF X_Validation_type = 'F' THEN
3608:
3609: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3610:
3611: IF (QP_UTIL.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value)) THEN
3612:
3613:
3614: IF Fmt.Has_Id Then --id is defined.Hence compare for id
3615: If l_attr_value = l_id Then

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

4075: end if;
4076:
4077: fnd_profile.get('QP_SOURCE_SYSTEM_CODE', l_profile_source_system_code);
4078:
4079: IF qp_util.attrmgr_installed = 'Y' then
4080: fnd_profile.get('QP_PRICING_TRANSACTION_ENTITY', l_profile_pte_code);
4081: if (((l_pte_code <> l_profile_pte_code) or
4082: (l_source_system_code <> l_profile_source_system_code)
4083: )

Line 4180: QP_UTIL.Get_Context_Type(p_flexfield_name, p_context_name,

4176: IF l_pte_code IS NULL THEN
4177: l_pte_code := 'ORDFUL';
4178: END IF;
4179:
4180: QP_UTIL.Get_Context_Type(p_flexfield_name, p_context_name,
4181: l_context_type, l_error_code);
4182: IF l_error_code = 0 THEN
4183:
4184: OPEN attribute_cur(l_context_type, p_context_name,

Line 4384: l_qp_status := QP_UTIL.Get_QP_Status;

4380: l_pte_code := 'ORDFUL';
4381: END IF;
4382:
4383: --Get QP Install Status
4384: l_qp_status := QP_UTIL.Get_QP_Status;
4385:
4386: FOR l_rec IN context_cur(l_pte_code, l_qp_status, p_limits,
4387: p_list_line_type_code)
4388: LOOP

Line 4655: l_qp_status := QP_UTIL.Get_QP_Status;

4651: l_pte_code := 'ORDFUL';
4652: END IF;
4653:
4654: --Get QP Install Status
4655: l_qp_status := QP_UTIL.Get_QP_Status;
4656:
4657: FOR l_rec IN attribute_cur(p_context_type,
4658: p_context_code, l_pte_code)
4659: LOOP

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

5040:
5041: return l_inv_org_id;
5042: EXCEPTION
5043: when no_data_found then
5044: oe_debug_pub.add('no data found exception in qp_util.Get_Item_Validation_Org');
5045: --fix for bug 4776045
5046: -- G_ORGANIZATION_ID := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5047: -- return G_ORGANIZATION_ID;
5048: return null;

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

5047: -- return G_ORGANIZATION_ID;
5048: return null;
5049:
5050: when others then
5051: oe_debug_pub.add('others exception in qp_util.Get_Item_Validation_Org, error is ' || SQLERRM);
5052: --fix for bug 4776045
5053: -- G_ORGANIZATION_ID := FND_PROFILE.Value('QP_ORGANIZATION_ID');
5054: -- return G_ORGANIZATION_ID;
5055: return null;

Line 5216: END QP_UTIL;

5212: WHEN OTHERS THEN
5213: null;
5214: END Validate_Item;
5215:
5216: END QP_UTIL;