APPS.IGI_IMP_IAC_EXPORT_PKG dependencies on IGI_IMP_IAC_INTERFACE

Line 63: p_book IN IGI_IMP_IAC_INTERFACE.book_type_code%type,

59: /* Main Process */
60: PROCEDURE Export_data_process(
61: errbuf OUT NOCOPY varchar2 ,
62: retcode OUT NOCOPY number,
63: p_book IN IGI_IMP_IAC_INTERFACE.book_type_code%type,
64: p_category_id IN IGI_IMP_IAC_INTERFACE.category_id%type,
65: category_name IN varchar2) IS
66:
67: /* Cursor to get all the groups for a book and category_id */

Line 64: p_category_id IN IGI_IMP_IAC_INTERFACE.category_id%type,

60: PROCEDURE Export_data_process(
61: errbuf OUT NOCOPY varchar2 ,
62: retcode OUT NOCOPY number,
63: p_book IN IGI_IMP_IAC_INTERFACE.book_type_code%type,
64: p_category_id IN IGI_IMP_IAC_INTERFACE.category_id%type,
65: category_name IN varchar2) IS
66:
67: /* Cursor to get all the groups for a book and category_id */
68: Cursor c_get_groups is

Line 69: Select distinct group_id from igi_imp_iac_interface

65: category_name IN varchar2) IS
66:
67: /* Cursor to get all the groups for a book and category_id */
68: Cursor c_get_groups is
69: Select distinct group_id from igi_imp_iac_interface
70: where book_type_code = p_book and
71: category_id = p_category_id;
72:
73:

Line 80: -- l_bookname_sans_spaces IGI_IMP_IAC_INTERFACE.book_type_code%type; -- Bug 2843747 (Tpradhan) - Commented since no longer required

76: l_fname_with_locn varchar2(1000);
77: l_request_id NUMBER;
78: l_message varchar2(1000);
79: l_gp_present_chk_flag varchar2(1);
80: -- l_bookname_sans_spaces IGI_IMP_IAC_INTERFACE.book_type_code%type; -- Bug 2843747 (Tpradhan) - Commented since no longer required
81: l_file_loc varchar2(1000);
82:
83: IGI_IMP_IAC_GROUP_NOTFOUND Exception;
84: IGI_IAC_REQUEST_SUB_ERR Exception;

Line 236: /* Update the igi_imp_iac_interface table with the export details */

232: raise IGI_IAC_REQUEST_SUB_ERR;
233: ELSE
234: commit;
235: /* Bug No : 2497429 sowsubra start storing the entire directory path for export file instead of just the file name */
236: /* Update the igi_imp_iac_interface table with the export details */
237: update igi_imp_iac_interface set export_file=l_fname_with_locn ,export_date=trunc(sysdate)
238: where book_type_code = p_book and
239: category_id = p_category_id and
240: group_id =l_get_groups.group_id;

Line 237: update igi_imp_iac_interface set export_file=l_fname_with_locn ,export_date=trunc(sysdate)

233: ELSE
234: commit;
235: /* Bug No : 2497429 sowsubra start storing the entire directory path for export file instead of just the file name */
236: /* Update the igi_imp_iac_interface table with the export details */
237: update igi_imp_iac_interface set export_file=l_fname_with_locn ,export_date=trunc(sysdate)
238: where book_type_code = p_book and
239: category_id = p_category_id and
240: group_id =l_get_groups.group_id;
241: /* Bug No:2497429 sowsubra end */