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

Line 58: If (px_dunning_id IS NULL) OR (px_dunning_id = FND_API.G_MISS_NUM) then

54: SELECT IEX_dunnings_s.nextval
55: FROM sys.dual;
56: BEGIN
57: --
58: If (px_dunning_id IS NULL) OR (px_dunning_id = FND_API.G_MISS_NUM) then
59: OPEN get_seq_csr;
60: FETCH get_seq_csr INTO px_dunning_id;
61: CLOSE get_seq_csr;
62: End If;

Line 107: , DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)

103: , addt_delivery_status
104: , as_of_date
105: ) VALUES (
106: px_dunning_id
107: , DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
108: , DECODE(p_callback_YN, FND_API.G_MISS_CHAR, NULL, p_callback_YN)
109: , DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
110: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
111: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)

Line 108: , DECODE(p_callback_YN, FND_API.G_MISS_CHAR, NULL, p_callback_YN)

104: , as_of_date
105: ) VALUES (
106: px_dunning_id
107: , DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
108: , DECODE(p_callback_YN, FND_API.G_MISS_CHAR, NULL, p_callback_YN)
109: , DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
110: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
111: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
112: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)

Line 109: , DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)

105: ) VALUES (
106: px_dunning_id
107: , DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
108: , DECODE(p_callback_YN, FND_API.G_MISS_CHAR, NULL, p_callback_YN)
109: , DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
110: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
111: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
112: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
113: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)

Line 110: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)

106: px_dunning_id
107: , DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
108: , DECODE(p_callback_YN, FND_API.G_MISS_CHAR, NULL, p_callback_YN)
109: , DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
110: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
111: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
112: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
113: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
114: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)

Line 111: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)

107: , DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
108: , DECODE(p_callback_YN, FND_API.G_MISS_CHAR, NULL, p_callback_YN)
109: , DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
110: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
111: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
112: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
113: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
114: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
115: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)

Line 112: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)

108: , DECODE(p_callback_YN, FND_API.G_MISS_CHAR, NULL, p_callback_YN)
109: , DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
110: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
111: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
112: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
113: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
114: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
115: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
116: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)

Line 113: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)

109: , DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
110: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
111: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
112: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
113: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
114: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
115: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
116: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
117: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)

Line 114: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)

110: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
111: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
112: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
113: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
114: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
115: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
116: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
117: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
118: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)

Line 115: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)

111: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
112: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
113: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
114: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
115: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
116: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
117: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
118: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
119: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)

Line 116: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)

112: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
113: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
114: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
115: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
116: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
117: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
118: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
119: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
120: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)

Line 117: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)

113: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
114: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
115: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
116: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
117: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
118: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
119: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
120: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
121: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)

Line 118: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)

114: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
115: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
116: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
117: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
118: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
119: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
120: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
121: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
122: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)

Line 119: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)

115: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
116: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
117: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
118: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
119: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
120: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
121: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
122: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
123: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)

Line 120: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)

116: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
117: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
118: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
119: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
120: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
121: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
122: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
123: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
124: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)

Line 121: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)

117: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
118: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
119: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
120: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
121: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
122: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
123: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
124: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
125: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)

Line 122: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)

118: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
119: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
120: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
121: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
122: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
123: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
124: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
125: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
126: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)

Line 123: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)

119: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
120: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
121: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
122: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
123: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
124: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
125: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
126: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
127: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)

Line 124: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)

120: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
121: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
122: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
123: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
124: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
125: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
126: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
127: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
128: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)

Line 125: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)

121: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
122: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
123: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
124: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
125: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
126: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
127: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
128: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
129: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)

Line 126: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)

122: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
123: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
124: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
125: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
126: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
127: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
128: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
129: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
130: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)

Line 127: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)

123: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
124: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
125: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
126: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
127: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
128: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
129: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
130: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
131: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)

Line 128: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)

124: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
125: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
126: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
127: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
128: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
129: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
130: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
131: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
132: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)

Line 129: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)

