DBA Data[Home] [Help]

APPS.ASO_SALES_TEAM_PVT dependencies on FND_GLOBAL

Line 13: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_SALES_TEAM_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asovstmb.pls';
13: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
14: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
15:
16:
17: PROCEDURE Assign_Sales_Team(

Line 14: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_SALES_TEAM_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asovstmb.pls';
13: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
14: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
15:
16:
17: PROCEDURE Assign_Sales_Team(
18: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 740: last_updated_by = fnd_global.user_id,

736: UPDATE ASO_QUOTE_HEADERS_ALL
737: SET Resource_Id = l_primary_salesagent,
738: Resource_Grp_Id = l_primary_res_grp,
739: last_update_date = sysdate,
740: last_updated_by = fnd_global.user_id,
741: last_update_login = fnd_global.conc_login_id,
742: object_version_number = object_version_number+1
743: WHERE quote_number = P_Qte_Header_Rec.quote_number
744: AND max_version_flag = 'Y'

Line 741: last_update_login = fnd_global.conc_login_id,

737: SET Resource_Id = l_primary_salesagent,
738: Resource_Grp_Id = l_primary_res_grp,
739: last_update_date = sysdate,
740: last_updated_by = fnd_global.user_id,
741: last_update_login = fnd_global.conc_login_id,
742: object_version_number = object_version_number+1
743: WHERE quote_number = P_Qte_Header_Rec.quote_number
744: AND max_version_flag = 'Y'
745: RETURNING quote_header_id, last_update_date, resource_id, resource_grp_id, object_version_number

Line 1883: last_updated_by = fnd_global.user_id,

1879: UPDATE ASO_QUOTE_HEADERS_ALL
1880: SET Resource_Id = l_primary_salesagent,
1881: Resource_Grp_Id = l_primary_res_grp,
1882: last_update_date = sysdate,
1883: last_updated_by = fnd_global.user_id,
1884: last_update_login = fnd_global.conc_login_id,
1885: object_version_number = object_version_number+1
1886: WHERE quote_number = P_Qte_Header_Rec.quote_number
1887: AND max_version_flag = 'Y'

Line 1884: last_update_login = fnd_global.conc_login_id,

1880: SET Resource_Id = l_primary_salesagent,
1881: Resource_Grp_Id = l_primary_res_grp,
1882: last_update_date = sysdate,
1883: last_updated_by = fnd_global.user_id,
1884: last_update_login = fnd_global.conc_login_id,
1885: object_version_number = object_version_number+1
1886: WHERE quote_number = P_Qte_Header_Rec.quote_number
1887: AND max_version_flag = 'Y'
1888: RETURNING quote_header_id, last_update_date, resource_id, resource_grp_id, object_version_number

Line 2461: last_updated_by = fnd_global.user_id,

2457: UPDATE ASO_QUOTE_HEADERS_ALL
2458: SET Resource_Id = l_primary_salesagent,
2459: Resource_Grp_Id = l_primary_res_grp,
2460: last_update_date = sysdate,
2461: last_updated_by = fnd_global.user_id,
2462: last_update_login = fnd_global.conc_login_id,
2463: object_version_number = object_version_number+1
2464: WHERE quote_number = P_Qte_Header_Rec.quote_number
2465: AND max_version_flag = 'Y'

Line 2462: last_update_login = fnd_global.conc_login_id,

2458: SET Resource_Id = l_primary_salesagent,
2459: Resource_Grp_Id = l_primary_res_grp,
2460: last_update_date = sysdate,
2461: last_updated_by = fnd_global.user_id,
2462: last_update_login = fnd_global.conc_login_id,
2463: object_version_number = object_version_number+1
2464: WHERE quote_number = P_Qte_Header_Rec.quote_number
2465: AND max_version_flag = 'Y'
2466: RETURNING quote_header_id, last_update_date, resource_id, resource_grp_id, object_version_number