eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_PRE_PROCESS_PVT dependencies on OZF_RESALE_BATCHES_ALL

Line 304: l_resale_batch_rec ozf_resale_batches_all%rowtype;

300: IS
301: l_api_name CONSTANT VARCHAR2(30) := 'resale_pre_process';
302: l_api_version_number CONSTANT NUMBER := 1.0;
303:
304: l_resale_batch_rec ozf_resale_batches_all%rowtype;
305: l_line_record resale_line_int_rec_type;
306:
307: l_status VARCHAR2(30) := NULL;
308: l_dispute_reason VARCHAR2(100);

Line 315: FROM ozf_resale_batches_all a

311:
312: CURSOR get_count (pc_batch_id IN NUMBER) IS
313: SELECT COUNT(DECODE(b.status_code, 'DISPUTED', 1, NULL)),
314: COUNT(b.status_code)
315: FROM ozf_resale_batches_all a
316: , ozf_resale_lines_int_all b
317: WHERE a.resale_batch_id = b.resale_batch_id
318: AND a.resale_batch_id = pc_batch_id;
319:

Line 322: FROM ozf_resale_batches_all

318: AND a.resale_batch_id = pc_batch_id;
319:
320: CURSOR get_batch_org(cv_resale_batch_id IN NUMBER) IS
321: SELECT org_id
322: FROM ozf_resale_batches_all
323: WHERE resale_batch_id = cv_resale_batch_id;
324:
325: BEGIN
326:

Line 384: -- Validates and Updates Ozf_Resale_Batches_all

380: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
381: RAISE FND_API.g_exc_unexpected_error;
382: END IF;
383:
384: -- Validates and Updates Ozf_Resale_Batches_all
385: Batch_Update
386: ( p_api_version_number => 1.0,
387: p_init_msg_list => FND_API.G_FALSE,
388: p_commit => FND_API.G_FALSE,

Line 547: x_resale_batch_rec OUT NOCOPY ozf_resale_batches_all%rowtype,

543: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
544: p_commit IN VARCHAR2 := FND_API.G_FALSE,
545: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
546: p_batch_id IN NUMBER,
547: x_resale_batch_rec OUT NOCOPY ozf_resale_batches_all%rowtype,
548: x_return_status OUT NOCOPY VARCHAR2,
549: x_msg_count OUT NOCOPY NUMBER,
550: x_msg_data OUT NOCOPY VARCHAR2
551: )

Line 556: l_resale_batch_rec ozf_resale_batches_all%rowtype;

552: IS
553: l_api_name CONSTANT VARCHAR2(30) := 'Batch_Update';
554: l_api_version_number CONSTANT NUMBER := 1.0;
555:
556: l_resale_batch_rec ozf_resale_batches_all%rowtype;
557: l_msg_count NUMBER;
558: l_msg_data VARCHAR2(32000);
559: l_batch_status VARCHAR2(30);
560:

Line 659: x_resale_batch_rec OUT NOCOPY ozf_resale_batches_all%rowtype,

655:
656: PROCEDURE Batch_Fetch
657: (
658: p_batch_id IN NUMBER,
659: x_resale_batch_rec OUT NOCOPY ozf_resale_batches_all%rowtype,
660: x_return_status OUT NOCOPY VARCHAR2
661: )
662: IS
663:

Line 670: FROM ozf_resale_batches_all

666:
667: CURSOR csr_get_batch_info(cv_batch_id NUMBER)
668: IS
669: SELECT *
670: FROM ozf_resale_batches_all
671: WHERE resale_batch_id = cv_batch_id;
672:
673: CURSOR get_ecx_party_id ( pc_party_site NUMBER)
674: IS

Line 788: p_resale_batch_rec IN ozf_resale_batches_all%rowtype,

