APPS.CN_PAYMENT_SECURITY_PVT dependencies on CN_PAYMENT_WORKSHEETS

Line 23: FROM cn_payment_worksheets

19: BEGIN
20: IF p_type = 'WORKSHEET' THEN
21: SELECT payment_worksheet_id, object_version_number
22: INTO l_obj_id, l_ovn
23: FROM cn_payment_worksheets
24: WHERE payrun_id = p_payrun_id
25: AND salesrep_id = p_salesrep_id
26: AND quota_id IS NULL ;
27:

Line 245: FROM cn_payment_worksheets

241:
242: CURSOR c_wksht_csr
243: IS
244: SELECT payment_worksheet_id
245: FROM cn_payment_worksheets
246: WHERE payrun_id = p_payrun_id;
247:
248: --R12
249: l_ovn NUMBER;

Line 287: p_source_object_code => 'CN_PAYMENT_WORKSHEETS',

283: x_return_status => x_return_status,
284: x_msg_count => x_msg_count,
285: x_msg_data => x_msg_data,
286: p_source_object_id => l_wksht_csr.payment_worksheet_id,
287: p_source_object_code => 'CN_PAYMENT_WORKSHEETS',
288: p_notes => l_note_msg,
289: p_notes_detail => l_note_msg,
290: p_note_type => 'CN_SYSGEN', -- for system generated
291: x_jtf_note_id => l_note_id -- returned

Line 480: l_new_status cn_payment_worksheets.worksheet_status%TYPE := NULL;

476: x_msg_data OUT NOCOPY VARCHAR2
477: )
478: IS
479: l_api_name CONSTANT VARCHAR2 (30) := 'Worksheet_Audit';
480: l_new_status cn_payment_worksheets.worksheet_status%TYPE := NULL;
481: l_loading_status VARCHAR2 (30);
482: l_org_id NUMBER;
483: l_has_access BOOLEAN;
484: l_ovn NUMBER ;

Line 610: cn_payment_worksheets_pkg.UPDATE_STATUS (p_salesrep_id => p_salesrep_id,

606: l_event_name := 'reject' ;
607:
608: END IF;
609:
610: cn_payment_worksheets_pkg.UPDATE_STATUS (p_salesrep_id => p_salesrep_id,
611: p_payrun_id => p_payrun_id,
612: p_worksheet_status => l_new_status
613: );
614:

Line 624: p_source_object_code => 'CN_PAYMENT_WORKSHEETS',

620: x_return_status => x_return_status,
621: x_msg_count => x_msg_count,
622: x_msg_data => x_msg_data,
623: p_source_object_id => p_worksheet_id,
624: p_source_object_code => 'CN_PAYMENT_WORKSHEETS',
625: p_notes => l_note_msg,
626: p_notes_detail => l_note_msg,
627: p_note_type => 'CN_SYSGEN', -- for system generated
628: x_jtf_note_id => l_note_id -- returned

Line 724: FROM cn_payment_worksheets

720:
721: CURSOR cw
722: IS
723: SELECT worksheet_status
724: FROM cn_payment_worksheets
725: WHERE payrun_id = p_payrun_id
726: FOR UPDATE OF worksheet_status NOWAIT
727: ;
728:

Line 829: FROM cn_payment_worksheets

825:
826: -- should never perform any payrun action when one of the worksheets is processing
827: SELECT COUNT(1)
828: INTO l_temp
829: FROM cn_payment_worksheets
830: WHERE worksheet_status IN ('PROCESSING', 'FAILED')
831: AND payrun_id = p_payrun_id
832: AND rownum < 2;
833:

Line 927: FROM cn_payment_worksheets

923: SELECT 1
924: INTO l_tmp
925: FROM DUAL
926: WHERE EXISTS (SELECT 1
927: FROM cn_payment_worksheets
928: WHERE payrun_id = p_payrun_id AND worksheet_status <> 'APPROVED');
929:
930: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
931: THEN

Line 1054: l_worksheet_rec cn_payment_worksheets%ROWTYPE;

1050: l_api_name CONSTANT VARCHAR2 (30) := 'Worksheet_action';
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;

Line 1076: FROM cn_payment_worksheets

1072:
1073: CURSOR cw
1074: IS
1075: SELECT worksheet_status
1076: FROM cn_payment_worksheets
1077: WHERE payment_worksheet_id = p_worksheet_id
1078: --FOR UPDATE OF worksheet_status NOWAIT
1079: ;
1080:

Line 1120: FROM cn_payment_worksheets wk,

1116: l_payrun_status,
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