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

Line 52: decode( p_new_lead_id, FND_API.G_MISS_NUM, NULL, p_new_lead_id),

48: opp_forecast_amount,
49: opp_best_forecast_amount,
50: endday_log_flag) VALUES (
51: AS_SALES_CREDIT_LOG_S.nextval,
52: decode( p_new_lead_id, FND_API.G_MISS_NUM, NULL, p_new_lead_id),
53: decode( p_new_lead_line_id,FND_API.G_MISS_NUM, NULL, p_new_lead_line_id),
54: decode( p_new_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_new_sales_credit_id),
55: decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
56: decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),

Line 53: decode( p_new_lead_line_id,FND_API.G_MISS_NUM, NULL, p_new_lead_line_id),

49: opp_best_forecast_amount,
50: endday_log_flag) VALUES (
51: AS_SALES_CREDIT_LOG_S.nextval,
52: decode( p_new_lead_id, FND_API.G_MISS_NUM, NULL, p_new_lead_id),
53: decode( p_new_lead_line_id,FND_API.G_MISS_NUM, NULL, p_new_lead_line_id),
54: decode( p_new_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_new_sales_credit_id),
55: decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
56: decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
57: decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),

Line 54: decode( p_new_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_new_sales_credit_id),

50: endday_log_flag) VALUES (
51: AS_SALES_CREDIT_LOG_S.nextval,
52: decode( p_new_lead_id, FND_API.G_MISS_NUM, NULL, p_new_lead_id),
53: decode( p_new_lead_line_id,FND_API.G_MISS_NUM, NULL, p_new_lead_line_id),
54: decode( p_new_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_new_sales_credit_id),
55: decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
56: decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
57: decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
58: decode( p_new_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_creation_date),

Line 55: decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),

51: AS_SALES_CREDIT_LOG_S.nextval,
52: decode( p_new_lead_id, FND_API.G_MISS_NUM, NULL, p_new_lead_id),
53: decode( p_new_lead_line_id,FND_API.G_MISS_NUM, NULL, p_new_lead_line_id),
54: decode( p_new_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_new_sales_credit_id),
55: decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
56: decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
57: decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
58: decode( p_new_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_creation_date),
59: decode( p_new_created_by,FND_API.G_MISS_NUM, NULL, p_new_created_by),

Line 56: decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),

52: decode( p_new_lead_id, FND_API.G_MISS_NUM, NULL, p_new_lead_id),
53: decode( p_new_lead_line_id,FND_API.G_MISS_NUM, NULL, p_new_lead_line_id),
54: decode( p_new_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_new_sales_credit_id),
55: decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
56: decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
57: decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
58: decode( p_new_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_creation_date),
59: decode( p_new_created_by,FND_API.G_MISS_NUM, NULL, p_new_created_by),
60: p_TRIGGER_MODE,

Line 57: decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),

53: decode( p_new_lead_line_id,FND_API.G_MISS_NUM, NULL, p_new_lead_line_id),
54: decode( p_new_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_new_sales_credit_id),
55: decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
56: decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
57: decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
58: decode( p_new_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_creation_date),
59: decode( p_new_created_by,FND_API.G_MISS_NUM, NULL, p_new_created_by),
60: p_TRIGGER_MODE,
61: decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),

Line 58: decode( p_new_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_creation_date),

54: decode( p_new_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_new_sales_credit_id),
55: decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
56: decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
57: decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
58: decode( p_new_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_creation_date),
59: decode( p_new_created_by,FND_API.G_MISS_NUM, NULL, p_new_created_by),
60: p_TRIGGER_MODE,
61: decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
62: decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),

Line 59: decode( p_new_created_by,FND_API.G_MISS_NUM, NULL, p_new_created_by),

55: decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
56: decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
57: decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
58: decode( p_new_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_creation_date),
59: decode( p_new_created_by,FND_API.G_MISS_NUM, NULL, p_new_created_by),
60: p_TRIGGER_MODE,
61: decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
62: decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
63: decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),

Line 61: decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),

57: decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
58: decode( p_new_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_creation_date),
59: decode( p_new_created_by,FND_API.G_MISS_NUM, NULL, p_new_created_by),
60: p_TRIGGER_MODE,
61: decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
62: decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
63: decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
64: decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
65: decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),

Line 62: decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),

58: decode( p_new_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_creation_date),
59: decode( p_new_created_by,FND_API.G_MISS_NUM, NULL, p_new_created_by),
60: p_TRIGGER_MODE,
61: decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
62: decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
63: decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
64: decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
65: decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
66: decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),

Line 63: decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),

