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_HEADERS_PVT dependencies on FND_GLOBAL

Line 676: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

672: l_sysdate DATE;
673: l_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
674: l_price_attributes_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
675:
676: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
677: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
678:
679: l_org_id NUMBER;
680: l_valid_org_id number; --New variable to store ORG_ID Yogeshwar (MOAC)

Line 677: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

673: l_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
674: l_price_attributes_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
675:
676: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
677: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
678:
679: l_org_id NUMBER;
680: l_valid_org_id number; --New variable to store ORG_ID Yogeshwar (MOAC)
681:

Line 1657: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

1653:
1654: l_sysdate DATE ;
1655: l_qte_header_id NUMBER := p_qte_header_rec.quote_header_id;
1656: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1657: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1658: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1659: l_qte_hdr_rec ASO_QUOTE_PUB.qte_header_rec_Type;
1660: lx_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1661:

Line 1658: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

1654: l_sysdate DATE ;
1655: l_qte_header_id NUMBER := p_qte_header_rec.quote_header_id;
1656: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1657: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1658: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1659: l_qte_hdr_rec ASO_QUOTE_PUB.qte_header_rec_Type;
1660: lx_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1661:
1662:

Line 3928: last_updated_by = fnd_global.user_id,

3924: -- Update the corresponding columns in the header table
3925: -- this update has been commented out as the update for this column is done below
3926: /*update aso_quote_headers_all
3927: set header_paynow_charges = l_paynow_charges,
3928: last_updated_by = fnd_global.user_id,
3929: last_update_login = fnd_global.conc_login_id
3930: where quote_header_id = P_Qte_Header_id; */
3931:
3932:

Line 3929: last_update_login = fnd_global.conc_login_id

3925: -- this update has been commented out as the update for this column is done below
3926: /*update aso_quote_headers_all
3927: set header_paynow_charges = l_paynow_charges,
3928: last_updated_by = fnd_global.user_id,
3929: last_update_login = fnd_global.conc_login_id
3930: where quote_header_id = P_Qte_Header_id; */
3931:
3932:
3933: END IF; -- end if for payment trm id null check

Line 3949: last_updated_by = fnd_global.user_id,

3945: total_quote_price = l_total_quote_price,
3946: total_tax = l_total_tax,
3947: header_paynow_charges = nvl(l_paynow_charges,header_paynow_charges),
3948: last_update_date = sysdate,
3949: last_updated_by = fnd_global.user_id,
3950: last_update_login = fnd_global.conc_login_id
3951: WHERE quote_header_id = p_qte_header_id;
3952:
3953: IF SQL%ROWCOUNT = 0 THEN

Line 3950: last_update_login = fnd_global.conc_login_id

3946: total_tax = l_total_tax,
3947: header_paynow_charges = nvl(l_paynow_charges,header_paynow_charges),
3948: last_update_date = sysdate,
3949: last_updated_by = fnd_global.user_id,
3950: last_update_login = fnd_global.conc_login_id
3951: WHERE quote_header_id = p_qte_header_id;
3952:
3953: IF SQL%ROWCOUNT = 0 THEN
3954:

Line 4088: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

4084: l_Tax_Control_Rec ASO_TAX_INT.Tax_Control_Rec_Type;
4085: x_tax_amount NUMBER;
4086: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
4087:
4088: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
4089: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
4090:
4091: l_price_updated_date_flag VARCHAR2(1) := fnd_api.g_false;
4092:

Line 4089: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

4085: x_tax_amount NUMBER;
4086: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
4087:
4088: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
4089: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
4090:
4091: l_price_updated_date_flag VARCHAR2(1) := fnd_api.g_false;
4092:
4093: cursor c_last_update_date( p_qte_hdr_id number ) is

Line 4257: IF FND_GLOBAL.User_Id IS NULL THEN

4253: l_control_rec.calculate_tax_flag := NULL;
4254:
4255: -- Validate Environment
4256:
4257: IF FND_GLOBAL.User_Id IS NULL THEN
4258:
4259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4260: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
4261: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

Line 6131: last_updated_by = fnd_global.user_id,

6127: update aso_quote_line_details
6128: set ref_type_code = 'CONFIG',
6129: ref_line_id = l_line_rltship_rec.quote_line_id,
6130: last_update_date = sysdate,
6131: last_updated_by = fnd_global.user_id,
6132: last_update_login = fnd_global.conc_login_id
6133: where quote_line_id = l_line_rltship_rec.related_quote_line_id;
6134:
6135: end if;

Line 6132: last_update_login = fnd_global.conc_login_id

