DBA Data[Home] [Help]

APPS.ASO_SUBMIT_QUOTE_PVT dependencies on FND_GLOBAL

Line 237: IF FND_GLOBAL.User_Id IS NULL THEN

233: --
234: -- ******************************************************************
235: -- Validate Environment
236: -- ******************************************************************
237: IF FND_GLOBAL.User_Id IS NULL THEN
238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
239: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
240: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
241: FND_MSG_PUB.ADD;

Line 960: last_updated_by = fnd_global.user_id,

956: UPDATE ASO_QUOTE_HEADERS_ALL
957: SET order_Id = x_order_header_rec.order_header_id,
958: quote_status_id = l_qte_status_id,
959: last_update_date = sysdate,
960: last_updated_by = fnd_global.user_id,
961: last_update_login = fnd_global.conc_login_id
962: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
963:
964: FOR i IN 1..lx_order_line_tbl.count LOOP

Line 961: last_update_login = fnd_global.conc_login_id

957: SET order_Id = x_order_header_rec.order_header_id,
958: quote_status_id = l_qte_status_id,
959: last_update_date = sysdate,
960: last_updated_by = fnd_global.user_id,
961: last_update_login = fnd_global.conc_login_id
962: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
963:
964: FOR i IN 1..lx_order_line_tbl.count LOOP
965: -- update order line id for quote lines

Line 970: last_updated_by = fnd_global.user_id,

966:
967: UPDATE ASO_SHIPMENTS
968: SET order_line_id = lx_order_line_tbl(i).order_line_id,
969: last_update_date = sysdate,
970: last_updated_by = fnd_global.user_id,
971: last_update_login = fnd_global.conc_login_id
972: WHERE shipment_id = lx_order_line_tbl(i).quote_shipment_line_id;
973:
974: -- update installment details

Line 971: last_update_login = fnd_global.conc_login_id

967: UPDATE ASO_SHIPMENTS
968: SET order_line_id = lx_order_line_tbl(i).order_line_id,
969: last_update_date = sysdate,
970: last_updated_by = fnd_global.user_id,
971: last_update_login = fnd_global.conc_login_id
972: WHERE shipment_id = lx_order_line_tbl(i).quote_shipment_line_id;
973:
974: -- update installment details
975: -- hyang 1935614 csi integration

Line 1100: last_updated_by = fnd_global.user_id,

1096:
1097: UPDATE ASO_QUOTE_HEADERS_ALL
1098: SET Order_Id = x_order_header_rec.order_header_id,
1099: last_update_date = sysdate,
1100: last_updated_by = fnd_global.user_id,
1101: last_update_login = fnd_global.conc_login_id
1102: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
1103:
1104: END IF;

Line 1101: last_update_login = fnd_global.conc_login_id

1097: UPDATE ASO_QUOTE_HEADERS_ALL
1098: SET Order_Id = x_order_header_rec.order_header_id,
1099: last_update_date = sysdate,
1100: last_updated_by = fnd_global.user_id,
1101: last_update_login = fnd_global.conc_login_id
1102: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
1103:
1104: END IF;
1105:

Line 3458: pvalue => FND_GLOBAL.Resp_Id );

3454: pvalue => P_Control_Rec.Server_Id );
3455:
3456: l_event.AddParameterToList(
3457: pname => 'ECX_PARAMETER4',
3458: pvalue => FND_GLOBAL.Resp_Id );
3459:
3460: l_event.AddParameterToList(
3461: pname => 'ECX_PARAMETER5',
3462: pvalue => FND_GLOBAL.Resp_Appl_Id );

Line 3462: pvalue => FND_GLOBAL.Resp_Appl_Id );

3458: pvalue => FND_GLOBAL.Resp_Id );
3459:
3460: l_event.AddParameterToList(
3461: pname => 'ECX_PARAMETER5',
3462: pvalue => FND_GLOBAL.Resp_Appl_Id );
3463:
3464: wf_event.raise(
3465: p_event_name => 'oracle.apps.wf.replay.aso.submitquote',
3466: p_event_key => to_char(P_Quote_Header_Id),