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 201: from ozf_resale_batches

197:
198: CURSOR get_batch_id (pc_batch_no VARCHAR2)
199: IS
200: select resale_batch_id
201: from ozf_resale_batches
202: where batch_number = pc_batch_no;
203:
204: BEGIN
205: IF OZF_DEBUG_HIGH_ON THEN

Line 243: UPDATE ozf_resale_batches_all

239: END IF;
240: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
241: IF l_batch_status = g_batch_open THEN
242: -- nepanda : Updating the batch status to PROCESSING before raising business event from WebADI for Process Batch
243: UPDATE ozf_resale_batches_all
244: SET status_code = 'PROCESSING'
245: WHERE resale_batch_id = l_batch_id;
246:
247: -- Call Data Processing Event

Line 317: l_resale_batch_rec ozf_resale_batches_all%rowtype;

313: IS
314: l_api_name CONSTANT VARCHAR2(30) := 'resale_pre_process';
315: l_api_version_number CONSTANT NUMBER := 1.0;
316:
317: l_resale_batch_rec ozf_resale_batches_all%rowtype;
318: l_line_record resale_line_int_rec_type;
319:
320: l_status VARCHAR2(30) := NULL;
321: l_dispute_reason VARCHAR2(100);

Line 328: FROM ozf_resale_batches_all a

324:
325: CURSOR get_count (pc_batch_id IN NUMBER) IS
326: SELECT COUNT(DECODE(b.status_code, 'DISPUTED', 1, NULL)),
327: COUNT(b.status_code)
328: FROM ozf_resale_batches_all a
329: , ozf_resale_lines_int_all b
330: WHERE a.resale_batch_id = b.resale_batch_id
331: AND a.resale_batch_id = pc_batch_id;
332:

Line 335: FROM ozf_resale_batches_all

331: AND a.resale_batch_id = pc_batch_id;
332:
333: CURSOR get_batch_org(cv_resale_batch_id IN NUMBER) IS
334: SELECT org_id
335: FROM ozf_resale_batches_all
336: WHERE resale_batch_id = cv_resale_batch_id;
337:
338: BEGIN
339:

Line 398: -- Validates and Updates Ozf_Resale_Batches_all

394: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
395: RAISE FND_API.g_exc_unexpected_error;
396: END IF;
397:
398: -- Validates and Updates Ozf_Resale_Batches_all
399: Batch_Update
400: ( p_api_version_number => 1.0,
401: p_init_msg_list => FND_API.G_FALSE,
402: p_commit => FND_API.G_FALSE,

Line 513: Update ozf_resale_batches

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

Line 526: Update ozf_resale_batches

522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: --ROLLBACK TO resale_pre_process;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;
526: Update ozf_resale_batches
527: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
528: WHERE resale_batch_id = p_batch_id;
529:
530: -- Standard call to get message count and if count=1, get the message

Line 539: Update ozf_resale_batches

535: WHEN OTHERS THEN
536: --ROLLBACK TO resale_pre_process;
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;
539: Update ozf_resale_batches
540: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
541: WHERE resale_batch_id = p_batch_id;
542:
543: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 561: x_resale_batch_rec OUT NOCOPY ozf_resale_batches_all%rowtype,

557: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
558: p_commit IN VARCHAR2 := FND_API.G_FALSE,
559: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
560: p_batch_id IN NUMBER,
561: x_resale_batch_rec OUT NOCOPY ozf_resale_batches_all%rowtype,
562: x_return_status OUT NOCOPY VARCHAR2,
563: x_msg_count OUT NOCOPY NUMBER,
564: x_msg_data OUT NOCOPY VARCHAR2
565: )

Line 570: l_resale_batch_rec ozf_resale_batches_all%rowtype;