125: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
126: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
127: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
128: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
129: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
130: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
131: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
132: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
133: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)

Line 130: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)

126: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
127: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
128: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
129: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
130: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
131: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
132: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
133: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
134: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)

Line 131: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)

127: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
128: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
129: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
130: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
131: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
132: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
133: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
134: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
135: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)

Line 132: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)

128: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
129: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
130: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
131: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
132: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
133: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
134: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
135: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
136: , DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)

Line 133: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)

129: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
130: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
131: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
132: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
133: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
134: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
135: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
136: , DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
137: , DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)

Line 134: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)

130: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
131: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
132: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
133: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
134: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
135: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
136: , DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
137: , DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
138: , DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)

Line 135: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)

131: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
132: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
133: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
134: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
135: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
136: , DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
137: , DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
138: , DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
139: , DECODE(p_org_id, FND_API.G_MISS_NUM, NULL, p_org_id) -- added for bug 9151851

Line 136: , DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)

132: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
133: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
134: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
135: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
136: , DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
137: , DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
138: , DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
139: , DECODE(p_org_id, FND_API.G_MISS_NUM, NULL, p_org_id) -- added for bug 9151851
140: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)

Line 137: , DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)

133: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
134: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
135: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
136: , DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
137: , DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
138: , DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
139: , DECODE(p_org_id, FND_API.G_MISS_NUM, NULL, p_org_id) -- added for bug 9151851
140: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
141: , DECODE(p_correspondence_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_correspondence_date)

Line 138: , DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)

134: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
135: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
136: , DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
137: , DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
138: , DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
139: , DECODE(p_org_id, FND_API.G_MISS_NUM, NULL, p_org_id) -- added for bug 9151851
140: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
141: , DECODE(p_correspondence_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_correspondence_date)
142: , DECODE(p_addt_xml_template_id, FND_API.G_MISS_NUM, NULL, p_addt_xml_template_id)

Line 139: , DECODE(p_org_id, FND_API.G_MISS_NUM, NULL, p_org_id) -- added for bug 9151851

135: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
136: , DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
137: , DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
138: , DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
139: , DECODE(p_org_id, FND_API.G_MISS_NUM, NULL, p_org_id) -- added for bug 9151851
140: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
141: , DECODE(p_correspondence_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_correspondence_date)
142: , DECODE(p_addt_xml_template_id, FND_API.G_MISS_NUM, NULL, p_addt_xml_template_id)
143: , DECODE(p_addt_delivery_status, FND_API.G_MISS_CHAR, NULL, p_addt_delivery_status)

Line 140: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)

136: , DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
137: , DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
138: , DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
139: , DECODE(p_org_id, FND_API.G_MISS_NUM, NULL, p_org_id) -- added for bug 9151851
140: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
141: , DECODE(p_correspondence_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_correspondence_date)
142: , DECODE(p_addt_xml_template_id, FND_API.G_MISS_NUM, NULL, p_addt_xml_template_id)
143: , DECODE(p_addt_delivery_status, FND_API.G_MISS_CHAR, NULL, p_addt_delivery_status)
144: , DECODE(p_as_of_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_as_of_date)

Line 141: , DECODE(p_correspondence_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_correspondence_date)

137: , DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
138: , DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
139: , DECODE(p_org_id, FND_API.G_MISS_NUM, NULL, p_org_id) -- added for bug 9151851
140: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
141: , DECODE(p_correspondence_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_correspondence_date)
142: , DECODE(p_addt_xml_template_id, FND_API.G_MISS_NUM, NULL, p_addt_xml_template_id)
143: , DECODE(p_addt_delivery_status, FND_API.G_MISS_CHAR, NULL, p_addt_delivery_status)
144: , DECODE(p_as_of_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_as_of_date)
145: );

Line 142: , DECODE(p_addt_xml_template_id, FND_API.G_MISS_NUM, NULL, p_addt_xml_template_id)

