eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_QUOTE_LINES_PVT dependencies on ASO_QUOTE_HEADERS

Line 75: FROM aso_quote_headers_all

71: IS
72:
73: cursor get_quote_number( l_qte_header_id number) is
74: SELECT quote_number
75: FROM aso_quote_headers_all
76: WHERE quote_header_id = l_qte_header_id;
77:
78:
79: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

Line 1226: FROM aso_quote_headers_all

1222: WHERE quote_line_id = p_qte_line_rec.quote_line_id;
1223:
1224: CURSOR C_customer IS
1225: SELECT cust_account_id, party_id
1226: FROM aso_quote_headers_all
1227: WHERE quote_header_id = p_qte_line_rec.quote_header_id;
1228:
1229: CURSOR C_service_item IS
1230: SELECT qln.start_date_active, qln.end_date_active,

Line 1236: aso_quote_headers_all qhd

1232: detail.service_coterminate_flag,
1233: qhd.cust_account_id, qhd.party_id
1234: FROM aso_quote_lines_all qln,
1235: aso_quote_line_details detail,
1236: aso_quote_headers_all qhd
1237: WHERE detail.quote_line_id = qln.quote_line_id
1238: AND qln.quote_line_id = p_qte_line_rec.quote_line_id
1239: AND qln.quote_header_id = qhd.quote_header_id;
1240:

Line 1243: FROM aso_quote_headers_all

1239: AND qln.quote_header_id = qhd.quote_header_id;
1240:
1241: CURSOR C_org_id IS
1242: SELECT org_id
1243: FROM aso_quote_headers_all
1244: WHERE quote_header_id = p_qte_line_rec.quote_header_id;
1245:
1246: CURSOR c_line_number ( p_quote_line_id NUMBER ) IS
1247: SELECT line_number

Line 2589: From ASO_QUOTE_HEADERS_ALL

2585: IS
2586:
2587: Cursor C_Get_quote(c_QUOTE_HEADER_ID Number) IS
2588: Select LAST_UPDATE_DATE, QUOTE_STATUS_ID, QUOTE_NUMBER, TOTAL_ADJUSTED_PERCENT
2589: From ASO_QUOTE_HEADERS_ALL
2590: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
2591:
2592: CURSOR C_Qte_Status(c_qte_status_id NUMBER) IS
2593: SELECT UPDATE_ALLOWED_FLAG, AUTO_VERSION_FLAG FROM ASO_QUOTE_STATUSES_B

Line 2598: FROM ASO_QUOTE_HEADERS_ALL

2594: WHERE quote_status_id = c_qte_status_id;
2595:
2596: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
2597: SELECT max(quote_version)
2598: FROM ASO_QUOTE_HEADERS_ALL
2599: WHERE quote_number = X_qte_number;
2600:
2601: CURSOR get_cust_acct(cust_QUOTE_HEADER_ID Number) IS
2602: SELECT CUST_ACCOUNT_ID

Line 2603: FROM ASO_QUOTE_HEADERS_ALL

2599: WHERE quote_number = X_qte_number;
2600:
2601: CURSOR get_cust_acct(cust_QUOTE_HEADER_ID Number) IS
2602: SELECT CUST_ACCOUNT_ID
2603: FROM ASO_QUOTE_HEADERS_ALL
2604: WHERE QUOTE_HEADER_ID = cust_QUOTE_HEADER_ID;
2605:
2606: CURSOR c_reservation(C_inv_item_id NUMBER,C_Organization_id NUMBER) IS
2607: SELECT INVENTORY_ITEM_ID,ORGANIZATION_ID FROM mtl_system_items_b

Line 2616: From ASO_QUOTE_HEADERS_ALL

2612:
2613:
2614: Cursor C_exp_date(c_QUOTE_HEADER_ID Number) IS
2615: Select quote_expiration_date
2616: From ASO_QUOTE_HEADERS_ALL
2617: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
2618:
2619: CURSOR C_org_id IS
2620: SELECT org_id

Line 2621: FROM aso_quote_headers_all

2617: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
2618:
2619: CURSOR C_org_id IS
2620: SELECT org_id
2621: FROM aso_quote_headers_all
2622: WHERE quote_header_id = p_qte_line_rec.quote_header_id;
2623:
2624: cursor c_service (p_qln_id number)is
2625: select service_item_flag,serviceable_product_flag

