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 50: If (px_dunning_id IS NULL) OR (px_dunning_id = FND_API.G_MISS_NUM) then

46: SELECT IEX_dunnings_s.nextval
47: FROM sys.dual;
48: BEGIN
49: --
50: If (px_dunning_id IS NULL) OR (px_dunning_id = FND_API.G_MISS_NUM) then
51: OPEN get_seq_csr;
52: FETCH get_seq_csr INTO px_dunning_id;
53: CLOSE get_seq_csr;
54: End If;

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

86: , delivery_status
87: , parent_dunning_id
88: ) VALUES (
89: px_dunning_id
90: , DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
91: , DECODE(p_callback_YN, FND_API.G_MISS_CHAR, NULL, p_callback_YN)
92: , DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
93: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
94: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)

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

87: , parent_dunning_id
88: ) VALUES (
89: px_dunning_id
90: , DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
91: , DECODE(p_callback_YN, FND_API.G_MISS_CHAR, NULL, p_callback_YN)
92: , DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
93: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
94: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
95: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)

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

88: ) VALUES (
89: px_dunning_id
90: , DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
91: , DECODE(p_callback_YN, FND_API.G_MISS_CHAR, NULL, p_callback_YN)
92: , DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
93: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
94: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
95: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
96: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)

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

89: px_dunning_id
90: , DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
91: , DECODE(p_callback_YN, FND_API.G_MISS_CHAR, NULL, p_callback_YN)
92: , DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
93: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
94: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
95: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
96: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
97: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)

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

90: , DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
91: , DECODE(p_callback_YN, FND_API.G_MISS_CHAR, NULL, p_callback_YN)
92: , DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
93: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
94: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
95: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
96: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
97: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
98: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)

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

91: , DECODE(p_callback_YN, FND_API.G_MISS_CHAR, NULL, p_callback_YN)
92: , DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
93: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
94: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
95: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
96: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
97: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
98: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
99: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)

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

92: , DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
93: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
94: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
95: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
96: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
97: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
98: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
99: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
100: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)

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

93: , DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
94: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
95: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
96: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
97: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
98: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
99: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
100: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
101: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)

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

94: , DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
95: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
96: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
97: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
98: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
99: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
100: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
101: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
102: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)

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

95: , DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
96: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
97: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
98: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
99: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
100: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
101: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
102: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
103: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)

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

96: , DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
97: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
98: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
99: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
100: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
101: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
102: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
103: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
104: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)

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

97: , DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
98: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
99: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
100: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
101: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
102: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
103: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
104: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
105: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)

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

98: , DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
99: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
100: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
101: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
102: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
103: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
104: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
105: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
106: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)

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

99: , DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
100: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
101: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
102: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
103: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
104: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
105: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
106: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
107: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)

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

100: , DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
101: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
102: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
103: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
104: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
105: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
106: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
107: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
108: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)

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

101: , DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
102: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
103: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
104: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
105: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
106: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
107: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
108: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
109: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)

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

102: , DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
103: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
104: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
105: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
106: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
107: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
108: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
109: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
110: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)

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

103: , DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
104: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
105: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
106: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
107: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
108: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
109: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
110: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
111: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)

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

104: , DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
105: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
106: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
107: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
108: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
109: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
110: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
111: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
112: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)

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

105: , DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
106: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
107: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
108: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
109: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
110: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
111: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
112: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
113: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)

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

106: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_last_update_date)
107: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
108: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
109: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
110: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
111: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
112: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
113: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
114: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)

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

107: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by)
108: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
109: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
110: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
111: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
112: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
113: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
114: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
115: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)

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

108: , DECODE(p_creation_date, FND_API.G_MISS_DATE, TO_DATE(NULL), p_creation_date)
109: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
110: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
111: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
112: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
113: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
114: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
115: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
116: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)

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

109: , DECODE(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by)
110: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
111: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
112: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
113: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
114: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
115: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
116: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
117: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)

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

110: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, NULL, p_last_update_login)
111: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
112: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
113: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
114: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
115: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
116: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
117: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
118: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)

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

111: , DECODE(p_request_id, FND_API.G_MISS_NUM, NULL, p_request_id)
112: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
113: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
114: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
115: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
116: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
117: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
118: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
119: , DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)

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

112: , DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
113: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
114: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
115: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
116: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
117: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
118: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
119: , DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
120: );

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

113: , DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
114: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
115: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
116: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
117: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
118: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
119: , DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
120: );
121:

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

114: , DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
115: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
116: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
117: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
118: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
119: , DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
120: );
121:
122: OPEN l_insert;

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

115: , DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
116: , DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
117: , DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
118: , DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
119: , DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
120: );
121:
122: OPEN l_insert;
123: FETCH l_insert INTO px_rowid;

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

177: ) IS
178: BEGIN
179: UPDATE iex_dunnings
180: SET
181: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
182: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
183: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
184: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
185: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)

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

178: BEGIN
179: UPDATE iex_dunnings
180: SET
181: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
182: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
183: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
184: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
185: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
186: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)

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

179: UPDATE iex_dunnings
180: SET
181: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
182: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
183: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
184: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
185: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
186: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
187: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)

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

180: SET
181: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
182: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
183: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
184: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
185: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
186: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
187: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
188: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)

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

181: dunning_id = DECODE(p_dunning_id, FND_API.G_MISS_NUM, NULL, p_dunning_id)
182: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
183: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
184: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
185: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
186: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
187: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
188: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
189: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)

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

182: , template_id = DECODE(p_template_id, FND_API.G_MISS_NUM, NULL, p_template_id)
183: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
184: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
185: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
186: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
187: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
188: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
189: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
190: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)

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

183: , callback_yn = DECODE(p_callback_yn, FND_API.G_MISS_CHAR, NULL, p_callback_yn)
184: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
185: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
186: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
187: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
188: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
189: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
190: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
191: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)

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

184: , callback_date = DECODE(p_callback_date, FND_API.G_MISS_DATE, NULL, p_callback_date)
185: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
186: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
187: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
188: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
189: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
190: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
191: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
192: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)

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

185: , campaign_sched_id = DECODE(p_campaign_sched_id, FND_API.G_MISS_NUM, NULL, p_campaign_sched_id)
186: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
187: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
188: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
189: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
190: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
191: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
192: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
193: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)

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

186: , status = DECODE(p_status, FND_API.G_MISS_CHAR, NULL, p_status)
187: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
188: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
189: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
190: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
191: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
192: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
193: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
194: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)

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

187: , delinquency_id = DECODE(p_delinquency_id, FND_API.G_MISS_NUM, NULL, p_delinquency_id)
188: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
189: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
190: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
191: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
192: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
193: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
194: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
195: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)

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

188: , ffm_request_id = DECODE(p_ffm_request_id, FND_API.G_MISS_NUM, NULL, p_ffm_request_id)
189: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
190: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
191: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
192: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
193: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
194: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
195: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
196: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)

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

189: , xml_request_id = DECODE(p_xml_request_id, FND_API.G_MISS_NUM, NULL, p_xml_request_id)
190: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
191: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
192: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
193: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
194: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
195: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
196: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
197: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)

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

190: , xml_template_id = DECODE(p_xml_template_id, FND_API.G_MISS_NUM, NULL, p_xml_template_id)
191: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
192: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
193: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
194: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
195: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
196: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
197: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
198: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)

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

191: , object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)
192: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
193: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
194: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
195: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
196: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
197: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
198: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
199: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)

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

192: , object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type)
193: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
194: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
195: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
196: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
197: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
198: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
199: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
200: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)

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

193: , dunning_object_id = DECODE(p_dunning_object_id, FND_API.G_MISS_NUM, NULL, p_dunning_object_id)
194: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
195: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
196: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
197: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
198: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
199: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
200: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
201: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)

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

194: , dunning_level = DECODE(p_dunning_level, FND_API.G_MISS_CHAR, NULL, p_dunning_level)
195: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
196: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
197: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
198: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
199: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
200: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
201: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
202: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)

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

195: , dunning_method = DECODE(p_dunning_method, FND_API.G_MISS_CHAR, NULL, p_dunning_method)
196: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
197: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
198: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
199: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
200: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
201: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
202: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
203: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)

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

196: , amount_due_remaining = DECODE(p_amount_due_remaining, FND_API.G_MISS_NUM, NULL, p_amount_due_remaining)
197: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
198: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
199: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
200: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
201: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
202: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
203: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
204: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)

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

197: , currency_code = DECODE(p_currency_code, FND_API.G_MISS_CHAR, NULL, p_currency_code)
198: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
199: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
200: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
201: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
202: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
203: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
204: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
205: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)

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

198: , last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_last_update_date)
199: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
200: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
201: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
202: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
203: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
204: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
205: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
206: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)

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

199: , last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,NULL,p_last_updated_by)
200: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
201: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
202: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
203: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
204: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
205: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
206: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
207: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)

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

200: , creation_date = DECODE(p_creation_date,FND_API.G_MISS_DATE,TO_DATE(NULL),p_creation_date)
201: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
202: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
203: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
204: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
205: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
206: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
207: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
208: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)

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

201: , created_by = DECODE(p_created_by,FND_API.G_MISS_NUM,NULL,p_created_by)
202: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
203: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
204: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
205: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
206: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
207: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
208: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
209: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)

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

202: , last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,NULL,p_last_update_login)
203: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
204: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
205: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
206: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
207: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
208: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
209: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
210: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)

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

203: , request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
204: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
205: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
206: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
207: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
208: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
209: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
210: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
211: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)

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

204: , financial_charge = DECODE(p_financial_charge, FND_API.G_MISS_NUM, NULL, p_financial_charge)
205: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
206: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
207: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
208: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
209: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
210: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
211: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
212: WHERE ROWID = p_rowid;

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

205: , letter_name = DECODE(p_letter_name, FND_API.G_MISS_CHAR, NULL, p_letter_name)
206: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
207: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
208: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
209: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
210: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
211: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
212: WHERE ROWID = p_rowid;
213: IF (SQL%NOTFOUND) THEN

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

206: , interest_amt = DECODE(p_interest_amt, FND_API.G_MISS_NUM, NULL, p_interest_amt)
207: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
208: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
209: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
210: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
211: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
212: WHERE ROWID = p_rowid;
213: IF (SQL%NOTFOUND) THEN
214: RAISE NO_DATA_FOUND;

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

207: , dunning_plan_id = DECODE(p_dunning_plan_id, FND_API.G_MISS_NUM, NULL, p_dunning_plan_id)
208: , contact_destination = DECODE(p_contact_destination, FND_API.G_MISS_CHAR, NULL, p_contact_destination)
209: , contact_party_id = DECODE(p_contact_party_id, FND_API.G_MISS_NUM, NULL, p_contact_party_id)
210: , delivery_status = DECODE(p_delivery_status, FND_API.G_MISS_CHAR, NULL, p_delivery_status)
211: , parent_dunning_id = DECODE(p_parent_dunning_id, FND_API.G_MISS_NUM, NULL, p_parent_dunning_id)
212: WHERE ROWID = p_rowid;
213: IF (SQL%NOTFOUND) THEN
214: RAISE NO_DATA_FOUND;
215: END IF;