eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_NA_DDN_RULE_PKG dependencies on FND_API

Line 77: DECODE( px_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, px_na_deduction_rule_id),

73: last_update_date,
74: last_updated_by,
75: last_update_login
76: ) VALUES (
77: DECODE( px_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, px_na_deduction_rule_id),
78: DECODE( p_transaction_source_code, FND_API.g_miss_char, NULL, p_transaction_source_code),
79: DECODE( p_transaction_type_code, FND_API.g_miss_char, NULL, p_transaction_type_code),
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),

Line 78: DECODE( p_transaction_source_code, FND_API.g_miss_char, NULL, p_transaction_source_code),

74: last_updated_by,
75: last_update_login
76: ) VALUES (
77: DECODE( px_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, px_na_deduction_rule_id),
78: DECODE( p_transaction_source_code, FND_API.g_miss_char, NULL, p_transaction_source_code),
79: DECODE( p_transaction_type_code, FND_API.g_miss_char, NULL, p_transaction_type_code),
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),

Line 79: DECODE( p_transaction_type_code, FND_API.g_miss_char, NULL, p_transaction_type_code),

75: last_update_login
76: ) VALUES (
77: DECODE( px_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, px_na_deduction_rule_id),
78: DECODE( p_transaction_source_code, FND_API.g_miss_char, NULL, p_transaction_source_code),
79: DECODE( p_transaction_type_code, FND_API.g_miss_char, NULL, p_transaction_type_code),
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),

Line 80: DECODE( p_deduction_identifier_id, FND_API.G_MISS_CHAR, NULL, p_deduction_identifier_id),

76: ) VALUES (
77: DECODE( px_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, px_na_deduction_rule_id),
78: DECODE( p_transaction_source_code, FND_API.g_miss_char, NULL, p_transaction_source_code),
79: DECODE( p_transaction_type_code, FND_API.g_miss_char, NULL, p_transaction_type_code),
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),

Line 81: DECODE( p_deduction_identifier_org_id, FND_API.G_MISS_NUM, NULL, p_deduction_identifier_org_id),

77: DECODE( px_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, px_na_deduction_rule_id),
78: DECODE( p_transaction_source_code, FND_API.g_miss_char, NULL, p_transaction_source_code),
79: DECODE( p_transaction_type_code, FND_API.g_miss_char, NULL, p_transaction_type_code),
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),

Line 82: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

78: DECODE( p_transaction_source_code, FND_API.g_miss_char, NULL, p_transaction_source_code),
79: DECODE( p_transaction_type_code, FND_API.g_miss_char, NULL, p_transaction_type_code),
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),

Line 83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

79: DECODE( p_transaction_type_code, FND_API.g_miss_char, NULL, p_transaction_type_code),
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));

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 85: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

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:
89: INSERT INTO ozf_na_deduction_rules_tl(

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 102: DECODE( px_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, px_na_deduction_rule_id),

98: name ,
99: description
100: )
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),

