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_PAYMENT_SECURITY_PVT dependencies on CN_PAYRUNS

Line 36: FROM cn_payruns

32:
33: ELSIF p_type = 'PAYRUN' THEN
34: SELECT payrun_id, object_version_number
35: INTO l_obj_id, l_ovn
36: FROM cn_payruns
37: WHERE payrun_id = p_payrun_id ;
38:
39: l_key := p_event_name || '-' || l_obj_id || '-' || l_ovn ;
40: wf_event.AddParameterToList('PAYRUN_ID' , p_payrun_id, l_list);

Line 71: from cn_payruns

67: l_ret_val varchar2(1) ;
68: BEGIN
69: select payrun_mode
70: into l_ret_val
71: from cn_payruns
72: where payrun_id = p_payrun_id ;
73:
74: IF l_ret_val NOT IN ('Y','N')
75: THEN

Line 255: FROM cn_payruns

251:
252: CURSOR getobj
253: IS
254: SELECT object_version_number
255: FROM cn_payruns
256: WHERE payrun_id = p_payrun_id;
257: BEGIN
258: -- Initialize API return status to success
259: x_return_status := fnd_api.g_ret_sts_success;

Line 310: cn_payruns_pkg.UPDATE_RECORD (x_payrun_id => p_payrun_id,

306: RAISE fnd_api.g_exc_error;
307: END IF;
308:
309: -- update payrun status='PAID'
310: cn_payruns_pkg.UPDATE_RECORD (x_payrun_id => p_payrun_id,
311: x_status => 'PAID',
312: x_last_updated_by => fnd_global.user_id,
313: x_last_update_date => SYSDATE,
314: x_last_update_login => fnd_global.login_id,

Line 354: l_new_status cn_payruns.status%TYPE := NULL;

350: x_msg_data OUT NOCOPY VARCHAR2
351: )
352: IS
353: l_api_name CONSTANT VARCHAR2 (30) := 'Payrun_Audit';
354: l_new_status cn_payruns.status%TYPE := NULL;
355: l_loading_status VARCHAR2 (30);
356: l_ovn NUMBER;
357: l_has_access BOOLEAN;
358: l_event_name VARCHAR2 (30);

Line 362: FROM cn_payruns

358: l_event_name VARCHAR2 (30);
359: CURSOR getobj
360: IS
361: SELECT object_version_number
362: FROM cn_payruns
363: WHERE payrun_id = p_payrun_id;
364: BEGIN
365: -- Initialize API return status to success
366: x_return_status := fnd_api.g_ret_sts_success;

Line 431: cn_payruns_pkg.UPDATE_RECORD (x_payrun_id => p_payrun_id,

427: --Added for R12 payment security check end.
428: l_new_status := 'UNPAID';
429: END IF;
430:
431: cn_payruns_pkg.UPDATE_RECORD (x_payrun_id => p_payrun_id,
432: x_status => l_new_status,
433: x_last_updated_by => fnd_global.user_id,
434: x_last_update_date => SYSDATE,
435: x_last_update_login => fnd_global.login_id,

Line 637: p_source_object_code => 'CN_PAYRUNS',

633: x_return_status => x_return_status,
634: x_msg_count => x_msg_count,
635: x_msg_data => x_msg_data,
636: p_source_object_id => p_payrun_id,
637: p_source_object_code => 'CN_PAYRUNS',
638: p_notes => l_note_msg,
639: p_notes_detail => l_note_msg,
640: p_note_type => 'CN_SYSGEN', -- for system generated
641: x_jtf_note_id => l_note_id -- returned

Line 707: l_payrun_status cn_payruns.status%TYPE;

703: IS
704: l_api_name CONSTANT VARCHAR2 (30) := 'Payrun_Action';
705: l_api_version CONSTANT NUMBER := 1.0;
706: l_period_id cn_period_statuses.period_id%TYPE;
707: l_payrun_status cn_payruns.status%TYPE;
708: l_tmp NUMBER;
709: l_temp NUMBER ;
710:
711: CURSOR c

Line 714: FROM cn_payruns

710:
711: CURSOR c
712: IS
713: SELECT status
714: FROM cn_payruns
715: WHERE payrun_id = p_payrun_id
716: FOR UPDATE OF status NOWAIT
717: ;
718:

Line 758: FROM cn_payruns

754: SELECT pay_period_id,
755: status
756: INTO l_period_id,
757: l_payrun_status
758: FROM cn_payruns
759: WHERE payrun_id = p_payrun_id;
760: EXCEPTION
761: WHEN NO_DATA_FOUND
762: THEN

Line 1055: l_payrun_status cn_payruns.status%TYPE;

1051: l_api_version CONSTANT NUMBER := 1.0;
1052: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1053: l_period_id cn_period_statuses.period_id%TYPE;
1054: l_worksheet_rec cn_payment_worksheets%ROWTYPE;
1055: l_payrun_status cn_payruns.status%TYPE;
1056: l_pay_period_id cn_payruns.pay_period_id%TYPE;
1057: l_assigned_to_user_id cn_salesreps.assigned_to_user_id%TYPE := NULL;
1058: l_tmp NUMBER;
1059: l_org_id NUMBER;

Line 1056: l_pay_period_id cn_payruns.pay_period_id%TYPE;

1052: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1053: l_period_id cn_period_statuses.period_id%TYPE;
1054: l_worksheet_rec cn_payment_worksheets%ROWTYPE;
1055: l_payrun_status cn_payruns.status%TYPE;
1056: l_pay_period_id cn_payruns.pay_period_id%TYPE;
1057: l_assigned_to_user_id cn_salesreps.assigned_to_user_id%TYPE := NULL;
1058: l_tmp NUMBER;
1059: l_org_id NUMBER;
1060:

Line 1062: c_payrun_id cn_payruns.payrun_id%TYPE

1058: l_tmp NUMBER;
1059: l_org_id NUMBER;
1060:
1061: CURSOR c (
1062: c_payrun_id cn_payruns.payrun_id%TYPE
1063: )
1064: IS
1065: SELECT status
1066: FROM cn_payruns

Line 1066: FROM cn_payruns

1062: c_payrun_id cn_payruns.payrun_id%TYPE
1063: )
1064: IS
1065: SELECT status
1066: FROM cn_payruns
1067: WHERE payrun_id = c_payrun_id
1068: --FOR UPDATE OF status NOWAIT
1069: ;
1070:

Line 1121: cn_payruns pay,

1117: l_pay_period_id,
1118: l_assigned_to_user_id,
1119: l_org_id
1120: FROM cn_payment_worksheets wk,
1121: cn_payruns pay,
1122: cn_salesreps s
1123: WHERE wk.payment_worksheet_id = p_worksheet_id
1124: AND pay.payrun_id = wk.payrun_id
1125: AND s.salesrep_id = wk.salesrep_id

Line 1698: WHERE pr.period_id = (SELECT p1.pay_period_id FROM cn_payruns p1 WHERE p1.payrun_id = p_payrun_id)

1694: SELECT DECODE( (SELECT 1 FROM dual WHERE EXISTS ( SELECT 1
1695: FROM jtf_rs_group_usages u2,jtf_rs_rep_managers m2,jtf_rs_resource_extns_vl re2,
1696: (SELECT DISTINCT m1.resource_id, GREATEST(pr.start_date,m1.start_date_active) start_date,LEAST(pr.end_date,Nvl(m1.end_date_active,pr.end_date)) end_date
1697: FROM cn_period_statuses pr,jtf_rs_group_usages u1, jtf_rs_rep_managers m1
1698: WHERE pr.period_id = (SELECT p1.pay_period_id FROM cn_payruns p1 WHERE p1.payrun_id = p_payrun_id)
1699: AND pr.org_id =(SELECT org_id FROM cn_payruns where payrun_id=p_payrun_id)
1700: AND u1.usage = 'COMP_PAYMENT'
1701: AND m1.resource_id = ( SELECT resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id)
1702: AND ((m1.start_date_active <= pr.end_date) AND (pr.start_date <= Nvl(m1.end_date_active,pr.start_date)))

Line 1699: AND pr.org_id =(SELECT org_id FROM cn_payruns where payrun_id=p_payrun_id)

1695: FROM jtf_rs_group_usages u2,jtf_rs_rep_managers m2,jtf_rs_resource_extns_vl re2,
1696: (SELECT DISTINCT m1.resource_id, GREATEST(pr.start_date,m1.start_date_active) start_date,LEAST(pr.end_date,Nvl(m1.end_date_active,pr.end_date)) end_date
1697: FROM cn_period_statuses pr,jtf_rs_group_usages u1, jtf_rs_rep_managers m1
1698: WHERE pr.period_id = (SELECT p1.pay_period_id FROM cn_payruns p1 WHERE p1.payrun_id = p_payrun_id)
1699: AND pr.org_id =(SELECT org_id FROM cn_payruns where payrun_id=p_payrun_id)
1700: AND u1.usage = 'COMP_PAYMENT'
1701: AND m1.resource_id = ( SELECT resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id)
1702: AND ((m1.start_date_active <= pr.end_date) AND (pr.start_date <= Nvl(m1.end_date_active,pr.start_date)))
1703: AND u1.group_id = m1.group_id