DBA Data[Home] [Help]

APPS.ENG_TYPE_CONFIGURATION_PKG dependencies on AK_CUSTOM_REGION_ITEMS

Line 320: DELETE FROM AK_CUSTOM_REGION_ITEMS

316: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
317: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
318: AND REGION_CODE = X_REGION_CODE;
319:
320: DELETE FROM AK_CUSTOM_REGION_ITEMS
321: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
322: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
323: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
324: AND REGION_CODE = X_REGION_CODE;

Line 326: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL

322: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
323: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
324: AND REGION_CODE = X_REGION_CODE;
325:
326: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL
327: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
328: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
329: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
330: AND REGION_CODE = X_REGION_CODE;

Line 377: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

373: IF FND_API.To_Boolean(x_init_msg_list) THEN
374: FND_MSG_PUB.Initialize;
375: END IF;
376:
377: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
378: X_ROWID => l_rowid,
379: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
380: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
381: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 398: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

394: );
395:
396: IF (X_ORDER_SEQUENCE IS NOT NULL) THEN
397:
398: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
399: X_ROWID => l_rowid,
400: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
401: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
402: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 421: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

417: END IF;
418:
419: IF (X_ORDER_DIRECTION IS NOT NULL) THEN
420:
421: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
422: X_ROWID => l_rowid,
423: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
424: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
425: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 443: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

439: END IF;
440:
441: IF (X_COLUMN_NAME IS NOT NULL) THEN
442:
443: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
444: X_ROWID => l_rowid,
445: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
446: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
447: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 465: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

461: END IF;
462:
463: IF (X_SHOW_TOTAL IS NOT NULL) THEN
464:
465: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
466: X_ROWID => l_rowid,
467: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
468: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
469: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 527: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

523: IF FND_API.To_Boolean(x_init_msg_list) THEN
524: FND_MSG_PUB.Initialize;
525: END IF;
526:
527: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
528: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
529: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
530: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
531: X_REGION_CODE => X_REGION_CODE,

Line 546: AK_CUSTOM_REGION_ITEMS

542:
543: SELECT
544: COUNT(*) INTO l_count
545: FROM
546: AK_CUSTOM_REGION_ITEMS
547: WHERE
548: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
549: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
550: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 559: DELETE FROM AK_CUSTOM_REGION_ITEMS

555:
556: IF (X_ORDER_SEQUENCE IS NULL) THEN
557:
558: IF (l_count > 0) THEN
559: DELETE FROM AK_CUSTOM_REGION_ITEMS
560: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
561: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
562: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
563: AND REGION_CODE = X_REGION_CODE

Line 573: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

569: ELSE
570:
571: IF (l_count > 0) THEN
572:
573: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
574: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
575: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
576: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
577: X_REGION_CODE => X_REGION_CODE,

Line 591: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

587: );
588:
589: ELSE
590:
591: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
592: X_ROWID => l_rowid,
593: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
594: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
595: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 618: AK_CUSTOM_REGION_ITEMS

614:
615: SELECT
616: COUNT(*) INTO l_count
617: FROM
618: AK_CUSTOM_REGION_ITEMS
619: WHERE
620: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
621: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
622: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 631: DELETE FROM AK_CUSTOM_REGION_ITEMS

627:
628: IF (X_ORDER_DIRECTION IS NULL) THEN
629:
630: IF (l_count > 0) THEN
631: DELETE FROM AK_CUSTOM_REGION_ITEMS
632: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
633: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
634: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
635: AND REGION_CODE = X_REGION_CODE

Line 645: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

641: ELSE
642:
643: IF (l_count > 0) THEN
644:
645: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
646: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
647: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
648: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
649: X_REGION_CODE => X_REGION_CODE,

Line 663: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

659: );
660:
661: ELSE
662:
663: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
664: X_ROWID => l_rowid,
665: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
666: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
667: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 689: AK_CUSTOM_REGION_ITEMS

685:
686: SELECT
687: COUNT(*) INTO l_count
688: FROM
689: AK_CUSTOM_REGION_ITEMS
690: WHERE
691: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
692: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
693: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 702: DELETE FROM AK_CUSTOM_REGION_ITEMS

698:
699: IF (X_COLUMN_NAME IS NULL) THEN
700:
701: IF (l_count > 0) THEN
702: DELETE FROM AK_CUSTOM_REGION_ITEMS
703: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
704: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
705: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
706: AND REGION_CODE = X_REGION_CODE

Line 716: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

712: ELSE
713:
714: IF (l_count > 0) THEN
715:
716: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
717: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
718: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
719: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
720: X_REGION_CODE => X_REGION_CODE,

Line 734: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

730: );
731:
732: ELSE
733:
734: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
735: X_ROWID => l_rowid,
736: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
737: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
738: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 760: AK_CUSTOM_REGION_ITEMS

756:
757: SELECT
758: COUNT(*) INTO l_count
759: FROM
760: AK_CUSTOM_REGION_ITEMS
761: WHERE
762: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
763: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
764: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID

Line 773: DELETE FROM AK_CUSTOM_REGION_ITEMS

769:
770: IF (X_SHOW_TOTAL IS NULL) THEN
771:
772: IF (l_count > 0) THEN
773: DELETE FROM AK_CUSTOM_REGION_ITEMS
774: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
775: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
776: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
777: AND REGION_CODE = X_REGION_CODE

Line 787: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

783: ELSE
784:
785: IF (l_count > 0) THEN
786:
787: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
788: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
789: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
790: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
791: X_REGION_CODE => X_REGION_CODE,

Line 805: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

801: );
802:
803: ELSE
804:
805: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
806: X_ROWID => l_rowid,
807: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
808: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
809: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 857: DELETE FROM AK_CUSTOM_REGION_ITEMS

853: IF FND_API.To_Boolean(x_init_msg_list) THEN
854: FND_MSG_PUB.Initialize;
855: END IF;
856:
857: DELETE FROM AK_CUSTOM_REGION_ITEMS
858: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
859: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
860: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
861: AND REGION_CODE = X_REGION_CODE

Line 865: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL

861: AND REGION_CODE = X_REGION_CODE
862: AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
863: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
864:
865: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL
866: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
867: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
868: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
869: AND REGION_CODE = X_REGION_CODE

Line 911: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(

907: IF FND_API.To_Boolean(x_init_msg_list) THEN
908: FND_MSG_PUB.Initialize;
909: END IF;
910:
911: AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
912: X_ROWID => l_rowid,
913: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
914: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
915: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,

Line 967: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(

963: IF FND_API.To_Boolean(x_init_msg_list) THEN
964: FND_MSG_PUB.Initialize;
965: END IF;
966:
967: AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
968: X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
969: X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
970: X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
971: X_REGION_CODE => X_REGION_CODE,

Line 1011: DELETE FROM AK_CUSTOM_REGION_ITEMS

1007: IF FND_API.To_Boolean(x_init_msg_list) THEN
1008: FND_MSG_PUB.Initialize;
1009: END IF;
1010:
1011: DELETE FROM AK_CUSTOM_REGION_ITEMS
1012: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1013: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1014: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1015: AND REGION_CODE = X_REGION_CODE

Line 1019: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL

1015: AND REGION_CODE = X_REGION_CODE
1016: AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
1017: AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
1018:
1019: DELETE FROM AK_CUSTOM_REGION_ITEMS_TL
1020: WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
1021: AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
1022: AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
1023: AND REGION_CODE = X_REGION_CODE