APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on DBMS_SQL

Line 486: p_applied_pgc IN dbms_sql.varchar2_table, --bug 3198445 by jjhuang.

482: p_salesrep_id IN cn_payment_worksheets.salesrep_id%TYPE,
483: p_incentive_type IN cn_payruns.incentive_type_code%TYPE,
484: p_payrun_id IN cn_payruns.payrun_id%TYPE,
485: p_payment_group_code IN cn_pmt_plans.payment_group_code%TYPE, --bug 3175375 by jjhuang.
486: p_applied_pgc IN dbms_sql.varchar2_table, --bug 3198445 by jjhuang.
487: x_calc_rec_tbl IN OUT NOCOPY calc_rec_tbl_type,
488: --R12
489: p_org_id IN cn_payruns.org_id%TYPE
490: ) IS

Line 1022: l_applied_pgc dbms_sql.varchar2_table;

1018: l_pmt_plan_count NUMBER := 0;
1019: -- varialve added for Bug 3140343
1020: l_ispayee NUMBER := 0;
1021: --Bug 3198445 by jjhuang
1022: l_applied_pgc dbms_sql.varchar2_table;
1023: l_applied_pgc_count NUMBER;
1024: BEGIN
1025: --
1026: -- get quarter Number and Year Number