APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_LINE_RELATIONSHIPS

Line 2311: FROM ASO_LINE_RELATIONSHIPS

2307: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
2308: , REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID
2309: , PROGRAM_UPDATE_DATE, QUOTE_LINE_ID, RELATED_QUOTE_LINE_ID
2310: , RELATIONSHIP_TYPE_CODE, RECIPROCAL_FLAG, OBJECT_VERSION_NUMBER
2311: FROM ASO_LINE_RELATIONSHIPS
2312: WHERE quote_line_id IN ( SELECT quote_line_id
2313: FROM aso_quote_lines_all
2314: WHERE quote_header_id = x_quote_header_id )
2315: AND relationship_type_code <> 'SERVICE';

Line 2424: FROM ASO_LINE_RELATIONSHIPS

2420: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
2421: , REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID
2422: , PROGRAM_UPDATE_DATE, QUOTE_LINE_ID, RELATED_QUOTE_LINE_ID
2423: , RELATIONSHIP_TYPE_CODE, RECIPROCAL_FLAG, OBJECT_VERSION_NUMBER
2424: FROM ASO_LINE_RELATIONSHIPS
2425: WHERE relationship_type_code <> 'SERVICE'
2426: CONNECT BY PRIOR related_quote_line_id = quote_line_id
2427: START WITH quote_line_id = x_quote_line_id;
2428:

Line 3867: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (

3863: -- copy line relationships
3864:
3865: FOR line_rel_rec IN c_line_relation ( p_qte_header_id ) LOOP
3866: lx_LINE_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
3867: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (
3868: px_LINE_RELATIONSHIP_ID => lx_LINE_RELATIONSHIP_ID
3869: , p_CREATION_DATE => SYSDATE
3870: , p_CREATED_BY => G_USER_ID
3871: , p_LAST_UPDATED_BY => G_USER_ID

Line 3939: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (

3935: END IF;
3936:
3937: FOR line_rel_rec IN c_line_relation_from_line_id ( P_Qte_Line_Id ) LOOP
3938: lx_LINE_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
3939: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (
3940: px_LINE_RELATIONSHIP_ID => lx_LINE_RELATIONSHIP_ID
3941: , p_CREATION_DATE => SYSDATE
3942: , p_CREATED_BY => G_USER_ID
3943: , p_LAST_UPDATED_BY => G_USER_ID

Line 4754: FROM aso_line_relationships

4750: CURSOR line_id_from_service (
4751: qte_ln_id NUMBER
4752: ) IS
4753: SELECT related_quote_line_id
4754: FROM aso_line_relationships
4755: WHERE quote_line_id = qte_ln_id
4756: AND relationship_type_code = 'SERVICE';
4757:
4758: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 5566: FROM ASO_LINE_RELATIONSHIPS

5562: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
5563: , REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID
5564: , PROGRAM_UPDATE_DATE, QUOTE_LINE_ID, RELATED_QUOTE_LINE_ID
5565: , RELATIONSHIP_TYPE_CODE, RECIPROCAL_FLAG, OBJECT_VERSION_NUMBER
5566: FROM ASO_LINE_RELATIONSHIPS
5567: WHERE relationship_type_code <> 'SERVICE'
5568: CONNECT BY PRIOR related_quote_line_id = quote_line_id
5569: START WITH quote_line_id = x_quote_line_id;
5570:

Line 6550: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (

6546:
6547: FOR line_rel_rec IN c_line_relation ( P_Original_Qte_Line_Rec.quote_line_id ) LOOP
6548:
6549: lx_LINE_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
6550: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (
6551: px_LINE_RELATIONSHIP_ID => lx_LINE_RELATIONSHIP_ID
6552: , p_CREATION_DATE => SYSDATE
6553: , p_CREATED_BY => G_USER_ID
6554: , p_LAST_UPDATED_BY => G_USER_ID