2000: );
2001:
2002:
2003: -- create access for new offer owner
2004: INSERT INTO ams_act_access
2005: (activity_access_id
2006: ,last_update_date
2007: ,last_updated_by
2008: ,creation_date
2020: ,security_group_id
2021: ,delete_flag
2022: ,owner_flag)
2023: VALUES
2024: (ams_act_access_s.NEXTVAL
2025: ,SYSDATE
2026: ,FND_GLOBAL.user_id
2027: ,SYSDATE
2028: ,FND_GLOBAL.user_id
2040: ,'N'
2041: ,'Y');
2042: -- end create access for owner
2043:
2044: -- create access in ams_act_access_denorm for new offer owner
2045: INSERT INTO ams_act_access_denorm
2046: (access_denorm_id
2047: ,object_type
2048: ,object_id
2041: ,'Y');
2042: -- end create access for owner
2043:
2044: -- create access in ams_act_access_denorm for new offer owner
2045: INSERT INTO ams_act_access_denorm
2046: (access_denorm_id
2047: ,object_type
2048: ,object_id
2049: ,resource_id
2055: ,last_update_login
2056: ,last_updated_by
2057: ,created_by)
2058: VALUES
2059: (ams_act_access_denorm_s.NEXTVAL
2060: ,'OFFR'
2061: ,l_offer_rec.qp_list_header_id
2062: ,l_offer_rec.owner_id
2063: ,'Y'
2067: ,SYSDATE
2068: ,FND_GLOBAL.conc_login_id
2069: ,FND_GLOBAL.user_id
2070: ,FND_GLOBAL.user_id);
2071: -- end create access in ams_act_access_denorm
2072:
2073: -- create access for default team
2074: l_default_team := FND_PROFILE.value('OZF_DEFAULT_OFFER_TEAM');
2075: IF l_default_team IS NOT NULL AND l_default_team <> FND_API.G_MISS_NUM THEN
2072:
2073: -- create access for default team
2074: l_default_team := FND_PROFILE.value('OZF_DEFAULT_OFFER_TEAM');
2075: IF l_default_team IS NOT NULL AND l_default_team <> FND_API.G_MISS_NUM THEN
2076: INSERT INTO ams_act_access
2077: (activity_access_id
2078: ,last_update_date
2079: ,last_updated_by
2080: ,creation_date
2092: ,security_group_id
2093: ,delete_flag
2094: ,owner_flag)
2095: VALUES
2096: (ams_act_access_s.NEXTVAL
2097: ,SYSDATE
2098: ,FND_GLOBAL.user_id
2099: ,SYSDATE
2100: ,FND_GLOBAL.user_id