138: , DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
139: , DECODE(p_org_id, FND_API.G_MISS_NUM, NULL, p_org_id) -- added for bug 9151851
140: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
141: , DECODE(p_correspondence_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_correspondence_date)
142: , DECODE(p_addt_xml_template_id, FND_API.G_MISS_NUM, NULL, p_addt_xml_template_id)
143: , DECODE(p_addt_delivery_status, FND_API.G_MISS_CHAR, NULL, p_addt_delivery_status)
144: , DECODE(p_as_of_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_as_of_date)
145: );
146:

Line 143: , DECODE(p_addt_delivery_status, FND_API.G_MISS_CHAR, NULL, p_addt_delivery_status)

139: , DECODE(p_org_id, FND_API.G_MISS_NUM, NULL, p_org_id) -- added for bug 9151851
140: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
141: , DECODE(p_correspondence_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_correspondence_date)
142: , DECODE(p_addt_xml_template_id, FND_API.G_MISS_NUM, NULL, p_addt_xml_template_id)
143: , DECODE(p_addt_delivery_status, FND_API.G_MISS_CHAR, NULL, p_addt_delivery_status)
144: , DECODE(p_as_of_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_as_of_date)
145: );
146:
147: OPEN l_insert;

Line 144: , DECODE(p_as_of_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_as_of_date)

140: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
141: , DECODE(p_correspondence_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_correspondence_date)
142: , DECODE(p_addt_xml_template_id, FND_API.G_MISS_NUM, NULL, p_addt_xml_template_id)
143: , DECODE(p_addt_delivery_status, FND_API.G_MISS_CHAR, NULL, p_addt_delivery_status)
144: , DECODE(p_as_of_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_as_of_date)
145: );
146:
147: OPEN l_insert;
148: FETCH l_insert INTO px_rowid;

Line 212: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)

208: ) IS
209: BEGIN
210: UPDATE iex_dunnings
211: SET
212: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
213: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
214: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
215: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
216: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)

Line 213: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)

209: BEGIN
210: UPDATE iex_dunnings
211: SET
212: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
213: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
214: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
215: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
216: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
217: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)

Line 214: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)

210: UPDATE iex_dunnings
211: SET
212: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
213: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
214: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
215: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
216: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
217: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
218: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)

Line 215: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)

211: SET
212: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
213: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
214: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
215: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
216: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
217: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
218: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
219: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)

Line 216: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)

212: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
213: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
214: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
215: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
216: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
217: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
218: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
219: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
220: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)

Line 217: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)

213: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
214: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
215: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
216: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
217: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
218: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
219: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
220: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
221: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)

Line 218: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)

214: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
215: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
216: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
217: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
218: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
219: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
220: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
221: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
222: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)

Line 219: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)

215: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
216: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
217: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
218: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
219: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
220: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
221: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
222: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
223: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)

Line 220: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)

216: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
217: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
218: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
219: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
220: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
221: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
222: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
223: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
224: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)

Line 221: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)

217: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
218: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
219: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
220: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
221: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
222: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
223: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
224: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
225: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)

Line 222: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)

218: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
219: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
220: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
221: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
222: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
223: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
224: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
225: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
226: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)

Line 223: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)

219: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
220: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
221: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
222: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
223: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
224: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
225: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
226: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
227: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)

Line 224: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)

220: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
221: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
222: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
223: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
224: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
225: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
226: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
227: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
228: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)

Line 225: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)

221: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
222: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
223: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
224: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
225: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
226: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
227: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
228: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
229: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)

Line 226: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)

222: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
223: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
224: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
225: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
226: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
227: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
228: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
229: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
230: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)

Line 227: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)

223: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
224: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
225: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
226: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
227: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
228: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
229: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
230: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
231: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)

Line 228: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)

224: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
225: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
226: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
227: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
228: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
229: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
230: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
231: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
232: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)

Line 229: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)

225: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
226: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
227: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
228: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
229: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
230: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
231: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
232: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
233: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)

Line 230: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)

226: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
227: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
228: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
229: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
230: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
231: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
232: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
233: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
234: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)

Line 231: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)

227: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
228: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
229: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
230: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
231: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
232: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
233: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
234: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
235: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)

Line 232: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)

228: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
229: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
230: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
231: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
232: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
233: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
234: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
235: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
236: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)

Line 233: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)

229: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
230: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
231: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
232: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
233: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
234: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
235: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
236: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
237: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)

Line 234: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)

230: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
231: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
232: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
233: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
234: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
235: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
236: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
237: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
238: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)

Line 235: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)

231: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
232: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
233: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
234: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
235: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
236: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
237: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
238: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
239: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)

Line 236: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)

232: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
233: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
234: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
235: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
236: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
237: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
238: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
239: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
240: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)

Line 237: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)

233: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
234: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
235: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
236: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
237: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
238: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
239: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
240: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
241: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)

Line 238: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)

234: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
235: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
236: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
237: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
238: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
239: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
240: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
241: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
242: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)

Line 239: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)

235: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
236: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
237: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
238: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
239: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
240: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
241: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
242: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
243: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)

Line 240: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)

236: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
237: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
238: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
239: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
240: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
241: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
242: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
243: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
244: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)

Line 241: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)

237: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
238: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
239: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
240: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
241: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
242: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
243: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
244: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
245: , ag_dn_xref_id = DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)

Line 242: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)

238: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
239: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
240: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
241: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
242: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
243: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
244: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
245: , ag_dn_xref_id = DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
246: , correspondence_date = DECODE(p_correspondence_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_correspondence_date)

Line 243: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)

239: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
240: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
241: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
242: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
243: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
244: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
245: , ag_dn_xref_id = DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
246: , correspondence_date = DECODE(p_correspondence_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_correspondence_date)
247: , addt_xml_template_id = DECODE(p_addt_xml_template_id, FND_API.G_MISS_NUM, NULL, p_addt_xml_template_id)

Line 244: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)

240: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
241: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
242: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
243: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
244: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
245: , ag_dn_xref_id = DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
246: , correspondence_date = DECODE(p_correspondence_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_correspondence_date)
247: , addt_xml_template_id = DECODE(p_addt_xml_template_id, FND_API.G_MISS_NUM, NULL, p_addt_xml_template_id)
248: , addt_delivery_status = DECODE(p_addt_delivery_status, FND_API.G_MISS_CHAR, NULL, p_addt_delivery_status)

Line 245: , ag_dn_xref_id = DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)

241: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
242: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
243: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
244: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
245: , ag_dn_xref_id = DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
246: , correspondence_date = DECODE(p_correspondence_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_correspondence_date)
247: , addt_xml_template_id = DECODE(p_addt_xml_template_id, FND_API.G_MISS_NUM, NULL, p_addt_xml_template_id)
248: , addt_delivery_status = DECODE(p_addt_delivery_status, FND_API.G_MISS_CHAR, NULL, p_addt_delivery_status)
249: WHERE ROWID = p_rowid;

Line 246: , correspondence_date = DECODE(p_correspondence_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_correspondence_date)

242: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
243: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
244: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
245: , ag_dn_xref_id = DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
246: , correspondence_date = DECODE(p_correspondence_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_correspondence_date)
247: , addt_xml_template_id = DECODE(p_addt_xml_template_id, FND_API.G_MISS_NUM, NULL, p_addt_xml_template_id)
248: , addt_delivery_status = DECODE(p_addt_delivery_status, FND_API.G_MISS_CHAR, NULL, p_addt_delivery_status)
249: WHERE ROWID = p_rowid;
250: IF (SQL%NOTFOUND) THEN

Line 247: , addt_xml_template_id = DECODE(p_addt_xml_template_id, FND_API.G_MISS_NUM, NULL, p_addt_xml_template_id)

