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 3429: SELECT PQP_FLXDU_XML_TAGS_S.nextval

3425:
3426: BEGIN
3427:
3428: -- get next sequence value
3429: SELECT PQP_FLXDU_XML_TAGS_S.nextval
3430: INTO l_riw_xml_id
3431: FROM dual;
3432:
3433: -- get the count of FLXDU_XML_TAG_ID in PQP_FLXDU_XML_TAGS

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

3429: SELECT PQP_FLXDU_XML_TAGS_S.nextval
3430: INTO l_riw_xml_id
3431: FROM dual;
3432:
3433: -- get the count of FLXDU_XML_TAG_ID in PQP_FLXDU_XML_TAGS
3434: SELECT count(FLXDU_XML_TAG_ID)
3435: INTO l_count
3436: FROM PQP_FLXDU_XML_TAGS
3437: WHERE BUSINESS_GROUP_ID = p_business_group_id

Line 3436: FROM PQP_FLXDU_XML_TAGS

3432:
3433: -- get the count of FLXDU_XML_TAG_ID in PQP_FLXDU_XML_TAGS
3434: SELECT count(FLXDU_XML_TAG_ID)
3435: INTO l_count
3436: FROM PQP_FLXDU_XML_TAGS
3437: WHERE BUSINESS_GROUP_ID = p_business_group_id
3438: AND FLXDU_COLUMN_ID = p_field_id;
3439:
3440: -- if count = 0 , then insert into PQP_FLXDU_XML_TAGS

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

3436: FROM PQP_FLXDU_XML_TAGS
3437: WHERE BUSINESS_GROUP_ID = p_business_group_id
3438: AND FLXDU_COLUMN_ID = p_field_id;
3439:
3440: -- if count = 0 , then insert into PQP_FLXDU_XML_TAGS
3441: IF l_count = 0 THEN
3442: IF p_xml_tag_name IS NOT NULL THEN
3443: insert into PQP_FLXDU_XML_TAGS
3444: (FLXDU_COLUMN_ID

Line 3443: insert into PQP_FLXDU_XML_TAGS

3439:
3440: -- if count = 0 , then insert into PQP_FLXDU_XML_TAGS
3441: IF l_count = 0 THEN
3442: IF p_xml_tag_name IS NOT NULL THEN
3443: insert into PQP_FLXDU_XML_TAGS
3444: (FLXDU_COLUMN_ID
3445: ,FLXDU_XML_TAG_ID
3446: ,FLXDU_XML_TAG_NAME
3447: ,BUSINESS_GROUP_ID

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

3464: ,1);
3465: END IF;
3466: -- if count > 0 then
3467: ELSE
3468: -- update PQP_FLXDU_XML_TAGS if p_xml_tag_name is not null
3469: IF p_xml_tag_name IS NOT NULL THEN
3470: UPDATE PQP_FLXDU_XML_TAGS
3471: SET FLXDU_XML_TAG_NAME = p_xml_tag_name
3472: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id;

Line 3470: UPDATE PQP_FLXDU_XML_TAGS

3466: -- if count > 0 then
3467: ELSE
3468: -- update PQP_FLXDU_XML_TAGS if p_xml_tag_name is not null
3469: IF p_xml_tag_name IS NOT NULL THEN
3470: UPDATE PQP_FLXDU_XML_TAGS
3471: SET FLXDU_XML_TAG_NAME = p_xml_tag_name
3472: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id;
3473: -- delete frm PQP_FLXDU_XML_TAGS if p_xml_tag_name is null
3474: ELSE

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

3469: IF p_xml_tag_name IS NOT NULL THEN
3470: UPDATE PQP_FLXDU_XML_TAGS
3471: SET FLXDU_XML_TAG_NAME = p_xml_tag_name
3472: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id;
3473: -- delete frm PQP_FLXDU_XML_TAGS if p_xml_tag_name is null
3474: ELSE
3475: DELETE
3476: FROM PQP_FLXDU_XML_TAGS
3477: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id;

Line 3476: FROM PQP_FLXDU_XML_TAGS

3472: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id;
3473: -- delete frm PQP_FLXDU_XML_TAGS if p_xml_tag_name is null
3474: ELSE
3475: DELETE
3476: FROM PQP_FLXDU_XML_TAGS
3477: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id;
3478: END IF;
3479: END IF;
3480: END Create_RIW_XML_Tags;

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

3493: l_proc VARCHAR(72) := g_package||'Delete_RIW_XML_Tag';
3494:
3495: BEGIN
3496:
3497: -- delete mxl tag from PQP_FLXDU_XML_TAGS for tagId and bgId passed
3498: DELETE
3499: FROM PQP_FLXDU_XML_TAGS
3500: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id
3501: AND BUSINESS_GROUP_ID = p_business_group_id;

Line 3499: FROM PQP_FLXDU_XML_TAGS

3495: BEGIN
3496:
3497: -- delete mxl tag from PQP_FLXDU_XML_TAGS for tagId and bgId passed
3498: DELETE
3499: FROM PQP_FLXDU_XML_TAGS
3500: WHERE FLXDU_XML_TAG_ID = p_xml_tag_id
3501: AND BUSINESS_GROUP_ID = p_business_group_id;
3502:
3503: