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_QUOTE_HEADERS_PVT dependencies on ASO_LINE_RELATIONSHIPS

Line 6101: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row(

6097: IF l_index IS NOT NULL AND l_index >=1 AND l_index <= x_qte_line_tbl.count THEN
6098: l_line_rltship_rec.related_quote_line_id := x_qte_line_tbl(l_index).quote_line_id;
6099: END IF;
6100:
6101: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row(
6102: px_LINE_RELATIONSHIP_ID => l_line_rltship_rec.LINE_RELATIONSHIP_ID,
6103: p_CREATION_DATE => SYSDATE,
6104: p_CREATED_BY => G_USER_ID,
6105: p_LAST_UPDATED_BY => G_USER_ID,

Line 10972: -- Adding a check to find if find line relationship already exists bug 12608111 to avoid data corruption in aso_line_relationships

10968: l_line_rltship_rec := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;
10969: x_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(x_qte_line_tbl(i).quote_line_id);
10970: IF x_qte_line_dtl_tbl.count > 0 THEN
10971: IF x_qte_line_dtl_tbl(1).ref_line_id IS NOT NULL AND x_qte_line_dtl_tbl(1).ref_line_id <> FND_API.G_MISS_NUM THEN
10972: -- Adding a check to find if find line relationship already exists bug 12608111 to avoid data corruption in aso_line_relationships
10973: select count(*) into ct_rel
10974: from aso_line_relationships
10975: where quote_line_id = x_qte_line_dtl_tbl(1).ref_line_id
10976: and related_quote_line_id = x_qte_line_dtl_tbl(1).quote_line_id

Line 10974: from aso_line_relationships

10970: IF x_qte_line_dtl_tbl.count > 0 THEN
10971: IF x_qte_line_dtl_tbl(1).ref_line_id IS NOT NULL AND x_qte_line_dtl_tbl(1).ref_line_id <> FND_API.G_MISS_NUM THEN
10972: -- Adding a check to find if find line relationship already exists bug 12608111 to avoid data corruption in aso_line_relationships
10973: select count(*) into ct_rel
10974: from aso_line_relationships
10975: where quote_line_id = x_qte_line_dtl_tbl(1).ref_line_id
10976: and related_quote_line_id = x_qte_line_dtl_tbl(1).quote_line_id
10977: and relationship_type_code='CONFIG';
10978: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 11019: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row(

11015: END IF;
11016: IF l_line_rltship_rec.operation_code = 'CREATE' THEN
11017: -- BC4J Fix
11018: --l_line_rltship_rec.LINE_RELATIONSHIP_ID := NULL;
11019: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row(
11020: px_LINE_RELATIONSHIP_ID => l_line_rltship_rec.LINE_RELATIONSHIP_ID,
11021: p_CREATION_DATE => SYSDATE,
11022: p_CREATED_BY => G_USER_ID,
11023: p_LAST_UPDATED_BY => G_USER_ID,

Line 11037: ASO_LINE_RELATIONSHIPS_PKG.Update_Row(

11033: P_RELATIONSHIP_TYPE_CODE =>l_line_rltship_rec.RELATIONSHIP_TYPE_CODE,
11034: p_OBJECT_VERSION_NUMBER => l_line_rltship_rec.OBJECT_VERSION_NUMBER
11035: );
11036: ELSIF l_line_rltship_rec.operation_code = 'UPDATE' THEN
11037: ASO_LINE_RELATIONSHIPS_PKG.Update_Row(
11038: p_LINE_RELATIONSHIP_ID => l_line_rltship_rec.LINE_RELATIONSHIP_ID,
11039: p_CREATION_DATE => l_line_rltship_rec.creation_date,
11040: p_CREATED_BY => G_USER_ID,
11041: p_LAST_UPDATED_BY => G_USER_ID,

Line 11055: ASO_LINE_RELATIONSHIPS_PKG.delete_Row(

11051: P_RELATIONSHIP_TYPE_CODE =>l_line_rltship_rec.RELATIONSHIP_TYPE_CODE,
11052: p_OBJECT_VERSION_NUMBER => l_line_rltship_rec.OBJECT_VERSION_NUMBER
11053: );
11054: ELSIF l_line_rltship_rec.operation_code = 'DELETE' THEN
11055: ASO_LINE_RELATIONSHIPS_PKG.delete_Row(
11056: p_LINE_RELATIONSHIP_ID => l_line_rltship_rec.LINE_RELATIONSHIP_ID);
11057: END IF;
11058: X_line_Rltship_Tbl(i) := l_line_rltship_rec;
11059:

Line 11887: RECIPROCAL_FLAG FROM ASO_LINE_RELATIONSHIPS

11883: PROGRAM_UPDATE_DATE,
11884: QUOTE_LINE_ID,
11885: RELATED_QUOTE_LINE_ID,
11886: RELATIONSHIP_TYPE_CODE,
11887: RECIPROCAL_FLAG FROM ASO_LINE_RELATIONSHIPS
11888: WHERE quote_line_id IN
11889: (SELECT quote_line_id FROM aso_quote_lines_all
11890: WHERE quote_header_id = x_quote_header_id)
11891: AND related_quote_line_id IN

Line 11913: RECIPROCAL_FLAG FROM ASO_LINE_RELATIONSHIPS

11909: PROGRAM_UPDATE_DATE,
11910: QUOTE_LINE_ID,
11911: RELATED_QUOTE_LINE_ID,
11912: RELATIONSHIP_TYPE_CODE,
11913: RECIPROCAL_FLAG FROM ASO_LINE_RELATIONSHIPS
11914: WHERE EXISTS
11915: (SELECT 'x' FROM aso_quote_lines_all aql
11916: WHERE aql.quote_header_id = x_quote_header_id
11917: AND aql.quote_line_id = aso_line_relationships.quote_line_id)

Line 11917: AND aql.quote_line_id = aso_line_relationships.quote_line_id)

11913: RECIPROCAL_FLAG FROM ASO_LINE_RELATIONSHIPS
11914: WHERE EXISTS
11915: (SELECT 'x' FROM aso_quote_lines_all aql
11916: WHERE aql.quote_header_id = x_quote_header_id
11917: AND aql.quote_line_id = aso_line_relationships.quote_line_id)
11918: AND EXISTS
11919: (SELECT 'x' FROM aso_quote_lines_all aql
11920: WHERE aql.quote_header_id = x_quote_header_id
11921: AND aql.quote_line_id = aso_line_relationships.related_quote_line_id);

Line 11921: AND aql.quote_line_id = aso_line_relationships.related_quote_line_id);

11917: AND aql.quote_line_id = aso_line_relationships.quote_line_id)
11918: AND EXISTS
11919: (SELECT 'x' FROM aso_quote_lines_all aql
11920: WHERE aql.quote_header_id = x_quote_header_id
11921: AND aql.quote_line_id = aso_line_relationships.related_quote_line_id);
11922:
11923: */
11924:
11925:

Line 13473: FROM aso_line_relationships

13469: IS
13470:
13471: CURSOR line_id_from_service IS
13472: SELECT related_quote_line_id
13473: FROM aso_line_relationships
13474: WHERE quote_line_id = p_qte_line_id
13475: AND relationship_type_code = 'SERVICE';
13476:
13477: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;