243: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
244: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
245: , ag_dn_xref_id = DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
246: , correspondence_date = DECODE(p_correspondence_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_correspondence_date)
247: , addt_xml_template_id = DECODE(p_addt_xml_template_id, FND_API.G_MISS_NUM, NULL, p_addt_xml_template_id)
248: , addt_delivery_status = DECODE(p_addt_delivery_status, FND_API.G_MISS_CHAR, NULL, p_addt_delivery_status)
249: WHERE ROWID = p_rowid;
250: IF (SQL%NOTFOUND) THEN
251: RAISE NO_DATA_FOUND;

Line 248: , addt_delivery_status = DECODE(p_addt_delivery_status, FND_API.G_MISS_CHAR, NULL, p_addt_delivery_status)

244: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
245: , ag_dn_xref_id = DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
246: , correspondence_date = DECODE(p_correspondence_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_correspondence_date)
247: , addt_xml_template_id = DECODE(p_addt_xml_template_id, FND_API.G_MISS_NUM, NULL, p_addt_xml_template_id)
248: , addt_delivery_status = DECODE(p_addt_delivery_status, FND_API.G_MISS_CHAR, NULL, p_addt_delivery_status)
249: WHERE ROWID = p_rowid;
250: IF (SQL%NOTFOUND) THEN
251: RAISE NO_DATA_FOUND;
252: END IF;

Line 422: If (px_dunning_trx_id IS NULL) OR (px_dunning_trx_id = FND_API.G_MISS_NUM) then

418: SELECT iex_dunning_transactions_s.nextval
419: FROM sys.dual;
420: BEGIN
421: --
422: If (px_dunning_trx_id IS NULL) OR (px_dunning_trx_id = FND_API.G_MISS_NUM) then
423: OPEN get_seq_csr;
424: FETCH get_seq_csr INTO px_dunning_trx_id;
425: CLOSE get_seq_csr;
426: End If;

Line 444: , DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)

440: , LAST_UPDATE_LOGIN
441: , OBJECT_VERSION_NUMBER
442: ) VALUES (
443: px_dunning_trx_id
444: , DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
445: , DECODE(p_cust_trx_id, FND_API.G_MISS_NUM, NULL, p_cust_trx_id)
446: , DECODE(p_payment_schedule_id, FND_API.G_MISS_NUM, NULL, p_payment_schedule_id)
447: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
448: , DECODE(p_stage_number, FND_API.G_MISS_NUM, NULL, p_stage_number)

Line 445: , DECODE(p_cust_trx_id, FND_API.G_MISS_NUM, NULL, p_cust_trx_id)

441: , OBJECT_VERSION_NUMBER
442: ) VALUES (
443: px_dunning_trx_id
444: , DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
445: , DECODE(p_cust_trx_id, FND_API.G_MISS_NUM, NULL, p_cust_trx_id)
446: , DECODE(p_payment_schedule_id, FND_API.G_MISS_NUM, NULL, p_payment_schedule_id)
447: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
448: , DECODE(p_stage_number, FND_API.G_MISS_NUM, NULL, p_stage_number)
449: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)

Line 446: , DECODE(p_payment_schedule_id, FND_API.G_MISS_NUM, NULL, p_payment_schedule_id)

442: ) VALUES (
443: px_dunning_trx_id
444: , DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
445: , DECODE(p_cust_trx_id, FND_API.G_MISS_NUM, NULL, p_cust_trx_id)
446: , DECODE(p_payment_schedule_id, FND_API.G_MISS_NUM, NULL, p_payment_schedule_id)
447: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
448: , DECODE(p_stage_number, FND_API.G_MISS_NUM, NULL, p_stage_number)
449: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
450: , DECODE(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date)

Line 447: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)

443: px_dunning_trx_id
444: , DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
445: , DECODE(p_cust_trx_id, FND_API.G_MISS_NUM, NULL, p_cust_trx_id)
446: , DECODE(p_payment_schedule_id, FND_API.G_MISS_NUM, NULL, p_payment_schedule_id)
447: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
448: , DECODE(p_stage_number, FND_API.G_MISS_NUM, NULL, p_stage_number)
449: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
450: , DECODE(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date)
451: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)

