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,
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,
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,
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
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
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'
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
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'
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
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'
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