1: PACKAGE cn_payment_worksheet_pvt AUTHID CURRENT_USER AS
2: -- $Header: cnvwkshs.pls 120.10 2007/10/11 05:50:49 rrshetty ship $
3: TYPE worksheet_rec_type IS RECORD (
4: payrun_id cn_payment_worksheets.payrun_id%TYPE,
5: salesrep_id cn_payment_worksheets.salesrep_id%TYPE,
6: call_from VARCHAR2(30),
7: worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
8: --R12
1: PACKAGE cn_payment_worksheet_pvt AUTHID CURRENT_USER AS
2: -- $Header: cnvwkshs.pls 120.10 2007/10/11 05:50:49 rrshetty ship $
3: TYPE worksheet_rec_type IS RECORD (
4: payrun_id cn_payment_worksheets.payrun_id%TYPE,
5: salesrep_id cn_payment_worksheets.salesrep_id%TYPE,
6: call_from VARCHAR2(30),
7: worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
8: --R12
9: org_id cn_payment_worksheets.org_id%TYPE
3: TYPE worksheet_rec_type IS RECORD (
4: payrun_id cn_payment_worksheets.payrun_id%TYPE,
5: salesrep_id cn_payment_worksheets.salesrep_id%TYPE,
6: call_from VARCHAR2(30),
7: worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
8: --R12
9: org_id cn_payment_worksheets.org_id%TYPE
10: );
11:
5: salesrep_id cn_payment_worksheets.salesrep_id%TYPE,
6: call_from VARCHAR2(30),
7: worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
8: --R12
9: org_id cn_payment_worksheets.org_id%TYPE
10: );
11:
12: CONCURRENT_PROGRAM_CALL CONSTANT VARCHAR2(30) := 'CONCURRENT_PROGRAM_CALL' ;
13:
24: PROCEDURE generic_conc_processor
25: (
26: p_payrun_id IN NUMBER,
27: p_params IN conc_params,
28: p_org_id cn_payment_worksheets.org_id%TYPE,
29: p_salesrep_tbl IN salesrep_tab_typ,
30: x_errbuf OUT NOCOPY VARCHAR2,
31: x_retcode OUT NOCOPY NUMBER
32: );