APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_LINE_RELATIONSHIPS

Line 5963: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row(

5959: IF l_index IS NOT NULL AND l_index >=1 AND l_index <= x_qte_line_tbl.count THEN
5960: l_line_rltship_rec.related_quote_line_id := x_qte_line_tbl(l_index).quote_line_id;
5961: END IF;
5962:
5963: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row(
5964: px_LINE_RELATIONSHIP_ID => l_line_rltship_rec.LINE_RELATIONSHIP_ID,
5965: p_CREATION_DATE => SYSDATE,
5966: p_CREATED_BY => G_USER_ID,
5967: p_LAST_UPDATED_BY => G_USER_ID,

Line 9948: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row(

9944: END IF;
9945: IF l_line_rltship_rec.operation_code = 'CREATE' THEN
9946: -- BC4J Fix
9947: --l_line_rltship_rec.LINE_RELATIONSHIP_ID := NULL;
9948: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row(
9949: px_LINE_RELATIONSHIP_ID => l_line_rltship_rec.LINE_RELATIONSHIP_ID,
9950: p_CREATION_DATE => SYSDATE,
9951: p_CREATED_BY => G_USER_ID,
9952: p_LAST_UPDATED_BY => G_USER_ID,

Line 9966: ASO_LINE_RELATIONSHIPS_PKG.Update_Row(

9962: P_RELATIONSHIP_TYPE_CODE =>l_line_rltship_rec.RELATIONSHIP_TYPE_CODE,
9963: p_OBJECT_VERSION_NUMBER => l_line_rltship_rec.OBJECT_VERSION_NUMBER
9964: );
9965: ELSIF l_line_rltship_rec.operation_code = 'UPDATE' THEN
9966: ASO_LINE_RELATIONSHIPS_PKG.Update_Row(
9967: p_LINE_RELATIONSHIP_ID => l_line_rltship_rec.LINE_RELATIONSHIP_ID,
9968: p_CREATION_DATE => l_line_rltship_rec.creation_date,
9969: p_CREATED_BY => G_USER_ID,
9970: p_LAST_UPDATED_BY => G_USER_ID,

Line 9984: ASO_LINE_RELATIONSHIPS_PKG.delete_Row(

9980: P_RELATIONSHIP_TYPE_CODE =>l_line_rltship_rec.RELATIONSHIP_TYPE_CODE,
9981: p_OBJECT_VERSION_NUMBER => l_line_rltship_rec.OBJECT_VERSION_NUMBER
9982: );
9983: ELSIF l_line_rltship_rec.operation_code = 'DELETE' THEN
9984: ASO_LINE_RELATIONSHIPS_PKG.delete_Row(
9985: p_LINE_RELATIONSHIP_ID => l_line_rltship_rec.LINE_RELATIONSHIP_ID);
9986: END IF;
9987: X_line_Rltship_Tbl(i) := l_line_rltship_rec;
9988:

Line 10816: RECIPROCAL_FLAG FROM ASO_LINE_RELATIONSHIPS

10812: PROGRAM_UPDATE_DATE,
10813: QUOTE_LINE_ID,
10814: RELATED_QUOTE_LINE_ID,
10815: RELATIONSHIP_TYPE_CODE,
10816: RECIPROCAL_FLAG FROM ASO_LINE_RELATIONSHIPS
10817: WHERE quote_line_id IN
10818: (SELECT quote_line_id FROM aso_quote_lines_all
10819: WHERE quote_header_id = x_quote_header_id)
10820: AND related_quote_line_id IN

Line 10842: RECIPROCAL_FLAG FROM ASO_LINE_RELATIONSHIPS

10838: PROGRAM_UPDATE_DATE,
10839: QUOTE_LINE_ID,
10840: RELATED_QUOTE_LINE_ID,
10841: RELATIONSHIP_TYPE_CODE,
10842: RECIPROCAL_FLAG FROM ASO_LINE_RELATIONSHIPS
10843: WHERE EXISTS
10844: (SELECT 'x' FROM aso_quote_lines_all aql
10845: WHERE aql.quote_header_id = x_quote_header_id
10846: AND aql.quote_line_id = aso_line_relationships.quote_line_id)

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

10842: RECIPROCAL_FLAG FROM ASO_LINE_RELATIONSHIPS
10843: WHERE EXISTS
10844: (SELECT 'x' FROM aso_quote_lines_all aql
10845: WHERE aql.quote_header_id = x_quote_header_id
10846: AND aql.quote_line_id = aso_line_relationships.quote_line_id)
10847: AND EXISTS
10848: (SELECT 'x' FROM aso_quote_lines_all aql
10849: WHERE aql.quote_header_id = x_quote_header_id
10850: AND aql.quote_line_id = aso_line_relationships.related_quote_line_id);

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

10846: AND aql.quote_line_id = aso_line_relationships.quote_line_id)
10847: AND EXISTS
10848: (SELECT 'x' FROM aso_quote_lines_all aql
10849: WHERE aql.quote_header_id = x_quote_header_id
10850: AND aql.quote_line_id = aso_line_relationships.related_quote_line_id);
10851:
10852: */
10853:
10854:

Line 12402: FROM aso_line_relationships

12398: IS
12399:
12400: CURSOR line_id_from_service IS
12401: SELECT related_quote_line_id
12402: FROM aso_line_relationships
12403: WHERE quote_line_id = p_qte_line_id
12404: AND relationship_type_code = 'SERVICE';
12405:
12406: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;