Line 2646: SELECT org_id,quote_type FROM aso_quote_headers_all

2642: AND ORGANIZATION_ID = C_Organization_id;
2643:
2644:
2645: CURSOR c_header_org IS
2646: SELECT org_id,quote_type FROM aso_quote_headers_all
2647: WHERE quote_header_id = P_qte_line_rec.quote_header_id;
2648:
2649:
2650:

Line 2952: update aso_quote_headers_all

2948: x_return_status := FND_API.G_RET_STS_ERROR;
2949:
2950: END IF;
2951:
2952: update aso_quote_headers_all
2953: set quote_version = l_quote_version + 1,
2954: max_version_flag = 'Y',
2955: last_update_date = sysdate,
2956: last_updated_by = fnd_global.user_id,

Line 2960: update aso_quote_headers_all

2956: last_updated_by = fnd_global.user_id,
2957: last_update_login = fnd_global.conc_login_id
2958: where quote_header_id = p_qte_line_rec.quote_header_id;
2959:
2960: update aso_quote_headers_all
2961: set max_version_flag = 'N',
2962: quote_version = l_old_header_rec.quote_version,
2963: last_update_date = sysdate,
2964: last_updated_by = fnd_global.user_id,

Line 2968: update aso_quote_headers_all

2964: last_updated_by = fnd_global.user_id,
2965: last_update_login = fnd_global.conc_login_id
2966: where quote_header_id = x_quote_header_id;
2967:
2968: update aso_quote_headers_all
2969: set quote_version = l_quote_version,
2970: last_update_date = sysdate,
2971: last_updated_by = fnd_global.user_id,
2972: last_update_login = fnd_global.conc_login_id

Line 3007: l_db_object_name := ASO_QUOTE_HEADERS_PVT.G_QUOTE_LINE_DB_NAME;

3003: aso_debug_pub.add('Defaulting_Flow_Code: '|| l_def_control_rec.Defaulting_Flow_Code, 1, 'Y');
3004: END IF ;
3005:
3006: IF l_def_control_rec.application_type_code = 'QUOTING HTML' OR l_def_control_rec.application_type_code = 'QUOTING FORM' THEN
3007: l_db_object_name := ASO_QUOTE_HEADERS_PVT.G_QUOTE_LINE_DB_NAME;
3008: ELSIF l_def_control_rec.application_type_code = 'ISTORE' THEN
3009: l_db_object_name := ASO_QUOTE_HEADERS_PVT.G_STORE_CART_LINE_DB_NAME;
3010: ELSE
3011: l_control_rec.Defaulting_Fwk_Flag := 'N';

Line 3009: l_db_object_name := ASO_QUOTE_HEADERS_PVT.G_STORE_CART_LINE_DB_NAME;

3005:
3006: IF l_def_control_rec.application_type_code = 'QUOTING HTML' OR l_def_control_rec.application_type_code = 'QUOTING FORM' THEN
3007: l_db_object_name := ASO_QUOTE_HEADERS_PVT.G_QUOTE_LINE_DB_NAME;
3008: ELSIF l_def_control_rec.application_type_code = 'ISTORE' THEN
3009: l_db_object_name := ASO_QUOTE_HEADERS_PVT.G_STORE_CART_LINE_DB_NAME;
3010: ELSE
3011: l_control_rec.Defaulting_Fwk_Flag := 'N';
3012: END IF;
3013:

Line 3077: IF aso_quote_headers_pvt.Shipment_Null_Rec_Exists(lx_ln_shipment_rec, l_db_object_name) THEN

3073: END IF;
3074:
3075: END IF;
3076:
3077: IF aso_quote_headers_pvt.Shipment_Null_Rec_Exists(lx_ln_shipment_rec, l_db_object_name) THEN
3078: lx_ln_shipment_tbl(1) := lx_ln_shipment_rec;
3079: END IF;
3080:
3081: -- IF aso_quote_headers_pvt.Payment_Null_Rec_Exists(lx_ln_payment_rec, l_db_object_name) THEN

Line 3081: -- IF aso_quote_headers_pvt.Payment_Null_Rec_Exists(lx_ln_payment_rec, l_db_object_name) THEN

