APPS.AMS_DM_LIFT_PKG dependencies on FND_API

Line 75: DECODE( px_LIFT_ID, FND_API.g_miss_num, NULL, px_LIFT_ID),

71: roi,
72: target_confidence,
73: non_target_confidence
74: ) VALUES (
75: DECODE( px_LIFT_ID, FND_API.g_miss_num, NULL, px_LIFT_ID),
76: DECODE( p_LAST_UPDATE_DATE, FND_API.g_miss_date, NULL, p_LAST_UPDATE_DATE),
77: DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, NULL, p_LAST_UPDATED_BY),
78: DECODE( p_CREATION_DATE, FND_API.g_miss_date, NULL, p_CREATION_DATE),
79: DECODE( p_CREATED_BY, FND_API.g_miss_num, NULL, p_CREATED_BY),

Line 76: DECODE( p_LAST_UPDATE_DATE, FND_API.g_miss_date, NULL, p_LAST_UPDATE_DATE),

72: target_confidence,
73: non_target_confidence
74: ) VALUES (
75: DECODE( px_LIFT_ID, FND_API.g_miss_num, NULL, px_LIFT_ID),
76: DECODE( p_LAST_UPDATE_DATE, FND_API.g_miss_date, NULL, p_LAST_UPDATE_DATE),
77: DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, NULL, p_LAST_UPDATED_BY),
78: DECODE( p_CREATION_DATE, FND_API.g_miss_date, NULL, p_CREATION_DATE),
79: DECODE( p_CREATED_BY, FND_API.g_miss_num, NULL, p_CREATED_BY),
80: DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, NULL, p_LAST_UPDATE_LOGIN),

Line 77: DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, NULL, p_LAST_UPDATED_BY),

73: non_target_confidence
74: ) VALUES (
75: DECODE( px_LIFT_ID, FND_API.g_miss_num, NULL, px_LIFT_ID),
76: DECODE( p_LAST_UPDATE_DATE, FND_API.g_miss_date, NULL, p_LAST_UPDATE_DATE),
77: DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, NULL, p_LAST_UPDATED_BY),
78: DECODE( p_CREATION_DATE, FND_API.g_miss_date, NULL, p_CREATION_DATE),
79: DECODE( p_CREATED_BY, FND_API.g_miss_num, NULL, p_CREATED_BY),
80: DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, NULL, p_LAST_UPDATE_LOGIN),
81: DECODE( px_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, NULL, px_OBJECT_VERSION_NUMBER),

Line 78: DECODE( p_CREATION_DATE, FND_API.g_miss_date, NULL, p_CREATION_DATE),

74: ) VALUES (
75: DECODE( px_LIFT_ID, FND_API.g_miss_num, NULL, px_LIFT_ID),
76: DECODE( p_LAST_UPDATE_DATE, FND_API.g_miss_date, NULL, p_LAST_UPDATE_DATE),
77: DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, NULL, p_LAST_UPDATED_BY),
78: DECODE( p_CREATION_DATE, FND_API.g_miss_date, NULL, p_CREATION_DATE),
79: DECODE( p_CREATED_BY, FND_API.g_miss_num, NULL, p_CREATED_BY),
80: DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, NULL, p_LAST_UPDATE_LOGIN),
81: DECODE( px_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, NULL, px_OBJECT_VERSION_NUMBER),
82: DECODE( p_MODEL_ID, FND_API.g_miss_num, NULL, p_MODEL_ID),

Line 79: DECODE( p_CREATED_BY, FND_API.g_miss_num, NULL, p_CREATED_BY),

75: DECODE( px_LIFT_ID, FND_API.g_miss_num, NULL, px_LIFT_ID),
76: DECODE( p_LAST_UPDATE_DATE, FND_API.g_miss_date, NULL, p_LAST_UPDATE_DATE),
77: DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, NULL, p_LAST_UPDATED_BY),
78: DECODE( p_CREATION_DATE, FND_API.g_miss_date, NULL, p_CREATION_DATE),
79: DECODE( p_CREATED_BY, FND_API.g_miss_num, NULL, p_CREATED_BY),
80: DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, NULL, p_LAST_UPDATE_LOGIN),
81: DECODE( px_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, NULL, px_OBJECT_VERSION_NUMBER),
82: DECODE( p_MODEL_ID, FND_API.g_miss_num, NULL, p_MODEL_ID),
83: DECODE( p_QUANTILE, FND_API.g_miss_num, NULL, p_QUANTILE),

