DBA Data[Home] [Help]

APPS.ASO_SUBMIT_QUOTE_PVT dependencies on FND_GLOBAL

Line 246: IF FND_GLOBAL.User_Id IS NULL THEN

242: --
243: -- ******************************************************************
244: -- Validate Environment
245: -- ******************************************************************
246: IF FND_GLOBAL.User_Id IS NULL THEN
247: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
248: FND_MESSAGE.Set_Name('ASO', 'UT_CANNOT_GET_PROFILE_VALUE');
249: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
250: FND_MSG_PUB.ADD;

Line 1089: last_updated_by = fnd_global.user_id,

1085: UPDATE ASO_QUOTE_HEADERS_ALL
1086: SET order_Id = x_order_header_rec.order_header_id,
1087: quote_status_id = l_qte_status_id,
1088: last_update_date = sysdate,
1089: last_updated_by = fnd_global.user_id,
1090: last_update_login = fnd_global.conc_login_id
1091: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
1092:
1093: FOR i IN 1..lx_order_line_tbl.count LOOP

Line 1090: last_update_login = fnd_global.conc_login_id

1086: SET order_Id = x_order_header_rec.order_header_id,
1087: quote_status_id = l_qte_status_id,
1088: last_update_date = sysdate,
1089: last_updated_by = fnd_global.user_id,
1090: last_update_login = fnd_global.conc_login_id
1091: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
1092:
1093: FOR i IN 1..lx_order_line_tbl.count LOOP
1094: -- update order line id for quote lines

Line 1099: last_updated_by = fnd_global.user_id,

1095:
1096: UPDATE ASO_SHIPMENTS
1097: SET order_line_id = lx_order_line_tbl(i).order_line_id,
1098: last_update_date = sysdate,
1099: last_updated_by = fnd_global.user_id,
1100: last_update_login = fnd_global.conc_login_id
1101: WHERE shipment_id = lx_order_line_tbl(i).quote_shipment_line_id;
1102:
1103: -- update installment details

Line 1100: last_update_login = fnd_global.conc_login_id

1096: UPDATE ASO_SHIPMENTS
1097: SET order_line_id = lx_order_line_tbl(i).order_line_id,
1098: last_update_date = sysdate,
1099: last_updated_by = fnd_global.user_id,
1100: last_update_login = fnd_global.conc_login_id
1101: WHERE shipment_id = lx_order_line_tbl(i).quote_shipment_line_id;
1102:
1103: -- update installment details
1104: -- hyang 1935614 csi integration

Line 1229: last_updated_by = fnd_global.user_id,

1225:
1226: UPDATE ASO_QUOTE_HEADERS_ALL
1227: SET Order_Id = x_order_header_rec.order_header_id,
1228: last_update_date = sysdate,
1229: last_updated_by = fnd_global.user_id,
1230: last_update_login = fnd_global.conc_login_id
1231: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
1232:
1233: END IF;

Line 1230: last_update_login = fnd_global.conc_login_id

1226: UPDATE ASO_QUOTE_HEADERS_ALL
1227: SET Order_Id = x_order_header_rec.order_header_id,
1228: last_update_date = sysdate,
1229: last_updated_by = fnd_global.user_id,
1230: last_update_login = fnd_global.conc_login_id
1231: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
1232:
1233: END IF;
1234:

Line 3611: pvalue => FND_GLOBAL.Resp_Id );

3607: pvalue => P_Control_Rec.Server_Id );
3608:
3609: l_event.AddParameterToList(
3610: pname => 'ECX_PARAMETER4',
3611: pvalue => FND_GLOBAL.Resp_Id );
3612:
3613: l_event.AddParameterToList(
3614: pname => 'ECX_PARAMETER5',
3615: pvalue => FND_GLOBAL.Resp_Appl_Id );

Line 3615: pvalue => FND_GLOBAL.Resp_Appl_Id );

3611: pvalue => FND_GLOBAL.Resp_Id );
3612:
3613: l_event.AddParameterToList(
3614: pname => 'ECX_PARAMETER5',
3615: pvalue => FND_GLOBAL.Resp_Appl_Id );
3616:
3617: wf_event.raise(
3618: p_event_name => 'oracle.apps.wf.replay.aso.submitquote',
3619: p_event_key => to_char(P_Quote_Header_Id),