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

Line 192: from ozf_resale_batches

188:
189: CURSOR get_batch_id (pc_batch_no VARCHAR2)
190: IS
191: select resale_batch_id
192: from ozf_resale_batches
193: where batch_number = pc_batch_no;
194:
195: BEGIN
196: IF OZF_DEBUG_HIGH_ON THEN

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 499: Update ozf_resale_batches

495: WHEN FND_API.G_EXC_ERROR THEN
496: --ROLLBACK TO resale_pre_process;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;
499: Update ozf_resale_batches
500: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
501: WHERE resale_batch_id = p_batch_id;
502:
503: -- Standard call to get message count and if count=1, get the message

Line 512: Update ozf_resale_batches

508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509: --ROLLBACK TO resale_pre_process;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;
512: Update ozf_resale_batches
513: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
514: WHERE resale_batch_id = p_batch_id;
515:
516: -- Standard call to get message count and if count=1, get the message

Line 525: Update ozf_resale_batches

521: WHEN OTHERS THEN
522: --ROLLBACK TO resale_pre_process;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;
525: Update ozf_resale_batches
526: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
527: WHERE resale_batch_id = p_batch_id;
528:
529: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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: )

Line 7409: OZF_RESALE_BATCHES_PKG.Update_Row(

7405: BEGIN
7406: IF OZF_DEBUG_LOW_ON THEN
7407: ozf_utility_pvt.debug_message('Resale Batch ID ' || p_int_batch_rec.resale_batch_id);
7408: END IF;
7409: OZF_RESALE_BATCHES_PKG.Update_Row(
7410: p_resale_batch_id => p_int_batch_rec.resale_batch_id,
7411: p_object_version_number => p_int_batch_rec.object_version_number ,
7412: p_last_update_date => p_int_batch_rec.last_update_date,
7413: p_last_updated_by => p_int_batch_rec.last_updated_by,

Line 7580: FROM ozf_resale_batches

7576: CURSOR get_party ( pc_batch_id NUMBER )
7577: IS
7578: SELECT partner_party_id
7579: , partner_site_id
7580: FROM ozf_resale_batches
7581: WHERE resale_batch_id = pc_batch_id;
7582:
7583:
7584:

Line 7960: FROM ozf_resale_batches

7956: CURSOR get_batch ( pc_batch_id NUMBER)
7957: IS
7958: SELECT partner_party_id
7959: , partner_site_id
7960: FROM ozf_resale_batches
7961: WHERE resale_batch_id = pc_batch_id;
7962:
7963: BEGIN
7964: IF OZF_DEBUG_HIGH_ON THEN