APPS.CN_API dependencies on JTF_VARCHAR2_TABLE_2000

Line 3216: l_cnw_srp_salrep_id JTF_VARCHAR2_TABLE_2000;

3212: AND srp.quota_id <> -1000
3213: AND srp.org_id = p_ORG_ID
3214: AND srp.salesrep_id = cnw.SALESREP_ID;
3215:
3216: l_cnw_srp_salrep_id JTF_VARCHAR2_TABLE_2000;
3217:
3218: CURSOR get_role_cursor
3219: IS
3220: SELECT /*+ leading(cnw_srp,assign) use_nl(assign,rl) */ DISTINCT

Line 3228: FROM TABLE(CAST(l_cnw_srp_salrep_id AS JTF_VARCHAR2_TABLE_2000))

3224: (SELECT TO_NUMBER(SUBSTR(column_value, 1, INSTR(column_value, '-', 1, 1) - 1 ) ) SALESREP_ID,
3225: TO_NUMBER(SUBSTR(column_value , INSTR(column_value, '-', 1, 1) + 1,
3226: (INSTR(column_value, '-', 1, 2) - INSTR(column_value, '-', 1, 1))-1) ) PLANASSIGNID,
3227: TO_NUMBER(SUBSTR(column_value , INSTR(column_value, '-', 1, 2) + 1 ,LENGTH(column_value) )) PERIOD_ID
3228: FROM TABLE(CAST(l_cnw_srp_salrep_id AS JTF_VARCHAR2_TABLE_2000))
3229: ) cnw_srp
3230: WHERE assign.ORG_ID = p_ORG_ID
3231: AND assign.srp_plan_assign_id(+) = cnw_srp.PLANASSIGNID
3232: AND assign.salesrep_id(+) = cnw_srp.SALESREP_ID

Line 3240: l_role_name_tbl JTF_VARCHAR2_TABLE_2000;

3236:
3237:
3238: l_salesrep_id_tbl JTF_NUMBER_TABLE;
3239: l_period_tbl JTF_NUMBER_TABLE;
3240: l_role_name_tbl JTF_VARCHAR2_TABLE_2000;
3241: l_start_date_tbl JTF_DATE_TABLE;
3242: l_sales_id_tbl JTF_NUMBER_TABLE;
3243:
3244: l_role_name_cache VARCHAR2(2000);

Line 3273: l_role_name_tbl :=JTF_VARCHAR2_TABLE_2000();

3269: IF populate =1
3270: THEN
3271: l_salesrep_id_tbl :=JTF_NUMBER_TABLE();
3272: l_period_tbl :=JTF_NUMBER_TABLE();
3273: l_role_name_tbl :=JTF_VARCHAR2_TABLE_2000();
3274: l_start_date_tbl :=JTF_DATE_TABLE();
3275: l_sales_id_tbl :=JTF_NUMBER_TABLE();
3276: l_cnw_salesrep_id := JTF_NUMBER_TABLE();
3277: l_cnw_srp_salrep_id :=JTF_VARCHAR2_TABLE_2000();

Line 3277: l_cnw_srp_salrep_id :=JTF_VARCHAR2_TABLE_2000();

3273: l_role_name_tbl :=JTF_VARCHAR2_TABLE_2000();
3274: l_start_date_tbl :=JTF_DATE_TABLE();
3275: l_sales_id_tbl :=JTF_NUMBER_TABLE();
3276: l_cnw_salesrep_id := JTF_NUMBER_TABLE();
3277: l_cnw_srp_salrep_id :=JTF_VARCHAR2_TABLE_2000();
3278:
3279: OPEN C_GET_SALESREP_ID;
3280: FETCH C_GET_SALESREP_ID BULK COLLECT INTO l_cnw_salesrep_id;
3281: CLOSE C_GET_SALESREP_ID;