APPS.CN_COLLECTION_AIA_OM_PUB dependencies on CN_AIA_ORDER_CAPTURE

Line 27: FUNCTION get_employee_number(p_salesrep_id IN cn_aia_order_capture.salesrep_id%TYPE,

23: -- Function name : get_employee_number
24: -- Type : Public.
25: -- Pre-reqs :
26:
27: FUNCTION get_employee_number(p_salesrep_id IN cn_aia_order_capture.salesrep_id%TYPE,
28: p_org_id cn_aia_order_capture.org_id%TYPE) RETURN cn_aia_order_capture.employee_number%TYPE IS
29:
30: cursor get_emp_num_cur IS
31: SELECT salesrep_number

Line 28: p_org_id cn_aia_order_capture.org_id%TYPE) RETURN cn_aia_order_capture.employee_number%TYPE IS

24: -- Type : Public.
25: -- Pre-reqs :
26:
27: FUNCTION get_employee_number(p_salesrep_id IN cn_aia_order_capture.salesrep_id%TYPE,
28: p_org_id cn_aia_order_capture.org_id%TYPE) RETURN cn_aia_order_capture.employee_number%TYPE IS
29:
30: cursor get_emp_num_cur IS
31: SELECT salesrep_number
32: FROM jtf_rs_salesreps

Line 37: l_employee_num cn_aia_order_capture.employee_number%TYPE;

33: WHERE salesrep_id = p_salesrep_id
34: AND org_id = p_org_id;
35:
36: l_empnum_cr get_emp_num_cur%ROWTYPE;
37: l_employee_num cn_aia_order_capture.employee_number%TYPE;
38: BEGIN
39: debugmsg('CN_COLLECTION_AIA_OM_PUB.get_employee_number: p_salesrep_id, org_id: ' || p_salesrep_id || ' , ' || p_org_id);
40: l_employee_num := '-1';
41:

Line 62: FUNCTION get_exchange_rate(p_from_currency IN cn_aia_order_capture.amt_curcy_cd%TYPE,

58:
59: -- Function name : get_exchange_rate
60: -- Type : Public.
61: -- Pre-reqs :
62: FUNCTION get_exchange_rate(p_from_currency IN cn_aia_order_capture.amt_curcy_cd%TYPE,
63: p_conversion_date IN cn_aia_order_capture.processed_date%TYPE,
64: p_org_id IN cn_aia_order_capture.org_id%TYPE) RETURN cn_aia_order_capture.exchange_rate%TYPE IS
65:
66: CURSOR c1(l_to_currency varchar2,l_conversion_type varchar2) IS

Line 63: p_conversion_date IN cn_aia_order_capture.processed_date%TYPE,

59: -- Function name : get_exchange_rate
60: -- Type : Public.
61: -- Pre-reqs :
62: FUNCTION get_exchange_rate(p_from_currency IN cn_aia_order_capture.amt_curcy_cd%TYPE,
63: p_conversion_date IN cn_aia_order_capture.processed_date%TYPE,
64: p_org_id IN cn_aia_order_capture.org_id%TYPE) RETURN cn_aia_order_capture.exchange_rate%TYPE IS
65:
66: CURSOR c1(l_to_currency varchar2,l_conversion_type varchar2) IS
67: SELECT conversion_date

Line 64: p_org_id IN cn_aia_order_capture.org_id%TYPE) RETURN cn_aia_order_capture.exchange_rate%TYPE IS

60: -- Type : Public.
61: -- Pre-reqs :
62: FUNCTION get_exchange_rate(p_from_currency IN cn_aia_order_capture.amt_curcy_cd%TYPE,
63: p_conversion_date IN cn_aia_order_capture.processed_date%TYPE,
64: p_org_id IN cn_aia_order_capture.org_id%TYPE) RETURN cn_aia_order_capture.exchange_rate%TYPE IS
65:
66: CURSOR c1(l_to_currency varchar2,l_conversion_type varchar2) IS
67: SELECT conversion_date
68: FROM gl_daily_rates

Line 84: l_exchange_rate cn_aia_order_capture.exchange_rate%TYPE;

80: AND to_currency = l_to_currency
81: AND conversion_type = l_conversion_type
82: AND conversion_date < p_conversion_date;
83:
84: l_exchange_rate cn_aia_order_capture.exchange_rate%TYPE;
85: l_to_currency cn_aia_order_capture.amt_curcy_cd%TYPE;
86: l_conversion_date DATE;
87: l_conversion_type VARCHAR2(30);
88: l_check_max CHAR(1) := 'Y';

Line 85: l_to_currency cn_aia_order_capture.amt_curcy_cd%TYPE;

81: AND conversion_type = l_conversion_type
82: AND conversion_date < p_conversion_date;
83:
84: l_exchange_rate cn_aia_order_capture.exchange_rate%TYPE;
85: l_to_currency cn_aia_order_capture.amt_curcy_cd%TYPE;
86: l_conversion_date DATE;
87: l_conversion_type VARCHAR2(30);
88: l_check_max CHAR(1) := 'Y';
89:

Line 153: FROM cn_aia_order_capture

149:
150: CURSOR fetch_aia_salesreps_cur IS
151: SELECT DISTINCT salesrep_id,
152: amt_curcy_cd,processed_date, revenue_type
153: FROM cn_aia_order_capture
154: WHERE
155: preprocess_flag = fnd_api.g_false AND
156: org_id = p_org_id
157: AND update_flag = 'N';

Line 188: UPDATE cn_aia_order_capture

184: debugmsg('CN_COLLECTION_AIA_OM_PUB.oic_pre_load_data_process: l_exchange_rate : ' || l_exchange_rate);
185: debugmsg('CN_COLLECTION_AIA_OM_PUB.oic_pre_load_data_process: l_revenue_type : ' || l_revenue_type);
186:
187:
188: UPDATE cn_aia_order_capture
189: SET employee_number = l_employee_num,
190: exchange_rate = l_exchange_rate,
191: revenue_type = l_revenue_type,
192: adjust_status = 'MANUAL',