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_API dependencies on JTF_NUMBER_TABLE

Line 24: g_user_tab jtf_number_table;

20: g_salesrep_info_cache salesrep_cache_tbl_type;
21:
22:
23:
24: g_user_tab jtf_number_table;
25:
26: --| ----------------------------------------------------------------------+
27: --| Procedure Name : get_fnd_message
28: --| ----------------------------------------------------------------------+

Line 3203: l_cnw_salesrep_id JTF_NUMBER_TABLE;

3199: WHERE cnw.payrun_id = p_payrun_id
3200: AND cnw.org_id = p_ORG_ID
3201: AND cnw.quota_id IS NULL ;
3202:
3203: l_cnw_salesrep_id JTF_NUMBER_TABLE;
3204:
3205: CURSOR C_SRP_ASSIGN_ID
3206: IS
3207: SELECT /*+ leading(cnw,srp) use_nl(srp) */ DISTINCT

Line 3210: (SELECT column_value SALESREP_ID FROM TABLE(CAST(l_cnw_salesrep_id AS JTF_NUMBER_TABLE))) cnw

3206: IS
3207: SELECT /*+ leading(cnw,srp) use_nl(srp) */ DISTINCT
3208: srp.salesrep_id ||'-' ||srp_plan_assign_id ||'-' ||srp.period_id
3209: FROM cn_srp_periods srp,
3210: (SELECT column_value SALESREP_ID FROM TABLE(CAST(l_cnw_salesrep_id AS JTF_NUMBER_TABLE))) cnw
3211: WHERE srp.period_id = p_period_id
3212: AND srp.quota_id <> -1000
3213: AND srp.org_id = p_ORG_ID
3214: AND srp.salesrep_id = cnw.SALESREP_ID;

Line 3238: l_salesrep_id_tbl JTF_NUMBER_TABLE;

3234: AND rl.role_type_code = 'SALES_COMP'
3235: ORDER BY assign.start_date;
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;

Line 3239: l_period_tbl JTF_NUMBER_TABLE;

3235: ORDER BY assign.start_date;
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:

Line 3242: l_sales_id_tbl JTF_NUMBER_TABLE;

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);
3245: l_html_text VARCHAR2(2000);
3246: l_role_str VARCHAR2(2000):= '';

Line 3271: l_salesrep_id_tbl :=JTF_NUMBER_TABLE();

3267:
3268:
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();

Line 3272: l_period_tbl :=JTF_NUMBER_TABLE();

3268:
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();

Line 3275: l_sales_id_tbl :=JTF_NUMBER_TABLE();

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();
3278:
3279: OPEN C_GET_SALESREP_ID;

Line 3276: l_cnw_salesrep_id := 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();
3278:
3279: OPEN C_GET_SALESREP_ID;
3280: FETCH C_GET_SALESREP_ID BULK COLLECT INTO l_cnw_salesrep_id;

Line 3338: RETURN jtf_number_table IS

3334:
3335:
3336:
3337: FUNCTION get_user(p_user_id NUMBER DEFAULT NULL,p_payrun_id NUMBER DEFAULT NULL)
3338: RETURN jtf_number_table IS
3339:
3340: CURSOR C_USER(l_user_id number,l_payrun_id number)
3341: is
3342: SELECT DISTINCT re2.user_id

Line 3377: l_user_tab jtf_number_table;

3373: AND m2.hierarchy_type IN ('MGR_TO_MGR', 'MGR_TO_REP', 'REP_TO_REP')
3374: AND m2.resource_id = re2.resource_id;
3375:
3376:
3377: l_user_tab jtf_number_table;
3378: l_user_id number;
3379: l_payrun_id number;
3380: l_found boolean;
3381:

Line 3384: --G_USER_TAB := jtf_number_table();

3380: l_found boolean;
3381:
3382: Begin
3383:
3384: --G_USER_TAB := jtf_number_table();
3385:
3386: l_found := FALSE;
3387:
3388: IF g_user_tab.COUNT > 0 THEN

Line 3395: l_user_tab := jtf_number_table();

3391: END IF;
3392:
3393: IF NOT l_found
3394: THEN
3395: l_user_tab := jtf_number_table();
3396:
3397: OPEN c_user(p_user_id,p_payrun_id);
3398: FETCH c_user BULK COLLECT INTO l_user_tab;
3399: CLOSE c_user;

Line 3445: l_user_tab jtf_number_table;

3441: AND m2.category <> 'TBH'
3442: AND m2.hierarchy_type IN ('MGR_TO_MGR', 'MGR_TO_REP', 'REP_TO_REP')
3443: AND m2.resource_id = re2.resource_id;
3444:
3445: l_user_tab jtf_number_table;
3446:
3447: begin
3448:
3449: l_user_tab := jtf_number_table();

Line 3449: l_user_tab := jtf_number_table();

3445: l_user_tab jtf_number_table;
3446:
3447: begin
3448:
3449: l_user_tab := jtf_number_table();
3450: G_USER_TAB := jtf_number_table();
3451:
3452: OPEN c_user(p_user_id,p_payrun_id);
3453: FETCH c_user BULK COLLECT INTO l_user_tab;

Line 3450: G_USER_TAB := jtf_number_table();

3446:
3447: begin
3448:
3449: l_user_tab := jtf_number_table();
3450: G_USER_TAB := jtf_number_table();
3451:
3452: OPEN c_user(p_user_id,p_payrun_id);
3453: FETCH c_user BULK COLLECT INTO l_user_tab;
3454: CLOSE c_user;