59: decode( p_new_created_by,FND_API.G_MISS_NUM, NULL, p_new_created_by),
60: p_TRIGGER_MODE,
61: decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
62: decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
63: decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
64: decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
65: decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
66: decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
67: decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),

Line 64: decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),

60: p_TRIGGER_MODE,
61: decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
62: decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
63: decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
64: decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
65: decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
66: decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
67: decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),
68: decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),

Line 65: decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),

61: decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
62: decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
63: decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
64: decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
65: decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
66: decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
67: decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),
68: decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),
69: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));

Line 66: decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),

62: decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
63: decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
64: decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
65: decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
66: decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
67: decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),
68: decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),
69: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
70: EXCEPTION

Line 67: decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),

63: decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
64: decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
65: decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
66: decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
67: decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),
68: decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),
69: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
70: EXCEPTION
71: WHEN OTHERS THEN

Line 68: decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),

64: decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
65: decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
66: decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
67: decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),
68: decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),
69: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
70: EXCEPTION
71: WHEN OTHERS THEN
72: -- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG After Insert Statement Seems some error');

Line 69: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));

65: decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
66: decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
67: decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),
68: decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),
69: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
70: EXCEPTION
71: WHEN OTHERS THEN
72: -- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG After Insert Statement Seems some error');
73: -- dbms_output.put_line('Error Number:'||SQLCODE);

Line 113: SET object_version_number = nvl(object_version_number,0) + 1, lead_id = decode( p_new_lead_id, FND_API.G_MISS_NUM, NULL, p_new_lead_id),

109: 'asxtsclb: In AS_SALES_CREDITS_LOG_PKG before Update_Row');
110: END IF;
111:
112: Update AS_SALES_CREDITS_LOG
113: SET object_version_number = nvl(object_version_number,0) + 1, lead_id = decode( p_new_lead_id, FND_API.G_MISS_NUM, NULL, p_new_lead_id),
114: lead_line_id = decode( p_new_lead_line_id,FND_API.G_MISS_NUM, NULL, p_new_lead_line_id),
115: last_update_date = decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
116: last_updated_by = decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
117: last_update_login = decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),

Line 114: lead_line_id = decode( p_new_lead_line_id,FND_API.G_MISS_NUM, NULL, p_new_lead_line_id),

110: END IF;
111:
112: Update AS_SALES_CREDITS_LOG
113: SET object_version_number = nvl(object_version_number,0) + 1, lead_id = decode( p_new_lead_id, FND_API.G_MISS_NUM, NULL, p_new_lead_id),
114: lead_line_id = decode( p_new_lead_line_id,FND_API.G_MISS_NUM, NULL, p_new_lead_line_id),
115: last_update_date = decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
116: last_updated_by = decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
117: last_update_login = decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
118: LOG_MODE = p_TRIGGER_MODE,

Line 115: last_update_date = decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),

111:
112: Update AS_SALES_CREDITS_LOG
113: SET object_version_number = nvl(object_version_number,0) + 1, lead_id = decode( p_new_lead_id, FND_API.G_MISS_NUM, NULL, p_new_lead_id),
114: lead_line_id = decode( p_new_lead_line_id,FND_API.G_MISS_NUM, NULL, p_new_lead_line_id),
115: last_update_date = decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
116: last_updated_by = decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
117: last_update_login = decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
118: LOG_MODE = p_TRIGGER_MODE,
119: salesforce_id = decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),

Line 116: last_updated_by = decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),

112: Update AS_SALES_CREDITS_LOG
113: SET object_version_number = nvl(object_version_number,0) + 1, lead_id = decode( p_new_lead_id, FND_API.G_MISS_NUM, NULL, p_new_lead_id),
114: lead_line_id = decode( p_new_lead_line_id,FND_API.G_MISS_NUM, NULL, p_new_lead_line_id),
115: last_update_date = decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
116: last_updated_by = decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
117: last_update_login = decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
118: LOG_MODE = p_TRIGGER_MODE,
119: salesforce_id = decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
120: salesgroup_id = decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),

Line 117: last_update_login = decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),

113: SET object_version_number = nvl(object_version_number,0) + 1, lead_id = decode( p_new_lead_id, FND_API.G_MISS_NUM, NULL, p_new_lead_id),
114: lead_line_id = decode( p_new_lead_line_id,FND_API.G_MISS_NUM, NULL, p_new_lead_line_id),
115: last_update_date = decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
116: last_updated_by = decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
117: last_update_login = decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
118: LOG_MODE = p_TRIGGER_MODE,
119: salesforce_id = decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
120: salesgroup_id = decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
121: credit_type_id = decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),