Line 110: DECODE( p_name, FND_API.G_MISS_CHAR, NULL, p_name),

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
113: WHERE l.installed_flag IN ('I','B')
114: AND NOT EXISTS(SELECT NULL FROM ozf_na_deduction_rules_tl t

Line 111: DECODE( p_description, FND_API.G_MISS_CHAR, NULL, p_description)

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
113: WHERE l.installed_flag IN ('I','B')
114: AND NOT EXISTS(SELECT NULL FROM ozf_na_deduction_rules_tl t
115: WHERE t.na_deduction_rule_id = DECODE( px_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, px_na_deduction_rule_id)

Line 115: WHERE t.na_deduction_rule_id = DECODE( px_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, px_na_deduction_rule_id)

111: DECODE( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
112: FROM fnd_languages l
113: WHERE l.installed_flag IN ('I','B')
114: AND NOT EXISTS(SELECT NULL FROM ozf_na_deduction_rules_tl t
115: WHERE t.na_deduction_rule_id = DECODE( px_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, px_na_deduction_rule_id)
116: AND t.language = l.language_code);
117: END Insert_Row;
118:
119:

Line 152: na_deduction_rule_id = DECODE( p_na_deduction_rule_id, null, na_deduction_rule_id, FND_API.G_MISS_NUM, null, p_na_deduction_rule_id),

148: IS
149: BEGIN
150: Update ozf_na_deduction_rules_b
151: SET
152: na_deduction_rule_id = DECODE( p_na_deduction_rule_id, null, na_deduction_rule_id, FND_API.G_MISS_NUM, null, p_na_deduction_rule_id),
153: transaction_source_code = DECODE( p_transaction_source_code, null, transaction_source_code, FND_API.g_miss_char, null, p_transaction_source_code),
154: transaction_type_code = DECODE( p_transaction_type_code, null, transaction_type_code, FND_API.g_miss_char, null, p_transaction_type_code),
155: deduction_identifier_id = DECODE( p_deduction_identifier_id, null, deduction_identifier_id, FND_API.G_MISS_CHAR, null, p_deduction_identifier_id),
156: deduction_identifier_org_id = DECODE( p_deduction_identifier_org_id, null, deduction_identifier_org_id, FND_API.G_MISS_NUM, null, p_deduction_identifier_org_id),

Line 153: transaction_source_code = DECODE( p_transaction_source_code, null, transaction_source_code, FND_API.g_miss_char, null, p_transaction_source_code),

149: BEGIN
150: Update ozf_na_deduction_rules_b
151: SET
152: na_deduction_rule_id = DECODE( p_na_deduction_rule_id, null, na_deduction_rule_id, FND_API.G_MISS_NUM, null, p_na_deduction_rule_id),
153: transaction_source_code = DECODE( p_transaction_source_code, null, transaction_source_code, FND_API.g_miss_char, null, p_transaction_source_code),
154: transaction_type_code = DECODE( p_transaction_type_code, null, transaction_type_code, FND_API.g_miss_char, null, p_transaction_type_code),
155: deduction_identifier_id = DECODE( p_deduction_identifier_id, null, deduction_identifier_id, FND_API.G_MISS_CHAR, null, p_deduction_identifier_id),
156: deduction_identifier_org_id = DECODE( p_deduction_identifier_org_id, null, deduction_identifier_org_id, FND_API.G_MISS_NUM, null, p_deduction_identifier_org_id),
157: object_version_number = nvl(p_object_version_number,0) + 1 ,

Line 154: transaction_type_code = DECODE( p_transaction_type_code, null, transaction_type_code, FND_API.g_miss_char, null, p_transaction_type_code),

150: Update ozf_na_deduction_rules_b
151: SET
152: na_deduction_rule_id = DECODE( p_na_deduction_rule_id, null, na_deduction_rule_id, FND_API.G_MISS_NUM, null, p_na_deduction_rule_id),
153: transaction_source_code = DECODE( p_transaction_source_code, null, transaction_source_code, FND_API.g_miss_char, null, p_transaction_source_code),
154: transaction_type_code = DECODE( p_transaction_type_code, null, transaction_type_code, FND_API.g_miss_char, null, p_transaction_type_code),
155: deduction_identifier_id = DECODE( p_deduction_identifier_id, null, deduction_identifier_id, FND_API.G_MISS_CHAR, null, p_deduction_identifier_id),
156: deduction_identifier_org_id = DECODE( p_deduction_identifier_org_id, null, deduction_identifier_org_id, FND_API.G_MISS_NUM, null, p_deduction_identifier_org_id),
157: object_version_number = nvl(p_object_version_number,0) + 1 ,
158: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

Line 155: deduction_identifier_id = DECODE( p_deduction_identifier_id, null, deduction_identifier_id, FND_API.G_MISS_CHAR, null, p_deduction_identifier_id),

151: SET
152: na_deduction_rule_id = DECODE( p_na_deduction_rule_id, null, na_deduction_rule_id, FND_API.G_MISS_NUM, null, p_na_deduction_rule_id),
153: transaction_source_code = DECODE( p_transaction_source_code, null, transaction_source_code, FND_API.g_miss_char, null, p_transaction_source_code),
154: transaction_type_code = DECODE( p_transaction_type_code, null, transaction_type_code, FND_API.g_miss_char, null, p_transaction_type_code),
155: deduction_identifier_id = DECODE( p_deduction_identifier_id, null, deduction_identifier_id, FND_API.G_MISS_CHAR, null, p_deduction_identifier_id),
156: deduction_identifier_org_id = DECODE( p_deduction_identifier_org_id, null, deduction_identifier_org_id, FND_API.G_MISS_NUM, null, p_deduction_identifier_org_id),
157: object_version_number = nvl(p_object_version_number,0) + 1 ,
158: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
159: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 156: deduction_identifier_org_id = DECODE( p_deduction_identifier_org_id, null, deduction_identifier_org_id, FND_API.G_MISS_NUM, null, p_deduction_identifier_org_id),

152: na_deduction_rule_id = DECODE( p_na_deduction_rule_id, null, na_deduction_rule_id, FND_API.G_MISS_NUM, null, p_na_deduction_rule_id),
153: transaction_source_code = DECODE( p_transaction_source_code, null, transaction_source_code, FND_API.g_miss_char, null, p_transaction_source_code),
154: transaction_type_code = DECODE( p_transaction_type_code, null, transaction_type_code, FND_API.g_miss_char, null, p_transaction_type_code),
155: deduction_identifier_id = DECODE( p_deduction_identifier_id, null, deduction_identifier_id, FND_API.G_MISS_CHAR, null, p_deduction_identifier_id),
156: deduction_identifier_org_id = DECODE( p_deduction_identifier_org_id, null, deduction_identifier_org_id, FND_API.G_MISS_NUM, null, p_deduction_identifier_org_id),
157: object_version_number = nvl(p_object_version_number,0) + 1 ,
158: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
159: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
160: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

Line 158: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

154: transaction_type_code = DECODE( p_transaction_type_code, null, transaction_type_code, FND_API.g_miss_char, null, p_transaction_type_code),
155: deduction_identifier_id = DECODE( p_deduction_identifier_id, null, deduction_identifier_id, FND_API.G_MISS_CHAR, null, p_deduction_identifier_id),
156: deduction_identifier_org_id = DECODE( p_deduction_identifier_org_id, null, deduction_identifier_org_id, FND_API.G_MISS_NUM, null, p_deduction_identifier_org_id),
157: object_version_number = nvl(p_object_version_number,0) + 1 ,
158: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
159: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
160: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
161: WHERE na_deduction_rule_id = p_na_deduction_rule_id
162: AND object_version_number = p_object_version_number;

Line 159: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

155: deduction_identifier_id = DECODE( p_deduction_identifier_id, null, deduction_identifier_id, FND_API.G_MISS_CHAR, null, p_deduction_identifier_id),
156: deduction_identifier_org_id = DECODE( p_deduction_identifier_org_id, null, deduction_identifier_org_id, FND_API.G_MISS_NUM, null, p_deduction_identifier_org_id),
157: object_version_number = nvl(p_object_version_number,0) + 1 ,
158: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
159: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
160: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
161: WHERE na_deduction_rule_id = p_na_deduction_rule_id
162: AND object_version_number = p_object_version_number;
163:

Line 160: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

156: deduction_identifier_org_id = DECODE( p_deduction_identifier_org_id, null, deduction_identifier_org_id, FND_API.G_MISS_NUM, null, p_deduction_identifier_org_id),
157: object_version_number = nvl(p_object_version_number,0) + 1 ,
158: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
159: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
160: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
161: WHERE na_deduction_rule_id = p_na_deduction_rule_id
162: AND object_version_number = p_object_version_number;
163:
164: UPDATE ozf_na_deduction_rules_tl

Line 165: set name = DECODE( p_name, null, name, FND_API.g_miss_char, null, p_name),

161: WHERE na_deduction_rule_id = p_na_deduction_rule_id
162: AND object_version_number = p_object_version_number;
163:
164: UPDATE ozf_na_deduction_rules_tl
165: set name = DECODE( p_name, null, name, FND_API.g_miss_char, null, p_name),
166: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
167: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
168: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
169: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 166: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),

162: AND object_version_number = p_object_version_number;
163:
164: UPDATE ozf_na_deduction_rules_tl
165: set name = DECODE( p_name, null, name, FND_API.g_miss_char, null, p_name),
166: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
167: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
168: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
169: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
170: source_lang = USERENV('LANG')

Line 167: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

163:
164: UPDATE ozf_na_deduction_rules_tl
165: set name = DECODE( p_name, null, name, FND_API.g_miss_char, null, p_name),
166: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
167: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
168: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
169: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
170: source_lang = USERENV('LANG')
171: WHERE na_deduction_rule_id = p_na_deduction_rule_id

Line 168: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

164: UPDATE ozf_na_deduction_rules_tl
165: set name = DECODE( p_name, null, name, FND_API.g_miss_char, null, p_name),
166: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
167: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
168: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
169: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
170: source_lang = USERENV('LANG')
171: WHERE na_deduction_rule_id = p_na_deduction_rule_id
172: AND USERENV('LANG') IN (language, source_lang);

Line 169: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

165: set name = DECODE( p_name, null, name, FND_API.g_miss_char, null, p_name),
166: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
167: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
168: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
169: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
170: source_lang = USERENV('LANG')
171: WHERE na_deduction_rule_id = p_na_deduction_rule_id
172: AND USERENV('LANG') IN (language, source_lang);
173:

Line 175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

171: WHERE na_deduction_rule_id = p_na_deduction_rule_id
172: AND USERENV('LANG') IN (language, source_lang);
173:
174: IF (SQL%NOTFOUND) THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178:
179: END Update_Row;

Line 208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

204: DELETE FROM ozf_na_deduction_rules_tl
205: WHERE na_deduction_rule_id = p_na_deduction_rule_id;
206:
207: If (SQL%NOTFOUND) then
208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
209: End If;
210: END Delete_Row ;
211:
212:

Line 246: RAISE FND_API.g_exc_error;

242: FETCH c INTO Recinfo;
243: IF (c%NOTFOUND) THEN
244: CLOSE c;
245: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
246: RAISE FND_API.g_exc_error;
247: END IF;
248: CLOSE c;
249: END Lock_Row;
250: