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_RELATED_DEAL_LINES_PKG dependencies on FND_API

Line 83: DECODE( px_related_deal_lines_id, FND_API.g_miss_num, NULL, px_related_deal_lines_id),

79: estimated_amount,
80: qp_list_header_id,
81: estimate_qty_uom
82: ) VALUES (
83: DECODE( px_related_deal_lines_id, FND_API.g_miss_num, NULL, px_related_deal_lines_id),
84: DECODE( p_modifier_id, FND_API.g_miss_num, NULL, p_modifier_id),
85: DECODE( p_related_modifier_id, FND_API.g_miss_num, NULL, p_related_modifier_id),
86: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
87: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 84: DECODE( p_modifier_id, FND_API.g_miss_num, NULL, p_modifier_id),

80: qp_list_header_id,
81: estimate_qty_uom
82: ) VALUES (
83: DECODE( px_related_deal_lines_id, FND_API.g_miss_num, NULL, px_related_deal_lines_id),
84: DECODE( p_modifier_id, FND_API.g_miss_num, NULL, p_modifier_id),
85: DECODE( p_related_modifier_id, FND_API.g_miss_num, NULL, p_related_modifier_id),
86: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
87: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
88: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),

Line 85: DECODE( p_related_modifier_id, FND_API.g_miss_num, NULL, p_related_modifier_id),

81: estimate_qty_uom
82: ) VALUES (
83: DECODE( px_related_deal_lines_id, FND_API.g_miss_num, NULL, px_related_deal_lines_id),
84: DECODE( p_modifier_id, FND_API.g_miss_num, NULL, p_modifier_id),
85: DECODE( p_related_modifier_id, FND_API.g_miss_num, NULL, p_related_modifier_id),
86: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
87: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
88: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
89: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 86: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),

82: ) VALUES (
83: DECODE( px_related_deal_lines_id, FND_API.g_miss_num, NULL, px_related_deal_lines_id),
84: DECODE( p_modifier_id, FND_API.g_miss_num, NULL, p_modifier_id),
85: DECODE( p_related_modifier_id, FND_API.g_miss_num, NULL, p_related_modifier_id),
86: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
87: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
88: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
89: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
90: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 87: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

83: DECODE( px_related_deal_lines_id, FND_API.g_miss_num, NULL, px_related_deal_lines_id),
84: DECODE( p_modifier_id, FND_API.g_miss_num, NULL, p_modifier_id),
85: DECODE( p_related_modifier_id, FND_API.g_miss_num, NULL, p_related_modifier_id),
86: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
87: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
88: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
89: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
90: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
91: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 88: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),

84: DECODE( p_modifier_id, FND_API.g_miss_num, NULL, p_modifier_id),
85: DECODE( p_related_modifier_id, FND_API.g_miss_num, NULL, p_related_modifier_id),
86: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
87: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
88: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
89: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
90: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
91: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
92: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),

Line 89: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

85: DECODE( p_related_modifier_id, FND_API.g_miss_num, NULL, p_related_modifier_id),
86: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
87: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
88: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
89: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
90: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
91: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
92: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
93: DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, NULL, p_estimated_qty_is_max),

Line 90: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

86: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
87: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
88: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
89: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
90: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
91: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
92: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
93: DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, NULL, p_estimated_qty_is_max),
94: DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, NULL, p_estimated_amount_is_max),

Line 91: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

87: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
88: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
89: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
90: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
91: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
92: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
93: DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, NULL, p_estimated_qty_is_max),
94: DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, NULL, p_estimated_amount_is_max),
95: DECODE( p_estimated_qty, FND_API.g_miss_num, NULL, p_estimated_qty),

Line 92: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),

88: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
89: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
90: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
91: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
92: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
93: DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, NULL, p_estimated_qty_is_max),
94: DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, NULL, p_estimated_amount_is_max),
95: DECODE( p_estimated_qty, FND_API.g_miss_num, NULL, p_estimated_qty),
96: DECODE( p_estimated_amount, FND_API.g_miss_num, NULL, p_estimated_amount),

Line 93: DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, NULL, p_estimated_qty_is_max),

89: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
90: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
91: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
92: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
93: DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, NULL, p_estimated_qty_is_max),
94: DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, NULL, p_estimated_amount_is_max),
95: DECODE( p_estimated_qty, FND_API.g_miss_num, NULL, p_estimated_qty),
96: DECODE( p_estimated_amount, FND_API.g_miss_num, NULL, p_estimated_amount),
97: DECODE( p_qp_list_header_id, FND_API.g_miss_num, NULL, p_qp_list_header_id),

Line 94: DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, NULL, p_estimated_amount_is_max),

90: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
91: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
92: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
93: DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, NULL, p_estimated_qty_is_max),
94: DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, NULL, p_estimated_amount_is_max),
95: DECODE( p_estimated_qty, FND_API.g_miss_num, NULL, p_estimated_qty),
96: DECODE( p_estimated_amount, FND_API.g_miss_num, NULL, p_estimated_amount),
97: DECODE( p_qp_list_header_id, FND_API.g_miss_num, NULL, p_qp_list_header_id),
98: DECODE( p_estimate_qty_uom, FND_API.g_miss_char, NULL, p_estimate_qty_uom));

Line 95: DECODE( p_estimated_qty, FND_API.g_miss_num, NULL, p_estimated_qty),

91: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
92: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
93: DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, NULL, p_estimated_qty_is_max),
94: DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, NULL, p_estimated_amount_is_max),
95: DECODE( p_estimated_qty, FND_API.g_miss_num, NULL, p_estimated_qty),
96: DECODE( p_estimated_amount, FND_API.g_miss_num, NULL, p_estimated_amount),
97: DECODE( p_qp_list_header_id, FND_API.g_miss_num, NULL, p_qp_list_header_id),
98: DECODE( p_estimate_qty_uom, FND_API.g_miss_char, NULL, p_estimate_qty_uom));
99: END Insert_Row;

Line 96: DECODE( p_estimated_amount, FND_API.g_miss_num, NULL, p_estimated_amount),

92: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
93: DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, NULL, p_estimated_qty_is_max),
94: DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, NULL, p_estimated_amount_is_max),
95: DECODE( p_estimated_qty, FND_API.g_miss_num, NULL, p_estimated_qty),
96: DECODE( p_estimated_amount, FND_API.g_miss_num, NULL, p_estimated_amount),
97: DECODE( p_qp_list_header_id, FND_API.g_miss_num, NULL, p_qp_list_header_id),
98: DECODE( p_estimate_qty_uom, FND_API.g_miss_char, NULL, p_estimate_qty_uom));
99: END Insert_Row;
100:

Line 97: DECODE( p_qp_list_header_id, FND_API.g_miss_num, NULL, p_qp_list_header_id),

93: DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, NULL, p_estimated_qty_is_max),
94: DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, NULL, p_estimated_amount_is_max),
95: DECODE( p_estimated_qty, FND_API.g_miss_num, NULL, p_estimated_qty),
96: DECODE( p_estimated_amount, FND_API.g_miss_num, NULL, p_estimated_amount),
97: DECODE( p_qp_list_header_id, FND_API.g_miss_num, NULL, p_qp_list_header_id),
98: DECODE( p_estimate_qty_uom, FND_API.g_miss_char, NULL, p_estimate_qty_uom));
99: END Insert_Row;
100:
101:

Line 98: DECODE( p_estimate_qty_uom, FND_API.g_miss_char, NULL, p_estimate_qty_uom));

94: DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, NULL, p_estimated_amount_is_max),
95: DECODE( p_estimated_qty, FND_API.g_miss_num, NULL, p_estimated_qty),
96: DECODE( p_estimated_amount, FND_API.g_miss_num, NULL, p_estimated_amount),
97: DECODE( p_qp_list_header_id, FND_API.g_miss_num, NULL, p_qp_list_header_id),
98: DECODE( p_estimate_qty_uom, FND_API.g_miss_char, NULL, p_estimate_qty_uom));
99: END Insert_Row;
100:
101:
102: ----------------------------------------------------------

Line 138: related_deal_lines_id = DECODE( p_related_deal_lines_id, FND_API.g_miss_num, related_deal_lines_id, p_related_deal_lines_id),

134: IS
135: BEGIN
136: Update OZF_RELATED_DEAL_LINES
137: SET
138: related_deal_lines_id = DECODE( p_related_deal_lines_id, FND_API.g_miss_num, related_deal_lines_id, p_related_deal_lines_id),
139: modifier_id = DECODE( p_modifier_id, FND_API.g_miss_num, modifier_id, p_modifier_id),
140: related_modifier_id = DECODE( p_related_modifier_id, FND_API.g_miss_num, related_modifier_id, p_related_modifier_id),
141: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
142: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 139: modifier_id = DECODE( p_modifier_id, FND_API.g_miss_num, modifier_id, p_modifier_id),

135: BEGIN
136: Update OZF_RELATED_DEAL_LINES
137: SET
138: related_deal_lines_id = DECODE( p_related_deal_lines_id, FND_API.g_miss_num, related_deal_lines_id, p_related_deal_lines_id),
139: modifier_id = DECODE( p_modifier_id, FND_API.g_miss_num, modifier_id, p_modifier_id),
140: related_modifier_id = DECODE( p_related_modifier_id, FND_API.g_miss_num, related_modifier_id, p_related_modifier_id),
141: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
142: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
143: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 140: related_modifier_id = DECODE( p_related_modifier_id, FND_API.g_miss_num, related_modifier_id, p_related_modifier_id),

136: Update OZF_RELATED_DEAL_LINES
137: SET
138: related_deal_lines_id = DECODE( p_related_deal_lines_id, FND_API.g_miss_num, related_deal_lines_id, p_related_deal_lines_id),
139: modifier_id = DECODE( p_modifier_id, FND_API.g_miss_num, modifier_id, p_modifier_id),
140: related_modifier_id = DECODE( p_related_modifier_id, FND_API.g_miss_num, related_modifier_id, p_related_modifier_id),
141: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
142: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
143: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
144: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

Line 141: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

137: SET
138: related_deal_lines_id = DECODE( p_related_deal_lines_id, FND_API.g_miss_num, related_deal_lines_id, p_related_deal_lines_id),
139: modifier_id = DECODE( p_modifier_id, FND_API.g_miss_num, modifier_id, p_modifier_id),
140: related_modifier_id = DECODE( p_related_modifier_id, FND_API.g_miss_num, related_modifier_id, p_related_modifier_id),
141: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
142: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
143: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
144: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
145: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),

Line 142: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

138: related_deal_lines_id = DECODE( p_related_deal_lines_id, FND_API.g_miss_num, related_deal_lines_id, p_related_deal_lines_id),
139: modifier_id = DECODE( p_modifier_id, FND_API.g_miss_num, modifier_id, p_modifier_id),
140: related_modifier_id = DECODE( p_related_modifier_id, FND_API.g_miss_num, related_modifier_id, p_related_modifier_id),
141: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
142: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
143: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
144: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
145: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
146: estimated_qty_is_max = DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, estimated_qty_is_max, p_estimated_qty_is_max),

Line 143: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

139: modifier_id = DECODE( p_modifier_id, FND_API.g_miss_num, modifier_id, p_modifier_id),
140: related_modifier_id = DECODE( p_related_modifier_id, FND_API.g_miss_num, related_modifier_id, p_related_modifier_id),
141: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
142: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
143: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
144: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
145: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
146: estimated_qty_is_max = DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, estimated_qty_is_max, p_estimated_qty_is_max),
147: estimated_amount_is_max = DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, estimated_amount_is_max, p_estimated_amount_is_max),

Line 144: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

140: related_modifier_id = DECODE( p_related_modifier_id, FND_API.g_miss_num, related_modifier_id, p_related_modifier_id),
141: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
142: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
143: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
144: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
145: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
146: estimated_qty_is_max = DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, estimated_qty_is_max, p_estimated_qty_is_max),
147: estimated_amount_is_max = DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, estimated_amount_is_max, p_estimated_amount_is_max),
148: estimated_qty = DECODE( p_estimated_qty, FND_API.g_miss_num, estimated_qty, p_estimated_qty),

Line 145: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),

141: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
142: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
143: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
144: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
145: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
146: estimated_qty_is_max = DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, estimated_qty_is_max, p_estimated_qty_is_max),
147: estimated_amount_is_max = DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, estimated_amount_is_max, p_estimated_amount_is_max),
148: estimated_qty = DECODE( p_estimated_qty, FND_API.g_miss_num, estimated_qty, p_estimated_qty),
149: estimated_amount = DECODE( p_estimated_amount, FND_API.g_miss_num, estimated_amount, p_estimated_amount),

Line 146: estimated_qty_is_max = DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, estimated_qty_is_max, p_estimated_qty_is_max),

142: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
143: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
144: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
145: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
146: estimated_qty_is_max = DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, estimated_qty_is_max, p_estimated_qty_is_max),
147: estimated_amount_is_max = DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, estimated_amount_is_max, p_estimated_amount_is_max),
148: estimated_qty = DECODE( p_estimated_qty, FND_API.g_miss_num, estimated_qty, p_estimated_qty),
149: estimated_amount = DECODE( p_estimated_amount, FND_API.g_miss_num, estimated_amount, p_estimated_amount),
150: qp_list_header_id = DECODE( p_qp_list_header_id, FND_API.g_miss_num, qp_list_header_id, p_qp_list_header_id),

Line 147: estimated_amount_is_max = DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, estimated_amount_is_max, p_estimated_amount_is_max),

143: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
144: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
145: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
146: estimated_qty_is_max = DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, estimated_qty_is_max, p_estimated_qty_is_max),
147: estimated_amount_is_max = DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, estimated_amount_is_max, p_estimated_amount_is_max),
148: estimated_qty = DECODE( p_estimated_qty, FND_API.g_miss_num, estimated_qty, p_estimated_qty),
149: estimated_amount = DECODE( p_estimated_amount, FND_API.g_miss_num, estimated_amount, p_estimated_amount),
150: qp_list_header_id = DECODE( p_qp_list_header_id, FND_API.g_miss_num, qp_list_header_id, p_qp_list_header_id),
151: estimate_qty_uom = DECODE( p_estimate_qty_uom, FND_API.g_miss_char, estimate_qty_uom, p_estimate_qty_uom)

Line 148: estimated_qty = DECODE( p_estimated_qty, FND_API.g_miss_num, estimated_qty, p_estimated_qty),

144: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
145: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
146: estimated_qty_is_max = DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, estimated_qty_is_max, p_estimated_qty_is_max),
147: estimated_amount_is_max = DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, estimated_amount_is_max, p_estimated_amount_is_max),
148: estimated_qty = DECODE( p_estimated_qty, FND_API.g_miss_num, estimated_qty, p_estimated_qty),
149: estimated_amount = DECODE( p_estimated_amount, FND_API.g_miss_num, estimated_amount, p_estimated_amount),
150: qp_list_header_id = DECODE( p_qp_list_header_id, FND_API.g_miss_num, qp_list_header_id, p_qp_list_header_id),
151: estimate_qty_uom = DECODE( p_estimate_qty_uom, FND_API.g_miss_char, estimate_qty_uom, p_estimate_qty_uom)
152: WHERE RELATED_DEAL_LINES_ID = p_RELATED_DEAL_LINES_ID