Line 119: salesforce_id = decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),

115: last_update_date = decode( p_new_last_update_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_new_last_update_date),
116: last_updated_by = decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
117: last_update_login = decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
118: LOG_MODE = p_TRIGGER_MODE,
119: salesforce_id = decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
120: salesgroup_id = decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
121: credit_type_id = decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
122: credit_percent = decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
123: credit_amount = decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),

Line 120: salesgroup_id = decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),

116: last_updated_by = decode( p_new_last_updated_by,FND_API.G_MISS_NUM, NULL, p_new_last_updated_by),
117: last_update_login = decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
118: LOG_MODE = p_TRIGGER_MODE,
119: salesforce_id = decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
120: salesgroup_id = decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
121: credit_type_id = decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
122: credit_percent = decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
123: credit_amount = decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
124: opp_worst_forecast_amount = decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),

Line 121: credit_type_id = decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),

117: last_update_login = decode( p_new_last_update_login,FND_API.G_MISS_NUM, NULL, p_new_last_update_login),
118: LOG_MODE = p_TRIGGER_MODE,
119: salesforce_id = decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
120: salesgroup_id = decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
121: credit_type_id = decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
122: credit_percent = decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
123: credit_amount = decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
124: opp_worst_forecast_amount = decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
125: opp_forecast_amount = decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),

Line 122: credit_percent = decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),

118: LOG_MODE = p_TRIGGER_MODE,
119: salesforce_id = decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
120: salesgroup_id = decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
121: credit_type_id = decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
122: credit_percent = decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
123: credit_amount = decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
124: opp_worst_forecast_amount = decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
125: opp_forecast_amount = decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),
126: opp_best_forecast_amount = decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),

Line 123: credit_amount = decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),

119: salesforce_id = decode( p_new_salesforce_id,FND_API.G_MISS_NUM, NULL, p_new_salesforce_id),
120: salesgroup_id = decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
121: credit_type_id = decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
122: credit_percent = decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
123: credit_amount = decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
124: opp_worst_forecast_amount = decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
125: opp_forecast_amount = decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),
126: opp_best_forecast_amount = decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),
127: endday_log_flag = decode( p_endday_log_flag,FND_API.G_MISS_CHAR, endday_log_flag, p_endday_log_flag)

Line 124: opp_worst_forecast_amount = decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),

120: salesgroup_id = decode( p_new_salesgroup_id,FND_API.G_MISS_NUM, NULL, p_new_salesgroup_id),
121: credit_type_id = decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
122: credit_percent = decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
123: credit_amount = decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
124: opp_worst_forecast_amount = decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
125: opp_forecast_amount = decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),
126: opp_best_forecast_amount = decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),
127: endday_log_flag = decode( p_endday_log_flag,FND_API.G_MISS_CHAR, endday_log_flag, p_endday_log_flag)
128: WHERE log_id = (select max(log_id)

Line 125: opp_forecast_amount = decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),

121: credit_type_id = decode( p_new_credit_type_id,FND_API.G_MISS_NUM, NULL, p_new_credit_type_id),
122: credit_percent = decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
123: credit_amount = decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
124: opp_worst_forecast_amount = decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
125: opp_forecast_amount = decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),
126: opp_best_forecast_amount = decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),
127: endday_log_flag = decode( p_endday_log_flag,FND_API.G_MISS_CHAR, endday_log_flag, p_endday_log_flag)
128: WHERE log_id = (select max(log_id)
129: from AS_SALES_CREDITS_LOG

Line 126: opp_best_forecast_amount = decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),

122: credit_percent = decode( p_new_credit_percent,FND_API.G_MISS_NUM, NULL, p_new_credit_percent),
123: credit_amount = decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
124: opp_worst_forecast_amount = decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
125: opp_forecast_amount = decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),
126: opp_best_forecast_amount = decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),
127: endday_log_flag = decode( p_endday_log_flag,FND_API.G_MISS_CHAR, endday_log_flag, p_endday_log_flag)
128: WHERE log_id = (select max(log_id)
129: from AS_SALES_CREDITS_LOG
130: where SALES_CREDIT_ID = p_old_sales_credit_id);

Line 127: endday_log_flag = decode( p_endday_log_flag,FND_API.G_MISS_CHAR, endday_log_flag, p_endday_log_flag)

