APPS.PA_DCTN_APRV_NOTIFICATION dependencies on PA_DEDUCTIONS

Line 845: l_deduction_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE;

841: ,actid IN NUMBER
842: ,funcmode IN VARCHAR2
843: ,resultout OUT NOCOPY VARCHAR2) IS
844:
845: l_deduction_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE;
846: l_dctn_rec_info PA_DEDUCTIONS.cur_dctn_hdr_info%ROWTYPE;
847:
848: CURSOR C1(c_dctn_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE) IS
849: SELECT * FROM PA_DEDUCTIONS_ALL WHERE deduction_req_num = c_dctn_req_num;

Line 846: l_dctn_rec_info PA_DEDUCTIONS.cur_dctn_hdr_info%ROWTYPE;

842: ,funcmode IN VARCHAR2
843: ,resultout OUT NOCOPY VARCHAR2) IS
844:
845: l_deduction_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE;
846: l_dctn_rec_info PA_DEDUCTIONS.cur_dctn_hdr_info%ROWTYPE;
847:
848: CURSOR C1(c_dctn_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE) IS
849: SELECT * FROM PA_DEDUCTIONS_ALL WHERE deduction_req_num = c_dctn_req_num;
850:

Line 848: CURSOR C1(c_dctn_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE) IS

844:
845: l_deduction_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE;
846: l_dctn_rec_info PA_DEDUCTIONS.cur_dctn_hdr_info%ROWTYPE;
847:
848: CURSOR C1(c_dctn_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE) IS
849: SELECT * FROM PA_DEDUCTIONS_ALL WHERE deduction_req_num = c_dctn_req_num;
850:
851: l_msg_count NUMBER;
852: l_msg_data VARCHAR2(4000);

Line 849: SELECT * FROM PA_DEDUCTIONS_ALL WHERE deduction_req_num = c_dctn_req_num;

845: l_deduction_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE;
846: l_dctn_rec_info PA_DEDUCTIONS.cur_dctn_hdr_info%ROWTYPE;
847:
848: CURSOR C1(c_dctn_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE) IS
849: SELECT * FROM PA_DEDUCTIONS_ALL WHERE deduction_req_num = c_dctn_req_num;
850:
851: l_msg_count NUMBER;
852: l_msg_data VARCHAR2(4000);
853: l_return_status VARCHAR2(4000);

Line 866: PA_DEDUCTIONS.Submit_For_DebitMemo

862: OPEN C1(l_deduction_req_num);
863: FETCH C1 INTO l_dctn_rec_info;
864: CLOSE C1;
865:
866: PA_DEDUCTIONS.Submit_For_DebitMemo
867: (l_dctn_rec_info
868: ,l_msg_count
869: ,l_msg_data
870: ,l_return_status);