Line 80: DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, NULL, p_LAST_UPDATE_LOGIN),

76: DECODE( p_LAST_UPDATE_DATE, FND_API.g_miss_date, NULL, p_LAST_UPDATE_DATE),
77: DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, NULL, p_LAST_UPDATED_BY),
78: DECODE( p_CREATION_DATE, FND_API.g_miss_date, NULL, p_CREATION_DATE),
79: DECODE( p_CREATED_BY, FND_API.g_miss_num, NULL, p_CREATED_BY),
80: DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, NULL, p_LAST_UPDATE_LOGIN),
81: DECODE( px_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, NULL, px_OBJECT_VERSION_NUMBER),
82: DECODE( p_MODEL_ID, FND_API.g_miss_num, NULL, p_MODEL_ID),
83: DECODE( p_QUANTILE, FND_API.g_miss_num, NULL, p_QUANTILE),
84: DECODE( p_LIFT, FND_API.g_miss_num, NULL, p_LIFT),

Line 81: DECODE( px_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, NULL, px_OBJECT_VERSION_NUMBER),

77: DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, NULL, p_LAST_UPDATED_BY),
78: DECODE( p_CREATION_DATE, FND_API.g_miss_date, NULL, p_CREATION_DATE),
79: DECODE( p_CREATED_BY, FND_API.g_miss_num, NULL, p_CREATED_BY),
80: DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, NULL, p_LAST_UPDATE_LOGIN),
81: DECODE( px_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, NULL, px_OBJECT_VERSION_NUMBER),
82: DECODE( p_MODEL_ID, FND_API.g_miss_num, NULL, p_MODEL_ID),
83: DECODE( p_QUANTILE, FND_API.g_miss_num, NULL, p_QUANTILE),
84: DECODE( p_LIFT, FND_API.g_miss_num, NULL, p_LIFT),
85: DECODE( p_TARGETS, FND_API.g_miss_num, NULL, p_TARGETS),

Line 82: DECODE( p_MODEL_ID, FND_API.g_miss_num, NULL, p_MODEL_ID),

78: DECODE( p_CREATION_DATE, FND_API.g_miss_date, NULL, p_CREATION_DATE),
79: DECODE( p_CREATED_BY, FND_API.g_miss_num, NULL, p_CREATED_BY),
80: DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, NULL, p_LAST_UPDATE_LOGIN),
81: DECODE( px_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, NULL, px_OBJECT_VERSION_NUMBER),
82: DECODE( p_MODEL_ID, FND_API.g_miss_num, NULL, p_MODEL_ID),
83: DECODE( p_QUANTILE, FND_API.g_miss_num, NULL, p_QUANTILE),
84: DECODE( p_LIFT, FND_API.g_miss_num, NULL, p_LIFT),
85: DECODE( p_TARGETS, FND_API.g_miss_num, NULL, p_TARGETS),
86: DECODE( p_NON_TARGETS, FND_API.g_miss_num, NULL, p_NON_TARGETS),

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

79: DECODE( p_CREATED_BY, FND_API.g_miss_num, NULL, p_CREATED_BY),
80: DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, NULL, p_LAST_UPDATE_LOGIN),
81: DECODE( px_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, NULL, px_OBJECT_VERSION_NUMBER),
82: DECODE( p_MODEL_ID, FND_API.g_miss_num, NULL, p_MODEL_ID),
83: DECODE( p_QUANTILE, FND_API.g_miss_num, NULL, p_QUANTILE),
84: DECODE( p_LIFT, FND_API.g_miss_num, NULL, p_LIFT),
85: DECODE( p_TARGETS, FND_API.g_miss_num, NULL, p_TARGETS),
86: DECODE( p_NON_TARGETS, FND_API.g_miss_num, NULL, p_NON_TARGETS),
87: DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, NULL, p_TARGETS_CUMM),

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

80: DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, NULL, p_LAST_UPDATE_LOGIN),
81: DECODE( px_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, NULL, px_OBJECT_VERSION_NUMBER),
82: DECODE( p_MODEL_ID, FND_API.g_miss_num, NULL, p_MODEL_ID),
83: DECODE( p_QUANTILE, FND_API.g_miss_num, NULL, p_QUANTILE),
84: DECODE( p_LIFT, FND_API.g_miss_num, NULL, p_LIFT),
85: DECODE( p_TARGETS, FND_API.g_miss_num, NULL, p_TARGETS),
86: DECODE( p_NON_TARGETS, FND_API.g_miss_num, NULL, p_NON_TARGETS),
87: DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, NULL, p_TARGETS_CUMM),
88: DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, NULL, p_TARGET_DENSITY_CUMM),

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

81: DECODE( px_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, NULL, px_OBJECT_VERSION_NUMBER),
82: DECODE( p_MODEL_ID, FND_API.g_miss_num, NULL, p_MODEL_ID),
83: DECODE( p_QUANTILE, FND_API.g_miss_num, NULL, p_QUANTILE),
84: DECODE( p_LIFT, FND_API.g_miss_num, NULL, p_LIFT),
85: DECODE( p_TARGETS, FND_API.g_miss_num, NULL, p_TARGETS),
86: DECODE( p_NON_TARGETS, FND_API.g_miss_num, NULL, p_NON_TARGETS),
87: DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, NULL, p_TARGETS_CUMM),
88: DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, NULL, p_TARGET_DENSITY_CUMM),
89: DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, NULL, p_TARGET_DENSITY),

Line 86: DECODE( p_NON_TARGETS, FND_API.g_miss_num, NULL, p_NON_TARGETS),

82: DECODE( p_MODEL_ID, FND_API.g_miss_num, NULL, p_MODEL_ID),
83: DECODE( p_QUANTILE, FND_API.g_miss_num, NULL, p_QUANTILE),
84: DECODE( p_LIFT, FND_API.g_miss_num, NULL, p_LIFT),
85: DECODE( p_TARGETS, FND_API.g_miss_num, NULL, p_TARGETS),
86: DECODE( p_NON_TARGETS, FND_API.g_miss_num, NULL, p_NON_TARGETS),
87: DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, NULL, p_TARGETS_CUMM),
88: DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, NULL, p_TARGET_DENSITY_CUMM),
89: DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, NULL, p_TARGET_DENSITY),
90: DECODE( p_MARGIN, FND_API.g_miss_num, NULL, p_MARGIN),

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

83: DECODE( p_QUANTILE, FND_API.g_miss_num, NULL, p_QUANTILE),
84: DECODE( p_LIFT, FND_API.g_miss_num, NULL, p_LIFT),
85: DECODE( p_TARGETS, FND_API.g_miss_num, NULL, p_TARGETS),
86: DECODE( p_NON_TARGETS, FND_API.g_miss_num, NULL, p_NON_TARGETS),
87: DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, NULL, p_TARGETS_CUMM),
88: DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, NULL, p_TARGET_DENSITY_CUMM),
89: DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, NULL, p_TARGET_DENSITY),
90: DECODE( p_MARGIN, FND_API.g_miss_num, NULL, p_MARGIN),
91: DECODE( p_ROI, FND_API.g_miss_num, NULL, p_ROI),

Line 88: DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, NULL, p_TARGET_DENSITY_CUMM),

84: DECODE( p_LIFT, FND_API.g_miss_num, NULL, p_LIFT),
85: DECODE( p_TARGETS, FND_API.g_miss_num, NULL, p_TARGETS),
86: DECODE( p_NON_TARGETS, FND_API.g_miss_num, NULL, p_NON_TARGETS),
87: DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, NULL, p_TARGETS_CUMM),
88: DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, NULL, p_TARGET_DENSITY_CUMM),
89: DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, NULL, p_TARGET_DENSITY),
90: DECODE( p_MARGIN, FND_API.g_miss_num, NULL, p_MARGIN),
91: DECODE( p_ROI, FND_API.g_miss_num, NULL, p_ROI),
92: DECODE( p_TARGET_CONFIDENCE, FND_API.g_miss_num, NULL, p_TARGET_CONFIDENCE),

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

85: DECODE( p_TARGETS, FND_API.g_miss_num, NULL, p_TARGETS),
86: DECODE( p_NON_TARGETS, FND_API.g_miss_num, NULL, p_NON_TARGETS),
87: DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, NULL, p_TARGETS_CUMM),
88: DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, NULL, p_TARGET_DENSITY_CUMM),
89: DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, NULL, p_TARGET_DENSITY),
90: DECODE( p_MARGIN, FND_API.g_miss_num, NULL, p_MARGIN),
91: DECODE( p_ROI, FND_API.g_miss_num, NULL, p_ROI),
92: DECODE( p_TARGET_CONFIDENCE, FND_API.g_miss_num, NULL, p_TARGET_CONFIDENCE),
93: DECODE( p_NON_TARGET_CONFIDENCE, FND_API.g_miss_num, NULL, p_NON_TARGET_CONFIDENCE)

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

86: DECODE( p_NON_TARGETS, FND_API.g_miss_num, NULL, p_NON_TARGETS),
87: DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, NULL, p_TARGETS_CUMM),
88: DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, NULL, p_TARGET_DENSITY_CUMM),
89: DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, NULL, p_TARGET_DENSITY),
90: DECODE( p_MARGIN, FND_API.g_miss_num, NULL, p_MARGIN),
91: DECODE( p_ROI, FND_API.g_miss_num, NULL, p_ROI),
92: DECODE( p_TARGET_CONFIDENCE, FND_API.g_miss_num, NULL, p_TARGET_CONFIDENCE),
93: DECODE( p_NON_TARGET_CONFIDENCE, FND_API.g_miss_num, NULL, p_NON_TARGET_CONFIDENCE)
94: );

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

87: DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, NULL, p_TARGETS_CUMM),
88: DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, NULL, p_TARGET_DENSITY_CUMM),
89: DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, NULL, p_TARGET_DENSITY),
90: DECODE( p_MARGIN, FND_API.g_miss_num, NULL, p_MARGIN),
91: DECODE( p_ROI, FND_API.g_miss_num, NULL, p_ROI),
92: DECODE( p_TARGET_CONFIDENCE, FND_API.g_miss_num, NULL, p_TARGET_CONFIDENCE),
93: DECODE( p_NON_TARGET_CONFIDENCE, FND_API.g_miss_num, NULL, p_NON_TARGET_CONFIDENCE)
94: );
95: END Insert_Row;

Line 92: DECODE( p_TARGET_CONFIDENCE, FND_API.g_miss_num, NULL, p_TARGET_CONFIDENCE),

88: DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, NULL, p_TARGET_DENSITY_CUMM),
89: DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, NULL, p_TARGET_DENSITY),
90: DECODE( p_MARGIN, FND_API.g_miss_num, NULL, p_MARGIN),
91: DECODE( p_ROI, FND_API.g_miss_num, NULL, p_ROI),
92: DECODE( p_TARGET_CONFIDENCE, FND_API.g_miss_num, NULL, p_TARGET_CONFIDENCE),
93: DECODE( p_NON_TARGET_CONFIDENCE, FND_API.g_miss_num, NULL, p_NON_TARGET_CONFIDENCE)
94: );
95: END Insert_Row;
96:

Line 93: DECODE( p_NON_TARGET_CONFIDENCE, FND_API.g_miss_num, NULL, p_NON_TARGET_CONFIDENCE)

89: DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, NULL, p_TARGET_DENSITY),
90: DECODE( p_MARGIN, FND_API.g_miss_num, NULL, p_MARGIN),
91: DECODE( p_ROI, FND_API.g_miss_num, NULL, p_ROI),
92: DECODE( p_TARGET_CONFIDENCE, FND_API.g_miss_num, NULL, p_TARGET_CONFIDENCE),
93: DECODE( p_NON_TARGET_CONFIDENCE, FND_API.g_miss_num, NULL, p_NON_TARGET_CONFIDENCE)
94: );
95: END Insert_Row;
96:
97: PROCEDURE Update_Row(

Line 120: lift_id = DECODE( p_LIFT_ID, FND_API.g_miss_num, LIFT_ID, p_LIFT_ID),

116: IS
117: BEGIN
118: Update AMS_DM_LIFT
119: SET
120: lift_id = DECODE( p_LIFT_ID, FND_API.g_miss_num, LIFT_ID, p_LIFT_ID),
121: last_update_date = DECODE( p_LAST_UPDATE_DATE, FND_API.g_miss_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
122: last_updated_by = DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
123: last_update_login = DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
124: object_version_number = DECODE( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),

Line 121: last_update_date = DECODE( p_LAST_UPDATE_DATE, FND_API.g_miss_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

117: BEGIN
118: Update AMS_DM_LIFT
119: SET
120: lift_id = DECODE( p_LIFT_ID, FND_API.g_miss_num, LIFT_ID, p_LIFT_ID),
121: last_update_date = DECODE( p_LAST_UPDATE_DATE, FND_API.g_miss_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
122: last_updated_by = DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
123: last_update_login = DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
124: object_version_number = DECODE( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
125: model_id = DECODE( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),

Line 122: last_updated_by = DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

118: Update AMS_DM_LIFT
119: SET
120: lift_id = DECODE( p_LIFT_ID, FND_API.g_miss_num, LIFT_ID, p_LIFT_ID),
121: last_update_date = DECODE( p_LAST_UPDATE_DATE, FND_API.g_miss_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
122: last_updated_by = DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
123: last_update_login = DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
124: object_version_number = DECODE( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
125: model_id = DECODE( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),
126: quantile = DECODE( p_QUANTILE, FND_API.g_miss_num, QUANTILE, p_QUANTILE),

Line 123: last_update_login = DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

119: SET
120: lift_id = DECODE( p_LIFT_ID, FND_API.g_miss_num, LIFT_ID, p_LIFT_ID),
121: last_update_date = DECODE( p_LAST_UPDATE_DATE, FND_API.g_miss_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
122: last_updated_by = DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
123: last_update_login = DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
124: object_version_number = DECODE( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
125: model_id = DECODE( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),
126: quantile = DECODE( p_QUANTILE, FND_API.g_miss_num, QUANTILE, p_QUANTILE),
127: lift = DECODE( p_LIFT, FND_API.g_miss_num, LIFT, p_LIFT),

Line 124: object_version_number = DECODE( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),

120: lift_id = DECODE( p_LIFT_ID, FND_API.g_miss_num, LIFT_ID, p_LIFT_ID),
121: last_update_date = DECODE( p_LAST_UPDATE_DATE, FND_API.g_miss_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
122: last_updated_by = DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
123: last_update_login = DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
124: object_version_number = DECODE( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
125: model_id = DECODE( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),
126: quantile = DECODE( p_QUANTILE, FND_API.g_miss_num, QUANTILE, p_QUANTILE),
127: lift = DECODE( p_LIFT, FND_API.g_miss_num, LIFT, p_LIFT),
128: targets = DECODE( p_TARGETS, FND_API.g_miss_num, TARGETS, p_TARGETS),

Line 125: model_id = DECODE( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),

121: last_update_date = DECODE( p_LAST_UPDATE_DATE, FND_API.g_miss_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
122: last_updated_by = DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
123: last_update_login = DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
124: object_version_number = DECODE( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
125: model_id = DECODE( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),
126: quantile = DECODE( p_QUANTILE, FND_API.g_miss_num, QUANTILE, p_QUANTILE),
127: lift = DECODE( p_LIFT, FND_API.g_miss_num, LIFT, p_LIFT),
128: targets = DECODE( p_TARGETS, FND_API.g_miss_num, TARGETS, p_TARGETS),
129: non_targets = DECODE( p_NON_TARGETS, FND_API.g_miss_num, NON_TARGETS, p_NON_TARGETS),

Line 126: quantile = DECODE( p_QUANTILE, FND_API.g_miss_num, QUANTILE, p_QUANTILE),

122: last_updated_by = DECODE( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
123: last_update_login = DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
124: object_version_number = DECODE( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
125: model_id = DECODE( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),
126: quantile = DECODE( p_QUANTILE, FND_API.g_miss_num, QUANTILE, p_QUANTILE),
127: lift = DECODE( p_LIFT, FND_API.g_miss_num, LIFT, p_LIFT),
128: targets = DECODE( p_TARGETS, FND_API.g_miss_num, TARGETS, p_TARGETS),
129: non_targets = DECODE( p_NON_TARGETS, FND_API.g_miss_num, NON_TARGETS, p_NON_TARGETS),
130: targets_cumm = DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, TARGETS_CUMM, p_TARGETS_CUMM),

Line 127: lift = DECODE( p_LIFT, FND_API.g_miss_num, LIFT, p_LIFT),

123: last_update_login = DECODE( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
124: object_version_number = DECODE( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
125: model_id = DECODE( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),
126: quantile = DECODE( p_QUANTILE, FND_API.g_miss_num, QUANTILE, p_QUANTILE),
127: lift = DECODE( p_LIFT, FND_API.g_miss_num, LIFT, p_LIFT),
128: targets = DECODE( p_TARGETS, FND_API.g_miss_num, TARGETS, p_TARGETS),
129: non_targets = DECODE( p_NON_TARGETS, FND_API.g_miss_num, NON_TARGETS, p_NON_TARGETS),
130: targets_cumm = DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, TARGETS_CUMM, p_TARGETS_CUMM),
131: target_density_cumm = DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, TARGET_DENSITY_CUMM, p_TARGET_DENSITY_CUMM),

Line 128: targets = DECODE( p_TARGETS, FND_API.g_miss_num, TARGETS, p_TARGETS),

124: object_version_number = DECODE( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
125: model_id = DECODE( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),
126: quantile = DECODE( p_QUANTILE, FND_API.g_miss_num, QUANTILE, p_QUANTILE),
127: lift = DECODE( p_LIFT, FND_API.g_miss_num, LIFT, p_LIFT),
128: targets = DECODE( p_TARGETS, FND_API.g_miss_num, TARGETS, p_TARGETS),
129: non_targets = DECODE( p_NON_TARGETS, FND_API.g_miss_num, NON_TARGETS, p_NON_TARGETS),
130: targets_cumm = DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, TARGETS_CUMM, p_TARGETS_CUMM),
131: target_density_cumm = DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, TARGET_DENSITY_CUMM, p_TARGET_DENSITY_CUMM),
132: target_density = DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, TARGET_DENSITY, p_TARGET_DENSITY),

Line 129: non_targets = DECODE( p_NON_TARGETS, FND_API.g_miss_num, NON_TARGETS, p_NON_TARGETS),

125: model_id = DECODE( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),
126: quantile = DECODE( p_QUANTILE, FND_API.g_miss_num, QUANTILE, p_QUANTILE),
127: lift = DECODE( p_LIFT, FND_API.g_miss_num, LIFT, p_LIFT),
128: targets = DECODE( p_TARGETS, FND_API.g_miss_num, TARGETS, p_TARGETS),
129: non_targets = DECODE( p_NON_TARGETS, FND_API.g_miss_num, NON_TARGETS, p_NON_TARGETS),
130: targets_cumm = DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, TARGETS_CUMM, p_TARGETS_CUMM),
131: target_density_cumm = DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, TARGET_DENSITY_CUMM, p_TARGET_DENSITY_CUMM),
132: target_density = DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, TARGET_DENSITY, p_TARGET_DENSITY),
133: margin = DECODE( p_MARGIN, FND_API.g_miss_num, MARGIN, p_MARGIN),

Line 130: targets_cumm = DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, TARGETS_CUMM, p_TARGETS_CUMM),

126: quantile = DECODE( p_QUANTILE, FND_API.g_miss_num, QUANTILE, p_QUANTILE),
127: lift = DECODE( p_LIFT, FND_API.g_miss_num, LIFT, p_LIFT),
128: targets = DECODE( p_TARGETS, FND_API.g_miss_num, TARGETS, p_TARGETS),
129: non_targets = DECODE( p_NON_TARGETS, FND_API.g_miss_num, NON_TARGETS, p_NON_TARGETS),
130: targets_cumm = DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, TARGETS_CUMM, p_TARGETS_CUMM),
131: target_density_cumm = DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, TARGET_DENSITY_CUMM, p_TARGET_DENSITY_CUMM),
132: target_density = DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, TARGET_DENSITY, p_TARGET_DENSITY),
133: margin = DECODE( p_MARGIN, FND_API.g_miss_num, MARGIN, p_MARGIN),
134: roi = DECODE( p_ROI, FND_API.g_miss_num, ROI, p_ROI),

Line 131: target_density_cumm = DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, TARGET_DENSITY_CUMM, p_TARGET_DENSITY_CUMM),

127: lift = DECODE( p_LIFT, FND_API.g_miss_num, LIFT, p_LIFT),
128: targets = DECODE( p_TARGETS, FND_API.g_miss_num, TARGETS, p_TARGETS),
129: non_targets = DECODE( p_NON_TARGETS, FND_API.g_miss_num, NON_TARGETS, p_NON_TARGETS),
130: targets_cumm = DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, TARGETS_CUMM, p_TARGETS_CUMM),
131: target_density_cumm = DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, TARGET_DENSITY_CUMM, p_TARGET_DENSITY_CUMM),
132: target_density = DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, TARGET_DENSITY, p_TARGET_DENSITY),
133: margin = DECODE( p_MARGIN, FND_API.g_miss_num, MARGIN, p_MARGIN),
134: roi = DECODE( p_ROI, FND_API.g_miss_num, ROI, p_ROI),
135: target_confidence = DECODE( p_TARGET_CONFIDENCE, FND_API.g_miss_num, TARGET_CONFIDENCE, p_TARGET_CONFIDENCE),

Line 132: target_density = DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, TARGET_DENSITY, p_TARGET_DENSITY),