123: credit_amount = decode( p_new_credit_amount,FND_API.G_MISS_NUM, NULL, p_new_credit_amount),
124: opp_worst_forecast_amount = decode( p_new_opp_worst_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_worst_frcst_amount),
125: opp_forecast_amount = decode( p_new_opp_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_frcst_amount),
126: opp_best_forecast_amount = decode( p_new_opp_best_frcst_amount,FND_API.G_MISS_NUM, NULL, p_new_opp_best_frcst_amount),
127: endday_log_flag = decode( p_endday_log_flag,FND_API.G_MISS_CHAR, endday_log_flag, p_endday_log_flag)
128: WHERE log_id = (select max(log_id)
129: from AS_SALES_CREDITS_LOG
130: where SALES_CREDIT_ID = p_old_sales_credit_id);
131:

Line 178: decode( p_old_lead_id, FND_API.G_MISS_NUM, NULL, p_old_lead_id),

174: created_by,
175: log_mode,
176: endday_log_flag) VALUES (
177: AS_SALES_CREDIT_LOG_S.nextval,
178: decode( p_old_lead_id, FND_API.G_MISS_NUM, NULL, p_old_lead_id),
179: decode( p_old_lead_line_id,FND_API.G_MISS_NUM, NULL, p_old_lead_line_id),
180: decode( p_old_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_old_sales_credit_id),
181: sysdate,
182: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),

Line 179: decode( p_old_lead_line_id,FND_API.G_MISS_NUM, NULL, p_old_lead_line_id),

175: log_mode,
176: endday_log_flag) VALUES (
177: AS_SALES_CREDIT_LOG_S.nextval,
178: decode( p_old_lead_id, FND_API.G_MISS_NUM, NULL, p_old_lead_id),
179: decode( p_old_lead_line_id,FND_API.G_MISS_NUM, NULL, p_old_lead_line_id),
180: decode( p_old_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_old_sales_credit_id),
181: sysdate,
182: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),
183: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),

Line 180: decode( p_old_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_old_sales_credit_id),

176: endday_log_flag) VALUES (
177: AS_SALES_CREDIT_LOG_S.nextval,
178: decode( p_old_lead_id, FND_API.G_MISS_NUM, NULL, p_old_lead_id),
179: decode( p_old_lead_line_id,FND_API.G_MISS_NUM, NULL, p_old_lead_line_id),
180: decode( p_old_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_old_sales_credit_id),
181: sysdate,
182: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),
183: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),
184: decode( p_old_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_old_creation_date),

Line 182: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),

178: decode( p_old_lead_id, FND_API.G_MISS_NUM, NULL, p_old_lead_id),
179: decode( p_old_lead_line_id,FND_API.G_MISS_NUM, NULL, p_old_lead_line_id),
180: decode( p_old_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_old_sales_credit_id),
181: sysdate,
182: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),
183: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),
184: decode( p_old_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_old_creation_date),
185: decode( p_old_created_by,FND_API.G_MISS_NUM, NULL, p_old_created_by),
186: 'D',

Line 183: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),

179: decode( p_old_lead_line_id,FND_API.G_MISS_NUM, NULL, p_old_lead_line_id),
180: decode( p_old_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_old_sales_credit_id),
181: sysdate,
182: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),
183: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),
184: decode( p_old_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_old_creation_date),
185: decode( p_old_created_by,FND_API.G_MISS_NUM, NULL, p_old_created_by),
186: 'D',
187: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));

Line 184: decode( p_old_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_old_creation_date),

180: decode( p_old_sales_credit_id,FND_API.G_MISS_NUM, NULL, p_old_sales_credit_id),
181: sysdate,
182: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),
183: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),
184: decode( p_old_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_old_creation_date),
185: decode( p_old_created_by,FND_API.G_MISS_NUM, NULL, p_old_created_by),
186: 'D',
187: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
188:

Line 185: decode( p_old_created_by,FND_API.G_MISS_NUM, NULL, p_old_created_by),

181: sysdate,
182: decode( p_old_last_updated_by,FND_API.G_MISS_NUM, NULL, p_old_last_updated_by),
183: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),
184: decode( p_old_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_old_creation_date),
185: decode( p_old_created_by,FND_API.G_MISS_NUM, NULL, p_old_created_by),
186: 'D',
187: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
188:
189: EXCEPTION

Line 187: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));

183: decode( p_old_last_update_login,FND_API.G_MISS_NUM, NULL, p_old_last_update_login),
184: decode( p_old_creation_date,FND_API.G_MISS_DATE, TO_DATE(NULL), p_old_creation_date),
185: decode( p_old_created_by,FND_API.G_MISS_NUM, NULL, p_old_created_by),
186: 'D',
187: decode( p_endday_log_flag,FND_API.G_MISS_CHAR, NULL, p_endday_log_flag));
188:
189: EXCEPTION
190: WHEN OTHERS THEN
191: -- dbms_output.put_line('In AS_SALES_CREDITS_LOG_PKG After Delete Statement Seems some error');