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.PO_EXHIBITS_PVT dependencies on PO_EXHIBIT_DETAILS

Line 224: AND NOT EXISTS (SELECT 1 FROM po_exhibit_details_merge_v pex

220: FROM
221: (SELECT lookup_code
222: FROM fnd_lookup_values lk
223: WHERE lookup_type = 'PO_CLM_EXHIBIT_NUMBER'
224: AND NOT EXISTS (SELECT 1 FROM po_exhibit_details_merge_v pex
225: WHERE pex.po_header_id = p_header_id
226: AND pex.draft_id = p_draft_id
227: AND pex.exhibit_name = lk.lookup_code)
228: ORDER BY LENGTH(lookup_code),lookup_code

Line 243: --p_po_exhibit_details_id

239: --Function:
240: -- Obtain database lock for the record in draft table
241: --Parameters:
242: --IN:
243: --p_po_exhibit_details_id
244: -- id for po exhibit record
245: --p_draft_id
246: -- draft unique identifier
247: --RETURN:

Line 251: ( p_po_exhibit_details_id IN NUMBER,

247: --RETURN:
248: --End of Comments
249: ------------------------------------------------------------------------
250: PROCEDURE lock_draft_record
251: ( p_po_exhibit_details_id IN NUMBER,
252: p_draft_id IN NUMBER
253: ) IS
254:
255: d_api_name CONSTANT VARCHAR2(30) := 'lock_draft_record';

Line 269: FROM po_exhibit_details_draft

265: END IF;
266:
267: SELECT 1
268: INTO l_dummy
269: FROM po_exhibit_details_draft
270: WHERE po_exhibit_details_id = p_po_exhibit_details_id
271: AND draft_id = p_draft_id
272: FOR UPDATE NOWAIT;
273:

Line 270: WHERE po_exhibit_details_id = p_po_exhibit_details_id

266:
267: SELECT 1
268: INTO l_dummy
269: FROM po_exhibit_details_draft
270: WHERE po_exhibit_details_id = p_po_exhibit_details_id
271: AND draft_id = p_draft_id
272: FOR UPDATE NOWAIT;
273:
274: IF (PO_LOG.d_proc) THEN

Line 290: --p_po_exhibit_details_id

286: --Function:
287: -- Obtain database lock for the record in transaction table
288: --Parameters:
289: --IN:
290: --p_po_exhibit_details_id
291: -- id for po exibit record
292: --RETURN:
293: --End of Comments
294: ------------------------------------------------------------------------

Line 296: ( p_po_exhibit_details_id IN NUMBER

292: --RETURN:
293: --End of Comments
294: ------------------------------------------------------------------------
295: PROCEDURE lock_transaction_record
296: ( p_po_exhibit_details_id IN NUMBER
297: ) IS
298:
299: d_api_name CONSTANT VARCHAR2(30) := 'lock_transaction_record';
300: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 313: FROM po_exhibit_details

309: END IF;
310:
311: SELECT 1
312: INTO l_dummy
313: FROM po_exhibit_details
314: WHERE po_exhibit_details_id = p_po_exhibit_details_id
315: FOR UPDATE NOWAIT;
316:
317: IF (PO_LOG.d_proc) THEN

Line 314: WHERE po_exhibit_details_id = p_po_exhibit_details_id

310:
311: SELECT 1
312: INTO l_dummy
313: FROM po_exhibit_details
314: WHERE po_exhibit_details_id = p_po_exhibit_details_id
315: FOR UPDATE NOWAIT;
316:
317: IF (PO_LOG.d_proc) THEN
318: PO_LOG.proc_end(d_module);

Line 357: ( p_po_exhibit_details_id_tbl IN PO_TBL_NUMBER,

353: --Testing:
354: --End of Comments
355: ------------------------------------------------------------------------
356: PROCEDURE sync_draft_from_txn
357: ( p_po_exhibit_details_id_tbl IN PO_TBL_NUMBER,
358: p_draft_id_tbl IN PO_TBL_NUMBER,
359: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
360: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
361: ) IS

Line 379: p_po_exhibit_details_id_tbl => p_po_exhibit_details_id_tbl

375:
376: x_record_already_exist_tbl :=
377: draft_changes_exist
378: ( p_draft_id_tbl => p_draft_id_tbl,
379: p_po_exhibit_details_id_tbl => p_po_exhibit_details_id_tbl
380: );
381:
382: -- bug5471513 START
383: -- If there're duplicate entries in the id table,

Line 386: l_duplicate_flag_tbl.EXTEND(p_po_exhibit_details_id_tbl.COUNT);

382: -- bug5471513 START
383: -- If there're duplicate entries in the id table,
384: -- we do not want to insert multiple entries
385: -- Created an associative array to store what id has appeared.
386: l_duplicate_flag_tbl.EXTEND(p_po_exhibit_details_id_tbl.COUNT);
387:
388: FOR i IN 1..p_po_exhibit_details_id_tbl.COUNT LOOP
389: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN
390:

Line 388: FOR i IN 1..p_po_exhibit_details_id_tbl.COUNT LOOP

384: -- we do not want to insert multiple entries
385: -- Created an associative array to store what id has appeared.
386: l_duplicate_flag_tbl.EXTEND(p_po_exhibit_details_id_tbl.COUNT);
387:
388: FOR i IN 1..p_po_exhibit_details_id_tbl.COUNT LOOP
389: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN
390:
391: IF (l_distinct_id_list.EXISTS(p_po_exhibit_details_id_tbl(i))) THEN
392:

Line 391: IF (l_distinct_id_list.EXISTS(p_po_exhibit_details_id_tbl(i))) THEN

387:
388: FOR i IN 1..p_po_exhibit_details_id_tbl.COUNT LOOP
389: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN
390:
391: IF (l_distinct_id_list.EXISTS(p_po_exhibit_details_id_tbl(i))) THEN
392:
393: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
394: ELSE
395: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;

Line 397: l_distinct_id_list(p_po_exhibit_details_id_tbl(i)) := 1;

393: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
394: ELSE
395: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;
396:
397: l_distinct_id_list(p_po_exhibit_details_id_tbl(i)) := 1;
398: END IF;
399:
400: ELSE
401:

Line 413: FORALL i IN 1..p_po_exhibit_details_id_tbl.Count

409: IF (PO_LOG.d_stmt) THEN
410: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
411: END IF;
412:
413: FORALL i IN 1..p_po_exhibit_details_id_tbl.Count
414: INSERT INTO po_exhibit_details_draft
415: (
416: po_exhibit_details_id,
417: po_header_id,

Line 414: INSERT INTO po_exhibit_details_draft

410: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
411: END IF;
412:
413: FORALL i IN 1..p_po_exhibit_details_id_tbl.Count
414: INSERT INTO po_exhibit_details_draft
415: (
416: po_exhibit_details_id,
417: po_header_id,
418: draft_id,

Line 416: po_exhibit_details_id,

412:
413: FORALL i IN 1..p_po_exhibit_details_id_tbl.Count
414: INSERT INTO po_exhibit_details_draft
415: (
416: po_exhibit_details_id,
417: po_header_id,
418: draft_id,
419: delete_flag,
420: change_accepted_flag,

Line 433: po_exhibit_details_id,

429: CREATED_BY,
430: LAST_UPDATE_LOGIN
431: )
432: SELECT
433: po_exhibit_details_id,
434: po_header_id,
435: p_draft_id_tbl(i),
436: p_delete_flag_tbl(i),
437: NULL,

Line 448: FROM po_exhibit_details

444: LAST_UPDATED_BY,
445: CREATION_DATE,
446: CREATED_BY,
447: LAST_UPDATE_LOGIN
448: FROM po_exhibit_details
449: WHERE po_exhibit_details_id = p_po_exhibit_details_id_tbl(i)
450: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
451: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
452:

Line 449: WHERE po_exhibit_details_id = p_po_exhibit_details_id_tbl(i)

445: CREATION_DATE,
446: CREATED_BY,
447: LAST_UPDATE_LOGIN
448: FROM po_exhibit_details
449: WHERE po_exhibit_details_id = p_po_exhibit_details_id_tbl(i)
450: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
451: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
452:
453: d_position := 20;

Line 458: FORALL i IN 1..p_po_exhibit_details_id_tbl.COUNT

454: IF (PO_LOG.d_stmt) THEN
455: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
456: END IF;
457:
458: FORALL i IN 1..p_po_exhibit_details_id_tbl.COUNT
459: UPDATE po_exhibit_details_draft
460: SET delete_flag = p_delete_flag_tbl(i)
461: WHERE po_exhibit_details_id = p_po_exhibit_details_id_tbl(i)
462: AND draft_id = p_draft_id_tbl(i)

Line 459: UPDATE po_exhibit_details_draft

455: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
456: END IF;
457:
458: FORALL i IN 1..p_po_exhibit_details_id_tbl.COUNT
459: UPDATE po_exhibit_details_draft
460: SET delete_flag = p_delete_flag_tbl(i)
461: WHERE po_exhibit_details_id = p_po_exhibit_details_id_tbl(i)
462: AND draft_id = p_draft_id_tbl(i)
463: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989

Line 461: WHERE po_exhibit_details_id = p_po_exhibit_details_id_tbl(i)

457:
458: FORALL i IN 1..p_po_exhibit_details_id_tbl.COUNT
459: UPDATE po_exhibit_details_draft
460: SET delete_flag = p_delete_flag_tbl(i)
461: WHERE po_exhibit_details_id = p_po_exhibit_details_id_tbl(i)
462: AND draft_id = p_draft_id_tbl(i)
463: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989
464: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
465:

Line 516: ( p_po_exhibit_details_id IN NUMBER,

512: --Testing:
513: --End of Comments
514: ------------------------------------------------------------------------
515: PROCEDURE sync_draft_from_txn
516: ( p_po_exhibit_details_id IN NUMBER,
517: p_draft_id IN NUMBER,
518: p_delete_flag IN VARCHAR2,
519: x_record_already_exist OUT NOCOPY VARCHAR2
520: ) IS

Line 532: PO_LOG.proc_begin(d_module, 'p_po_exhibit_details_id', p_po_exhibit_details_id);

528: BEGIN
529: d_position := 0;
530: IF (PO_LOG.d_proc) THEN
531: PO_LOG.proc_begin(d_module);
532: PO_LOG.proc_begin(d_module, 'p_po_exhibit_details_id', p_po_exhibit_details_id);
533: END IF;
534:
535: sync_draft_from_txn
536: ( p_po_exhibit_details_id_tbl => PO_TBL_NUMBER(p_po_exhibit_details_id),

Line 536: ( p_po_exhibit_details_id_tbl => PO_TBL_NUMBER(p_po_exhibit_details_id),

532: PO_LOG.proc_begin(d_module, 'p_po_exhibit_details_id', p_po_exhibit_details_id);
533: END IF;
534:
535: sync_draft_from_txn
536: ( p_po_exhibit_details_id_tbl => PO_TBL_NUMBER(p_po_exhibit_details_id),
537: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
538: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
539: x_record_already_exist_tbl => l_record_already_exist_tbl
540: );

Line 568: -- given the draft_id or draft_id + po_exhibit_details_id

564: --Locks:
565: -- None
566: --Function:
567: -- Checks whether there is any draft changes in the draft table
568: -- given the draft_id or draft_id + po_exhibit_details_id
569: -- If only draft_id is provided, this program returns FND_API.G_TRUE for
570: -- any draft changes in this table for the draft
571: -- If the whole primary key is provided (draft_id + exhibit id), then
572: -- it return true if there is draft for this particular record in

Line 578: --p_po_exhibit_details_id_tbl

574: --Parameters:
575: --IN:
576: --p_draft_id_tbl
577: -- draft unique identifier
578: --p_po_exhibit_details_id_tbl
579: -- po exhibit unique identifier
580: --IN OUT:
581: --OUT:
582: --Returns:

Line 593: p_po_exhibit_details_id_tbl IN PO_TBL_NUMBER

589: --End of Comments
590: ------------------------------------------------------------------------
591: FUNCTION draft_changes_exist
592: ( p_draft_id_tbl IN PO_TBL_NUMBER,
593: p_po_exhibit_details_id_tbl IN PO_TBL_NUMBER
594: ) RETURN PO_TBL_VARCHAR1
595: IS
596: d_api_name CONSTANT VARCHAR2(30) := 'draft_changes_exist';
597: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 634: FROM po_exhibit_details_draft PDD

630: SELECT l_key,
631: l_index_tbl(i)
632: FROM DUAL
633: WHERE EXISTS (SELECT 1
634: FROM po_exhibit_details_draft PDD
635: WHERE PDD.draft_id = p_draft_id_tbl(i)
636: AND PDD.po_exhibit_details_id =
637: NVL(p_po_exhibit_details_id_tbl(i),
638: PDD.po_exhibit_details_id)

Line 636: AND PDD.po_exhibit_details_id =

632: FROM DUAL
633: WHERE EXISTS (SELECT 1
634: FROM po_exhibit_details_draft PDD
635: WHERE PDD.draft_id = p_draft_id_tbl(i)
636: AND PDD.po_exhibit_details_id =
637: NVL(p_po_exhibit_details_id_tbl(i),
638: PDD.po_exhibit_details_id)
639: AND NVL(PDD.change_accepted_flag, 'Y') = 'Y');
640:

Line 637: NVL(p_po_exhibit_details_id_tbl(i),

633: WHERE EXISTS (SELECT 1
634: FROM po_exhibit_details_draft PDD
635: WHERE PDD.draft_id = p_draft_id_tbl(i)
636: AND PDD.po_exhibit_details_id =
637: NVL(p_po_exhibit_details_id_tbl(i),
638: PDD.po_exhibit_details_id)
639: AND NVL(PDD.change_accepted_flag, 'Y') = 'Y');
640:
641:

Line 638: PDD.po_exhibit_details_id)

634: FROM po_exhibit_details_draft PDD
635: WHERE PDD.draft_id = p_draft_id_tbl(i)
636: AND PDD.po_exhibit_details_id =
637: NVL(p_po_exhibit_details_id_tbl(i),
638: PDD.po_exhibit_details_id)
639: AND NVL(PDD.change_accepted_flag, 'Y') = 'Y');
640:
641:
642: d_position := 30;

Line 686: --p_po_exhibit_details_id

682: --Parameters:
683: --IN:
684: --p_draft_id
685: -- draft unique identifier
686: --p_po_exhibit_details_id
687: -- exhibit unique identifier
688: --IN OUT:
689: --OUT:
690: --Returns:

Line 699: p_po_exhibit_details_id IN NUMBER

695: --End of Comments
696: ------------------------------------------------------------------------
697: FUNCTION draft_changes_exist
698: ( p_draft_id IN NUMBER,
699: p_po_exhibit_details_id IN NUMBER
700: ) RETURN VARCHAR2
701: IS
702: d_api_name CONSTANT VARCHAR2(30) := 'draft_changes_exist';
703: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 716: p_po_exhibit_details_id_tbl => PO_TBL_NUMBER(p_po_exhibit_details_id)

712:
713: l_exists_tbl :=
714: draft_changes_exist
715: ( p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
716: p_po_exhibit_details_id_tbl => PO_TBL_NUMBER(p_po_exhibit_details_id)
717: );
718:
719: IF (PO_LOG.d_stmt) THEN
720: PO_LOG.stmt(d_module, d_position, 'exists', l_exists_tbl(1));

Line 782: DELETE FROM po_exhibit_details pe

778:
779: -- bug5187544
780: -- Delete only records that have not been rejected
781:
782: DELETE FROM po_exhibit_details pe
783: WHERE pe.po_exhibit_details_id IN
784: ( SELECT ped.po_exhibit_details_id -- Bug 5292573
785: FROM po_exhibit_details_draft ped
786: WHERE ped.draft_id = p_draft_id

Line 783: WHERE pe.po_exhibit_details_id IN

779: -- bug5187544
780: -- Delete only records that have not been rejected
781:
782: DELETE FROM po_exhibit_details pe
783: WHERE pe.po_exhibit_details_id IN
784: ( SELECT ped.po_exhibit_details_id -- Bug 5292573
785: FROM po_exhibit_details_draft ped
786: WHERE ped.draft_id = p_draft_id
787: AND ped.delete_flag = 'Y'

Line 784: ( SELECT ped.po_exhibit_details_id -- Bug 5292573

780: -- Delete only records that have not been rejected
781:
782: DELETE FROM po_exhibit_details pe
783: WHERE pe.po_exhibit_details_id IN
784: ( SELECT ped.po_exhibit_details_id -- Bug 5292573
785: FROM po_exhibit_details_draft ped
786: WHERE ped.draft_id = p_draft_id
787: AND ped.delete_flag = 'Y'
788: AND NVL(ped.change_accepted_flag, 'Y') = 'Y' );

Line 785: FROM po_exhibit_details_draft ped

781:
782: DELETE FROM po_exhibit_details pe
783: WHERE pe.po_exhibit_details_id IN
784: ( SELECT ped.po_exhibit_details_id -- Bug 5292573
785: FROM po_exhibit_details_draft ped
786: WHERE ped.draft_id = p_draft_id
787: AND ped.delete_flag = 'Y'
788: AND NVL(ped.change_accepted_flag, 'Y') = 'Y' );
789:

Line 790: MERGE INTO po_exhibit_details PE

786: WHERE ped.draft_id = p_draft_id
787: AND ped.delete_flag = 'Y'
788: AND NVL(ped.change_accepted_flag, 'Y') = 'Y' );
789:
790: MERGE INTO po_exhibit_details PE
791: USING (
792: SELECT
793: PED.draft_id,
794: PED.delete_flag,

Line 796: PED.po_exhibit_details_id,

792: SELECT
793: PED.draft_id,
794: PED.delete_flag,
795: PED.change_accepted_flag,
796: PED.po_exhibit_details_id,
797: PED.po_header_id,
798: PED.exhibit_name,
799: PED.exhibit_description,
800: PED.is_cdrl,

Line 808: FROM po_exhibit_details_draft PED

804: PED.last_updated_by,
805: PED.creation_date,
806: PED.created_by,
807: PED.last_update_login
808: FROM po_exhibit_details_draft PED
809: WHERE PED.draft_id = p_draft_id
810: AND NVL(PED.change_accepted_flag, 'Y') = 'Y'
811: ) PEDV
812: ON (PE.po_exhibit_details_id = PEDV.po_exhibit_details_id)

Line 812: ON (PE.po_exhibit_details_id = PEDV.po_exhibit_details_id)

808: FROM po_exhibit_details_draft PED
809: WHERE PED.draft_id = p_draft_id
810: AND NVL(PED.change_accepted_flag, 'Y') = 'Y'
811: ) PEDV
812: ON (PE.po_exhibit_details_id = PEDV.po_exhibit_details_id)
813: WHEN MATCHED THEN
814: UPDATE
815: SET
816: PE.last_update_date = PEDV.last_update_date,

Line 829: PE.po_exhibit_details_id,

825: -- DELETE WHERE PDDV.delete_flag = 'Y'
826: WHEN NOT MATCHED THEN
827: INSERT
828: (
829: PE.po_exhibit_details_id,
830: PE.exhibit_name,
831: PE.exhibit_description,
832: PE.is_cdrl,
833: PE.revision_num,

Line 844: PEDV.po_exhibit_details_id,

840: PE.created_by
841: )
842: VALUES
843: (
844: PEDV.po_exhibit_details_id,
845: PEDV.exhibit_name,
846: PEDV.exhibit_description,
847: PEDV.is_cdrl,
848: PEDV.revision_num,

Line 941: -- If po_exhibit_details_id is also provided, then the one record that has such

937: --Function:
938: -- Deletes drafts for exhibits based on the information given
939: -- If only draft_id is provided, then all exhibits for the draft will be
940: -- deleted
941: -- If po_exhibit_details_id is also provided, then the one record that has such
942: -- primary key will be deleted
943: --Parameters:
944: --IN:
945: --p_draft_id

Line 958: p_po_exhibit_details_id IN NUMBER

954: --End of Comments
955: ------------------------------------------------------------------------
956: PROCEDURE delete_rows
957: ( p_draft_id IN NUMBER,
958: p_po_exhibit_details_id IN NUMBER
959: ) IS
960:
961: d_api_name CONSTANT VARCHAR2(30) := 'delete_rows';
962: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 964: po_exhibit_details_ids_tbl PO_TBL_NUMBER;

960:
961: d_api_name CONSTANT VARCHAR2(30) := 'delete_rows';
962: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
963: d_position NUMBER;
964: po_exhibit_details_ids_tbl PO_TBL_NUMBER;
965:
966: BEGIN
967: d_position := 0;
968: IF (PO_LOG.d_proc) THEN

Line 972: DELETE FROM po_exhibit_details_draft

968: IF (PO_LOG.d_proc) THEN
969: PO_LOG.proc_begin(d_module);
970: END IF;
971:
972: DELETE FROM po_exhibit_details_draft
973: WHERE draft_id = p_draft_id
974: AND po_exhibit_details_id = NVL(p_po_exhibit_details_id, po_exhibit_details_id);
975:
976: d_position := 10;

Line 974: AND po_exhibit_details_id = NVL(p_po_exhibit_details_id, po_exhibit_details_id);

970: END IF;
971:
972: DELETE FROM po_exhibit_details_draft
973: WHERE draft_id = p_draft_id
974: AND po_exhibit_details_id = NVL(p_po_exhibit_details_id, po_exhibit_details_id);
975:
976: d_position := 10;
977: EXCEPTION
978: WHEN OTHERS THEN

Line 1046: FROM po_exhibit_details ex

1042:
1043: BEGIN
1044: SELECT Nvl(is_cdrl,'N')
1045: INTO l_is_valid_exhibit
1046: FROM po_exhibit_details ex
1047: WHERE ex.exhibit_name = p_exhibit_name_tbl(i)
1048: AND ex.po_header_id = p_document_id_tbl(i);
1049: EXCEPTION
1050: WHEN No_Data_Found THEN

Line 1056: INSERT INTO po_exhibit_details

1052: END;
1053: -- No records exists for this exhibit for given document
1054: IF( l_is_valid_exhibit = 'Y') THEN
1055:
1056: INSERT INTO po_exhibit_details
1057: (
1058: po_exhibit_details_id,
1059: po_header_id,
1060: exhibit_name,

Line 1058: po_exhibit_details_id,

1054: IF( l_is_valid_exhibit = 'Y') THEN
1055:
1056: INSERT INTO po_exhibit_details
1057: (
1058: po_exhibit_details_id,
1059: po_header_id,
1060: exhibit_name,
1061: exhibit_description,
1062: is_cdrl,

Line 1071: po_exhibit_details_s.nextval,

1067: CREATED_BY,
1068: LAST_UPDATE_LOGIN
1069: )
1070: SELECT
1071: po_exhibit_details_s.nextval,
1072: p_document_id_tbl(i),
1073: p_exhibit_name_tbl(i),
1074: p_exhibit_description_tbl(i),
1075: p_is_cdrl_tbl(i),

Line 1083: WHERE NOT EXISTS (SELECT 1 FROM po_exhibit_details ex

1079: SYSDATE,
1080: fnd_global.user_id,
1081: fnd_global.login_id
1082: FROM dual
1083: WHERE NOT EXISTS (SELECT 1 FROM po_exhibit_details ex
1084: WHERE ex.exhibit_name = p_exhibit_name_tbl(i)
1085: AND ex.po_header_id = p_document_id_tbl(i));
1086:
1087: -- Records exists- Given exhibit is already been used by the Exhibit

Line 1100: FROM po_exhibit_details_merge_v ex

1096:
1097: BEGIN
1098: SELECT Nvl(is_cdrl, 'N')
1099: INTO l_is_valid_exhibit
1100: FROM po_exhibit_details_merge_v ex
1101: WHERE ex.exhibit_name = p_exhibit_name_tbl(i)
1102: AND ex.draft_id = p_document_id_tbl(i) ;
1103:
1104: EXCEPTION

Line 1111: INSERT INTO po_exhibit_details_draft

1107: END;
1108:
1109: -- No records exists for this exhibit for given document
1110: IF( l_is_valid_exhibit = 'Y') THEN
1111: INSERT INTO po_exhibit_details_draft
1112: (
1113: po_exhibit_details_id,
1114: po_header_id,
1115: draft_id,

Line 1113: po_exhibit_details_id,

1109: -- No records exists for this exhibit for given document
1110: IF( l_is_valid_exhibit = 'Y') THEN
1111: INSERT INTO po_exhibit_details_draft
1112: (
1113: po_exhibit_details_id,
1114: po_header_id,
1115: draft_id,
1116: exhibit_name,
1117: exhibit_description,

Line 1128: po_exhibit_details_s.nextval,

1124: CREATED_BY,
1125: LAST_UPDATE_LOGIN
1126: )
1127: SELECT
1128: po_exhibit_details_s.nextval,
1129: dft.DOCUMENT_ID,
1130: p_document_id_tbl(i),
1131: p_exhibit_name_tbl(i),
1132: p_exhibit_description_tbl(i),

Line 1143: AND NOT EXISTS (SELECT 1 FROM po_exhibit_details_merge_v mex

1139: fnd_global.user_id,
1140: fnd_global.login_id
1141: FROM po_drafts dft
1142: WHERE dft.draft_id = p_document_id_tbl(i)
1143: AND NOT EXISTS (SELECT 1 FROM po_exhibit_details_merge_v mex
1144: WHERE mex.exhibit_name = p_exhibit_name_tbl(i)
1145: AND mex.draft_id = p_document_id_tbl(i));
1146:
1147: -- Records exists- Given exhibit is already been used by the Exhibit

Line 1232: DELETE po_exhibit_details ex

1228: END IF;
1229:
1230: IF( p_document_type_tbl(i) IN ('PO_STANDARD', 'PA_CONTRACT', 'PA_BLANKET') ) THEN
1231:
1232: DELETE po_exhibit_details ex
1233: WHERE ex.exhibit_name = p_exhibit_name_tbl(i)
1234: AND ex.po_header_id = p_document_id_tbl(i)
1235: AND ex.is_cdrl = p_is_cdrl_tbl(i);
1236:

Line 1239: DELETE po_exhibit_details_draft mex

1235: AND ex.is_cdrl = p_is_cdrl_tbl(i);
1236:
1237: ELSIF( p_document_type_tbl(i) IN ('PO_STANDARD_MOD', 'PA_CONTRACT_MOD', 'PA_BLANKET_MOD') ) THEN
1238:
1239: DELETE po_exhibit_details_draft mex
1240: WHERE mex.exhibit_name = p_exhibit_name_tbl(i)
1241: AND mex.draft_id = p_document_id_tbl(i)
1242: AND mex.is_cdrl = p_is_cdrl_tbl(i);
1243:

Line 1340: INSERT INTO po_exhibit_details

1336: END IF;
1337:
1338: l_docid := p_po_header_id;
1339:
1340: INSERT INTO po_exhibit_details
1341: (
1342: po_exhibit_details_id,
1343: po_header_id,
1344: exhibit_name,

Line 1342: po_exhibit_details_id,

1338: l_docid := p_po_header_id;
1339:
1340: INSERT INTO po_exhibit_details
1341: (
1342: po_exhibit_details_id,
1343: po_header_id,
1344: exhibit_name,
1345: exhibit_description,
1346: is_cdrl,

Line 1355: po_exhibit_details_s.nextval,

1351: CREATED_BY,
1352: LAST_UPDATE_LOGIN
1353: )
1354: SELECT
1355: po_exhibit_details_s.nextval,
1356: p_po_header_id,
1357: l_new_exhibit_name,
1358: exhibit_description,
1359: is_cdrl,

Line 1366: FROM po_exhibit_details

1362: fnd_global.user_id,
1363: SYSDATE,
1364: fnd_global.user_id,
1365: fnd_global.login_id
1366: FROM po_exhibit_details
1367: WHERE po_header_id = p_po_header_id
1368: AND exhibit_name = p_exhibit_name;
1369:
1370: ELSE

Line 1382: INSERT INTO po_exhibit_details_draft

1378: END IF;
1379:
1380: l_docid := p_po_draft_id;
1381:
1382: INSERT INTO po_exhibit_details_draft
1383: (
1384: po_exhibit_details_id,
1385: po_header_id,
1386: draft_id,

Line 1384: po_exhibit_details_id,

1380: l_docid := p_po_draft_id;
1381:
1382: INSERT INTO po_exhibit_details_draft
1383: (
1384: po_exhibit_details_id,
1385: po_header_id,
1386: draft_id,
1387: exhibit_name,
1388: exhibit_description,

Line 1399: po_exhibit_details_s.nextval,

1395: CREATED_BY,
1396: LAST_UPDATE_LOGIN
1397: )
1398: SELECT
1399: po_exhibit_details_s.nextval,
1400: po_header_id,
1401: draft_id,
1402: l_new_exhibit_name,
1403: exhibit_description,

Line 1412: FROM po_exhibit_details_draft dft

1408: fnd_global.user_id,
1409: SYSDATE,
1410: fnd_global.user_id,
1411: fnd_global.login_id
1412: FROM po_exhibit_details_draft dft
1413: WHERE po_header_id = p_po_header_id
1414: AND draft_id = p_po_draft_id
1415: AND exhibit_name = p_exhibit_name;
1416: