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.PQP_RIW_WEBADI_UTILS dependencies on PQP_FLXDU_XML_TAGS

Line 3020: SELECT PQP_FLXDU_XML_TAGS_S.nextval

3016:
3017: BEGIN
3018:
3019: -- get next sequence value
3020: SELECT PQP_FLXDU_XML_TAGS_S.nextval
3021: INTO l_riw_xml_id
3022: FROM dual;
3023:
3024: -- get the count of FLXDU_XML_TAG_ID in PQP_FLXDU_XML_TAGS

Line 3024: -- get the count of FLXDU_XML_TAG_ID in PQP_FLXDU_XML_TAGS

3020: SELECT PQP_FLXDU_XML_TAGS_S.nextval
3021: INTO l_riw_xml_id
3022: FROM dual;
3023:
3024: -- get the count of FLXDU_XML_TAG_ID in PQP_FLXDU_XML_TAGS
3025: SELECT count(FLXDU_XML_TAG_ID)
3026: INTO l_count
3027: FROM PQP_FLXDU_XML_TAGS
3028: WHERE BUSINESS_GROUP_ID = p_business_group_id

Line 3027: FROM PQP_FLXDU_XML_TAGS

3023:
3024: -- get the count of FLXDU_XML_TAG_ID in PQP_FLXDU_XML_TAGS
3025: SELECT count(FLXDU_XML_TAG_ID)
3026: INTO l_count
3027: FROM PQP_FLXDU_XML_TAGS
3028: WHERE BUSINESS_GROUP_ID = p_business_group_id
3029: AND FLXDU_COLUMN_ID = p_field_id;
3030:
3031: -- if count = 0 , then insert into PQP_FLXDU_XML_TAGS

Line 3031: -- if count = 0 , then insert into PQP_FLXDU_XML_TAGS

3027: FROM PQP_FLXDU_XML_TAGS
3028: WHERE BUSINESS_GROUP_ID = p_business_group_id
3029: AND FLXDU_COLUMN_ID = p_field_id;
3030:
3031: -- if count = 0 , then insert into PQP_FLXDU_XML_TAGS
3032: IF l_count = 0 THEN
3033: IF p_xml_tag_name IS NOT NULL THEN
3034: insert into PQP_FLXDU_XML_TAGS
3035: (FLXDU_COLUMN_ID

Line 3034: insert into PQP_FLXDU_XML_TAGS

3030:
3031: -- if count = 0 , then insert into PQP_FLXDU_XML_TAGS
3032: IF l_count = 0 THEN
3033: IF p_xml_tag_name IS NOT NULL THEN
3034: insert into PQP_FLXDU_XML_TAGS
3035: (FLXDU_COLUMN_ID
3036: ,FLXDU_XML_TAG_ID
3037: ,FLXDU_XML_TAG_NAME
3038: ,BUSINESS_GROUP_ID

Line 3059: -- update PQP_FLXDU_XML_TAGS if p_xml_tag_name is not null

3055: ,1);
3056: END IF;
3057: -- if count > 0 then
3058: ELSE
3059: -- update PQP_FLXDU_XML_TAGS if p_xml_tag_name is not null
3060: IF p_xml_tag_name IS NOT NULL THEN
3061: UPDATE PQP_FLXDU_XML_TAGS
3062: SET FLXDU_XML_TAG_NAME = p_xml_tag_name
3063: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id;

Line 3061: UPDATE PQP_FLXDU_XML_TAGS

3057: -- if count > 0 then
3058: ELSE
3059: -- update PQP_FLXDU_XML_TAGS if p_xml_tag_name is not null
3060: IF p_xml_tag_name IS NOT NULL THEN
3061: UPDATE PQP_FLXDU_XML_TAGS
3062: SET FLXDU_XML_TAG_NAME = p_xml_tag_name
3063: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id;
3064: -- delete frm PQP_FLXDU_XML_TAGS if p_xml_tag_name is null
3065: ELSE

Line 3064: -- delete frm PQP_FLXDU_XML_TAGS if p_xml_tag_name is null

3060: IF p_xml_tag_name IS NOT NULL THEN
3061: UPDATE PQP_FLXDU_XML_TAGS
3062: SET FLXDU_XML_TAG_NAME = p_xml_tag_name
3063: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id;
3064: -- delete frm PQP_FLXDU_XML_TAGS if p_xml_tag_name is null
3065: ELSE
3066: DELETE
3067: FROM PQP_FLXDU_XML_TAGS
3068: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id;

Line 3067: FROM PQP_FLXDU_XML_TAGS

3063: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id;
3064: -- delete frm PQP_FLXDU_XML_TAGS if p_xml_tag_name is null
3065: ELSE
3066: DELETE
3067: FROM PQP_FLXDU_XML_TAGS
3068: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id;
3069: END IF;
3070: END IF;
3071: END Create_RIW_XML_Tags;

Line 3088: -- delete mxl tag from PQP_FLXDU_XML_TAGS for tagId and bgId passed

3084: l_proc VARCHAR(72) := g_package||'Delete_RIW_XML_Tag';
3085:
3086: BEGIN
3087:
3088: -- delete mxl tag from PQP_FLXDU_XML_TAGS for tagId and bgId passed
3089: DELETE
3090: FROM PQP_FLXDU_XML_TAGS
3091: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id
3092: AND BUSINESS_GROUP_ID = p_business_group_id;

Line 3090: FROM PQP_FLXDU_XML_TAGS

3086: BEGIN
3087:
3088: -- delete mxl tag from PQP_FLXDU_XML_TAGS for tagId and bgId passed
3089: DELETE
3090: FROM PQP_FLXDU_XML_TAGS
3091: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id
3092: AND BUSINESS_GROUP_ID = p_business_group_id;
3093:
3094: