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.AS_SALES_LEAD_SCORECARDS_PKG dependencies on FND_API

Line 39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)

35: , start_date_active
36: , end_date_active
37: ) VALUES (
38: x_scorecard_id
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
40: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
41: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
42: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
43: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

Line 40: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

36: , end_date_active
37: ) VALUES (
38: x_scorecard_id
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
40: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
41: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
42: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
43: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)

Line 41: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)

37: ) VALUES (
38: x_scorecard_id
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
40: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
41: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
42: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
43: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
45: , DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)

Line 42: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)

38: x_scorecard_id
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
40: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
41: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
42: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
43: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
45: , DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)
46: , DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)

Line 43: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
40: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
41: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
42: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
43: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
45: , DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)
46: , DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
47: , DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)

Line 44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)

40: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
41: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
42: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
43: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
45: , DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)
46: , DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
47: , DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
48: );

Line 45: , DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)

41: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
42: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
43: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
45: , DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)
46: , DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
47: , DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
48: );
49:

Line 46: , DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)

42: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
43: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
45: , DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)
46: , DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
47: , DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
48: );
49:
50: OPEN l_insert;

Line 47: , DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)

43: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
45: , DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)
46: , DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
47: , DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
48: );
49:
50: OPEN l_insert;
51: FETCH l_insert INTO x_rowid;

Line 85: scorecard_id = DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)

81: ) IS
82: BEGIN
83: UPDATE as_sales_lead_scorecards
84: SET
85: scorecard_id = DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)
86: , last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
87: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
88: , creation_date = DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
89: , created_by = DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)

Line 86: , last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)

82: BEGIN
83: UPDATE as_sales_lead_scorecards
84: SET
85: scorecard_id = DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)
86: , last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
87: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
88: , creation_date = DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
89: , created_by = DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
90: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

Line 87: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

83: UPDATE as_sales_lead_scorecards
84: SET
85: scorecard_id = DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)
86: , last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
87: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
88: , creation_date = DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
89: , created_by = DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
90: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
91: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)

Line 88: , creation_date = DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)

84: SET
85: scorecard_id = DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)
86: , last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
87: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
88: , creation_date = DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
89: , created_by = DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
90: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
91: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
92: , enabled_flag = DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)

Line 89: , created_by = DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)

85: scorecard_id = DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)
86: , last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
87: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
88: , creation_date = DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
89: , created_by = DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
90: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
91: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
92: , enabled_flag = DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)
93: , start_date_active = DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)

Line 90: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

86: , last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
87: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
88: , creation_date = DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
89: , created_by = DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
90: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
91: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
92: , enabled_flag = DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)
93: , start_date_active = DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
94: , end_date_active = DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)

Line 91: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)

87: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
88: , creation_date = DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
89: , created_by = DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
90: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
91: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
92: , enabled_flag = DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)
93: , start_date_active = DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
94: , end_date_active = DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
95: WHERE ROWID = x_rowid;

Line 92: , enabled_flag = DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)

88: , creation_date = DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
89: , created_by = DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
90: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
91: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
92: , enabled_flag = DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)
93: , start_date_active = DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
94: , end_date_active = DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
95: WHERE ROWID = x_rowid;
96: IF (SQL%NOTFOUND) THEN

Line 93: , start_date_active = DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)

89: , created_by = DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
90: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
91: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
92: , enabled_flag = DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)
93: , start_date_active = DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
94: , end_date_active = DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
95: WHERE ROWID = x_rowid;
96: IF (SQL%NOTFOUND) THEN
97: RAISE NO_DATA_FOUND;

Line 94: , end_date_active = DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)

90: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
91: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
92: , enabled_flag = DECODE(x_enabled_flag,FND_API.G_MISS_CHAR,NULL,x_enabled_flag)
93: , start_date_active = DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
94: , end_date_active = DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
95: WHERE ROWID = x_rowid;
96: IF (SQL%NOTFOUND) THEN
97: RAISE NO_DATA_FOUND;
98: END IF;

Line 113: scorecard_id = DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)

109: ) IS
110: BEGIN
111: UPDATE as_sales_lead_scorecards
112: SET
113: scorecard_id = DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)
114: , last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
115: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
116: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
117: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)

Line 114: , last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)

110: BEGIN
111: UPDATE as_sales_lead_scorecards
112: SET
113: scorecard_id = DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)
114: , last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
115: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
116: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
117: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
118: , start_date_active = DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)

Line 115: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

111: UPDATE as_sales_lead_scorecards
112: SET
113: scorecard_id = DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)
114: , last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
115: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
116: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
117: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
118: , start_date_active = DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
119: , end_date_active = DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)

Line 116: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

112: SET
113: scorecard_id = DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)
114: , last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
115: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
116: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
117: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
118: , start_date_active = DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
119: , end_date_active = DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
120: WHERE scorecard_id = x_scorecard_id;

Line 117: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)

113: scorecard_id = DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)
114: , last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
115: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
116: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
117: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
118: , start_date_active = DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
119: , end_date_active = DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
120: WHERE scorecard_id = x_scorecard_id;
121: IF (SQL%NOTFOUND) THEN

Line 118: , start_date_active = DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)

114: , last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
115: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
116: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
117: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
118: , start_date_active = DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
119: , end_date_active = DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
120: WHERE scorecard_id = x_scorecard_id;
121: IF (SQL%NOTFOUND) THEN
122: RAISE NO_DATA_FOUND;

Line 119: , end_date_active = DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)

115: , last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
116: , last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
117: , description = DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
118: , start_date_active = DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
119: , end_date_active = DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
120: WHERE scorecard_id = x_scorecard_id;
121: IF (SQL%NOTFOUND) THEN
122: RAISE NO_DATA_FOUND;
123: END IF;