APPS.OZF_NA_DDN_RULE_PKG dependencies on FND_GLOBAL

Line 84: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

80: DECODE( p_deduction_identifier_id, FND_API.G_MISS_CHAR, NULL, p_deduction_identifier_id),
81: DECODE( p_deduction_identifier_org_id, FND_API.G_MISS_NUM, NULL, p_deduction_identifier_org_id),
82: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
84: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
85: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
88:

Line 86: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

82: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
84: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
85: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
88:
89: INSERT INTO ozf_na_deduction_rules_tl(
90: na_deduction_rule_id ,

Line 87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
84: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
85: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
88:
89: INSERT INTO ozf_na_deduction_rules_tl(
90: na_deduction_rule_id ,
91: language ,

Line 105: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),

101: SELECT
102: DECODE( px_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, px_na_deduction_rule_id),
103: l.language_code,
104: DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
105: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
106: DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date),
107: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
108: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
109: USERENV('LANG'),

Line 107: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),

103: l.language_code,
104: DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
105: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
106: DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date),
107: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
108: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
109: USERENV('LANG'),
110: DECODE( p_name, FND_API.G_MISS_CHAR, NULL, p_name),
111: DECODE( p_description, FND_API.G_MISS_CHAR, NULL, p_description)

Line 108: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

104: DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
105: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
106: DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date),
107: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
108: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
109: USERENV('LANG'),
110: DECODE( p_name, FND_API.G_MISS_CHAR, NULL, p_name),
111: DECODE( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
112: FROM fnd_languages l