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: PROCEDURE INSERT_ACCESSES_ACCOUNTS(
17: x_errbuf OUT NOCOPY VARCHAR2,

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: PROCEDURE INSERT_ACCESSES_ACCOUNTS(
17: x_errbuf OUT NOCOPY VARCHAR2,
18: x_retcode OUT NOCOPY VARCHAR2,

Line 53: FND_GLOBAL.USER_ID ,

49: ASO_QUOTE_ACCESSES_S.nextval,
50: P_Qte_Header_Rec.quote_number,
51: p_WinningTerrMember_tbl.resource_id(l_index),
52: p_WinningTerrMember_tbl.group_ID(l_index),
53: FND_GLOBAL.USER_ID ,
54: SYSDATE ,
55: FND_GLOBAL.USER_ID ,
56: FND_GLOBAL.USER_ID ,
57: SYSDATE,

Line 55: FND_GLOBAL.USER_ID ,

51: p_WinningTerrMember_tbl.resource_id(l_index),
52: p_WinningTerrMember_tbl.group_ID(l_index),
53: FND_GLOBAL.USER_ID ,
54: SYSDATE ,
55: FND_GLOBAL.USER_ID ,
56: FND_GLOBAL.USER_ID ,
57: SYSDATE,
58: null,
59: null

Line 56: FND_GLOBAL.USER_ID ,

52: p_WinningTerrMember_tbl.group_ID(l_index),
53: FND_GLOBAL.USER_ID ,
54: SYSDATE ,
55: FND_GLOBAL.USER_ID ,
56: FND_GLOBAL.USER_ID ,
57: SYSDATE,
58: null,
59: null
60: from dual where not exists (select 1 from

Line 1031: last_updated_by = fnd_global.user_id,

1027: UPDATE ASO_QUOTE_HEADERS_ALL
1028: SET Resource_Id = l_primary_salesagent,
1029: Resource_Grp_Id = l_primary_res_grp,
1030: last_update_date = sysdate,
1031: last_updated_by = fnd_global.user_id,
1032: last_update_login = fnd_global.conc_login_id,
1033: object_version_number = object_version_number+1
1034: WHERE quote_number = P_Qte_Header_Rec.quote_number
1035: AND max_version_flag = 'Y'

Line 1032: last_update_login = fnd_global.conc_login_id,

1028: SET Resource_Id = l_primary_salesagent,
1029: Resource_Grp_Id = l_primary_res_grp,
1030: last_update_date = sysdate,
1031: last_updated_by = fnd_global.user_id,
1032: last_update_login = fnd_global.conc_login_id,
1033: object_version_number = object_version_number+1
1034: WHERE quote_number = P_Qte_Header_Rec.quote_number
1035: AND max_version_flag = 'Y'
1036: RETURNING quote_header_id, last_update_date, resource_id, resource_grp_id, object_version_number

Line 2322: last_updated_by = fnd_global.user_id,

2318: UPDATE ASO_QUOTE_HEADERS_ALL
2319: SET Resource_Id = l_primary_salesagent,
2320: Resource_Grp_Id = l_primary_res_grp,
2321: last_update_date = sysdate,
2322: last_updated_by = fnd_global.user_id,
2323: last_update_login = fnd_global.conc_login_id,
2324: object_version_number = object_version_number+1
2325: WHERE quote_number = P_Qte_Header_Rec.quote_number
2326: AND max_version_flag = 'Y'

Line 2323: last_update_login = fnd_global.conc_login_id,

2319: SET Resource_Id = l_primary_salesagent,
2320: Resource_Grp_Id = l_primary_res_grp,
2321: last_update_date = sysdate,
2322: last_updated_by = fnd_global.user_id,
2323: last_update_login = fnd_global.conc_login_id,
2324: object_version_number = object_version_number+1
2325: WHERE quote_number = P_Qte_Header_Rec.quote_number
2326: AND max_version_flag = 'Y'
2327: RETURNING quote_header_id, last_update_date, resource_id, resource_grp_id, object_version_number

Line 2900: last_updated_by = fnd_global.user_id,

2896: UPDATE ASO_QUOTE_HEADERS_ALL
2897: SET Resource_Id = l_primary_salesagent,
2898: Resource_Grp_Id = l_primary_res_grp,
2899: last_update_date = sysdate,
2900: last_updated_by = fnd_global.user_id,
2901: last_update_login = fnd_global.conc_login_id,
2902: object_version_number = object_version_number+1
2903: WHERE quote_number = P_Qte_Header_Rec.quote_number
2904: AND max_version_flag = 'Y'

Line 2901: last_update_login = fnd_global.conc_login_id,

2897: SET Resource_Id = l_primary_salesagent,
2898: Resource_Grp_Id = l_primary_res_grp,
2899: last_update_date = sysdate,
2900: last_updated_by = fnd_global.user_id,
2901: last_update_login = fnd_global.conc_login_id,
2902: object_version_number = object_version_number+1
2903: WHERE quote_number = P_Qte_Header_Rec.quote_number
2904: AND max_version_flag = 'Y'
2905: RETURNING quote_header_id, last_update_date, resource_id, resource_grp_id, object_version_number