APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on DBMS_SQL

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

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

Line 1024: l_applied_pgc dbms_sql.varchar2_table;

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