APPS.JTF_RS_IMPORT_USER_PUB dependencies on JTF_RS_UPLOAD_DATA

Line 48: from jtf_rs_upload_data

44:
45: cursor upload_data is
46: select column1, column2, column3, column4, column5, column6, column7, column8,
47: column9, column10, column11, column12, column13, record_no
48: from jtf_rs_upload_data
49: where transaction_no = p_transaction_no;
50:
51: cursor get_mgr_emp_id (p_mgr_user_name fnd_user.user_name%type) is
52: select employee_id

Line 134: l_record_no jtf_rs_upload_data.record_no%type;

130: l_error_flag varchar2(1) := 'N';
131: l_error_flag_resp varchar2(1) := 'N';
132: l_error_flag_role varchar2(1) := 'N';
133: l_error_flag_grp varchar2(1) := 'N';
134: l_record_no jtf_rs_upload_data.record_no%type;
135: l_error_text jtf_rs_upload_data.error_text%type := null;
136:
137: BEGIN
138:

Line 135: l_error_text jtf_rs_upload_data.error_text%type := null;

131: l_error_flag_resp varchar2(1) := 'N';
132: l_error_flag_role varchar2(1) := 'N';
133: l_error_flag_grp varchar2(1) := 'N';
134: l_record_no jtf_rs_upload_data.record_no%type;
135: l_error_text jtf_rs_upload_data.error_text%type := null;
136:
137: BEGIN
138:
139: for i_upload_data in upload_data loop

Line 635: P_TRANSACTION_NO IN JTF_RS_UPLOAD_DATA.TRANSACTION_NO%TYPE,

631: PROCEDURE import_user
632: (P_API_VERSION IN NUMBER,
633: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
634: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
635: P_TRANSACTION_NO IN JTF_RS_UPLOAD_DATA.TRANSACTION_NO%TYPE,
636: P_REQUEST_NO OUT NOCOPY NUMBER,
637: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
638: X_MSG_COUNT OUT NOCOPY NUMBER,
639: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 656: update jtf_rs_upload_data

652: argument1 => p_transaction_no);
653:
654: p_request_no := l_request;
655:
656: update jtf_rs_upload_data
657: set request_id = l_request
658: where transaction_no = p_transaction_no;
659:
660: exception when others then

Line 673: P_TRANSACTION_NO IN JTF_RS_UPLOAD_DATA.TRANSACTION_NO%TYPE,

669:
670: END import_user;
671:
672: procedure update_upload_data (
673: P_TRANSACTION_NO IN JTF_RS_UPLOAD_DATA.TRANSACTION_NO%TYPE,
674: P_RECORD_NO IN JTF_RS_UPLOAD_DATA.RECORD_NO%TYPE,
675: P_PROCESS_STATUS IN JTF_RS_UPLOAD_DATA.PROCESS_STATUS%TYPE,
676: P_ERROR_TEXT IN JTF_RS_UPLOAD_DATA.ERROR_TEXT%TYPE
677: ) IS

Line 674: P_RECORD_NO IN JTF_RS_UPLOAD_DATA.RECORD_NO%TYPE,

670: END import_user;
671:
672: procedure update_upload_data (
673: P_TRANSACTION_NO IN JTF_RS_UPLOAD_DATA.TRANSACTION_NO%TYPE,
674: P_RECORD_NO IN JTF_RS_UPLOAD_DATA.RECORD_NO%TYPE,
675: P_PROCESS_STATUS IN JTF_RS_UPLOAD_DATA.PROCESS_STATUS%TYPE,
676: P_ERROR_TEXT IN JTF_RS_UPLOAD_DATA.ERROR_TEXT%TYPE
677: ) IS
678:

Line 675: P_PROCESS_STATUS IN JTF_RS_UPLOAD_DATA.PROCESS_STATUS%TYPE,

671:
672: procedure update_upload_data (
673: P_TRANSACTION_NO IN JTF_RS_UPLOAD_DATA.TRANSACTION_NO%TYPE,
674: P_RECORD_NO IN JTF_RS_UPLOAD_DATA.RECORD_NO%TYPE,
675: P_PROCESS_STATUS IN JTF_RS_UPLOAD_DATA.PROCESS_STATUS%TYPE,
676: P_ERROR_TEXT IN JTF_RS_UPLOAD_DATA.ERROR_TEXT%TYPE
677: ) IS
678:
679: pragma autonomous_transaction;

Line 676: P_ERROR_TEXT IN JTF_RS_UPLOAD_DATA.ERROR_TEXT%TYPE

672: procedure update_upload_data (
673: P_TRANSACTION_NO IN JTF_RS_UPLOAD_DATA.TRANSACTION_NO%TYPE,
674: P_RECORD_NO IN JTF_RS_UPLOAD_DATA.RECORD_NO%TYPE,
675: P_PROCESS_STATUS IN JTF_RS_UPLOAD_DATA.PROCESS_STATUS%TYPE,
676: P_ERROR_TEXT IN JTF_RS_UPLOAD_DATA.ERROR_TEXT%TYPE
677: ) IS
678:
679: pragma autonomous_transaction;
680: begin

Line 682: update jtf_rs_upload_data

678:
679: pragma autonomous_transaction;
680: begin
681:
682: update jtf_rs_upload_data
683: set error_text = p_error_text,
684: process_status = p_process_status
685: where transaction_no = p_transaction_no
686: and record_no = p_record_no;