6128: set ref_type_code = 'CONFIG',
6129: ref_line_id = l_line_rltship_rec.quote_line_id,
6130: last_update_date = sysdate,
6131: last_updated_by = fnd_global.user_id,
6132: last_update_login = fnd_global.conc_login_id
6133: where quote_line_id = l_line_rltship_rec.related_quote_line_id;
6134:
6135: end if;
6136:

Line 6146: last_updated_by = fnd_global.user_id,

6142:
6143: update aso_quote_line_details
6144: set ref_type_code = 'CONFIG',
6145: last_update_date = sysdate,
6146: last_updated_by = fnd_global.user_id,
6147: last_update_login = fnd_global.conc_login_id
6148: where config_header_id is not null
6149: and config_revision_num is not null
6150: and ref_type_code is null

Line 6147: last_update_login = fnd_global.conc_login_id

6143: update aso_quote_line_details
6144: set ref_type_code = 'CONFIG',
6145: last_update_date = sysdate,
6146: last_updated_by = fnd_global.user_id,
6147: last_update_login = fnd_global.conc_login_id
6148: where config_header_id is not null
6149: and config_revision_num is not null
6150: and ref_type_code is null
6151: and quote_line_id in (select quote_line_id from aso_quote_lines_all

Line 6525: last_updated_by = fnd_global.user_id,

6521: set line_paynow_charges = l_paynow_charges,
6522: line_paynow_tax = l_paynow_tax,
6523: line_paynow_subtotal = l_paynow_amount,
6524: last_update_date = sysdate,
6525: last_updated_by = fnd_global.user_id,
6526: last_update_login = fnd_global.conc_login_id
6527: where quote_line_id = X_Qte_Line_Tbl(i).quote_line_id;
6528:
6529: end if; -- end if for term id null check

Line 6526: last_update_login = fnd_global.conc_login_id

6522: line_paynow_tax = l_paynow_tax,
6523: line_paynow_subtotal = l_paynow_amount,
6524: last_update_date = sysdate,
6525: last_updated_by = fnd_global.user_id,
6526: last_update_login = fnd_global.conc_login_id
6527: where quote_line_id = X_Qte_Line_Tbl(i).quote_line_id;
6528:
6529: end if; -- end if for term id null check
6530: end loop;

Line 6815: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

6811: where quote_object_id = p_qte_header_id
6812: and quote_object_type_code = 'HEADER'
6813: and relationship_type_code = 'OPP_QUOTE';
6814:
6815: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6816: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
6817: payment_rec c_payment_rec%rowtype;
6818: l_payment_db_tbl varchar_tbl_type;
6819: shipment_rec c_shipment_rec%ROWTYPE;

Line 6816: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

6812: and quote_object_type_code = 'HEADER'
6813: and relationship_type_code = 'OPP_QUOTE';
6814:
6815: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6816: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
6817: payment_rec c_payment_rec%rowtype;
6818: l_payment_db_tbl varchar_tbl_type;
6819: shipment_rec c_shipment_rec%ROWTYPE;
6820: l_shipment_db_tbl VARCHAR_TBL_TYPE;

Line 7264: IF FND_GLOBAL.User_Id IS NULL THEN

7260:
7261: -- ******************************************************************
7262: -- Validate Environment
7263: -- ******************************************************************
7264: IF FND_GLOBAL.User_Id IS NULL THEN
7265:
7266: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7267: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
7268: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

Line 11529: last_updated_by = fnd_global.user_id,

11525: set line_paynow_charges = l_paynow_charges,
11526: line_paynow_tax = l_paynow_tax,
11527: line_paynow_subtotal = l_paynow_amount,
11528: last_update_date = sysdate,
11529: last_updated_by = fnd_global.user_id,
11530: last_update_login = fnd_global.conc_login_id
11531: where quote_line_id = quote_lines_rec.quote_line_id;
11532:
11533: end if; -- check for term id null

Line 11530: last_update_login = fnd_global.conc_login_id

11526: line_paynow_tax = l_paynow_tax,
11527: line_paynow_subtotal = l_paynow_amount,
11528: last_update_date = sysdate,
11529: last_updated_by = fnd_global.user_id,
11530: last_update_login = fnd_global.conc_login_id
11531: where quote_line_id = quote_lines_rec.quote_line_id;
11532:
11533: end if; -- check for term id null
11534: end loop;

Line 12142: IF FND_GLOBAL.User_Id IS NULL THEN

12138: --
12139: -- ******************************************************************
12140: -- Validate Environment
12141: -- ******************************************************************
12142: IF FND_GLOBAL.User_Id IS NULL THEN
12143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12144: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
12145: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
12146: FND_MSG_PUB.ADD;