120:
121: PROCEDURE Generate_Message;
122:
123: PROCEDURE Create_Batch(
124: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
125: retcode OUT NOCOPY NUMBER , -- Request standard return status
126: p_batch_type IN VARCHAR2, -- Batch type E(ev), I(international)
127: p_validate_only IN VARCHAR2, -- Validate only flag 'Y' 'N'
128: p_org_id IN VARCHAR2,
121: PROCEDURE Generate_Message;
122:
123: PROCEDURE Create_Batch(
124: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
125: retcode OUT NOCOPY NUMBER , -- Request standard return status
126: p_batch_type IN VARCHAR2, -- Batch type E(ev), I(international)
127: p_validate_only IN VARCHAR2, -- Validate only flag 'Y' 'N'
128: p_org_id IN VARCHAR2,
129: p_dso_id IN VARCHAR2,
131: p_org_party_id IN NUMBER
132: ) ;
133:
134: PROCEDURE Purge_Batch(
135: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
136: retcode OUT NOCOPY NUMBER , -- Request standard return status
137: p_batch_type IN VARCHAR2 -- Batch type E(ev), I(international)
138: ) ;
139:
132: ) ;
133:
134: PROCEDURE Purge_Batch(
135: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
136: retcode OUT NOCOPY NUMBER , -- Request standard return status
137: p_batch_type IN VARCHAR2 -- Batch type E(ev), I(international)
138: ) ;
139:
140: PROCEDURE Insert_Summary_Info(
10194: ------------------------------------------------------------------------
10195: mmkumar 12-Sep-2005 Added one more parameter for p_org_id
10196: ******************************************************************/
10197: PROCEDURE EV_Batch_Process(
10198: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
10199: retcode OUT NOCOPY NUMBER , -- Request standard return status
10200: p_validate_only IN VARCHAR2, -- Validate only flag 'Y' 'N'
10201: p_org_id IN VARCHAR2,
10202: p_dso_id IN VARCHAR2
10195: mmkumar 12-Sep-2005 Added one more parameter for p_org_id
10196: ******************************************************************/
10197: PROCEDURE EV_Batch_Process(
10198: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
10199: retcode OUT NOCOPY NUMBER , -- Request standard return status
10200: p_validate_only IN VARCHAR2, -- Validate only flag 'Y' 'N'
10201: p_org_id IN VARCHAR2,
10202: p_dso_id IN VARCHAR2
10203: )
10351: ------------------------------------------------------------------------
10352: mmkumar 12-Sep-2005 SEVIS 5 uptake, Added new parameter for Org ID
10353: ******************************************************************/
10354: PROCEDURE Create_Batch(
10355: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
10356: retcode OUT NOCOPY NUMBER , -- Request standard return status
10357: p_batch_type IN VARCHAR2, -- Batch type E(ev), I(international), B (both)
10358: p_validate_only IN VARCHAR2, -- Validate only flag 'Y' 'N'
10359: p_org_id IN VARCHAR2,
10352: mmkumar 12-Sep-2005 SEVIS 5 uptake, Added new parameter for Org ID
10353: ******************************************************************/
10354: PROCEDURE Create_Batch(
10355: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
10356: retcode OUT NOCOPY NUMBER , -- Request standard return status
10357: p_batch_type IN VARCHAR2, -- Batch type E(ev), I(international), B (both)
10358: p_validate_only IN VARCHAR2, -- Validate only flag 'Y' 'N'
10359: p_org_id IN VARCHAR2,
10360: p_dso_id IN VARCHAR2,
11400: ------------------------------------------------------------------------
11401:
11402: ******************************************************************/
11403: PROCEDURE NIMG_Batch_Process(
11404: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
11405: retcode OUT NOCOPY NUMBER , -- Request standard return status
11406: p_validate_only IN VARCHAR2, -- Validate only flag 'Y' 'N'
11407: p_org_id IN VARCHAR2,
11408: p_dso_id IN VARCHAR2
11401:
11402: ******************************************************************/
11403: PROCEDURE NIMG_Batch_Process(
11404: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
11405: retcode OUT NOCOPY NUMBER , -- Request standard return status
11406: p_validate_only IN VARCHAR2, -- Validate only flag 'Y' 'N'
11407: p_org_id IN VARCHAR2,
11408: p_dso_id IN VARCHAR2
11409: ) IS
11489: ------------------------------------------------------------------------
11490:
11491: ******************************************************************/
11492: PROCEDURE Purge_Batch(
11493: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
11494: retcode OUT NOCOPY NUMBER , -- Request standard return status
11495: p_batch_type IN VARCHAR2 -- Batch type E(ev), I(international)
11496: ) IS
11497:
11490:
11491: ******************************************************************/
11492: PROCEDURE Purge_Batch(
11493: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
11494: retcode OUT NOCOPY NUMBER , -- Request standard return status
11495: p_batch_type IN VARCHAR2 -- Batch type E(ev), I(international)
11496: ) IS
11497:
11498: l_api_name CONSTANT VARCHAR2(25) := 'Purge_Batch';
11598: ------------------------------------------------------------------------
11599:
11600: ******************************************************************/
11601: PROCEDURE EV_Purge_Batch (
11602: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
11603: retcode OUT NOCOPY NUMBER -- Request standard return status
11604: ) IS
11605: l_api_name CONSTANT VARCHAR2(30) := 'EV_Purge_Batch';
11606: l_return_status VARCHAR2(1);
11599:
11600: ******************************************************************/
11601: PROCEDURE EV_Purge_Batch (
11602: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
11603: retcode OUT NOCOPY NUMBER -- Request standard return status
11604: ) IS
11605: l_api_name CONSTANT VARCHAR2(30) := 'EV_Purge_Batch';
11606: l_return_status VARCHAR2(1);
11607: l_msg_count NUMBER;
11658: ------------------------------------------------------------------------
11659:
11660: ******************************************************************/
11661: PROCEDURE NIMG_Purge_Batch (
11662: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
11663: retcode OUT NOCOPY NUMBER -- Request standard return status
11664: ) IS
11665: l_api_name CONSTANT VARCHAR2(30) := 'NIMG_Purge_Batch';
11666: l_return_status VARCHAR2(1);
11659:
11660: ******************************************************************/
11661: PROCEDURE NIMG_Purge_Batch (
11662: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
11663: retcode OUT NOCOPY NUMBER -- Request standard return status
11664: ) IS
11665: l_api_name CONSTANT VARCHAR2(30) := 'NIMG_Purge_Batch';
11666: l_return_status VARCHAR2(1);
11667: l_msg_count NUMBER;
12277: ------------------------------------------------------------------------
12278:
12279: ******************************************************************/
12280: PROCEDURE Generate_Batch_XML(
12281: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
12282: retcode OUT NOCOPY NUMBER , -- Request standard return status
12283: batch_id IN NUMBER
12284: )
12285: IS
12278:
12279: ******************************************************************/
12280: PROCEDURE Generate_Batch_XML(
12281: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
12282: retcode OUT NOCOPY NUMBER , -- Request standard return status
12283: batch_id IN NUMBER
12284: )
12285: IS
12286: CURSOR c_get_batch_type(cp_batch_id igs_sv_batches.batch_id%TYPE)