784: p_api_version_number IN NUMBER,
785: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
786: p_commit IN VARCHAR2 := FND_API.G_FALSE,
787: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
788: p_resale_batch_rec IN ozf_resale_batches_all%rowtype,
789: x_batch_status OUT NOCOPY VARCHAR2,
790: x_return_status OUT NOCOPY VARCHAR2,
791: x_msg_count OUT NOCOPY NUMBER,
792: x_msg_data OUT NOCOPY VARCHAR2

Line 1028: px_resale_batch_rec IN OUT NOCOPY ozf_resale_batches_all%rowtype,

1024: p_api_version_number IN NUMBER,
1025: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1026: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1027: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1028: px_resale_batch_rec IN OUT NOCOPY ozf_resale_batches_all%rowtype,
1029: x_return_status OUT NOCOPY VARCHAR2,
1030: x_msg_count OUT NOCOPY NUMBER,
1031: x_msg_data OUT NOCOPY VARCHAR2
1032: )

Line 1052: l_resale_batch_rec ozf_resale_batches_all%rowtype := px_resale_batch_rec;

1048:
1049: l_party_contact_id NUMBER;
1050: l_party_id NUMBER;
1051: l_party_site_id NUMBER;
1052: l_resale_batch_rec ozf_resale_batches_all%rowtype := px_resale_batch_rec;
1053: l_partner_cntct_rec party_cntct_rec_type;
1054: l_partner_rec party_rec_type;
1055: l_dqm_contact_rule VARCHAR2(100);
1056:

Line 1308: px_batch_record IN OUT NOCOPY ozf_resale_batches_all%rowtype,

1304:
1305: PROCEDURE Lines_Update
1306: (
1307: p_batch_id IN NUMBER,
1308: px_batch_record IN OUT NOCOPY ozf_resale_batches_all%rowtype,
1309: x_return_status OUT NOCOPY VARCHAR2,
1310: x_msg_data OUT NOCOPY VARCHAR2,
1311: x_msg_count OUT NOCOPY NUMBER
1312: )

Line 1727: px_batch_record IN OUT NOCOPY ozf_resale_batches_all%rowtype,

1723:
1724: PROCEDURE Lines_Process
1725: (
1726: p_line_count IN NUMBER,
1727: px_batch_record IN OUT NOCOPY ozf_resale_batches_all%rowtype,
1728: px_line_record IN OUT NOCOPY resale_line_int_rec_type,
1729: x_return_status OUT NOCOPY VARCHAR2,
1730: x_msg_data OUT NOCOPY VARCHAR2,
1731: x_msg_count OUT NOCOPY NUMBER

Line 2195: px_batch_record IN OUT NOCOPY ozf_resale_batches_all%ROWTYPE,

2191:
2192:
2193: PROCEDURE Line_Validations(
2194: p_line_count IN NUMBER,
2195: px_batch_record IN OUT NOCOPY ozf_resale_batches_all%ROWTYPE,
2196: px_line_record IN OUT NOCOPY resale_line_int_rec_type,
2197: x_return_status OUT NOCOPY VARCHAR2
2198: )
2199: IS

Line 3079: p_batch_record IN ozf_resale_batches_all%ROWTYPE,

3075:
3076:
3077: PROCEDURE Code_ID_Mapping
3078: (
3079: p_batch_record IN ozf_resale_batches_all%ROWTYPE,
3080: px_line_record IN OUT NOCOPY resale_line_int_rec_type,
3081: x_return_status OUT NOCOPY VARCHAR2,
3082: x_msg_data OUT NOCOPY VARCHAR2,
3083: x_msg_count OUT NOCOPY NUMBER

Line 7385: p_int_batch_rec IN ozf_resale_batches_all%rowtype,

7381: p_api_version_number IN NUMBER,
7382: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7383: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
7384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7385: p_int_batch_rec IN ozf_resale_batches_all%rowtype,
7386: x_return_status OUT NOCOPY VARCHAR2,
7387: x_msg_count OUT NOCOPY NUMBER,
7388: x_msg_data OUT NOCOPY VARCHAR2
7389: )