APPS.CN_COLLECTION_AIA_OM_PUB dependencies on CN_AIA_ORDER_CAPTURE

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

5: -- Function name : get_exchange_rate
6: -- Type : Public.
7: -- Pre-reqs :
8:
9: FUNCTION get_exchange_rate(p_from_currency IN cn_aia_order_capture.amt_curcy_cd%TYPE,
10: p_conversion_date IN cn_aia_order_capture.processed_date%TYPE,
11: p_org_id IN cn_aia_order_capture.org_id%TYPE)
12: RETURN cn_aia_order_capture.exchange_rate%TYPE;
13:

Line 10: p_conversion_date IN cn_aia_order_capture.processed_date%TYPE,

6: -- Type : Public.
7: -- Pre-reqs :
8:
9: FUNCTION get_exchange_rate(p_from_currency IN cn_aia_order_capture.amt_curcy_cd%TYPE,
10: p_conversion_date IN cn_aia_order_capture.processed_date%TYPE,
11: p_org_id IN cn_aia_order_capture.org_id%TYPE)
12: RETURN cn_aia_order_capture.exchange_rate%TYPE;
13:
14:

Line 11: p_org_id IN cn_aia_order_capture.org_id%TYPE)

7: -- Pre-reqs :
8:
9: FUNCTION get_exchange_rate(p_from_currency IN cn_aia_order_capture.amt_curcy_cd%TYPE,
10: p_conversion_date IN cn_aia_order_capture.processed_date%TYPE,
11: p_org_id IN cn_aia_order_capture.org_id%TYPE)
12: RETURN cn_aia_order_capture.exchange_rate%TYPE;
13:
14:
15: -- Function name : get_employee_number

Line 12: RETURN cn_aia_order_capture.exchange_rate%TYPE;

8:
9: FUNCTION get_exchange_rate(p_from_currency IN cn_aia_order_capture.amt_curcy_cd%TYPE,
10: p_conversion_date IN cn_aia_order_capture.processed_date%TYPE,
11: p_org_id IN cn_aia_order_capture.org_id%TYPE)
12: RETURN cn_aia_order_capture.exchange_rate%TYPE;
13:
14:
15: -- Function name : get_employee_number
16: -- Type : Public.

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

15: -- Function name : get_employee_number
16: -- Type : Public.
17: -- Pre-reqs :
18:
19: FUNCTION get_employee_number(p_salesrep_id IN cn_aia_order_capture.salesrep_id%TYPE,
20: p_org_id cn_aia_order_capture.org_id%TYPE)
21: RETURN cn_aia_order_capture.employee_number%TYPE;
22:
23: -- API name : pre_aia_om_load_process

Line 20: p_org_id cn_aia_order_capture.org_id%TYPE)

16: -- Type : Public.
17: -- Pre-reqs :
18:
19: FUNCTION get_employee_number(p_salesrep_id IN cn_aia_order_capture.salesrep_id%TYPE,
20: p_org_id cn_aia_order_capture.org_id%TYPE)
21: RETURN cn_aia_order_capture.employee_number%TYPE;
22:
23: -- API name : pre_aia_om_load_process
24: -- Type : Public.

Line 21: RETURN cn_aia_order_capture.employee_number%TYPE;

17: -- Pre-reqs :
18:
19: FUNCTION get_employee_number(p_salesrep_id IN cn_aia_order_capture.salesrep_id%TYPE,
20: p_org_id cn_aia_order_capture.org_id%TYPE)
21: RETURN cn_aia_order_capture.employee_number%TYPE;
22:
23: -- API name : pre_aia_om_load_process
24: -- Type : Public.
25: -- Pre-reqs :