3077: IF aso_quote_headers_pvt.Shipment_Null_Rec_Exists(lx_ln_shipment_rec, l_db_object_name) THEN
3078: lx_ln_shipment_tbl(1) := lx_ln_shipment_rec;
3079: END IF;
3080:
3081: -- IF aso_quote_headers_pvt.Payment_Null_Rec_Exists(lx_ln_payment_rec, l_db_object_name) THEN
3082: lx_ln_payment_tbl(1) := lx_ln_payment_rec;
3083: -- END IF;
3084:
3085: ELSE

Line 4472: ASO_QUOTE_HEADERS_PVT.Update_Quote_Total (

4468: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4469: aso_debug_pub.add('Create_Quote_lines - before update_quote_total '||l_return_status, 1, 'Y');
4470: end if;
4471:
4472: ASO_QUOTE_HEADERS_PVT.Update_Quote_Total (
4473: P_Qte_Header_id => x_Qte_line_rec.quote_header_id,
4474: P_calculate_tax => l_control_rec.CALCULATE_TAX_FLAG,
4475: P_calculate_freight_charge=> l_control_rec.calculate_freight_charge_flag,
4476: p_control_rec => l_control_rec,

Line 4515: FROM aso_quote_headers

4511: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
4512:
4513: SELECT quote_number
4514: INTO l_quote_number
4515: FROM aso_quote_headers
4516: WHERE quote_header_id = x_Qte_line_rec.quote_header_id ;
4517:
4518: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4519: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.Create_Quote_lines : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');

Line 4669: FROM ASO_QUOTE_HEADERS_ALL head,

4665:
4666: Cursor C_Get_quote(c_QUOTE_LINE_ID Number) IS
4667: SELECT head.LAST_UPDATE_DATE, head.QUOTE_STATUS_ID, head.QUOTE_NUMBER,
4668: head.TOTAL_ADJUSTED_PERCENT,head.quote_expiration_date
4669: FROM ASO_QUOTE_HEADERS_ALL head,
4670: ASO_QUOTE_LINES_ALL line
4671: WHERE head.QUOTE_HEADER_ID = line.QUOTE_HEADER_ID
4672: AND line.QUOTE_LINE_ID = c_QUOTE_LINE_ID;
4673:

Line 4680: FROM ASO_QUOTE_HEADERS_ALL

4676: WHERE quote_status_id = c_qte_status_id;
4677:
4678: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
4679: SELECT max(quote_version)
4680: FROM ASO_QUOTE_HEADERS_ALL
4681: WHERE quote_number = X_qte_number;
4682:
4683: CURSOR C_Inst_Details (X_shipment_id NUMBER) IS
4684: SELECT sum(customer_product_quantity) FROM cs_line_inst_details

Line 4702: FROM ASO_QUOTE_HEADERS_ALL

4698: WHERE quote_line_id = l_quote_line_id;
4699:
4700: CURSOR get_cust_acct(cust_QUOTE_HEADER_ID Number) IS
4701: SELECT CUST_ACCOUNT_ID
4702: FROM ASO_QUOTE_HEADERS_ALL
4703: WHERE QUOTE_HEADER_ID = cust_QUOTE_HEADER_ID;
4704:
4705: Cursor C_exp_date(c_QUOTE_HEADER_ID Number) IS
4706: Select quote_expiration_date

Line 4707: From ASO_QUOTE_HEADERS_ALL

4703: WHERE QUOTE_HEADER_ID = cust_QUOTE_HEADER_ID;
4704:
4705: Cursor C_exp_date(c_QUOTE_HEADER_ID Number) IS
4706: Select quote_expiration_date
4707: From ASO_QUOTE_HEADERS_ALL
4708: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
4709:
4710: CURSOR C_org_id IS
4711: SELECT org_id

Line 5112: update aso_quote_headers_all

5108: aso_debug_pub.add('After copy_quote x_quote_header_id: ' || x_quote_header_id);
5109: aso_debug_pub.add('After copy_quote l_qte_nbr: ' || l_qte_nbr);
5110: end if;
5111:
5112: update aso_quote_headers_all
5113: set quote_version = l_quote_version + 1,
5114: max_version_flag = 'Y',
5115: last_update_date = sysdate,
5116: last_updated_by = fnd_global.user_id,

Line 5120: update aso_quote_headers_all

5116: last_updated_by = fnd_global.user_id,
5117: last_update_login = fnd_global.conc_login_id
5118: where quote_header_id = p_qte_line_rec.quote_header_id;
5119:
5120: update aso_quote_headers_all
5121: set max_version_flag = 'N',
5122: quote_version = l_old_header_rec.quote_version,
5123: last_update_date = sysdate,
5124: last_updated_by = fnd_global.user_id,

Line 5128: update aso_quote_headers_all

5124: last_updated_by = fnd_global.user_id,
5125: last_update_login = fnd_global.conc_login_id
5126: where quote_header_id = x_quote_header_id;
5127:
5128: update aso_quote_headers_all
5129: set quote_version = l_quote_version,
5130: last_update_date = sysdate,
5131: last_updated_by = fnd_global.user_id,
5132: last_update_login = fnd_global.conc_login_id

Line 5163: l_db_object_name := ASO_QUOTE_HEADERS_PVT.G_QUOTE_LINE_DB_NAME;

5159: aso_debug_pub.add('last_update_date: '|| l_def_control_rec.last_update_date, 1, 'Y');
5160: END IF ;
5161:
5162: IF l_def_control_rec.application_type_code = 'QUOTING HTML' OR l_def_control_rec.application_type_code = 'QUOTING FORM' THEN
5163: l_db_object_name := ASO_QUOTE_HEADERS_PVT.G_QUOTE_LINE_DB_NAME;
5164: ELSIF l_def_control_rec.application_type_code = 'ISTORE' THEN
5165: l_db_object_name := ASO_QUOTE_HEADERS_PVT.G_STORE_CART_LINE_DB_NAME;
5166: ELSE
5167: l_control_rec.Defaulting_Fwk_Flag := 'N';

Line 5165: l_db_object_name := ASO_QUOTE_HEADERS_PVT.G_STORE_CART_LINE_DB_NAME;

5161:
5162: IF l_def_control_rec.application_type_code = 'QUOTING HTML' OR l_def_control_rec.application_type_code = 'QUOTING FORM' THEN
5163: l_db_object_name := ASO_QUOTE_HEADERS_PVT.G_QUOTE_LINE_DB_NAME;
5164: ELSIF l_def_control_rec.application_type_code = 'ISTORE' THEN
5165: l_db_object_name := ASO_QUOTE_HEADERS_PVT.G_STORE_CART_LINE_DB_NAME;
5166: ELSE
5167: l_control_rec.Defaulting_Fwk_Flag := 'N';
5168: END IF;
5169:

Line 5230: IF aso_quote_headers_pvt.Shipment_Null_Rec_Exists(lx_ln_shipment_rec, l_db_object_name) THEN

5226: END IF;
5227:
5228: END IF;
5229:
5230: IF aso_quote_headers_pvt.Shipment_Null_Rec_Exists(lx_ln_shipment_rec, l_db_object_name) THEN
5231: lx_ln_shipment_tbl(1) := lx_ln_shipment_rec;
5232: END IF;
5233:
5234: IF aso_quote_headers_pvt.Payment_Null_Rec_Exists(lx_ln_payment_rec, l_db_object_name) THEN

Line 5234: IF aso_quote_headers_pvt.Payment_Null_Rec_Exists(lx_ln_payment_rec, l_db_object_name) THEN

5230: IF aso_quote_headers_pvt.Shipment_Null_Rec_Exists(lx_ln_shipment_rec, l_db_object_name) THEN
5231: lx_ln_shipment_tbl(1) := lx_ln_shipment_rec;
5232: END IF;
5233:
5234: IF aso_quote_headers_pvt.Payment_Null_Rec_Exists(lx_ln_payment_rec, l_db_object_name) THEN
5235: lx_ln_payment_tbl(1) := lx_ln_payment_rec;
5236: END IF;
5237:
5238: ELSE

Line 8953: ASO_QUOTE_HEADERS_PVT.Update_Quote_Total (

8949: -- IF calculate_Freight_Charge = 'N', not summation on line level freight charge,
8950: -- just take the value of p_qte_rec.total_freight_charge
8951: -- how can i get the calc_tax_flag and calc_freight_charge_flag ??
8952:
8953: ASO_QUOTE_HEADERS_PVT.Update_Quote_Total (
8954: P_Qte_Header_id => l_Qte_Line_Rec.quote_header_id,
8955: P_calculate_tax => l_control_rec.CALCULATE_TAX_FLAG,
8956: P_calculate_freight_charge=> l_control_rec.calculate_freight_charge_flag,
8957: p_control_rec => l_control_rec,

Line 8988: FROM aso_quote_headers

8984: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
8985:
8986: SELECT quote_number
8987: INTO l_quote_number
8988: FROM aso_quote_headers
8989: WHERE quote_header_id = l_Qte_Line_Rec.quote_header_id;
8990:
8991: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8992: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.update_quote_line : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');

Line 9100: From ASO_QUOTE_HEADERS_ALL head,

9096: IS
9097: Cursor C_Get_quote(c_QUOTE_LINE_ID Number) IS
9098: Select head.LAST_UPDATE_DATE, head.QUOTE_STATUS_ID, head.QUOTE_NUMBER,
9099: head.TOTAL_ADJUSTED_PERCENT, head.quote_header_id
9100: From ASO_QUOTE_HEADERS_ALL head,
9101: ASO_QUOTE_LINES_ALL line
9102: Where head.QUOTE_HEADER_ID = line.QUOTE_HEADER_ID
9103: And line.QUOTE_LINE_ID = c_QUOTE_LINE_ID;
9104:

Line 9111: FROM ASO_QUOTE_HEADERS_ALL

9107: WHERE quote_status_id = c_qte_status_id;
9108:
9109: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
9110: SELECT max(quote_version)
9111: FROM ASO_QUOTE_HEADERS_ALL
9112: WHERE quote_number = X_qte_number;
9113:
9114: CURSOR C_Shipment IS
9115: SELECT shipment_id, reservation_id

Line 9163: FROM aso_quote_headers

9159: and a.quote_line_id <> p_qte_line_rec.quote_line_id;
9160:
9161: cursor get_qte_nbr(qte_hdr_id number) is
9162: SELECT quote_number
9163: FROM aso_quote_headers
9164: WHERE quote_header_id = qte_hdr_id;
9165:
9166: l_api_name CONSTANT VARCHAR2(30) := 'Delete_quote_line';
9167: l_api_version_number CONSTANT NUMBER := 1.0;

Line 9356: update aso_quote_headers_all

9352: aso_debug_pub.add('After copy_quote x_quote_header_id: ' || x_quote_header_id);
9353: aso_debug_pub.add('After copy_quote l_qte_nbr: ' || l_qte_nbr);
9354: end if;
9355:
9356: update aso_quote_headers_all
9357: set quote_version = l_quote_version + 1,
9358: max_version_flag = 'Y',
9359: last_update_date = sysdate,
9360: last_updated_by = fnd_global.user_id,

Line 9364: update aso_quote_headers_all

9360: last_updated_by = fnd_global.user_id,
9361: last_update_login = fnd_global.conc_login_id
9362: where quote_header_id = p_qte_line_rec.quote_header_id;
9363:
9364: update aso_quote_headers_all
9365: set max_version_flag = 'N',
9366: quote_version = l_old_header_rec.quote_version,
9367: last_update_date = sysdate,
9368: last_updated_by = fnd_global.user_id,

Line 9372: update aso_quote_headers_all

9368: last_updated_by = fnd_global.user_id,
9369: last_update_login = fnd_global.conc_login_id
9370: where quote_header_id = x_quote_header_id;
9371:
9372: update aso_quote_headers_all
9373: set quote_version = l_quote_version,
9374: last_update_date = sysdate,
9375: last_updated_by = fnd_global.user_id,
9376: last_update_login = fnd_global.conc_login_id

Line 9526: -- Invoke table handler(ASO_QUOTE_HEADERS_PKG.Delete_Row)

9522: end if;
9523:
9524: close c_prg_lines;
9525:
9526: -- Invoke table handler(ASO_QUOTE_HEADERS_PKG.Delete_Row)
9527: -- these tables may or may not have any rows
9528: -- ideally exception should be handled by the table handler
9529:
9530:

Line 9879: ASO_QUOTE_HEADERS_PVT.Update_Quote_Total(

9875: -- just take the value of p_qte_rec.total_freight_charge
9876: -- how can i get the calc_tax_flag and calc_freight_charge_flag ??
9877:
9878:
9879: ASO_QUOTE_HEADERS_PVT.Update_Quote_Total(
9880: P_Qte_Header_id => l_quote_header_id,
9881: P_calculate_tax => p_control_rec.CALCULATE_TAX_FLAG,
9882: P_calculate_freight_charge => p_control_rec.calculate_freight_charge_flag,
9883: p_control_rec => p_control_rec,