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 FND_GLOBAL

Line 79: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

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;
80: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
81: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
82: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_TBL_Type;
83: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 80: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

76: WHERE quote_header_id = l_qte_header_id;
77:
78:
79: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
80: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
81: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
82: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_TBL_Type;
83: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
84: l_freight_charge_rec ASO_QUOTE_PUB.Freight_Charge_Rec_Type;

Line 2806: IF FND_GLOBAL.User_Id IS NULL THEN

2802:
2803: -- ******************************************************************
2804: -- Validate Environment
2805: -- ******************************************************************
2806: IF FND_GLOBAL.User_Id IS NULL THEN
2807: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2808: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
2809: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2810: FND_MSG_PUB.ADD;

Line 2956: last_updated_by = fnd_global.user_id,

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,
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

Line 2957: last_update_login = fnd_global.conc_login_id

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,
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',

Line 2964: last_updated_by = fnd_global.user_id,

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,
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

Line 2965: last_update_login = fnd_global.conc_login_id

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,
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,

Line 2971: last_updated_by = fnd_global.user_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
2973: where quote_header_id = p_qte_line_rec.quote_header_id;
2974:
2975: END IF; -- auto_version set to 'Y'

Line 2972: last_update_login = fnd_global.conc_login_id

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
2973: where quote_header_id = p_qte_line_rec.quote_header_id;
2974:
2975: END IF; -- auto_version set to 'Y'
2976:

Line 4432: last_updated_by = fnd_global.user_id,

4428: UPDATE ASO_SHIPMENTS
4429: SET reservation_id = l_shipment_tbl(i).reservation_id,
4430: reserved_quantity = l_shipment_tbl(i).reserved_quantity,
4431: last_update_date = sysdate,
4432: last_updated_by = fnd_global.user_id,
4433: last_update_login = fnd_global.conc_login_id
4434: WHERE shipment_id = l_shipment_tbl(i).shipment_id;
4435:
4436: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

Line 4433: last_update_login = fnd_global.conc_login_id

4429: SET reservation_id = l_shipment_tbl(i).reservation_id,
4430: reserved_quantity = l_shipment_tbl(i).reserved_quantity,
4431: last_update_date = sysdate,
4432: last_updated_by = fnd_global.user_id,
4433: last_update_login = fnd_global.conc_login_id
4434: WHERE shipment_id = l_shipment_tbl(i).shipment_id;
4435:
4436: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4437: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 4663: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

4659: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
4660: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4661: )
4662: IS
4663: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
4664: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
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,

Line 4664: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

4660: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4661: )
4662: IS
4663: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
4664: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
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

Line 5002: IF FND_GLOBAL.User_Id IS NULL THEN

4998:
4999: -- ******************************************************************
5000: -- Validate Environment
5001: -- ******************************************************************
5002: IF FND_GLOBAL.User_Id IS NULL THEN
5003: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5004: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
5005: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
5006: FND_MSG_PUB.ADD;

Line 5140: last_updated_by = fnd_global.user_id,

5136: update aso_quote_headers_all
5137: set quote_version = l_quote_version + 1,
5138: max_version_flag = 'Y',
5139: last_update_date = sysdate,
5140: last_updated_by = fnd_global.user_id,
5141: last_update_login = fnd_global.conc_login_id
5142: where quote_header_id = p_qte_line_rec.quote_header_id;
5143:
5144: update aso_quote_headers_all

Line 5141: last_update_login = fnd_global.conc_login_id

5137: set quote_version = l_quote_version + 1,
5138: max_version_flag = 'Y',
5139: last_update_date = sysdate,
5140: last_updated_by = fnd_global.user_id,
5141: last_update_login = fnd_global.conc_login_id
5142: where quote_header_id = p_qte_line_rec.quote_header_id;
5143:
5144: update aso_quote_headers_all
5145: set max_version_flag = 'N',

Line 5148: last_updated_by = fnd_global.user_id,

5144: update aso_quote_headers_all
5145: set max_version_flag = 'N',
5146: quote_version = l_old_header_rec.quote_version,
5147: last_update_date = sysdate,
5148: last_updated_by = fnd_global.user_id,
5149: last_update_login = fnd_global.conc_login_id
5150: where quote_header_id = x_quote_header_id;
5151:
5152: update aso_quote_headers_all

Line 5149: last_update_login = fnd_global.conc_login_id

5145: set max_version_flag = 'N',
5146: quote_version = l_old_header_rec.quote_version,
5147: last_update_date = sysdate,
5148: last_updated_by = fnd_global.user_id,
5149: last_update_login = fnd_global.conc_login_id
5150: where quote_header_id = x_quote_header_id;
5151:
5152: update aso_quote_headers_all
5153: set quote_version = l_quote_version,