566: IS
567: l_api_name CONSTANT VARCHAR2(30) := 'Batch_Update';
568: l_api_version_number CONSTANT NUMBER := 1.0;
569:
570: l_resale_batch_rec ozf_resale_batches_all%rowtype;
571: l_msg_count NUMBER;
572: l_msg_data VARCHAR2(32000);
573: l_batch_status VARCHAR2(30);
574:

Line 673: x_resale_batch_rec OUT NOCOPY ozf_resale_batches_all%rowtype,

669:
670: PROCEDURE Batch_Fetch
671: (
672: p_batch_id IN NUMBER,
673: x_resale_batch_rec OUT NOCOPY ozf_resale_batches_all%rowtype,
674: x_return_status OUT NOCOPY VARCHAR2
675: )
676: IS
677:

Line 684: FROM ozf_resale_batches_all

680:
681: CURSOR csr_get_batch_info(cv_batch_id NUMBER)
682: IS
683: SELECT *
684: FROM ozf_resale_batches_all
685: WHERE resale_batch_id = cv_batch_id;
686:
687: CURSOR get_ecx_party_id ( pc_party_site NUMBER)
688: IS

Line 807: p_resale_batch_rec IN ozf_resale_batches_all%rowtype,

803: p_api_version_number IN NUMBER,
804: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
805: p_commit IN VARCHAR2 := FND_API.G_FALSE,
806: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
807: p_resale_batch_rec IN ozf_resale_batches_all%rowtype,
808: x_batch_status OUT NOCOPY VARCHAR2,
809: x_return_status OUT NOCOPY VARCHAR2,
810: x_msg_count OUT NOCOPY NUMBER,
811: x_msg_data OUT NOCOPY VARCHAR2

Line 1047: px_resale_batch_rec IN OUT NOCOPY ozf_resale_batches_all%rowtype,

1043: p_api_version_number IN NUMBER,
1044: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1045: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1046: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1047: px_resale_batch_rec IN OUT NOCOPY ozf_resale_batches_all%rowtype,
1048: x_return_status OUT NOCOPY VARCHAR2,
1049: x_msg_count OUT NOCOPY NUMBER,
1050: x_msg_data OUT NOCOPY VARCHAR2
1051: )

Line 1071: l_resale_batch_rec ozf_resale_batches_all%rowtype := px_resale_batch_rec;

1067:
1068: l_party_contact_id NUMBER;
1069: l_party_id NUMBER;
1070: l_party_site_id NUMBER;
1071: l_resale_batch_rec ozf_resale_batches_all%rowtype := px_resale_batch_rec;
1072: l_partner_cntct_rec party_cntct_rec_type;
1073: l_partner_rec party_rec_type;
1074: l_dqm_contact_rule VARCHAR2(100);
1075:

Line 1327: px_batch_record IN OUT NOCOPY ozf_resale_batches_all%rowtype,

1323:
1324: PROCEDURE Lines_Update
1325: (
1326: p_batch_id IN NUMBER,
1327: px_batch_record IN OUT NOCOPY ozf_resale_batches_all%rowtype,
1328: x_return_status OUT NOCOPY VARCHAR2,
1329: x_msg_data OUT NOCOPY VARCHAR2,
1330: x_msg_count OUT NOCOPY NUMBER
1331: )

Line 1756: px_batch_record IN OUT NOCOPY ozf_resale_batches_all%rowtype,