128: targets = DECODE( p_TARGETS, FND_API.g_miss_num, TARGETS, p_TARGETS),
129: non_targets = DECODE( p_NON_TARGETS, FND_API.g_miss_num, NON_TARGETS, p_NON_TARGETS),
130: targets_cumm = DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, TARGETS_CUMM, p_TARGETS_CUMM),
131: target_density_cumm = DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, TARGET_DENSITY_CUMM, p_TARGET_DENSITY_CUMM),
132: target_density = DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, TARGET_DENSITY, p_TARGET_DENSITY),
133: margin = DECODE( p_MARGIN, FND_API.g_miss_num, MARGIN, p_MARGIN),
134: roi = DECODE( p_ROI, FND_API.g_miss_num, ROI, p_ROI),
135: target_confidence = DECODE( p_TARGET_CONFIDENCE, FND_API.g_miss_num, TARGET_CONFIDENCE, p_TARGET_CONFIDENCE),
136: non_target_confidence = DECODE( p_NON_TARGET_CONFIDENCE, FND_API.g_miss_num, NON_TARGET_CONFIDENCE, p_NON_TARGET_CONFIDENCE)

Line 133: margin = DECODE( p_MARGIN, FND_API.g_miss_num, MARGIN, p_MARGIN),

129: non_targets = DECODE( p_NON_TARGETS, FND_API.g_miss_num, NON_TARGETS, p_NON_TARGETS),
130: targets_cumm = DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, TARGETS_CUMM, p_TARGETS_CUMM),
131: target_density_cumm = DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, TARGET_DENSITY_CUMM, p_TARGET_DENSITY_CUMM),
132: target_density = DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, TARGET_DENSITY, p_TARGET_DENSITY),
133: margin = DECODE( p_MARGIN, FND_API.g_miss_num, MARGIN, p_MARGIN),
134: roi = DECODE( p_ROI, FND_API.g_miss_num, ROI, p_ROI),
135: target_confidence = DECODE( p_TARGET_CONFIDENCE, FND_API.g_miss_num, TARGET_CONFIDENCE, p_TARGET_CONFIDENCE),
136: non_target_confidence = DECODE( p_NON_TARGET_CONFIDENCE, FND_API.g_miss_num, NON_TARGET_CONFIDENCE, p_NON_TARGET_CONFIDENCE)
137: WHERE LIFT_ID = p_LIFT_ID;

Line 134: roi = DECODE( p_ROI, FND_API.g_miss_num, ROI, p_ROI),

130: targets_cumm = DECODE( p_TARGETS_CUMM, FND_API.g_miss_num, TARGETS_CUMM, p_TARGETS_CUMM),
131: target_density_cumm = DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, TARGET_DENSITY_CUMM, p_TARGET_DENSITY_CUMM),
132: target_density = DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, TARGET_DENSITY, p_TARGET_DENSITY),
133: margin = DECODE( p_MARGIN, FND_API.g_miss_num, MARGIN, p_MARGIN),
134: roi = DECODE( p_ROI, FND_API.g_miss_num, ROI, p_ROI),
135: target_confidence = DECODE( p_TARGET_CONFIDENCE, FND_API.g_miss_num, TARGET_CONFIDENCE, p_TARGET_CONFIDENCE),
136: non_target_confidence = DECODE( p_NON_TARGET_CONFIDENCE, FND_API.g_miss_num, NON_TARGET_CONFIDENCE, p_NON_TARGET_CONFIDENCE)
137: WHERE LIFT_ID = p_LIFT_ID;
138:

Line 135: target_confidence = DECODE( p_TARGET_CONFIDENCE, FND_API.g_miss_num, TARGET_CONFIDENCE, p_TARGET_CONFIDENCE),

