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 675: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

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

Line 676: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

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

Line 1653: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

1649:
1650: l_sysdate DATE ;
1651: l_qte_header_id NUMBER := p_qte_header_rec.quote_header_id;
1652: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1653: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1654: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1655: l_qte_hdr_rec ASO_QUOTE_PUB.qte_header_rec_Type;
1656: lx_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1657:

Line 1654: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

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

Line 3846: last_updated_by = fnd_global.user_id,

3842: -- Update the corresponding columns in the header table
3843: -- this update has been commented out as the update for this column is done below
3844: /*update aso_quote_headers_all
3845: set header_paynow_charges = l_paynow_charges,
3846: last_updated_by = fnd_global.user_id,
3847: last_update_login = fnd_global.conc_login_id
3848: where quote_header_id = P_Qte_Header_id; */
3849:
3850:

Line 3847: last_update_login = fnd_global.conc_login_id

3843: -- this update has been commented out as the update for this column is done below
3844: /*update aso_quote_headers_all
3845: set header_paynow_charges = l_paynow_charges,
3846: last_updated_by = fnd_global.user_id,
3847: last_update_login = fnd_global.conc_login_id
3848: where quote_header_id = P_Qte_Header_id; */
3849:
3850:
3851: END IF; -- end if for payment trm id null check

Line 3867: last_updated_by = fnd_global.user_id,

3863: total_quote_price = l_total_quote_price,
3864: total_tax = l_total_tax,
3865: header_paynow_charges = nvl(l_paynow_charges,header_paynow_charges),
3866: last_update_date = sysdate,
3867: last_updated_by = fnd_global.user_id,
3868: last_update_login = fnd_global.conc_login_id
3869: WHERE quote_header_id = p_qte_header_id;
3870:
3871: IF SQL%ROWCOUNT = 0 THEN

Line 3868: last_update_login = fnd_global.conc_login_id

3864: total_tax = l_total_tax,
3865: header_paynow_charges = nvl(l_paynow_charges,header_paynow_charges),
3866: last_update_date = sysdate,
3867: last_updated_by = fnd_global.user_id,
3868: last_update_login = fnd_global.conc_login_id
3869: WHERE quote_header_id = p_qte_header_id;
3870:
3871: IF SQL%ROWCOUNT = 0 THEN
3872:

Line 4005: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

4001: l_Tax_Control_Rec ASO_TAX_INT.Tax_Control_Rec_Type;
4002: x_tax_amount NUMBER;
4003: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
4004:
4005: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
4006: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
4007:
4008: l_price_updated_date_flag VARCHAR2(1) := fnd_api.g_false;
4009:

Line 4006: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

4002: x_tax_amount NUMBER;
4003: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
4004:
4005: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
4006: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
4007:
4008: l_price_updated_date_flag VARCHAR2(1) := fnd_api.g_false;
4009:
4010: cursor c_last_update_date( p_qte_hdr_id number ) is

Line 4170: IF FND_GLOBAL.User_Id IS NULL THEN

4166: l_control_rec.calculate_tax_flag := NULL;
4167:
4168: -- Validate Environment
4169:
4170: IF FND_GLOBAL.User_Id IS NULL THEN
4171:
4172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4173: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
4174: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

Line 5993: last_updated_by = fnd_global.user_id,

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,
5994: last_update_login = fnd_global.conc_login_id
5995: where quote_line_id = l_line_rltship_rec.related_quote_line_id;
5996:
5997: end if;

Line 5994: last_update_login = fnd_global.conc_login_id

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,
5994: last_update_login = fnd_global.conc_login_id
5995: where quote_line_id = l_line_rltship_rec.related_quote_line_id;
5996:
5997: end if;
5998:

Line 6008: last_updated_by = fnd_global.user_id,

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
6010: where config_header_id is not null
6011: and config_revision_num is not null
6012: and ref_type_code is null

Line 6009: last_update_login = fnd_global.conc_login_id

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
6010: where config_header_id is not null
6011: and config_revision_num is not null
6012: and ref_type_code is null
6013: and quote_line_id in (select quote_line_id from aso_quote_lines_all

Line 6387: last_updated_by = fnd_global.user_id,

6383: set line_paynow_charges = l_paynow_charges,
6384: line_paynow_tax = l_paynow_tax,
6385: line_paynow_subtotal = l_paynow_amount,
6386: last_update_date = sysdate,
6387: last_updated_by = fnd_global.user_id,
6388: last_update_login = fnd_global.conc_login_id
6389: where quote_line_id = X_Qte_Line_Tbl(i).quote_line_id;
6390:
6391: end if; -- end if for term id null check

Line 6388: last_update_login = fnd_global.conc_login_id

6384: line_paynow_tax = l_paynow_tax,
6385: line_paynow_subtotal = l_paynow_amount,
6386: last_update_date = sysdate,
6387: last_updated_by = fnd_global.user_id,
6388: last_update_login = fnd_global.conc_login_id
6389: where quote_line_id = X_Qte_Line_Tbl(i).quote_line_id;
6390:
6391: end if; -- end if for term id null check
6392: end loop;

Line 6676: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

6672: where quote_object_id = p_qte_header_id
6673: and quote_object_type_code = 'HEADER'
6674: and relationship_type_code = 'OPP_QUOTE';
6675:
6676: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6677: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
6678: payment_rec c_payment_rec%rowtype;
6679: l_payment_db_tbl varchar_tbl_type;
6680: shipment_rec c_shipment_rec%ROWTYPE;

Line 6677: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

6673: and quote_object_type_code = 'HEADER'
6674: and relationship_type_code = 'OPP_QUOTE';
6675:
6676: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
6677: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
6678: payment_rec c_payment_rec%rowtype;
6679: l_payment_db_tbl varchar_tbl_type;
6680: shipment_rec c_shipment_rec%ROWTYPE;
6681: l_shipment_db_tbl VARCHAR_TBL_TYPE;

Line 6964: IF FND_GLOBAL.User_Id IS NULL THEN

6960:
6961: -- ******************************************************************
6962: -- Validate Environment
6963: -- ******************************************************************
6964: IF FND_GLOBAL.User_Id IS NULL THEN
6965:
6966: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6967: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
6968: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

Line 10458: last_updated_by = fnd_global.user_id,

10454: set line_paynow_charges = l_paynow_charges,
10455: line_paynow_tax = l_paynow_tax,
10456: line_paynow_subtotal = l_paynow_amount,
10457: last_update_date = sysdate,
10458: last_updated_by = fnd_global.user_id,
10459: last_update_login = fnd_global.conc_login_id
10460: where quote_line_id = quote_lines_rec.quote_line_id;
10461:
10462: end if; -- check for term id null

Line 10459: last_update_login = fnd_global.conc_login_id

10455: line_paynow_tax = l_paynow_tax,
10456: line_paynow_subtotal = l_paynow_amount,
10457: last_update_date = sysdate,
10458: last_updated_by = fnd_global.user_id,
10459: last_update_login = fnd_global.conc_login_id
10460: where quote_line_id = quote_lines_rec.quote_line_id;
10461:
10462: end if; -- check for term id null
10463: end loop;

Line 11071: IF FND_GLOBAL.User_Id IS NULL THEN

11067: --
11068: -- ******************************************************************
11069: -- Validate Environment
11070: -- ******************************************************************
11071: IF FND_GLOBAL.User_Id IS NULL THEN
11072: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11073: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
11074: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
11075: FND_MSG_PUB.ADD;