165: last_update_login = FND_GLOBAL.LOGIN_ID,
166: last_update_date = SYSDATE,
167: last_updated_by = FND_GLOBAL.USER_ID
168: WHERE org_id = p_org_id
169: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
170: intent,
171: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')
172: )
173: AND status_code = 'PENDINGPUB';
167: last_updated_by = FND_GLOBAL.USER_ID
168: WHERE org_id = p_org_id
169: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
170: intent,
171: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')
172: )
173: AND status_code = 'PENDINGPUB';
174:
175: -- Check If any rules are to be processed else exit
1039: last_update_login = FND_GLOBAL.LOGIN_ID,
1040: last_update_date = SYSDATE,
1041: last_updated_by = FND_GLOBAL.USER_ID
1042: WHERE org_id = p_org_id
1043: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
1044: intent,
1045: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')
1046: )
1047: AND status_code = 'PENDINGDISABLE';
1041: last_updated_by = FND_GLOBAL.USER_ID
1042: WHERE org_id = p_org_id
1043: AND intent = DECODE(NVL(fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT'),'A'),'A',
1044: intent,
1045: fnd_profile.value('OKC_LIBRARY_ACCESS_INTENT')
1046: )
1047: AND status_code = 'PENDINGDISABLE';
1048:
1049: -- Check If any rules are to be processed else exit