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

Line 36: , DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)

32: , end_date_active
33: , score
34: ) VALUES (
35: x_card_rule_id
36: , DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)
37: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
40: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)

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

33: , score
34: ) VALUES (
35: x_card_rule_id
36: , DECODE(x_scorecard_id,FND_API.G_MISS_NUM,NULL,x_scorecard_id)
37: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_last_update_date)
38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),x_creation_date)
40: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
41: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 45: , DECODE(x_score,FND_API.G_MISS_NUM,NULL,x_score)

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

Line 84: card_rule_id=DECODE(x_card_rule_id,FND_API.G_MISS_NUM,NULL,x_card_rule_id)

80: ) IS
81: BEGIN
82: UPDATE as_sales_lead_card_rules
83: SET
84: card_rule_id=DECODE(x_card_rule_id,FND_API.G_MISS_NUM,NULL,x_card_rule_id)
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)

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

81: BEGIN
82: UPDATE as_sales_lead_card_rules
83: SET
84: card_rule_id=DECODE(x_card_rule_id,FND_API.G_MISS_NUM,NULL,x_card_rule_id)
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: UPDATE as_sales_lead_card_rules
83: SET
84: card_rule_id=DECODE(x_card_rule_id,FND_API.G_MISS_NUM,NULL,x_card_rule_id)
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: SET
84: card_rule_id=DECODE(x_card_rule_id,FND_API.G_MISS_NUM,NULL,x_card_rule_id)
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: card_rule_id=DECODE(x_card_rule_id,FND_API.G_MISS_NUM,NULL,x_card_rule_id)
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: , start_date_active=DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)

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: , start_date_active=DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
93: , end_date_active=DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_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: , start_date_active=DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
93: , end_date_active=DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
94: , score=DECODE(x_score,FND_API.G_MISS_NUM,NULL,x_score)

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: , start_date_active=DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
93: , end_date_active=DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
94: , score=DECODE(x_score,FND_API.G_MISS_NUM,NULL,x_score)
95: WHERE ROWID = x_rowid;

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

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: , start_date_active=DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
93: , end_date_active=DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
94: , score=DECODE(x_score,FND_API.G_MISS_NUM,NULL,x_score)
95: WHERE ROWID = x_rowid;
96: IF (SQL%NOTFOUND) THEN

Line 93: , end_date_active=DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_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: , start_date_active=DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
93: , end_date_active=DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
94: , score=DECODE(x_score,FND_API.G_MISS_NUM,NULL,x_score)
95: WHERE ROWID = x_rowid;
96: IF (SQL%NOTFOUND) THEN
97: RAISE NO_DATA_FOUND;

Line 94: , score=DECODE(x_score,FND_API.G_MISS_NUM,NULL,x_score)

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: , start_date_active=DECODE(x_start_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_start_date_active)
93: , end_date_active=DECODE(x_end_date_active,FND_API.G_MISS_DATE,TO_DATE(NULL),x_end_date_active)
94: , score=DECODE(x_score,FND_API.G_MISS_NUM,NULL,x_score)
95: WHERE ROWID = x_rowid;
96: IF (SQL%NOTFOUND) THEN
97: RAISE NO_DATA_FOUND;
98: END IF;