2131: BEGIN
2132:
2133: -- Determine security information to be added where block has no security attribute
2134: /*
2135: if(p_validate_session) then -- icx_sec.validateSession sets all the fnd profile values
2136: -- l_validate_session := icx_sec.validateSession;
2137: null;
2138: end if;
2139: */
2138: end if;
2139: */
2140: -- Note that the global variables set here will be used by add_security
2141:
2142: fnd_profile.get_specific('ORG_ID',null,null,null,g_org_id, l_defined);
2143: g_bg_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
2144:
2145: -- Both should be set, so raise an error if there is a problem
2146: -- TO BE COMPLETED
2139: */
2140: -- Note that the global variables set here will be used by add_security
2141:
2142: fnd_profile.get_specific('ORG_ID',null,null,null,g_org_id, l_defined);
2143: g_bg_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
2144:
2145: -- Both should be set, so raise an error if there is a problem
2146: -- TO BE COMPLETED
2147:
3830: l_public_private HXC_TIME_ATTRIBUTES.ATTRIBUTE2%TYPE;
3831:
3832: begin
3833:
3834: if (fnd_profile.value('HXC_CREATE_PUBLIC_TEMPLATES') = 'Y') then
3835:
3836: l_public_private := 'PUBLIC';
3837:
3838: else