DBA Data[Home] [Help]

APPS.ASO_SALES_CREDIT_PVT dependencies on FND_GLOBAL

Line 12: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_SALES_CREDIT_PVT';
12: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
13: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
14:
15: PROCEDURE Allocate_Sales_Credits
16: (

Line 13: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_SALES_CREDIT_PVT';
12: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
13: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
14:
15: PROCEDURE Allocate_Sales_Credits
16: (
17: P_Api_Version_Number IN NUMBER,

Line 321: last_updated_by = fnd_global.user_id,

317: -- Update quote header with the credit_update_date
318: UPDATE ASO_QUOTE_HEADERS_ALL
319: SET Credit_Update_date = sysdate,
320: last_update_date = sysdate,
321: last_updated_by = fnd_global.user_id,
322: last_update_login = fnd_global.conc_login_id,
323: object_version_number = object_version_number+1
324: WHERE Quote_Header_Id = l_Qte_Header_Rec.Quote_Header_Id
325: RETURNING quote_header_id, last_update_date, credit_update_date, object_version_number

Line 322: last_update_login = fnd_global.conc_login_id,

318: UPDATE ASO_QUOTE_HEADERS_ALL
319: SET Credit_Update_date = sysdate,
320: last_update_date = sysdate,
321: last_updated_by = fnd_global.user_id,
322: last_update_login = fnd_global.conc_login_id,
323: object_version_number = object_version_number+1
324: WHERE Quote_Header_Id = l_Qte_Header_Rec.Quote_Header_Id
325: RETURNING quote_header_id, last_update_date, credit_update_date, object_version_number
326: INTO x_qte_header_rec.Quote_Header_Id, x_qte_header_rec.Last_Update_Date,