Line 448: , DECODE(p_stage_number, FND_API.G_MISS_NUM, NULL, p_stage_number)

444: , DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
445: , DECODE(p_cust_trx_id, FND_API.G_MISS_NUM, NULL, p_cust_trx_id)
446: , DECODE(p_payment_schedule_id, FND_API.G_MISS_NUM, NULL, p_payment_schedule_id)
447: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
448: , DECODE(p_stage_number, FND_API.G_MISS_NUM, NULL, p_stage_number)
449: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
450: , DECODE(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date)
451: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
452: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date)

Line 449: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)

445: , DECODE(p_cust_trx_id, FND_API.G_MISS_NUM, NULL, p_cust_trx_id)
446: , DECODE(p_payment_schedule_id, FND_API.G_MISS_NUM, NULL, p_payment_schedule_id)
447: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
448: , DECODE(p_stage_number, FND_API.G_MISS_NUM, NULL, p_stage_number)
449: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
450: , DECODE(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date)
451: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
452: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date)
453: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)

Line 450: , DECODE(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date)

446: , DECODE(p_payment_schedule_id, FND_API.G_MISS_NUM, NULL, p_payment_schedule_id)
447: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
448: , DECODE(p_stage_number, FND_API.G_MISS_NUM, NULL, p_stage_number)
449: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
450: , DECODE(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date)
451: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
452: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date)
453: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
454: , DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)

Line 451: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)

447: , DECODE(p_ag_dn_xref_id, FND_API.G_MISS_NUM, NULL, p_ag_dn_xref_id)
448: , DECODE(p_stage_number, FND_API.G_MISS_NUM, NULL, p_stage_number)
449: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
450: , DECODE(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date)
451: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
452: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date)
453: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
454: , DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
455: );

Line 452: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date)

448: , DECODE(p_stage_number, FND_API.G_MISS_NUM, NULL, p_stage_number)
449: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
450: , DECODE(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date)
451: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
452: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date)
453: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
454: , DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
455: );
456:

Line 453: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)

449: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
450: , DECODE(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date)
451: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
452: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date)
453: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
454: , DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
455: );
456:
457: OPEN l_insert;

Line 454: , DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)

450: , DECODE(p_creation_date, FND_API.G_MISS_DATE, NULL, p_creation_date)
451: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
452: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, NULL, p_last_update_date)
453: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
454: , DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
455: );
456:
457: OPEN l_insert;
458: FETCH l_insert INTO px_rowid;

Line 506: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)

502: ) IS
503: BEGIN
504: UPDATE iex_dunnings
505: SET
506: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
507: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
508: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
509: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
510: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)

Line 507: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)

503: BEGIN
504: UPDATE iex_dunnings
505: SET
506: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
507: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
508: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
509: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
510: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
511: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)

Line 508: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)

504: UPDATE iex_dunnings
505: SET
506: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
507: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
508: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
509: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
510: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
511: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
512: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)

Line 509: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)

505: SET
506: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
507: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
508: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
509: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
510: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
511: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
512: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
513: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)

Line 510: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)

506: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
507: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
508: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
509: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
510: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
511: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
512: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
513: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
514: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)

Line 511: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)

507: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
508: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
509: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
510: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
511: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
512: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
513: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
514: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
515: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)

Line 512: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)

508: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
509: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
510: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
511: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
512: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
513: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
514: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
515: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
516: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)

Line 513: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)

509: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
510: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
511: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
512: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
513: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
514: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
515: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
516: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
517: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)

Line 514: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)

510: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
511: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
512: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
513: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
514: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
515: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
516: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
517: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
518: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)

Line 515: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)

511: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
512: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
513: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
514: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
515: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
516: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
517: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
518: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
519: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)

Line 516: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)

512: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
513: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
514: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
515: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
516: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
517: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
518: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
519: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
520: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)

Line 517: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)

513: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
514: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
515: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
516: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
517: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
518: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
519: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
520: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
521: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)

Line 518: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)

514: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
515: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
516: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
517: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
518: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
519: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
520: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
521: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
522: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)

Line 519: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)

515: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
516: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
517: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
518: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
519: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
520: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
521: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
522: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
523: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)

Line 520: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)

516: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
517: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
518: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
519: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
520: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
521: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
522: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
523: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
524: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)

Line 521: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)

517: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
518: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
519: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
520: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
521: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
522: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
523: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
524: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
525: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)

Line 522: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)

518: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
519: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
520: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
521: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
522: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
523: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
524: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
525: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
526: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)

Line 523: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)

519: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
520: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
521: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
522: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
523: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
524: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
525: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
526: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
527: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)

Line 524: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)

520: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
521: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
522: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
523: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
524: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
525: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
526: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
527: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
528: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)

Line 525: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)

521: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
522: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
523: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
524: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
525: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
526: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
527: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
528: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
529: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)

Line 526: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)

522: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
523: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
524: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
525: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
526: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
527: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
528: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
529: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
530: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)

Line 527: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)

523: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
524: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
525: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
526: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
527: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
528: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
529: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
530: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
531: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)

Line 528: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)

524: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
525: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
526: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
527: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
528: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
529: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
530: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
531: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
532: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)

Line 529: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)

525: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
526: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
527: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
528: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
529: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
530: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
531: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
532: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
533: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)

Line 530: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)

526: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
527: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
528: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
529: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
530: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
531: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
532: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
533: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
534: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)

Line 531: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)

527: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
528: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
529: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
530: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
531: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
532: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
533: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
534: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
535: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)

Line 532: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)

528: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
529: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
530: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
531: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
532: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
533: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
534: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
535: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
536: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)

Line 533: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)

529: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
530: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
531: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
532: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
533: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
534: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
535: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
536: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
537: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)

Line 534: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)

530: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
531: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
532: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
533: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
534: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
535: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
536: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
537: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
538: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)

Line 535: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)

531: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
532: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
533: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
534: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
535: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
536: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
537: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
538: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
539: , dunning_plan_line_id = DECODE(p_dunning_plan_line_id, FND_API.G_MISS_CHAR, NULL, p_dunning_plan_line_id)

Line 536: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)

532: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
533: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
534: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
535: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
536: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
537: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
538: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
539: , dunning_plan_line_id = DECODE(p_dunning_plan_line_id, FND_API.G_MISS_CHAR, NULL, p_dunning_plan_line_id)
540: WHERE ROWID = p_rowid;

Line 537: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)

533: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
534: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
535: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
536: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
537: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
538: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
539: , dunning_plan_line_id = DECODE(p_dunning_plan_line_id, FND_API.G_MISS_CHAR, NULL, p_dunning_plan_line_id)
540: WHERE ROWID = p_rowid;
541: IF (SQL%NOTFOUND) THEN

Line 538: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)

534: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
535: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
536: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
537: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
538: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
539: , dunning_plan_line_id = DECODE(p_dunning_plan_line_id, FND_API.G_MISS_CHAR, NULL, p_dunning_plan_line_id)
540: WHERE ROWID = p_rowid;
541: IF (SQL%NOTFOUND) THEN
542: RAISE NO_DATA_FOUND;

Line 539: , dunning_plan_line_id = DECODE(p_dunning_plan_line_id, FND_API.G_MISS_CHAR, NULL, p_dunning_plan_line_id)

535: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
536: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
537: , dunning_mode = DECODE(p_dunning_mode, FND_API.G_MISS_CHAR, NULL, p_dunning_mode)
538: , confirmation_mode = DECODE(p_confirmation_mode, FND_API.G_MISS_CHAR, NULL, p_confirmation_mode)
539: , dunning_plan_line_id = DECODE(p_dunning_plan_line_id, FND_API.G_MISS_CHAR, NULL, p_dunning_plan_line_id)
540: WHERE ROWID = p_rowid;
541: IF (SQL%NOTFOUND) THEN
542: RAISE NO_DATA_FOUND;
543: END IF;