Line 5155: last_updated_by = fnd_global.user_id,

5151:
5152: update aso_quote_headers_all
5153: set quote_version = l_quote_version,
5154: last_update_date = sysdate,
5155: last_updated_by = fnd_global.user_id,
5156: last_update_login = fnd_global.conc_login_id
5157: where quote_header_id = p_qte_line_rec.quote_header_id;
5158:
5159: END IF; -- auto version flag

Line 5156: last_update_login = fnd_global.conc_login_id

5152: update aso_quote_headers_all
5153: set quote_version = l_quote_version,
5154: last_update_date = sysdate,
5155: last_updated_by = fnd_global.user_id,
5156: last_update_login = fnd_global.conc_login_id
5157: where quote_header_id = p_qte_line_rec.quote_header_id;
5158:
5159: END IF; -- auto version flag
5160:

Line 6860: last_updated_by = fnd_global.user_id,

6856: update aso_quote_lines_all
6857: set line_category_code = l_line_category_code,
6858: order_line_type_id = l_order_line_type_id,
6859: last_update_date = sysdate,
6860: last_updated_by = fnd_global.user_id,
6861: last_update_login = fnd_global.conc_login_id
6862: where NVL(line_type_source_flag,'X') <> 'C'
6863: and quote_line_id in( select quote_line_id
6864: from aso_quote_line_details

Line 6861: last_update_login = fnd_global.conc_login_id

6857: set line_category_code = l_line_category_code,
6858: order_line_type_id = l_order_line_type_id,
6859: last_update_date = sysdate,
6860: last_updated_by = fnd_global.user_id,
6861: last_update_login = fnd_global.conc_login_id
6862: where NVL(line_type_source_flag,'X') <> 'C'
6863: and quote_line_id in( select quote_line_id
6864: from aso_quote_line_details
6865: where ref_line_id is not null

Line 8811: last_updated_by = fnd_global.user_id,

8807:
8808: update aso_quote_lines_all
8809: set split_shipment_flag = 'T',
8810: last_update_date = sysdate,
8811: last_updated_by = fnd_global.user_id,
8812: last_update_login = fnd_global.conc_login_id
8813: where quote_line_id = l_Qte_Line_Rec.quote_line_id;
8814:
8815: ELSIF l_ship_count = 1 THEN

Line 8812: last_update_login = fnd_global.conc_login_id

8808: update aso_quote_lines_all
8809: set split_shipment_flag = 'T',
8810: last_update_date = sysdate,
8811: last_updated_by = fnd_global.user_id,
8812: last_update_login = fnd_global.conc_login_id
8813: where quote_line_id = l_Qte_Line_Rec.quote_line_id;
8814:
8815: ELSIF l_ship_count = 1 THEN
8816:

Line 8820: last_updated_by = fnd_global.user_id,

8816:
8817: update aso_quote_lines_all
8818: set split_shipment_flag = 'F',
8819: last_update_date = sysdate,
8820: last_updated_by = fnd_global.user_id,
8821: last_update_login = fnd_global.conc_login_id
8822: where quote_line_id = l_Qte_Line_Rec.quote_line_id;
8823:
8824: END IF;

Line 8821: last_update_login = fnd_global.conc_login_id

8817: update aso_quote_lines_all
8818: set split_shipment_flag = 'F',
8819: last_update_date = sysdate,
8820: last_updated_by = fnd_global.user_id,
8821: last_update_login = fnd_global.conc_login_id
8822: where quote_line_id = l_Qte_Line_Rec.quote_line_id;
8823:
8824: END IF;
8825:

Line 9036: last_updated_by = fnd_global.user_id,

9032: UPDATE ASO_SHIPMENTS
9033: SET reservation_id = l_shipment_tbl(i).reservation_id,
9034: reserved_quantity = l_shipment_tbl(i).reserved_quantity,
9035: last_update_date = sysdate,
9036: last_updated_by = fnd_global.user_id,
9037: last_update_login = fnd_global.conc_login_id
9038: WHERE shipment_id = l_shipment_tbl(i).shipment_id;
9039:
9040: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

Line 9037: last_update_login = fnd_global.conc_login_id

9033: SET reservation_id = l_shipment_tbl(i).reservation_id,
9034: reserved_quantity = l_shipment_tbl(i).reserved_quantity,
9035: last_update_date = sysdate,
9036: last_updated_by = fnd_global.user_id,
9037: last_update_login = fnd_global.conc_login_id
9038: WHERE shipment_id = l_shipment_tbl(i).shipment_id;
9039:
9040: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
9041: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 9359: IF FND_GLOBAL.User_Id IS NULL THEN

9355: --
9356: -- ******************************************************************
9357: -- Validate Environment
9358: -- ******************************************************************
9359: IF FND_GLOBAL.User_Id IS NULL THEN
9360: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9361: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
9362: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
9363: FND_MSG_PUB.ADD;

Line 9478: last_updated_by = fnd_global.user_id,

9474: update aso_quote_headers_all
9475: set quote_version = l_quote_version + 1,
9476: max_version_flag = 'Y',
9477: last_update_date = sysdate,
9478: last_updated_by = fnd_global.user_id,
9479: last_update_login = fnd_global.conc_login_id
9480: where quote_header_id = p_qte_line_rec.quote_header_id;
9481:
9482: update aso_quote_headers_all

Line 9479: last_update_login = fnd_global.conc_login_id

9475: set quote_version = l_quote_version + 1,
9476: max_version_flag = 'Y',
9477: last_update_date = sysdate,
9478: last_updated_by = fnd_global.user_id,
9479: last_update_login = fnd_global.conc_login_id
9480: where quote_header_id = p_qte_line_rec.quote_header_id;
9481:
9482: update aso_quote_headers_all
9483: set max_version_flag = 'N',

Line 9486: last_updated_by = fnd_global.user_id,

9482: update aso_quote_headers_all
9483: set max_version_flag = 'N',
9484: quote_version = l_old_header_rec.quote_version,
9485: last_update_date = sysdate,
9486: last_updated_by = fnd_global.user_id,
9487: last_update_login = fnd_global.conc_login_id
9488: where quote_header_id = x_quote_header_id;
9489:
9490: update aso_quote_headers_all

Line 9487: last_update_login = fnd_global.conc_login_id

9483: set max_version_flag = 'N',
9484: quote_version = l_old_header_rec.quote_version,
9485: last_update_date = sysdate,
9486: last_updated_by = fnd_global.user_id,
9487: last_update_login = fnd_global.conc_login_id
9488: where quote_header_id = x_quote_header_id;
9489:
9490: update aso_quote_headers_all
9491: set quote_version = l_quote_version,

Line 9493: last_updated_by = fnd_global.user_id,

9489:
9490: update aso_quote_headers_all
9491: set quote_version = l_quote_version,
9492: last_update_date = sysdate,
9493: last_updated_by = fnd_global.user_id,
9494: last_update_login = fnd_global.conc_login_id
9495: where quote_header_id = p_qte_line_rec.quote_header_id;
9496:
9497: END IF;

Line 9494: last_update_login = fnd_global.conc_login_id

9490: update aso_quote_headers_all
9491: set quote_version = l_quote_version,
9492: last_update_date = sysdate,
9493: last_updated_by = fnd_global.user_id,
9494: last_update_login = fnd_global.conc_login_id
9495: where quote_header_id = p_qte_line_rec.quote_header_id;
9496:
9497: END IF;
9498:

Line 10263: last_updated_by = fnd_global.user_id,

10259: begin
10260: UPDATE aso_quote_lines_all
10261: set quantity = l_qte_line_rec.quantity,
10262: last_update_date = sysdate,
10263: last_updated_by = fnd_global.user_id,
10264: last_update_login = fnd_global.conc_login_id
10265: where quote_line_id IN
10266: ( select quote_line_id from aso_quote_line_details
10267: where service_ref_type_code = 'QUOTE' and service_ref_line_id = l_qte_line_rec.quote_line_id );

Line 10264: last_update_login = fnd_global.conc_login_id

10260: UPDATE aso_quote_lines_all
10261: set quantity = l_qte_line_rec.quantity,
10262: last_update_date = sysdate,
10263: last_updated_by = fnd_global.user_id,
10264: last_update_login = fnd_global.conc_login_id
10265: where quote_line_id IN
10266: ( select quote_line_id from aso_quote_line_details
10267: where service_ref_type_code = 'QUOTE' and service_ref_line_id = l_qte_line_rec.quote_line_id );
10268:

Line 10387: last_updated_by = fnd_global.user_id,

10383:
10384: UPDATE aso_quote_lines_all
10385: set quantity = l_quantity,
10386: last_update_date = sysdate,
10387: last_updated_by = fnd_global.user_id,
10388: last_update_login = fnd_global.conc_login_id
10389: where quote_line_id = p_qte_line_rec.quote_line_id;
10390:
10391: EXCEPTION

Line 10388: last_update_login = fnd_global.conc_login_id

10384: UPDATE aso_quote_lines_all
10385: set quantity = l_quantity,
10386: last_update_date = sysdate,
10387: last_updated_by = fnd_global.user_id,
10388: last_update_login = fnd_global.conc_login_id
10389: where quote_line_id = p_qte_line_rec.quote_line_id;
10390:
10391: EXCEPTION
10392: WHEN OTHERS THEN