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 4978: IF FND_GLOBAL.User_Id IS NULL THEN

4974:
4975: -- ******************************************************************
4976: -- Validate Environment
4977: -- ******************************************************************
4978: IF FND_GLOBAL.User_Id IS NULL THEN
4979: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4980: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
4981: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
4982: FND_MSG_PUB.ADD;

Line 5116: last_updated_by = fnd_global.user_id,

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

Line 5117: last_update_login = fnd_global.conc_login_id

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

Line 5124: last_updated_by = fnd_global.user_id,

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

Line 5125: last_update_login = fnd_global.conc_login_id

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

Line 5131: last_updated_by = fnd_global.user_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
5133: where quote_header_id = p_qte_line_rec.quote_header_id;
5134:
5135: END IF; -- auto version flag

Line 5132: last_update_login = fnd_global.conc_login_id

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
5133: where quote_header_id = p_qte_line_rec.quote_header_id;
5134:
5135: END IF; -- auto version flag
5136:

Line 6742: last_updated_by = fnd_global.user_id,

6738: update aso_quote_lines_all
6739: set line_category_code = l_line_category_code,
6740: order_line_type_id = l_order_line_type_id,
6741: last_update_date = sysdate,
6742: last_updated_by = fnd_global.user_id,
6743: last_update_login = fnd_global.conc_login_id
6744: where NVL(line_type_source_flag,'X') <> 'C'
6745: and quote_line_id in( select quote_line_id
6746: from aso_quote_line_details

Line 6743: last_update_login = fnd_global.conc_login_id

6739: set line_category_code = l_line_category_code,
6740: order_line_type_id = l_order_line_type_id,
6741: last_update_date = sysdate,
6742: last_updated_by = fnd_global.user_id,
6743: last_update_login = fnd_global.conc_login_id
6744: where NVL(line_type_source_flag,'X') <> 'C'
6745: and quote_line_id in( select quote_line_id
6746: from aso_quote_line_details
6747: where ref_line_id is not null

Line 8693: last_updated_by = fnd_global.user_id,

8689:
8690: update aso_quote_lines_all
8691: set split_shipment_flag = 'T',
8692: last_update_date = sysdate,
8693: last_updated_by = fnd_global.user_id,
8694: last_update_login = fnd_global.conc_login_id
8695: where quote_line_id = l_Qte_Line_Rec.quote_line_id;
8696:
8697: ELSIF l_ship_count = 1 THEN

Line 8694: last_update_login = fnd_global.conc_login_id

8690: update aso_quote_lines_all
8691: set split_shipment_flag = 'T',
8692: last_update_date = sysdate,
8693: last_updated_by = fnd_global.user_id,
8694: last_update_login = fnd_global.conc_login_id
8695: where quote_line_id = l_Qte_Line_Rec.quote_line_id;
8696:
8697: ELSIF l_ship_count = 1 THEN
8698:

Line 8702: last_updated_by = fnd_global.user_id,

8698:
8699: update aso_quote_lines_all
8700: set split_shipment_flag = 'F',
8701: last_update_date = sysdate,
8702: last_updated_by = fnd_global.user_id,
8703: last_update_login = fnd_global.conc_login_id
8704: where quote_line_id = l_Qte_Line_Rec.quote_line_id;
8705:
8706: END IF;

Line 8703: last_update_login = fnd_global.conc_login_id

8699: update aso_quote_lines_all
8700: set split_shipment_flag = 'F',
8701: last_update_date = sysdate,
8702: last_updated_by = fnd_global.user_id,
8703: last_update_login = fnd_global.conc_login_id
8704: where quote_line_id = l_Qte_Line_Rec.quote_line_id;
8705:
8706: END IF;
8707:

Line 8918: last_updated_by = fnd_global.user_id,

8914: UPDATE ASO_SHIPMENTS
8915: SET reservation_id = l_shipment_tbl(i).reservation_id,
8916: reserved_quantity = l_shipment_tbl(i).reserved_quantity,
8917: last_update_date = sysdate,
8918: last_updated_by = fnd_global.user_id,
8919: last_update_login = fnd_global.conc_login_id
8920: WHERE shipment_id = l_shipment_tbl(i).shipment_id;
8921:
8922: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

Line 8919: last_update_login = fnd_global.conc_login_id

8915: SET reservation_id = l_shipment_tbl(i).reservation_id,
8916: reserved_quantity = l_shipment_tbl(i).reserved_quantity,
8917: last_update_date = sysdate,
8918: last_updated_by = fnd_global.user_id,
8919: last_update_login = fnd_global.conc_login_id
8920: WHERE shipment_id = l_shipment_tbl(i).shipment_id;
8921:
8922: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
8923: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 9241: IF FND_GLOBAL.User_Id IS NULL THEN

9237: --
9238: -- ******************************************************************
9239: -- Validate Environment
9240: -- ******************************************************************
9241: IF FND_GLOBAL.User_Id IS NULL THEN
9242: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9243: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
9244: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
9245: FND_MSG_PUB.ADD;

Line 9360: last_updated_by = fnd_global.user_id,

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

Line 9361: last_update_login = fnd_global.conc_login_id

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

Line 9368: last_updated_by = fnd_global.user_id,

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

Line 9369: last_update_login = fnd_global.conc_login_id

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

Line 9375: last_updated_by = fnd_global.user_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
9377: where quote_header_id = p_qte_line_rec.quote_header_id;
9378:
9379: END IF;

Line 9376: last_update_login = fnd_global.conc_login_id

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
9377: where quote_header_id = p_qte_line_rec.quote_header_id;
9378:
9379: END IF;
9380:

Line 10145: last_updated_by = fnd_global.user_id,

10141: begin
10142: UPDATE aso_quote_lines_all
10143: set quantity = l_qte_line_rec.quantity,
10144: last_update_date = sysdate,
10145: last_updated_by = fnd_global.user_id,
10146: last_update_login = fnd_global.conc_login_id
10147: where quote_line_id IN
10148: ( select quote_line_id from aso_quote_line_details
10149: where service_ref_type_code = 'QUOTE' and service_ref_line_id = l_qte_line_rec.quote_line_id );

Line 10146: last_update_login = fnd_global.conc_login_id

10142: UPDATE aso_quote_lines_all
10143: set quantity = l_qte_line_rec.quantity,
10144: last_update_date = sysdate,
10145: last_updated_by = fnd_global.user_id,
10146: last_update_login = fnd_global.conc_login_id
10147: where quote_line_id IN
10148: ( select quote_line_id from aso_quote_line_details
10149: where service_ref_type_code = 'QUOTE' and service_ref_line_id = l_qte_line_rec.quote_line_id );
10150:

Line 10245: last_updated_by = fnd_global.user_id,

10241:
10242: UPDATE aso_quote_lines_all
10243: set quantity = l_quantity,
10244: last_update_date = sysdate,
10245: last_updated_by = fnd_global.user_id,
10246: last_update_login = fnd_global.conc_login_id
10247: where quote_line_id = p_qte_line_rec.quote_line_id;
10248:
10249: EXCEPTION

Line 10246: last_update_login = fnd_global.conc_login_id

10242: UPDATE aso_quote_lines_all
10243: set quantity = l_quantity,
10244: last_update_date = sysdate,
10245: last_updated_by = fnd_global.user_id,
10246: last_update_login = fnd_global.conc_login_id
10247: where quote_line_id = p_qte_line_rec.quote_line_id;
10248:
10249: EXCEPTION
10250: WHEN OTHERS THEN