1752:
1753: PROCEDURE Lines_Process
1754: (
1755: p_line_count IN NUMBER,
1756: px_batch_record IN OUT NOCOPY ozf_resale_batches_all%rowtype,
1757: px_line_record IN OUT NOCOPY resale_line_int_rec_type,
1758: x_return_status OUT NOCOPY VARCHAR2,
1759: x_msg_data OUT NOCOPY VARCHAR2,
1760: x_msg_count OUT NOCOPY NUMBER

Line 2278: px_batch_record IN OUT NOCOPY ozf_resale_batches_all%ROWTYPE,

2274: /*
2275: -- For Bug#9447673 SSD IDSM ER(+)
2276: PROCEDURE Line_Validations(
2277: p_line_count IN NUMBER,
2278: px_batch_record IN OUT NOCOPY ozf_resale_batches_all%ROWTYPE,
2279: px_line_record IN OUT NOCOPY resale_line_int_rec_type,
2280: x_return_status OUT NOCOPY VARCHAR2
2281: )IS
2282: l_direct_order_flag VARCHAR2(1) := 'N';

Line 2298: px_batch_record IN OUT NOCOPY ozf_resale_batches_all%ROWTYPE,

2294: */
2295:
2296: PROCEDURE Line_Validations(
2297: p_line_count IN NUMBER,
2298: px_batch_record IN OUT NOCOPY ozf_resale_batches_all%ROWTYPE,
2299: px_line_record IN OUT NOCOPY resale_line_int_rec_type,
2300: --p_direct_order_flag IN VARCHAR2,
2301: x_return_status OUT NOCOPY VARCHAR2
2302: )

Line 3332: p_batch_record IN ozf_resale_batches_all%ROWTYPE,

3328:
3329:
3330: PROCEDURE Code_ID_Mapping
3331: (
3332: p_batch_record IN ozf_resale_batches_all%ROWTYPE,
3333: px_line_record IN OUT NOCOPY resale_line_int_rec_type,
3334: x_return_status OUT NOCOPY VARCHAR2,
3335: x_msg_data OUT NOCOPY VARCHAR2,
3336: x_msg_count OUT NOCOPY NUMBER

Line 7850: p_int_batch_rec IN ozf_resale_batches_all%rowtype,

7846: p_api_version_number IN NUMBER,
7847: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7848: p_Commit IN VARCHAR2 := FND_API.G_FALSE,
7849: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7850: p_int_batch_rec IN ozf_resale_batches_all%rowtype,
7851: x_return_status OUT NOCOPY VARCHAR2,
7852: x_msg_count OUT NOCOPY NUMBER,
7853: x_msg_data OUT NOCOPY VARCHAR2
7854: )

Line 7874: OZF_RESALE_BATCHES_PKG.Update_Row(

7870: BEGIN
7871: IF OZF_DEBUG_LOW_ON THEN
7872: ozf_utility_pvt.debug_message('Resale Batch ID ' || p_int_batch_rec.resale_batch_id);
7873: END IF;
7874: OZF_RESALE_BATCHES_PKG.Update_Row(
7875: p_resale_batch_id => p_int_batch_rec.resale_batch_id,
7876: p_object_version_number => p_int_batch_rec.object_version_number ,
7877: p_last_update_date => p_int_batch_rec.last_update_date,
7878: p_last_updated_by => p_int_batch_rec.last_updated_by,

Line 8047: FROM ozf_resale_batches

8043: CURSOR get_party ( pc_batch_id NUMBER )
8044: IS
8045: SELECT partner_party_id
8046: , partner_site_id
8047: FROM ozf_resale_batches
8048: WHERE resale_batch_id = pc_batch_id;
8049:
8050:
8051:

Line 8432: FROM ozf_resale_batches

8428: CURSOR get_batch ( pc_batch_id NUMBER)
8429: IS
8430: SELECT partner_party_id
8431: , partner_site_id
8432: FROM ozf_resale_batches
8433: WHERE resale_batch_id = pc_batch_id;
8434: --nepanda : Fix for Bug 12716192(13819601)
8435: CURSOR get_batch_org_id ( p_batch_id NUMBER)
8436: IS

Line 8438: FROM ozf_resale_batches_all

8434: --nepanda : Fix for Bug 12716192(13819601)
8435: CURSOR get_batch_org_id ( p_batch_id NUMBER)
8436: IS
8437: SELECT org_id
8438: FROM ozf_resale_batches_all
8439: WHERE resale_batch_id = p_batch_id;
8440: BEGIN
8441: IF OZF_DEBUG_HIGH_ON THEN
8442: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ' start');