DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_AGING_CONC_PUB dependencies on FND_PROFILE

Line 64: l_request_id := to_number(fnd_profile.value('CONC_REQUEST_ID'));

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');

Line 65: l_aging_days_noact := to_number(fnd_profile.value('AS_AGING_DAYS_NOACT'));

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');

Line 67: := to_number(fnd_profile.value('AS_AGING_DAYS_ABANDON'));

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) ||

Line 68: l_aging_abandon_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');

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);

Line 69: l_aging_noact_actions := fnd_profile.value('AS_AGING_ABANDON_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) ||

Line 151: l_aging_days_noact := to_number(fnd_profile.value('AS_AGING_DAYS_NOACT'));

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');

Line 153: := to_number(fnd_profile.value('AS_AGING_DAYS_ABANDON'));

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));

Line 154: l_aging_abandon_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');

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));

Line 155: l_aging_noact_actions := fnd_profile.value('AS_AGING_ABANDON_ACTIONS');

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));

Line 165: l_request_id := to_number(fnd_profile.value('CONC_REQUEST_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;