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.ASO_LINE_RLTSHIP_PVT dependencies on ASO_LINE_RELATIONSHIPS

Line 140: -- Invoke table handler(ASO_LINE_RELATIONSHIPS_PKG.Insert_Row)

136:
137: -- Debug Message
138: -- --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
139:
140: -- Invoke table handler(ASO_LINE_RELATIONSHIPS_PKG.Insert_Row)
141: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row(
142: px_LINE_RELATIONSHIP_ID => x_LINE_RELATIONSHIP_ID,
143: p_CREATION_DATE => SYSDATE,
144: p_CREATED_BY => G_USER_ID,

Line 141: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row(

137: -- Debug Message
138: -- --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
139:
140: -- Invoke table handler(ASO_LINE_RELATIONSHIPS_PKG.Insert_Row)
141: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row(
142: px_LINE_RELATIONSHIP_ID => x_LINE_RELATIONSHIP_ID,
143: p_CREATION_DATE => SYSDATE,
144: p_CREATED_BY => G_USER_ID,
145: p_LAST_UPDATED_BY => G_USER_ID,

Line 272: From ASO_LINE_RELATIONSHIPS

268: RELATED_QUOTE_LINE_ID,
269: RELATIONSHIP_TYPE_CODE,
270: RECIPROCAL_FLAG
271: -- RELATIONSHIP_TYPE_CODE
272: From ASO_LINE_RELATIONSHIPS
273: where LINE_RELATIONSHIP_ID = P_LINE_RLTSHIP_Rec.LINE_RELATIONSHIP_ID;
274: -- Hint: Developer need to provide Where clause
275: -- For Update NOWAIT;
276:

Line 416: -- Invoke table handler(ASO_LINE_RELATIONSHIPS_PKG.Update_Row)

412:
413: -- Debug Message
414: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
415:
416: -- Invoke table handler(ASO_LINE_RELATIONSHIPS_PKG.Update_Row)
417: ASO_LINE_RELATIONSHIPS_PKG.Update_Row(
418: p_LINE_RELATIONSHIP_ID => p_LINE_RLTSHIP_rec.LINE_RELATIONSHIP_ID,
419: p_CREATION_DATE => SYSDATE,
420: p_CREATED_BY => G_USER_ID,

Line 417: ASO_LINE_RELATIONSHIPS_PKG.Update_Row(

413: -- Debug Message
414: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
415:
416: -- Invoke table handler(ASO_LINE_RELATIONSHIPS_PKG.Update_Row)
417: ASO_LINE_RELATIONSHIPS_PKG.Update_Row(
418: p_LINE_RELATIONSHIP_ID => p_LINE_RLTSHIP_rec.LINE_RELATIONSHIP_ID,
419: p_CREATION_DATE => SYSDATE,
420: p_CREATED_BY => G_USER_ID,
421: p_LAST_UPDATED_BY => G_USER_ID,

Line 538: from aso_line_relationships

534: IS
535:
536: CURSOR C1(line_id NUMBER) IS
537: select line_relationship_id, quote_line_id, related_quote_line_id, relationship_type_code, reciprocal_flag
538: from aso_line_relationships
539: where quote_line_id = line_id;
540:
541:
542: CURSOR C2(line_id NUMBER) IS

Line 544: from aso_line_relationships

540:
541:
542: CURSOR C2(line_id NUMBER) IS
543: select line_relationship_id
544: from aso_line_relationships
545: where related_quote_line_id = line_id;
546:
547: CURSOR C3(line_id NUMBER, related_line_id NUMBER) IS
548: select line_relationship_id, quote_line_id, related_quote_line_id, relationship_type_code, reciprocal_flag

Line 549: from aso_line_relationships

545: where related_quote_line_id = line_id;
546:
547: CURSOR C3(line_id NUMBER, related_line_id NUMBER) IS
548: select line_relationship_id, quote_line_id, related_quote_line_id, relationship_type_code, reciprocal_flag
549: from aso_line_relationships
550: where quote_line_id = line_id
551: and related_quote_line_id = related_line_id;
552:
553:

Line 637: ASO_LINE_RELATIONSHIPS_PKG.Delete_Row(

633: IF p_LINE_RLTSHIP_rec.reciprocal_flag = FND_API.G_MISS_CHAR OR
634: p_LINE_RLTSHIP_rec.reciprocal_flag = FND_API.G_TRUE OR
635: p_LINE_RLTSHIP_rec.reciprocal_flag = i.reciprocal_flag THEN
636:
637: ASO_LINE_RELATIONSHIPS_PKG.Delete_Row(
638: p_LINE_RELATIONSHIP_ID => i.LINE_RELATIONSHIP_ID);
639:
640: IF (i.RELATIONSHIP_TYPE_CODE = 'SERVICE'
641: or i.RELATIONSHIP_TYPE_CODE = 'CONFIG') then

Line 664: ASO_LINE_RELATIONSHIPS_PKG.Delete_Row(

660:
661: END IF;
662: ELSE
663:
664: ASO_LINE_RELATIONSHIPS_PKG.Delete_Row(
665: p_LINE_RELATIONSHIP_ID => i.LINE_RELATIONSHIP_ID);
666:
667: l_line_rltship_rec.quote_line_id := i.related_quote_line_id;
668: l_line_rltship_rec.related_quote_line_id := i.quote_line_id;

Line 690: ASO_LINE_RELATIONSHIPS_PKG.Delete_Row(

686: ELSIF (p_LINE_RLTSHIP_rec.quote_line_id <> FND_API.G_MISS_NUM) THEN
687:
688: FOR i in C1(p_LINE_RLTSHIP_rec.quote_line_id) LOOP
689:
690: ASO_LINE_RELATIONSHIPS_PKG.Delete_Row(
691: p_LINE_RELATIONSHIP_ID => i.LINE_RELATIONSHIP_ID);
692:
693: IF (i.RELATIONSHIP_TYPE_CODE = 'SERVICE'
694: or i.RELATIONSHIP_TYPE_CODE = 'CONFIG') then

Line 713: ASO_LINE_RELATIONSHIPS_PKG.Delete_Row(

709: END IF;
710: END LOOP;
711:
712: FOR i in C2(p_LINE_RLTSHIP_rec.quote_line_id) LOOP
713: ASO_LINE_RELATIONSHIPS_PKG.Delete_Row(
714: p_LINE_RELATIONSHIP_ID => i.LINE_RELATIONSHIP_ID);
715: END LOOP;
716:
717:

Line 719: ASO_LINE_RELATIONSHIPS_PKG.Delete_Row(

715: END LOOP;
716:
717:
718: ELSIF (p_LINE_RLTSHIP_rec.line_relationship_id <> FND_API.G_MISS_NUM) THEN
719: ASO_LINE_RELATIONSHIPS_PKG.Delete_Row(
720: p_LINE_RELATIONSHIP_ID => p_LINE_RLTSHIP_rec.LINE_RELATIONSHIP_ID);
721:
722: END IF;
723:

Line 1075: from aso_line_relationships

1071:
1072: IF p_LINE_RELATIONSHIP_ID is not NULL AND p_LINE_RELATIONSHIP_ID <> FND_API.G_MISS_NUM THEN
1073:
1074: select count(*) into l_count
1075: from aso_line_relationships
1076: where line_relationship_id = p_LINE_RELATIONSHIP_ID;
1077:
1078: IF l_count < 1 THEN
1079: x_return_status := FND_API.G_RET_STS_ERROR;