APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_LINE_RELATIONSHIPS

Line 1616: FROM ASO_LINE_RELATIONSHIPS

1612: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
1613: , REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID
1614: , PROGRAM_UPDATE_DATE, QUOTE_LINE_ID, RELATED_QUOTE_LINE_ID
1615: , RELATIONSHIP_TYPE_CODE, RECIPROCAL_FLAG, OBJECT_VERSION_NUMBER
1616: FROM ASO_LINE_RELATIONSHIPS
1617: WHERE quote_line_id IN ( SELECT quote_line_id
1618: FROM aso_quote_lines_all
1619: WHERE quote_header_id = x_quote_header_id )
1620: AND relationship_type_code <> 'SERVICE';

Line 1729: FROM ASO_LINE_RELATIONSHIPS

1725: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
1726: , REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID
1727: , PROGRAM_UPDATE_DATE, QUOTE_LINE_ID, RELATED_QUOTE_LINE_ID
1728: , RELATIONSHIP_TYPE_CODE, RECIPROCAL_FLAG, OBJECT_VERSION_NUMBER
1729: FROM ASO_LINE_RELATIONSHIPS
1730: WHERE relationship_type_code <> 'SERVICE'
1731: CONNECT BY PRIOR related_quote_line_id = quote_line_id
1732: START WITH quote_line_id = x_quote_line_id;
1733:

Line 2652: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (

2648: -- copy line relationships
2649:
2650: FOR line_rel_rec IN c_line_relation ( p_qte_header_id ) LOOP
2651: lx_LINE_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
2652: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (
2653: px_LINE_RELATIONSHIP_ID => lx_LINE_RELATIONSHIP_ID
2654: , p_CREATION_DATE => SYSDATE
2655: , p_CREATED_BY => G_USER_ID
2656: , p_LAST_UPDATED_BY => G_USER_ID

Line 2724: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (

2720: END IF;
2721:
2722: FOR line_rel_rec IN c_line_relation_from_line_id ( P_Qte_Line_Id ) LOOP
2723: lx_LINE_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
2724: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (
2725: px_LINE_RELATIONSHIP_ID => lx_LINE_RELATIONSHIP_ID
2726: , p_CREATION_DATE => SYSDATE
2727: , p_CREATED_BY => G_USER_ID
2728: , p_LAST_UPDATED_BY => G_USER_ID

Line 3446: FROM aso_line_relationships

3442: CURSOR line_id_from_service (
3443: qte_ln_id NUMBER
3444: ) IS
3445: SELECT related_quote_line_id
3446: FROM aso_line_relationships
3447: WHERE quote_line_id = qte_ln_id
3448: AND relationship_type_code = 'SERVICE';
3449:
3450: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 4258: FROM ASO_LINE_RELATIONSHIPS

4254: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
4255: , REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID
4256: , PROGRAM_UPDATE_DATE, QUOTE_LINE_ID, RELATED_QUOTE_LINE_ID
4257: , RELATIONSHIP_TYPE_CODE, RECIPROCAL_FLAG, OBJECT_VERSION_NUMBER
4258: FROM ASO_LINE_RELATIONSHIPS
4259: WHERE relationship_type_code <> 'SERVICE'
4260: CONNECT BY PRIOR related_quote_line_id = quote_line_id
4261: START WITH quote_line_id = x_quote_line_id;
4262:

Line 5242: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (

5238:
5239: FOR line_rel_rec IN c_line_relation ( P_Original_Qte_Line_Rec.quote_line_id ) LOOP
5240:
5241: lx_LINE_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
5242: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (
5243: px_LINE_RELATIONSHIP_ID => lx_LINE_RELATIONSHIP_ID
5244: , p_CREATION_DATE => SYSDATE
5245: , p_CREATED_BY => G_USER_ID
5246: , p_LAST_UPDATED_BY => G_USER_ID