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.JTF_RS_ROLE_RELATE_VUHK dependencies on CN_API

Line 247: --l_start_period_id := cn_api.get_acc_period_id(p_start_date);

243: -- get org id
244: l_org_id := mo_global.get_current_org_id;
245:
246: -- bug 1942390 hlchen
247: --l_start_period_id := cn_api.get_acc_period_id(p_start_date);
248: l_start_period_id := cn_api.get_acc_period_id_fo(p_start_date, l_org_id);
249: l_end_period_id := cn_api.get_acc_period_id(p_end_date, l_org_id);
250:
251: debugmsg(' p_start_date = ' || p_start_date ||

Line 248: l_start_period_id := cn_api.get_acc_period_id_fo(p_start_date, l_org_id);

244: l_org_id := mo_global.get_current_org_id;
245:
246: -- bug 1942390 hlchen
247: --l_start_period_id := cn_api.get_acc_period_id(p_start_date);
248: l_start_period_id := cn_api.get_acc_period_id_fo(p_start_date, l_org_id);
249: l_end_period_id := cn_api.get_acc_period_id(p_end_date, l_org_id);
250:
251: debugmsg(' p_start_date = ' || p_start_date ||
252: ' p_end_date = ' || p_end_date ||

Line 249: l_end_period_id := cn_api.get_acc_period_id(p_end_date, l_org_id);

245:
246: -- bug 1942390 hlchen
247: --l_start_period_id := cn_api.get_acc_period_id(p_start_date);
248: l_start_period_id := cn_api.get_acc_period_id_fo(p_start_date, l_org_id);
249: l_end_period_id := cn_api.get_acc_period_id(p_end_date, l_org_id);
250:
251: debugmsg(' p_start_date = ' || p_start_date ||
252: ' p_end_date = ' || p_end_date ||
253: ' l_start_period_id = ' || l_start_period_id ||

Line 647: l_srp_start_period_id := cn_api.get_acc_period_id(srp_role.start_date, srp_role.org_id);

643:
644: IF l_count = 0 THEN
645: -- There is comp plan for the resource. Need to check if there is a worksheet. If there is a worksheet
646: -- then throw exception
647: l_srp_start_period_id := cn_api.get_acc_period_id(srp_role.start_date, srp_role.org_id);
648: l_salesrep_id := srp_role.salesrep_id;
649:
650:
651:

Line 671: SELECT cn_api.get_acc_period_id(prd.end_date, srp_role.org_id)

667: AND prun.org_id = w.org_id
668: AND w.org_id = srp_role.org_id;
669:
670: -- get the period's end date of max(pay_date) payruns
671: SELECT cn_api.get_acc_period_id(prd.end_date, srp_role.org_id)
672: into l_pay_run_period_id
673: FROM cn_payment_worksheets W, cn_period_statuses prd, cn_payruns prun
674: WHERE w.salesrep_id = l_salesrep_id
675: AND w.org_id = srp_role.org_id

Line 994: l_date_range_action_tbl cn_api.date_range_action_tbl_type;

990: l_team_id NUMBER;
991: l_team_name VARCHAR2(30);
992: l_team_event_name VARCHAR(60);
993: l_role_id NUMBER;
994: l_date_range_action_tbl cn_api.date_range_action_tbl_type;
995: l_role_resource_type jtf_rs_role_relations.role_resource_type%TYPE;
996:
997: -- clku, bug 3718575
998: l_resource_category VARCHAR2(30);

Line 1215: cn_api.get_date_range_diff_action

1211: CLOSE team_member_role_relate;
1212: ELSE
1213: CLOSE team_member_role_relate;
1214:
1215: cn_api.get_date_range_diff_action
1216: ( start_date_new => P_START_DATE_ACTIVE
1217: ,end_date_new => P_END_DATE_ACTIVE
1218: ,start_date_old => l_tm_start_date_old
1219: ,end_date_old => l_tm_end_date_old

Line 1419: l_date_range_action_tbl cn_api.date_range_action_tbl_type;

1415: l_count NUMBER;
1416: l_max_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
1417: -- clku, team role enhancement
1418: l_team_event_name VARCHAR(60);
1419: l_date_range_action_tbl cn_api.date_range_action_tbl_type;
1420: l_role_resource_type jtf_rs_role_relations.role_resource_type%TYPE;
1421: l_role_resource_id jtf_rs_role_relations.role_resource_id%TYPE;
1422:
1423: -- Bug 4083951 by mnativ

Line 1650: cn_api.get_date_range_diff_action

1646: IF fnd_profile.value('CN_MARK_EVENTS') = 'Y' THEN
1647: -- Team Member Role section
1648: IF l_role_resource_type = 'RS_TEAM_MEMBER' THEN
1649: IF g_team_id is not null then
1650: cn_api.get_date_range_diff_action
1651: ( start_date_new => P_START_DATE_ACTIVE
1652: ,end_date_new => P_END_DATE_ACTIVE
1653: ,start_date_old => g_tm_start_date_old
1654: ,end_date_old => g_tm_end_date_old

Line 1827: l_date_range_action_tbl cn_api.date_range_action_tbl_type;

1823: l_rr_end_date DATE;
1824: l_team_id NUMBER;
1825: l_team_name VARCHAR2(30);
1826: l_team_event_name VARCHAR(60);
1827: l_date_range_action_tbl cn_api.date_range_action_tbl_type;
1828: l_role_resource_id jtf_rs_role_relations.role_resource_id%TYPE;
1829: l_role_resource_type jtf_rs_role_relations.role_resource_type%TYPE;
1830:
1831: l_orig_org_id NUMBER;

Line 2032: cn_api.get_date_range_diff_action

2028: CLOSE team_member_role_relate;
2029: ELSE
2030: CLOSE team_member_role_relate;
2031:
2032: cn_api.get_date_range_diff_action
2033: ( start_date_new => l_tm_start_date
2034: ,end_date_new => l_tm_end_date
2035: ,start_date_old => l_rr_start_date
2036: ,end_date_old => l_rr_end_date

Line 2175: l_date_range_action_tbl cn_api.date_range_action_tbl_type;

2171: l_max_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
2172: --clku, team member rs role mark event
2173:
2174: l_team_event_name VARCHAR(60);
2175: l_date_range_action_tbl cn_api.date_range_action_tbl_type;
2176: l_role_resource_type jtf_rs_role_relations.role_resource_type%TYPE;
2177: l_role_resource_id jtf_rs_role_relations.role_resource_id%TYPE;
2178:
2179: -- get the salesrep ID's, org ID's

Line 2308: cn_api.get_date_range_diff_action

2304: CLOSE payee_role_info;
2305:
2306: g_resource_id := l_role_resource_id; -- for RS_INDIVIDUAL
2307:
2308: cn_api.get_date_range_diff_action
2309: (start_date_new => P_START_DATE_ACTIVE,
2310: end_date_new => P_END_DATE_ACTIVE,
2311: start_date_old => g_start_date_old,
2312: end_date_old => g_end_date_old,

Line 2322: IF CN_API.date_range_overlap

2318: -- the deleting paygroup date range
2319: For l_payee_assign_date_rec IN payee_assign_date_curs(l_salesrep_id) LOOP
2320: -- check if there is any date range over between
2321: -- srp paygroup date and payee assign date
2322: IF CN_API.date_range_overlap
2323: (l_date_range_action_tbl(i).start_date,
2324: l_date_range_action_tbl(i).end_date,
2325: l_payee_assign_date_rec.start_date,
2326: l_payee_assign_date_rec.end_date) = true THEN

Line 2359: cn_api.get_date_range_diff_action

2355: CLOSE team_member_role_relate;
2356: ELSE
2357: CLOSE team_member_role_relate;
2358:
2359: cn_api.get_date_range_diff_action
2360: ( start_date_new => P_START_DATE_ACTIVE
2361: ,end_date_new => P_END_DATE_ACTIVE
2362: ,start_date_old => g_tm_start_date_old
2363: ,end_date_old => g_tm_end_date_old