APPS.CSR_RULES_PVT dependencies on FND_GLOBAL

Line 241: , fnd_global.user_id

237: , NVL(p_resource_id, g_not_specified)
238: , p_enabled_flag
239: , p_rule_rank
240: , p_rule_doc
241: , fnd_global.user_id
242: , SYSDATE
243: , fnd_global.user_id
244: , SYSDATE
245: , fnd_global.login_id

Line 243: , fnd_global.user_id

239: , p_rule_rank
240: , p_rule_doc
241: , fnd_global.user_id
242: , SYSDATE
243: , fnd_global.user_id
244: , SYSDATE
245: , fnd_global.login_id
246: )
247: RETURNING rule_id INTO l_new_rule_id;

Line 245: , fnd_global.login_id

241: , fnd_global.user_id
242: , SYSDATE
243: , fnd_global.user_id
244: , SYSDATE
245: , fnd_global.login_id
246: )
247: RETURNING rule_id INTO l_new_rule_id;
248:
249: -- Insert the Rule's Translated Attributes

Line 267: , fnd_global.user_id

263: , l.language_code
264: , userenv('LANG')
265: , l_rule_name
266: , p_description
267: , fnd_global.user_id
268: , SYSDATE
269: , fnd_global.user_id
270: , SYSDATE
271: , fnd_global.login_id

Line 269: , fnd_global.user_id

265: , l_rule_name
266: , p_description
267: , fnd_global.user_id
268: , SYSDATE
269: , fnd_global.user_id
270: , SYSDATE
271: , fnd_global.login_id
272: FROM fnd_languages l
273: WHERE l.installed_flag in ('I','B')

Line 271: , fnd_global.login_id

267: , fnd_global.user_id
268: , SYSDATE
269: , fnd_global.user_id
270: , SYSDATE
271: , fnd_global.login_id
272: FROM fnd_languages l
273: WHERE l.installed_flag in ('I','B')
274: AND NOT EXISTS (
275: SELECT 1 FROM csr_rules_tl tl

Line 620: , fnd_global.user_id

616: , l.language_code
617: , userenv('LANG')
618: , p_window_names(i)
619: , p_window_descriptions(i)
620: , fnd_global.user_id
621: , SYSDATE
622: , fnd_global.user_id
623: , SYSDATE
624: , fnd_global.login_id

Line 622: , fnd_global.user_id

618: , p_window_names(i)
619: , p_window_descriptions(i)
620: , fnd_global.user_id
621: , SYSDATE
622: , fnd_global.user_id
623: , SYSDATE
624: , fnd_global.login_id
625: FROM fnd_languages l
626: WHERE l.installed_flag in ('I','B');

Line 624: , fnd_global.login_id

620: , fnd_global.user_id
621: , SYSDATE
622: , fnd_global.user_id
623: , SYSDATE
624: , fnd_global.login_id
625: FROM fnd_languages l
626: WHERE l.installed_flag in ('I','B');
627:
628: DBMS_XMLDOM.setNodeValue(l_window_id_node, l_window_id);

Line 633: , last_updated_by = fnd_global.user_id

629: ELSE
630: UPDATE csr_rule_windows_tl
631: SET window_name = p_window_names(i)
632: , description = p_window_descriptions(i)
633: , last_updated_by = fnd_global.user_id
634: , last_update_date = SYSDATE
635: , last_update_login = fnd_global.login_id
636: WHERE window_id = l_window_id
637: AND userenv('LANG') IN (language, source_lang);

Line 635: , last_update_login = fnd_global.login_id

631: SET window_name = p_window_names(i)
632: , description = p_window_descriptions(i)
633: , last_updated_by = fnd_global.user_id
634: , last_update_date = SYSDATE
635: , last_update_login = fnd_global.login_id
636: WHERE window_id = l_window_id
637: AND userenv('LANG') IN (language, source_lang);
638: END IF;
639: END LOOP;

Line 1139: , last_updated_by = fnd_global.user_id

1135: , resource_id = NVL(l_rule.resource_id, g_not_specified)
1136: , enabled_flag = l_rule.enabled_flag
1137: , rule_rank = l_rule.rule_rank
1138: , rule_doc = l_rule.rule_doc
1139: , last_updated_by = fnd_global.user_id
1140: , last_update_date = SYSDATE
1141: , last_update_login = fnd_global.login_id
1142: WHERE rule_id = p_rule_id;
1143:

Line 1141: , last_update_login = fnd_global.login_id

1137: , rule_rank = l_rule.rule_rank
1138: , rule_doc = l_rule.rule_doc
1139: , last_updated_by = fnd_global.user_id
1140: , last_update_date = SYSDATE
1141: , last_update_login = fnd_global.login_id
1142: WHERE rule_id = p_rule_id;
1143:
1144: -- Update the Rule's Translatable Attributes
1145: IF l_rule.rule_name <> p_rule_name

Line 1151: , last_updated_by = fnd_global.user_id

1147: THEN
1148: UPDATE csr_rules_tl
1149: SET rule_name = NVL(p_rule_name, rule_name)
1150: , description = NVL(p_description, description)
1151: , last_updated_by = fnd_global.user_id
1152: , last_update_date = SYSDATE
1153: , last_update_login = fnd_global.login_id
1154: WHERE rule_id = p_rule_id
1155: AND userenv('LANG') IN (language, source_lang);

Line 1153: , last_update_login = fnd_global.login_id

1149: SET rule_name = NVL(p_rule_name, rule_name)
1150: , description = NVL(p_description, description)
1151: , last_updated_by = fnd_global.user_id
1152: , last_update_date = SYSDATE
1153: , last_update_login = fnd_global.login_id
1154: WHERE rule_id = p_rule_id
1155: AND userenv('LANG') IN (language, source_lang);
1156: END IF;
1157: