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.CN_PAYMENT_API_PKG dependencies on CN_PAYMENT_API

Line 1: PACKAGE BODY CN_PAYMENT_API_PKG as

1: PACKAGE BODY CN_PAYMENT_API_PKG as
2: -- $Header: cntpmtab.pls 115.2 2001/10/29 17:15:38 pkm ship $
3:
4:
5: -------------------------------------------------------------------------+

Line 11: x_period_id cn_payment_api.period_id%TYPE

7: -- Purpose : Main insert procedure
8: -------------------------------------------------------------------------+
9:
10: PROCEDURE Insert_Record(
11: x_period_id cn_payment_api.period_id%TYPE
12: ,x_salesrep_id cn_payment_api.salesrep_id%TYPE
13: ,x_pay_date cn_payment_api.pay_date%TYPE
14: ,x_payment_type cn_payment_api.payment_type%TYPE
15: ,x_amount cn_payment_api.amount%TYPE

Line 12: ,x_salesrep_id cn_payment_api.salesrep_id%TYPE

8: -------------------------------------------------------------------------+
9:
10: PROCEDURE Insert_Record(
11: x_period_id cn_payment_api.period_id%TYPE
12: ,x_salesrep_id cn_payment_api.salesrep_id%TYPE
13: ,x_pay_date cn_payment_api.pay_date%TYPE
14: ,x_payment_type cn_payment_api.payment_type%TYPE
15: ,x_amount cn_payment_api.amount%TYPE
16: ,x_cost_center_id cn_payment_api.cost_center_id%TYPE

Line 13: ,x_pay_date cn_payment_api.pay_date%TYPE

9:
10: PROCEDURE Insert_Record(
11: x_period_id cn_payment_api.period_id%TYPE
12: ,x_salesrep_id cn_payment_api.salesrep_id%TYPE
13: ,x_pay_date cn_payment_api.pay_date%TYPE
14: ,x_payment_type cn_payment_api.payment_type%TYPE
15: ,x_amount cn_payment_api.amount%TYPE
16: ,x_cost_center_id cn_payment_api.cost_center_id%TYPE
17: ,x_payment_api_id cn_payment_api.payment_api_id%TYPE

Line 14: ,x_payment_type cn_payment_api.payment_type%TYPE

10: PROCEDURE Insert_Record(
11: x_period_id cn_payment_api.period_id%TYPE
12: ,x_salesrep_id cn_payment_api.salesrep_id%TYPE
13: ,x_pay_date cn_payment_api.pay_date%TYPE
14: ,x_payment_type cn_payment_api.payment_type%TYPE
15: ,x_amount cn_payment_api.amount%TYPE
16: ,x_cost_center_id cn_payment_api.cost_center_id%TYPE
17: ,x_payment_api_id cn_payment_api.payment_api_id%TYPE
18: ,x_payrun_id cn_payment_api.payrun_id%TYPE

Line 15: ,x_amount cn_payment_api.amount%TYPE

11: x_period_id cn_payment_api.period_id%TYPE
12: ,x_salesrep_id cn_payment_api.salesrep_id%TYPE
13: ,x_pay_date cn_payment_api.pay_date%TYPE
14: ,x_payment_type cn_payment_api.payment_type%TYPE
15: ,x_amount cn_payment_api.amount%TYPE
16: ,x_cost_center_id cn_payment_api.cost_center_id%TYPE
17: ,x_payment_api_id cn_payment_api.payment_api_id%TYPE
18: ,x_payrun_id cn_payment_api.payrun_id%TYPE
19: ,x_from_credit_type_id cn_payment_api.from_credit_type_id%TYPE

Line 16: ,x_cost_center_id cn_payment_api.cost_center_id%TYPE

12: ,x_salesrep_id cn_payment_api.salesrep_id%TYPE
13: ,x_pay_date cn_payment_api.pay_date%TYPE
14: ,x_payment_type cn_payment_api.payment_type%TYPE
15: ,x_amount cn_payment_api.amount%TYPE
16: ,x_cost_center_id cn_payment_api.cost_center_id%TYPE
17: ,x_payment_api_id cn_payment_api.payment_api_id%TYPE
18: ,x_payrun_id cn_payment_api.payrun_id%TYPE
19: ,x_from_credit_type_id cn_payment_api.from_credit_type_id%TYPE
20: ,x_to_credit_type_id cn_payment_api.to_credit_type_id%TYPE

Line 17: ,x_payment_api_id cn_payment_api.payment_api_id%TYPE

13: ,x_pay_date cn_payment_api.pay_date%TYPE
14: ,x_payment_type cn_payment_api.payment_type%TYPE
15: ,x_amount cn_payment_api.amount%TYPE
16: ,x_cost_center_id cn_payment_api.cost_center_id%TYPE
17: ,x_payment_api_id cn_payment_api.payment_api_id%TYPE
18: ,x_payrun_id cn_payment_api.payrun_id%TYPE
19: ,x_from_credit_type_id cn_payment_api.from_credit_type_id%TYPE
20: ,x_to_credit_type_id cn_payment_api.to_credit_type_id%TYPE
21: ,x_role_id cn_payment_api.role_id%TYPE

Line 18: ,x_payrun_id cn_payment_api.payrun_id%TYPE

14: ,x_payment_type cn_payment_api.payment_type%TYPE
15: ,x_amount cn_payment_api.amount%TYPE
16: ,x_cost_center_id cn_payment_api.cost_center_id%TYPE
17: ,x_payment_api_id cn_payment_api.payment_api_id%TYPE
18: ,x_payrun_id cn_payment_api.payrun_id%TYPE
19: ,x_from_credit_type_id cn_payment_api.from_credit_type_id%TYPE
20: ,x_to_credit_type_id cn_payment_api.to_credit_type_id%TYPE
21: ,x_role_id cn_payment_api.role_id%TYPE
22: ,x_created_by cn_payment_api.created_by%TYPE

Line 19: ,x_from_credit_type_id cn_payment_api.from_credit_type_id%TYPE

15: ,x_amount cn_payment_api.amount%TYPE
16: ,x_cost_center_id cn_payment_api.cost_center_id%TYPE
17: ,x_payment_api_id cn_payment_api.payment_api_id%TYPE
18: ,x_payrun_id cn_payment_api.payrun_id%TYPE
19: ,x_from_credit_type_id cn_payment_api.from_credit_type_id%TYPE
20: ,x_to_credit_type_id cn_payment_api.to_credit_type_id%TYPE
21: ,x_role_id cn_payment_api.role_id%TYPE
22: ,x_created_by cn_payment_api.created_by%TYPE
23: ,x_creation_date cn_payment_api.creation_date%TYPE

Line 20: ,x_to_credit_type_id cn_payment_api.to_credit_type_id%TYPE

16: ,x_cost_center_id cn_payment_api.cost_center_id%TYPE
17: ,x_payment_api_id cn_payment_api.payment_api_id%TYPE
18: ,x_payrun_id cn_payment_api.payrun_id%TYPE
19: ,x_from_credit_type_id cn_payment_api.from_credit_type_id%TYPE
20: ,x_to_credit_type_id cn_payment_api.to_credit_type_id%TYPE
21: ,x_role_id cn_payment_api.role_id%TYPE
22: ,x_created_by cn_payment_api.created_by%TYPE
23: ,x_creation_date cn_payment_api.creation_date%TYPE
24: )

Line 21: ,x_role_id cn_payment_api.role_id%TYPE

17: ,x_payment_api_id cn_payment_api.payment_api_id%TYPE
18: ,x_payrun_id cn_payment_api.payrun_id%TYPE
19: ,x_from_credit_type_id cn_payment_api.from_credit_type_id%TYPE
20: ,x_to_credit_type_id cn_payment_api.to_credit_type_id%TYPE
21: ,x_role_id cn_payment_api.role_id%TYPE
22: ,x_created_by cn_payment_api.created_by%TYPE
23: ,x_creation_date cn_payment_api.creation_date%TYPE
24: )
25: IS

Line 22: ,x_created_by cn_payment_api.created_by%TYPE

18: ,x_payrun_id cn_payment_api.payrun_id%TYPE
19: ,x_from_credit_type_id cn_payment_api.from_credit_type_id%TYPE
20: ,x_to_credit_type_id cn_payment_api.to_credit_type_id%TYPE
21: ,x_role_id cn_payment_api.role_id%TYPE
22: ,x_created_by cn_payment_api.created_by%TYPE
23: ,x_creation_date cn_payment_api.creation_date%TYPE
24: )
25: IS
26:

Line 23: ,x_creation_date cn_payment_api.creation_date%TYPE

19: ,x_from_credit_type_id cn_payment_api.from_credit_type_id%TYPE
20: ,x_to_credit_type_id cn_payment_api.to_credit_type_id%TYPE
21: ,x_role_id cn_payment_api.role_id%TYPE
22: ,x_created_by cn_payment_api.created_by%TYPE
23: ,x_creation_date cn_payment_api.creation_date%TYPE
24: )
25: IS
26:
27: BEGIN

Line 29: INSERT INTO cn_payment_api(

25: IS
26:
27: BEGIN
28:
29: INSERT INTO cn_payment_api(
30: period_id
31: ,salesrep_id
32: ,pay_date
33: ,payment_type

Line 50: ,Nvl(x_payment_api_id, cn_payment_api_s.NEXTVAL)

46: ,x_pay_date
47: ,x_payment_type
48: ,x_amount
49: ,x_cost_center_id
50: ,Nvl(x_payment_api_id, cn_payment_api_s.NEXTVAL)
51: ,x_payrun_id
52: ,x_from_credit_type_id
53: ,x_to_credit_type_id
54: ,x_role_id

Line 61: END CN_PAYMENT_API_PKG;

57: );
58:
59: END Insert_Record;
60:
61: END CN_PAYMENT_API_PKG;