APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_QUOTE_LINE_DETAILS

Line 5989: update aso_quote_line_details

5985: END IF;
5986:
5987: if l_line_rltship_rec.relationship_type_code = 'CONFIG' then
5988:
5989: update aso_quote_line_details
5990: set ref_type_code = 'CONFIG',
5991: ref_line_id = l_line_rltship_rec.quote_line_id,
5992: last_update_date = sysdate,
5993: last_updated_by = fnd_global.user_id,

Line 6005: update aso_quote_line_details

6001: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6002: aso_debug_pub.add('Create_Quote: x_qte_header_rec.quote_header_id: '|| x_qte_header_rec.quote_header_id);
6003: END IF;
6004:
6005: update aso_quote_line_details
6006: set ref_type_code = 'CONFIG',
6007: last_update_date = sysdate,
6008: last_updated_by = fnd_global.user_id,
6009: last_update_login = fnd_global.conc_login_id

Line 6780: select quote_line_id from aso_quote_line_details

6776: l_config_revision_num number;
6777: l_new_config_hdr_id number;
6778:
6779: cursor c_model_line (p_config_header_id NUMBER, p_config_revision_num NUMBER)is
6780: select quote_line_id from aso_quote_line_details
6781: where config_header_id = p_config_header_id
6782: and config_revision_num = p_config_revision_num
6783: and ref_type_code = 'CONFIG'
6784: and ref_line_id is NULL;

Line 9998: update aso_quote_line_details

9994: if l_line_rltship_rec.relationship_type_code = 'CONFIG' and
9995: (l_line_rltship_rec.operation_code = 'CREATE' or
9996: l_line_rltship_rec.operation_code = 'UPDATE') then
9997:
9998: update aso_quote_line_details
9999: set ref_type_code = 'CONFIG',
10000: ref_line_id = l_line_rltship_rec.quote_line_id,
10001: last_update_date = sysdate,
10002: last_updated_by = g_user_id,

Line 10014: update aso_quote_line_details

10010: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10011: aso_debug_pub.add('Update_Quote: x_qte_header_rec.quote_header_id: '|| x_qte_header_rec.quote_header_id);
10012: END IF;
10013:
10014: update aso_quote_line_details
10015: set ref_type_code = 'CONFIG',
10016: last_update_date = sysdate,
10017: last_updated_by = g_user_id,
10018: last_update_login = g_login_id

Line 12112: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID

12108: )
12109: IS
12110:
12111: CURSOR line_id_from_config IS
12112: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
12113: FROM ASO_Quote_Line_Details, ASO_Quote_Lines_all
12114: WHERE ASO_Quote_Line_Details.config_header_id = p_old_config_header_id
12115: AND ASO_Quote_Line_Details.config_revision_num = p_old_config_revision_num
12116: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id

Line 12113: FROM ASO_Quote_Line_Details, ASO_Quote_Lines_all

12109: IS
12110:
12111: CURSOR line_id_from_config IS
12112: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
12113: FROM ASO_Quote_Line_Details, ASO_Quote_Lines_all
12114: WHERE ASO_Quote_Line_Details.config_header_id = p_old_config_header_id
12115: AND ASO_Quote_Line_Details.config_revision_num = p_old_config_revision_num
12116: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
12117: AND ASO_Quote_Lines_all.item_type_code <> 'MDL'

Line 12114: WHERE ASO_Quote_Line_Details.config_header_id = p_old_config_header_id

12110:
12111: CURSOR line_id_from_config IS
12112: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
12113: FROM ASO_Quote_Line_Details, ASO_Quote_Lines_all
12114: WHERE ASO_Quote_Line_Details.config_header_id = p_old_config_header_id
12115: AND ASO_Quote_Line_Details.config_revision_num = p_old_config_revision_num
12116: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
12117: AND ASO_Quote_Lines_all.item_type_code <> 'MDL'
12118: AND aso_quote_lines_all.quote_header_id = qte_header_id;

Line 12115: AND ASO_Quote_Line_Details.config_revision_num = p_old_config_revision_num

12111: CURSOR line_id_from_config IS
12112: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
12113: FROM ASO_Quote_Line_Details, ASO_Quote_Lines_all
12114: WHERE ASO_Quote_Line_Details.config_header_id = p_old_config_header_id
12115: AND ASO_Quote_Line_Details.config_revision_num = p_old_config_revision_num
12116: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
12117: AND ASO_Quote_Lines_all.item_type_code <> 'MDL'
12118: AND aso_quote_lines_all.quote_header_id = qte_header_id;
12119:

Line 12116: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id

12112: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
12113: FROM ASO_Quote_Line_Details, ASO_Quote_Lines_all
12114: WHERE ASO_Quote_Line_Details.config_header_id = p_old_config_header_id
12115: AND ASO_Quote_Line_Details.config_revision_num = p_old_config_revision_num
12116: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
12117: AND ASO_Quote_Lines_all.item_type_code <> 'MDL'
12118: AND aso_quote_lines_all.quote_header_id = qte_header_id;
12119:
12120: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;