131: target_density_cumm = DECODE( p_TARGET_DENSITY_CUMM, FND_API.g_miss_num, TARGET_DENSITY_CUMM, p_TARGET_DENSITY_CUMM),
132: target_density = DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, TARGET_DENSITY, p_TARGET_DENSITY),
133: margin = DECODE( p_MARGIN, FND_API.g_miss_num, MARGIN, p_MARGIN),
134: roi = DECODE( p_ROI, FND_API.g_miss_num, ROI, p_ROI),
135: target_confidence = DECODE( p_TARGET_CONFIDENCE, FND_API.g_miss_num, TARGET_CONFIDENCE, p_TARGET_CONFIDENCE),
136: non_target_confidence = DECODE( p_NON_TARGET_CONFIDENCE, FND_API.g_miss_num, NON_TARGET_CONFIDENCE, p_NON_TARGET_CONFIDENCE)
137: WHERE LIFT_ID = p_LIFT_ID;
138:
139: IF (SQL%NOTFOUND) THEN

Line 136: non_target_confidence = DECODE( p_NON_TARGET_CONFIDENCE, FND_API.g_miss_num, NON_TARGET_CONFIDENCE, p_NON_TARGET_CONFIDENCE)

132: target_density = DECODE( p_TARGET_DENSITY, FND_API.g_miss_num, TARGET_DENSITY, p_TARGET_DENSITY),
133: margin = DECODE( p_MARGIN, FND_API.g_miss_num, MARGIN, p_MARGIN),
134: roi = DECODE( p_ROI, FND_API.g_miss_num, ROI, p_ROI),
135: target_confidence = DECODE( p_TARGET_CONFIDENCE, FND_API.g_miss_num, TARGET_CONFIDENCE, p_TARGET_CONFIDENCE),
136: non_target_confidence = DECODE( p_NON_TARGET_CONFIDENCE, FND_API.g_miss_num, NON_TARGET_CONFIDENCE, p_NON_TARGET_CONFIDENCE)
137: WHERE LIFT_ID = p_LIFT_ID;
138:
139: IF (SQL%NOTFOUND) THEN
140: RAISE NO_DATA_FOUND;