APPS.ASO_CFG_INT dependencies on ASO_LINE_RELATIONSHIPS

Line 485: from aso_line_relationships

481: l_return_status varchar2(1);
482:
483: CURSOR c_rel_exist( p_quote_line_id NUMBER ) is
484: select related_quote_line_id
485: from aso_line_relationships
486: where related_quote_line_id = p_quote_line_id;
487:
488:
489: BEGIN

Line 1426: aso_debug_pub.add('Get_config_details: Before deleting records from aso_line_relationships table');

1422:
1423: END IF;
1424:
1425: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1426: aso_debug_pub.add('Get_config_details: Before deleting records from aso_line_relationships table');
1427: END IF;
1428:
1429: DELETE aso_line_relationships
1430: WHERE line_relationship_id IN (SELECT line_relationship_id

Line 1429: DELETE aso_line_relationships

1425: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1426: aso_debug_pub.add('Get_config_details: Before deleting records from aso_line_relationships table');
1427: END IF;
1428:
1429: DELETE aso_line_relationships
1430: WHERE line_relationship_id IN (SELECT line_relationship_id
1431: FROM aso_line_relationships a
1432: WHERE a.relationship_type_code = 'CONFIG'
1433: START WITH a.quote_line_id = p_config_rec.quote_line_id

Line 1431: FROM aso_line_relationships a

1427: END IF;
1428:
1429: DELETE aso_line_relationships
1430: WHERE line_relationship_id IN (SELECT line_relationship_id
1431: FROM aso_line_relationships a
1432: WHERE a.relationship_type_code = 'CONFIG'
1433: START WITH a.quote_line_id = p_config_rec.quote_line_id
1434: CONNECT BY PRIOR a.related_quote_line_id = a.quote_line_id);
1435:

Line 1437: aso_debug_pub.add('Get_config_details: After deleting records from aso_line_relationships table');

1433: START WITH a.quote_line_id = p_config_rec.quote_line_id
1434: CONNECT BY PRIOR a.related_quote_line_id = a.quote_line_id);
1435:
1436: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1437: aso_debug_pub.add('Get_config_details: After deleting records from aso_line_relationships table');
1438: END IF;
1439:
1440: G_rtln_tbl := G_MISS_rtln_tbl;
1441:

Line 3039: , ASO_QUOTE_LINE_DETAILS and ASO_LINE_RELATIONSHIPS

3035: that are updated and deleted from the model.
3036: Parse_output_xml : parses the CZ output xml message to see if the configuration
3037: is valid and complete.
3038: Get_config_details : To save options along with the model line in ASO_QUOTE_LINES_ALL
3039: , ASO_QUOTE_LINE_DETAILS and ASO_LINE_RELATIONSHIPS
3040: -----------------------------------------------------------------------*/
3041:
3042: PROCEDURE Validate_Configuration
3043: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,