60: g_debug_flag := p_debug_mode;
61:
62: Debug('*** ASXSLAGMA starts ***');
63:
64: l_request_id := to_number(fnd_profile.value('CONC_REQUEST_ID'));
65: l_aging_days_noact := to_number(fnd_profile.value('AS_AGING_DAYS_NOACT'));
66: l_aging_days_abandon
67: := to_number(fnd_profile.value('AS_AGING_DAYS_ABANDON'));
68: l_aging_abandon_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
61:
62: Debug('*** ASXSLAGMA starts ***');
63:
64: l_request_id := to_number(fnd_profile.value('CONC_REQUEST_ID'));
65: l_aging_days_noact := to_number(fnd_profile.value('AS_AGING_DAYS_NOACT'));
66: l_aging_days_abandon
67: := to_number(fnd_profile.value('AS_AGING_DAYS_ABANDON'));
68: l_aging_abandon_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
69: l_aging_noact_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
63:
64: l_request_id := to_number(fnd_profile.value('CONC_REQUEST_ID'));
65: l_aging_days_noact := to_number(fnd_profile.value('AS_AGING_DAYS_NOACT'));
66: l_aging_days_abandon
67: := to_number(fnd_profile.value('AS_AGING_DAYS_ABANDON'));
68: l_aging_abandon_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
69: l_aging_noact_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
70:
71: Debug('aging_days_noact=' || to_char(l_aging_days_noact) ||
64: l_request_id := to_number(fnd_profile.value('CONC_REQUEST_ID'));
65: l_aging_days_noact := to_number(fnd_profile.value('AS_AGING_DAYS_NOACT'));
66: l_aging_days_abandon
67: := to_number(fnd_profile.value('AS_AGING_DAYS_ABANDON'));
68: l_aging_abandon_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
69: l_aging_noact_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
70:
71: Debug('aging_days_noact=' || to_char(l_aging_days_noact) ||
72: ' aging_noact_actions=' || l_aging_noact_actions);
65: l_aging_days_noact := to_number(fnd_profile.value('AS_AGING_DAYS_NOACT'));
66: l_aging_days_abandon
67: := to_number(fnd_profile.value('AS_AGING_DAYS_ABANDON'));
68: l_aging_abandon_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
69: l_aging_noact_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
70:
71: Debug('aging_days_noact=' || to_char(l_aging_days_noact) ||
72: ' aging_noact_actions=' || l_aging_noact_actions);
73: Debug('aging_days_abandon=' || to_char(l_aging_days_abandon) ||
147: BEGIN
148: Debug('*** ASXSLAGWF start ***');
149:
150: -----------------------------------------------------------------------------
151: l_aging_days_noact := to_number(fnd_profile.value('AS_AGING_DAYS_NOACT'));
152: l_aging_days_abandon
153: := to_number(fnd_profile.value('AS_AGING_DAYS_ABANDON'));
154: l_aging_abandon_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
155: l_aging_noact_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
149:
150: -----------------------------------------------------------------------------
151: l_aging_days_noact := to_number(fnd_profile.value('AS_AGING_DAYS_NOACT'));
152: l_aging_days_abandon
153: := to_number(fnd_profile.value('AS_AGING_DAYS_ABANDON'));
154: l_aging_abandon_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
155: l_aging_noact_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
156: -----------------------------------------------------------------------------
157: Debug('Parent Request ID : ' || to_char( p_parent_request_id));
150: -----------------------------------------------------------------------------
151: l_aging_days_noact := to_number(fnd_profile.value('AS_AGING_DAYS_NOACT'));
152: l_aging_days_abandon
153: := to_number(fnd_profile.value('AS_AGING_DAYS_ABANDON'));
154: l_aging_abandon_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
155: l_aging_noact_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
156: -----------------------------------------------------------------------------
157: Debug('Parent Request ID : ' || to_char( p_parent_request_id));
158: Debug('Sequence Number : ' || to_char(p_sequence_number));
151: l_aging_days_noact := to_number(fnd_profile.value('AS_AGING_DAYS_NOACT'));
152: l_aging_days_abandon
153: := to_number(fnd_profile.value('AS_AGING_DAYS_ABANDON'));
154: l_aging_abandon_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
155: l_aging_noact_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');
156: -----------------------------------------------------------------------------
157: Debug('Parent Request ID : ' || to_char( p_parent_request_id));
158: Debug('Sequence Number : ' || to_char(p_sequence_number));
159: Debug('Sales Lead ID : ' || to_char(p_sales_lead_id));
161: Debug('Aging Noact Actions : ' || l_aging_noact_actions);
162: Debug('Aging Days Abandon : ' || to_char(l_aging_days_abandon));
163: Debug('Aging Abandon Actions : ' || l_aging_abandon_actions);
164:
165: l_request_id := to_number(fnd_profile.value('CONC_REQUEST_ID'));
166: l_sales_lead_id := p_sales_lead_id;
167:
168: OPEN c_sales_lead(l_sales_lead_id);
169: FETCH c_sales_lead INTO l_assigned_resource_id;