679: (b_ResourceID NUMBER -- Resource ID of calendar user
680: ,b_ResourceType VARCHAR2 -- Resource Type of Calendar User
681: ,b_GroupID NUMBER -- Group ID of Group Calendar
682: )IS SELECT jpa.attribute_value color
683: FROM jtf_perz_profile jpp
684: , jtf_perz_data jpd
685: , jtf_perz_data_attrib jpa
686: WHERE jpp.profile_name = to_char(b_ResourceID)||':JTF_CAL'
687: AND jpp.profile_id = jpd.profile_id
735: (b_ResourceID NUMBER -- Resource ID of calendar user
736: ,b_ResourceType VARCHAR2 -- Resource Type of Calendar User
737: ,b_GroupID NUMBER -- Group ID of Group Calendar
738: )IS SELECT flu.meaning color
739: FROM jtf_perz_profile jpp
740: , jtf_perz_data jpd
741: , jtf_perz_data_attrib jpa
742: , fnd_lookups flu
743: WHERE jpp.profile_name = to_char(b_ResourceID)||':JTF_CAL'
795: (b_ResourceID NUMBER -- Resource ID of calendar user
796: ,b_ResourceType VARCHAR2 -- Resource Type of Calendar User
797: ,b_GroupID NUMBER -- Group ID of Group Calendar
798: )IS SELECT jpa.attribute_value color
799: FROM jtf_perz_profile jpp
800: , jtf_perz_data jpd
801: , jtf_perz_data_attrib jpa
802: WHERE jpp.profile_name = to_char(b_ResourceID)||':JTF_CAL'
803: AND jpp.profile_id = jpd.profile_id
902: CURSOR c_Preference
903: (b_ResourceID IN NUMBER
904: )IS SELECT jpa.attribute_name AttributeName
905: , jpa.attribute_value AttributeValue
906: FROM jtf_perz_profile jpp
907: , jtf_perz_data jpd
908: , jtf_perz_data_attrib jpa
909: WHERE jpp.profile_name = to_char(b_ResourceID)||':JTF_CAL'
910: AND jpp.profile_id = jpd.profile_id