APPS.ASO_CFG_INT dependencies on ASO_LINE_RELATIONSHIPS

Line 491: from aso_line_relationships

487: l_return_status varchar2(1);
488:
489: CURSOR c_rel_exist( p_quote_line_id NUMBER ) is
490: select related_quote_line_id
491: from aso_line_relationships
492: where related_quote_line_id = p_quote_line_id;
493:
494:
495: BEGIN

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

1595:
1596: END IF;
1597:
1598: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1599: aso_debug_pub.add('Get_config_details: Before deleting records from aso_line_relationships table');
1600: END IF;
1601:
1602: DELETE aso_line_relationships
1603: WHERE line_relationship_id IN (SELECT line_relationship_id

Line 1602: DELETE aso_line_relationships

1598: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1599: aso_debug_pub.add('Get_config_details: Before deleting records from aso_line_relationships table');
1600: END IF;
1601:
1602: DELETE aso_line_relationships
1603: WHERE line_relationship_id IN (SELECT line_relationship_id
1604: FROM aso_line_relationships a
1605: WHERE a.relationship_type_code = 'CONFIG'
1606: START WITH a.quote_line_id = p_config_rec.quote_line_id

Line 1604: FROM aso_line_relationships a

1600: END IF;
1601:
1602: DELETE aso_line_relationships
1603: WHERE line_relationship_id IN (SELECT line_relationship_id
1604: FROM aso_line_relationships a
1605: WHERE a.relationship_type_code = 'CONFIG'
1606: START WITH a.quote_line_id = p_config_rec.quote_line_id
1607: CONNECT BY PRIOR a.related_quote_line_id = a.quote_line_id);
1608:

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

1606: START WITH a.quote_line_id = p_config_rec.quote_line_id
1607: CONNECT BY PRIOR a.related_quote_line_id = a.quote_line_id);
1608:
1609: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1610: aso_debug_pub.add('Get_config_details: After deleting records from aso_line_relationships table');
1611: END IF;
1612:
1613: G_rtln_tbl := G_MISS_rtln_tbl;
1614:

Line 3334: , ASO_QUOTE_LINE_DETAILS and ASO_LINE_RELATIONSHIPS

3330: that are updated and deleted from the model.
3331: Parse_output_xml : parses the CZ output xml message to see if the configuration
3332: is valid and complete.
3333: Get_config_details : To save options along with the model line in ASO_QUOTE_LINES_ALL
3334: , ASO_QUOTE_LINE_DETAILS and ASO_LINE_RELATIONSHIPS
3335: -----------------------------------------------------------------------*/
3336:
3337: PROCEDURE Validate_Configuration
3338: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,