Line 149: estimated_amount = DECODE( p_estimated_amount, FND_API.g_miss_num, estimated_amount, p_estimated_amount),

145: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
146: estimated_qty_is_max = DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, estimated_qty_is_max, p_estimated_qty_is_max),
147: estimated_amount_is_max = DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, estimated_amount_is_max, p_estimated_amount_is_max),
148: estimated_qty = DECODE( p_estimated_qty, FND_API.g_miss_num, estimated_qty, p_estimated_qty),
149: estimated_amount = DECODE( p_estimated_amount, FND_API.g_miss_num, estimated_amount, p_estimated_amount),
150: qp_list_header_id = DECODE( p_qp_list_header_id, FND_API.g_miss_num, qp_list_header_id, p_qp_list_header_id),
151: estimate_qty_uom = DECODE( p_estimate_qty_uom, FND_API.g_miss_char, estimate_qty_uom, p_estimate_qty_uom)
152: WHERE RELATED_DEAL_LINES_ID = p_RELATED_DEAL_LINES_ID
153: AND object_version_number = p_object_version_number;

Line 150: qp_list_header_id = DECODE( p_qp_list_header_id, FND_API.g_miss_num, qp_list_header_id, p_qp_list_header_id),

146: estimated_qty_is_max = DECODE( p_estimated_qty_is_max, FND_API.g_miss_char, estimated_qty_is_max, p_estimated_qty_is_max),
147: estimated_amount_is_max = DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, estimated_amount_is_max, p_estimated_amount_is_max),
148: estimated_qty = DECODE( p_estimated_qty, FND_API.g_miss_num, estimated_qty, p_estimated_qty),
149: estimated_amount = DECODE( p_estimated_amount, FND_API.g_miss_num, estimated_amount, p_estimated_amount),
150: qp_list_header_id = DECODE( p_qp_list_header_id, FND_API.g_miss_num, qp_list_header_id, p_qp_list_header_id),
151: estimate_qty_uom = DECODE( p_estimate_qty_uom, FND_API.g_miss_char, estimate_qty_uom, p_estimate_qty_uom)
152: WHERE RELATED_DEAL_LINES_ID = p_RELATED_DEAL_LINES_ID
153: AND object_version_number = p_object_version_number;
154:

Line 151: estimate_qty_uom = DECODE( p_estimate_qty_uom, FND_API.g_miss_char, estimate_qty_uom, p_estimate_qty_uom)

147: estimated_amount_is_max = DECODE( p_estimated_amount_is_max, FND_API.g_miss_char, estimated_amount_is_max, p_estimated_amount_is_max),
148: estimated_qty = DECODE( p_estimated_qty, FND_API.g_miss_num, estimated_qty, p_estimated_qty),
149: estimated_amount = DECODE( p_estimated_amount, FND_API.g_miss_num, estimated_amount, p_estimated_amount),
150: qp_list_header_id = DECODE( p_qp_list_header_id, FND_API.g_miss_num, qp_list_header_id, p_qp_list_header_id),
151: estimate_qty_uom = DECODE( p_estimate_qty_uom, FND_API.g_miss_char, estimate_qty_uom, p_estimate_qty_uom)
152: WHERE RELATED_DEAL_LINES_ID = p_RELATED_DEAL_LINES_ID
153: AND object_version_number = p_object_version_number;
154:
155: IF (SQL%NOTFOUND) THEN

Line 156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

152: WHERE RELATED_DEAL_LINES_ID = p_RELATED_DEAL_LINES_ID
153: AND object_version_number = p_object_version_number;
154:
155: IF (SQL%NOTFOUND) THEN
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
157: END IF;
158: END Update_Row;
159:
160:

Line 184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

180: BEGIN
181: DELETE FROM OZF_RELATED_DEAL_LINES
182: WHERE RELATED_DEAL_LINES_ID = p_RELATED_DEAL_LINES_ID;
183: If (SQL%NOTFOUND) then
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: End If;
186: END Delete_Row ;
187:
188: