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.BNE_INTEGRATOR_UTILS dependencies on BNE_INTERFACE_COLS_B

Line 842: -- Generate the interface columns in the BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL tables

838: P_SOURCE_LANG,
839: P_USER_ID)
840: LOOP
841:
842: -- Generate the interface columns in the BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL tables
843:
844: INSERT INTO BNE_INTERFACE_COLS_B
845: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE,
846: INTERFACE_COL_NAME, ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG,

Line 844: INSERT INTO BNE_INTERFACE_COLS_B

840: LOOP
841:
842: -- Generate the interface columns in the BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL tables
843:
844: INSERT INTO BNE_INTERFACE_COLS_B
845: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE,
846: INTERFACE_COL_NAME, ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG,
847: SUMMARY_FLAG, MAPPING_ENABLED_FLAG, DATA_TYPE, FIELD_SIZE, DISPLAY_ORDER,
848: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 896: FROM BNE_INTERFACE_COLS_B BIC

892:
893: BEGIN
894: SELECT COUNT(*)
895: INTO VN_STANDARD_WHO_COUNT
896: FROM BNE_INTERFACE_COLS_B BIC
897: WHERE APPLICATION_ID = P_APPLICATION_ID
898: AND INTERFACE_CODE = P_INTERFACE_CODE
899: AND INTERFACE_COL_NAME IN
900: ('CREATED_BY','LAST_UPDATED_BY','LAST_UPDATE_LOGIN','CREATION_DATE','LAST_UPDATE_DATE');

Line 906: UPDATE BNE_INTERFACE_COLS_B

902: WHEN NO_DATA_FOUND THEN NULL;
903: END;
904:
905: IF VN_STANDARD_WHO_COUNT = 5 THEN
906: UPDATE BNE_INTERFACE_COLS_B
907: SET DISPLAY_FLAG = 'N'
908: ,REQUIRED_FLAG = 'Y'
909: ,DEFAULT_TYPE = 'ENVIRONMENT'
910: ,DEFAULT_VALUE = 'OAUSER.ID'

Line 916: UPDATE BNE_INTERFACE_COLS_B

912: AND INTERFACE_CODE = P_INTERFACE_CODE
913: AND INTERFACE_COL_NAME IN
914: ('CREATED_BY','LAST_UPDATED_BY','LAST_UPDATE_LOGIN');
915:
916: UPDATE BNE_INTERFACE_COLS_B
917: SET DISPLAY_FLAG = 'N'
918: ,REQUIRED_FLAG = 'Y'
919: ,DEFAULT_TYPE = 'ENVIRONMENT'
920: ,DEFAULT_VALUE = 'SYSDATE'

Line 1161: -- Generate the Interface Columns in table BNE_INTERFACE_COLS_B

1157: P_LANGUAGE,
1158: P_SOURCE_LANG,
1159: P_USER_ID) LOOP
1160:
1161: -- Generate the Interface Columns in table BNE_INTERFACE_COLS_B
1162:
1163: INSERT INTO BNE_INTERFACE_COLS_B
1164: (APPLICATION_ID,
1165: INTERFACE_CODE,

Line 1163: INSERT INTO BNE_INTERFACE_COLS_B

1159: P_USER_ID) LOOP
1160:
1161: -- Generate the Interface Columns in table BNE_INTERFACE_COLS_B
1162:
1163: INSERT INTO BNE_INTERFACE_COLS_B
1164: (APPLICATION_ID,
1165: INTERFACE_CODE,
1166: OBJECT_VERSION_NUMBER,
1167: SEQUENCE_NUM,

Line 1382: -- Generate the Interface Columns in the BNE_INTERFACE_COLS_B table.

1378: VALUES
1379: (P_APPLICATION_ID, P_INTERFACE_CODE, P_LANGUAGE, P_SOURCE_LANG, VV_DESCRIPTION,
1380: P_USER_ID, SYSDATE, P_USER_ID, SYSDATE);
1381:
1382: -- Generate the Interface Columns in the BNE_INTERFACE_COLS_B table.
1383:
1384: INSERT INTO BNE_INTERFACE_COLS_B
1385: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE, INTERFACE_COL_NAME,
1386: ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG, SUMMARY_FLAG, DATA_TYPE, MAPPING_ENABLED_FLAG, DISPLAY_ORDER,

Line 1384: INSERT INTO BNE_INTERFACE_COLS_B

1380: P_USER_ID, SYSDATE, P_USER_ID, SYSDATE);
1381:
1382: -- Generate the Interface Columns in the BNE_INTERFACE_COLS_B table.
1383:
1384: INSERT INTO BNE_INTERFACE_COLS_B
1385: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE, INTERFACE_COL_NAME,
1386: ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG, SUMMARY_FLAG, DATA_TYPE, MAPPING_ENABLED_FLAG, DISPLAY_ORDER,
1387: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
1388: SELECT P_APPLICATION_ID APPLICATION_ID,

Line 1459: -- removed from the BNE_INTERFACE_COLS_B table. --

1455: -- Date Username Description --
1456: -- 22-APR-2002 JRICHARD CREATED --
1457: -- 22-OCT-2002 KPEET Updated to use new primary keys in 8.3 schema. --
1458: -- 24-OCT-2002 KPEET Removed VAL_MSG_COL as this columns has been --
1459: -- removed from the BNE_INTERFACE_COLS_B table. --
1460: -- 16-FEB-2005 DGROVES Bug 4187173 Added new columns. --
1461: --------------------------------------------------------------------------------
1462: PROCEDURE UPSERT_INTERFACE_COLUMN
1463: (P_APPLICATION_ID IN NUMBER, P_INTERFACE_CODE IN VARCHAR2,

Line 1488: -- Check the BNE_INTERFACE_COLS_B table to ensure that the record

1484: P_USER_ID IN NUMBER)
1485: IS
1486: VN_NO_INTERFACE_COL_FLAG NUMBER;
1487: BEGIN
1488: -- Check the BNE_INTERFACE_COLS_B table to ensure that the record
1489: -- does not already exist
1490:
1491: VN_NO_INTERFACE_COL_FLAG := 0;
1492:

Line 1496: FROM BNE_INTERFACE_COLS_B

1492:
1493: BEGIN
1494: SELECT 1
1495: INTO VN_NO_INTERFACE_COL_FLAG
1496: FROM BNE_INTERFACE_COLS_B
1497: WHERE APPLICATION_ID = P_APPLICATION_ID
1498: AND INTERFACE_CODE = P_INTERFACE_CODE
1499: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
1500: EXCEPTION

Line 1508: -- Insert the required row in BNE_INTERFACE_COLS_B

1504: -- If the Interface Column was not found then create
1505:
1506: IF (VN_NO_INTERFACE_COL_FLAG = 0) THEN
1507:
1508: -- Insert the required row in BNE_INTERFACE_COLS_B
1509:
1510: INSERT INTO BNE_INTERFACE_COLS_B
1511: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE, INTERFACE_COL_NAME,
1512: ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG, SUMMARY_FLAG, MAPPING_ENABLED_FLAG,

Line 1510: INSERT INTO BNE_INTERFACE_COLS_B

1506: IF (VN_NO_INTERFACE_COL_FLAG = 0) THEN
1507:
1508: -- Insert the required row in BNE_INTERFACE_COLS_B
1509:
1510: INSERT INTO BNE_INTERFACE_COLS_B
1511: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE, INTERFACE_COL_NAME,
1512: ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG, SUMMARY_FLAG, MAPPING_ENABLED_FLAG,
1513: DATA_TYPE, FIELD_SIZE, DEFAULT_TYPE, DEFAULT_VALUE, SEGMENT_NUMBER, GROUP_NAME, OA_FLEX_CODE, OA_CONCAT_FLEX,
1514: VAL_TYPE, VAL_ID_COL, VAL_MEAN_COL, VAL_DESC_COL, VAL_OBJ_NAME, VAL_ADDL_W_C, VAL_COMPONENT_APP_ID,

Line 1537: -- Update the required row in BNE_INTERFACE_COLS_B

1533: (P_APPLICATION_ID, P_INTERFACE_CODE, P_SEQUENCE_NUM, P_LANGUAGE, P_SOURCE_LANG, P_USER_HINT, P_PROMPT_LEFT,
1534: P_USER_HELP_TEXT, P_PROMPT_ABOVE, P_USER_ID, SYSDATE, P_USER_ID, SYSDATE);
1535: END IF;
1536: ELSE
1537: -- Update the required row in BNE_INTERFACE_COLS_B
1538:
1539: UPDATE BNE_INTERFACE_COLS_B
1540: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1541: INTERFACE_COL_TYPE = P_INTERFACE_COL_TYPE,

Line 1539: UPDATE BNE_INTERFACE_COLS_B

1535: END IF;
1536: ELSE
1537: -- Update the required row in BNE_INTERFACE_COLS_B
1538:
1539: UPDATE BNE_INTERFACE_COLS_B
1540: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1541: INTERFACE_COL_TYPE = P_INTERFACE_COL_TYPE,
1542: INTERFACE_COL_NAME = P_INTERFACE_COL_NAME,
1543: ENABLED_FLAG = P_ENABLED_FLAG,

Line 1663: FROM BNE_INTERFACE_COLS_B IC

1659: WHERE ATC.OWNER = CP_ORACLE_USER
1660: AND ATC.TABLE_NAME = CP_VIEW_NAME
1661: AND NOT EXISTS
1662: (SELECT 1
1663: FROM BNE_INTERFACE_COLS_B IC
1664: WHERE SUBSTR(IC.INTERFACE_COL_NAME,3) = ATC.COLUMN_NAME
1665: AND IC.INTERFACE_CODE = CP_INTERFACE_CODE)
1666: ORDER BY ATC.COLUMN_ID;
1667: --

Line 1690: FROM BNE_INTERFACE_COLS_B

1686: VN_SEQUENCE_NUM := 0;
1687: BEGIN
1688: SELECT MAX(SEQUENCE_NUM)
1689: INTO VN_SEQUENCE_NUM
1690: FROM BNE_INTERFACE_COLS_B
1691: WHERE INTERFACE_CODE = P_INTERFACE_CODE
1692: AND APPLICATION_ID = P_APPLICATION_ID;
1693: EXCEPTION
1694: WHEN OTHERS THEN

Line 1710: -- Generate the view Columns in table BNE_INTERFACE_COLS_B

1706: P_VIEW_NAME) LOOP
1707: -- Keep note of number of cols we've inserted
1708: VN_SEQUENCE_NUM := VN_SEQUENCE_NUM + 1;
1709:
1710: -- Generate the view Columns in table BNE_INTERFACE_COLS_B
1711: -- for those view columns not matching an api param
1712: INSERT INTO BNE_INTERFACE_COLS_B
1713: (APPLICATION_ID,
1714: INTERFACE_CODE,

Line 1712: INSERT INTO BNE_INTERFACE_COLS_B

1708: VN_SEQUENCE_NUM := VN_SEQUENCE_NUM + 1;
1709:
1710: -- Generate the view Columns in table BNE_INTERFACE_COLS_B
1711: -- for those view columns not matching an api param
1712: INSERT INTO BNE_INTERFACE_COLS_B
1713: (APPLICATION_ID,
1714: INTERFACE_CODE,
1715: OBJECT_VERSION_NUMBER,
1716: SEQUENCE_NUM,

Line 2814: VV_INTERFACE_COL BNE_INTERFACE_COLS_B%ROWTYPE;

2810: VV_TABLE_HEADERS VARCHAR2(2000);
2811: VV_TABLE_COLUMNS VARCHAR2(2000);
2812: VV_TABLE_SELECT_COLUMNS VARCHAR2(2000);
2813: VV_TABLE_COLUMN_ALIAS VARCHAR2(2000);
2814: VV_INTERFACE_COL BNE_INTERFACE_COLS_B%ROWTYPE;
2815: VV_DATA_TYPE VARCHAR2(20);
2816: VV_LOV_TYPE VARCHAR2(30);
2817: BEGIN
2818:

Line 2856: FROM BNE_INTERFACE_COLS_B

2852: WHERE USER_ID = P_USER_ID;
2853:
2854: SELECT *
2855: INTO VV_INTERFACE_COL
2856: FROM BNE_INTERFACE_COLS_B
2857: WHERE APPLICATION_ID = P_APPLICATION_ID
2858: AND INTERFACE_CODE = VV_INTERFACE_CODE
2859: AND INTERFACE_COL_NAME = VV_INTERFACE_COL_NAME;
2860:

Line 2865: UPDATE BNE_INTERFACE_COLS_B

2861: VV_INTERFACE_CODE := VV_INTERFACE_COL.INTERFACE_CODE||'_C'||TO_CHAR(VV_INTERFACE_COL.SEQUENCE_NUM);
2862: VV_PARAM_LIST_CODE := VV_INTERFACE_CODE||'_L';
2863: VV_COMPONENT_CODE := VV_INTERFACE_CODE||'_COMP';
2864:
2865: UPDATE BNE_INTERFACE_COLS_B
2866: SET VAL_TYPE = 'TABLE',
2867: VAL_ID_COL = VV_ID_COL,
2868: VAL_MEAN_COL = VV_MEAN_COL,
2869: VAL_DESC_COL = VV_DESC_COL,

Line 3044: VV_INTERFACE_COL BNE_INTERFACE_COLS_B%ROWTYPE;

3040: VV_PARAM_LIST_CODE VARCHAR2(30);
3041: VV_PARAM_DEFN_CODE VARCHAR2(30);
3042: VV_COMPONENT_CODE VARCHAR2(30);
3043: VV_USER_NAME VARCHAR2(30);
3044: VV_INTERFACE_COL BNE_INTERFACE_COLS_B%ROWTYPE;
3045: VV_DATA_TYPE VARCHAR2(20);
3046: BEGIN
3047: VV_INTERFACE_CODE := TRIM(P_INTERFACE_CODE);
3048: VV_INTERFACE_COL_NAME := TRIM(P_INTERFACE_COL_NAME);

Line 3073: FROM BNE_INTERFACE_COLS_B

3069:
3070:
3071: SELECT *
3072: INTO VV_INTERFACE_COL
3073: FROM BNE_INTERFACE_COLS_B
3074: WHERE APPLICATION_ID = P_APPLICATION_ID
3075: AND INTERFACE_CODE = VV_INTERFACE_CODE
3076: AND INTERFACE_COL_NAME = VV_INTERFACE_COL_NAME;
3077:

Line 3082: UPDATE BNE_INTERFACE_COLS_B

3078: VV_INTERFACE_CODE := VV_INTERFACE_COL.INTERFACE_CODE||'_C'||TO_CHAR(VV_INTERFACE_COL.SEQUENCE_NUM);
3079: VV_PARAM_LIST_CODE := VV_INTERFACE_CODE||'_L';
3080: VV_COMPONENT_CODE := VV_INTERFACE_CODE||'_COMP';
3081:
3082: UPDATE BNE_INTERFACE_COLS_B
3083: SET VAL_TYPE = 'JAVA',
3084: VAL_ID_COL = NULL,
3085: VAL_MEAN_COL = NULL,
3086: VAL_DESC_COL = NULL,

Line 3193: VV_INTERFACE_COL BNE_INTERFACE_COLS_B%ROWTYPE;

3189: VV_PARAM_LIST_CODE VARCHAR2(30);
3190: VV_PARAM_DEFN_CODE VARCHAR2(30);
3191: VV_COMPONENT_CODE VARCHAR2(30);
3192: VV_USER_NAME VARCHAR2(30);
3193: VV_INTERFACE_COL BNE_INTERFACE_COLS_B%ROWTYPE;
3194: VV_DATA_TYPE VARCHAR2(20);
3195: BEGIN
3196: VV_INTERFACE_CODE := TRIM(P_INTERFACE_CODE);
3197: VV_INTERFACE_COL_NAME := TRIM(P_INTERFACE_COL_NAME);

Line 3221: FROM BNE_INTERFACE_COLS_B

3217: WHERE USER_ID = P_USER_ID;
3218:
3219: SELECT *
3220: INTO VV_INTERFACE_COL
3221: FROM BNE_INTERFACE_COLS_B
3222: WHERE APPLICATION_ID = P_APPLICATION_ID
3223: AND INTERFACE_CODE = VV_INTERFACE_CODE
3224: AND INTERFACE_COL_NAME = VV_INTERFACE_COL_NAME;
3225:

Line 3230: UPDATE BNE_INTERFACE_COLS_B

3226: VV_INTERFACE_CODE := VV_INTERFACE_COL.INTERFACE_CODE||'_C'||TO_CHAR(VV_INTERFACE_COL.SEQUENCE_NUM);
3227: VV_PARAM_LIST_CODE := VV_INTERFACE_CODE||'_L';
3228: VV_COMPONENT_CODE := VV_INTERFACE_CODE||'_COMP';
3229:
3230: UPDATE BNE_INTERFACE_COLS_B
3231: SET VAL_TYPE = 'JAVA',
3232: VAL_ID_COL = NULL,
3233: VAL_MEAN_COL = NULL,
3234: VAL_DESC_COL = NULL,

Line 3405: FROM BNE_INTERFACE_COLS_B

3401: WHERE USER_ID = P_USER_ID;
3402:
3403: SELECT COUNT(*)
3404: into VV_dummy
3405: FROM BNE_INTERFACE_COLS_B
3406: WHERE APPLICATION_ID = P_APPLICATION_ID
3407: AND INTERFACE_CODE = VV_INTERFACE_CODE
3408: AND INTERFACE_COL_NAME like VV_FLEX_SEG_COL_NAME_PREFIX||'%';
3409:

Line 3417: FROM BNE_INTERFACE_COLS_B

3413: end if;
3414:
3415: SELECT COUNT(*)
3416: INTO VV_DUMMY
3417: FROM BNE_INTERFACE_COLS_B
3418: WHERE APPLICATION_ID = P_APPLICATION_ID
3419: AND INTERFACE_CODE = VV_INTERFACE_CODE
3420: AND INTERFACE_COL_NAME = VV_GROUP_NAME;
3421:

Line 3429: FROM BNE_INTERFACE_COLS_B

3425: end if;
3426:
3427: SELECT COUNT(*)
3428: INTO VV_DUMMY
3429: FROM BNE_INTERFACE_COLS_B
3430: WHERE APPLICATION_ID = P_APPLICATION_ID
3431: AND INTERFACE_CODE = VV_INTERFACE_CODE
3432: AND GROUP_NAME = VV_GROUP_NAME;
3433:

Line 3443: UPDATE BNE_INTERFACE_COLS_B

3439: VV_PARAM_LIST_CODE := VV_INTERFACE_CODE||'_L';
3440: VV_COMPONENT_CODE := VV_INTERFACE_CODE||'_COMP';
3441:
3442:
3443: UPDATE BNE_INTERFACE_COLS_B
3444: SET GROUP_NAME = VV_GROUP_NAME,
3445: INTERFACE_COL_TYPE = 1,
3446: ENABLED_FLAG = 'Y',
3447: REQUIRED_FLAG = 'N',

Line 3470: FROM BNE_INTERFACE_COLS_B

3466: AND INTERFACE_COL_NAME like VV_FLEX_SEG_COL_NAME_PREFIX||'%';
3467:
3468: SELECT MAX(SEQUENCE_NUM)+1, MAX(DISPLAY_ORDER) + 10
3469: INTO VV_SEQUENCE_NUM, VV_DISPLAY_ORDER
3470: FROM BNE_INTERFACE_COLS_B
3471: WHERE APPLICATION_ID = P_APPLICATION_ID
3472: AND INTERFACE_CODE = VV_INTERFACE_CODE;
3473:
3474:

Line 3667: FROM BNE_INTERFACE_COLS_B

3663: WHERE USER_ID = P_USER_ID;
3664:
3665: SELECT COUNT(*)
3666: into VV_dummy
3667: FROM BNE_INTERFACE_COLS_B
3668: WHERE APPLICATION_ID = P_APPLICATION_ID
3669: AND INTERFACE_CODE = VV_INTERFACE_CODE
3670: AND INTERFACE_COL_NAME like VV_FLEX_SEG_COL_NAME_PREFIX||'%';
3671:

Line 3679: FROM BNE_INTERFACE_COLS_B

3675: end if;
3676:
3677: SELECT COUNT(*)
3678: INTO VV_DUMMY
3679: FROM BNE_INTERFACE_COLS_B
3680: WHERE APPLICATION_ID = P_APPLICATION_ID
3681: AND INTERFACE_CODE = VV_INTERFACE_CODE
3682: AND INTERFACE_COL_NAME = VV_GROUP_NAME;
3683:

Line 3691: FROM BNE_INTERFACE_COLS_B

3687: end if;
3688:
3689: SELECT COUNT(*)
3690: INTO VV_DUMMY
3691: FROM BNE_INTERFACE_COLS_B
3692: WHERE APPLICATION_ID = P_APPLICATION_ID
3693: AND INTERFACE_CODE = VV_INTERFACE_CODE
3694: AND GROUP_NAME = VV_GROUP_NAME;
3695:

Line 3709: FROM BNE_INTERFACE_COLS_B

3705: IF VV_CONTEXT_COL_NAME IS NOT NULL
3706: THEN
3707: SELECT COUNT(*)
3708: INTO VV_DUMMY
3709: FROM BNE_INTERFACE_COLS_B
3710: WHERE APPLICATION_ID = P_APPLICATION_ID
3711: AND INTERFACE_CODE = VV_INTERFACE_CODE
3712: AND INTERFACE_COL_NAME = VV_CONTEXT_COL_NAME;
3713:

Line 3722: UPDATE BNE_INTERFACE_COLS_B

3718:
3719: -- update column after segments.
3720: END IF;
3721:
3722: UPDATE BNE_INTERFACE_COLS_B
3723: SET GROUP_NAME = VV_GROUP_NAME,
3724: INTERFACE_COL_TYPE = 1,
3725: ENABLED_FLAG = 'Y',
3726: REQUIRED_FLAG = 'N',

Line 3750: UPDATE BNE_INTERFACE_COLS_B

3746:
3747: -- Update External context field AFTER segments, as they may share the same interface_col_name prefix.
3748: IF VV_CONTEXT_COL_NAME IS NOT NULL
3749: THEN
3750: UPDATE BNE_INTERFACE_COLS_B
3751: SET GROUP_NAME = VV_GROUP_NAME,
3752: INTERFACE_COL_TYPE = 1,
3753: ENABLED_FLAG = 'Y',
3754: REQUIRED_FLAG = 'N',

Line 3779: FROM BNE_INTERFACE_COLS_B

3775: END IF;
3776:
3777: SELECT MAX(SEQUENCE_NUM)+1, MAX(DISPLAY_ORDER) + 10
3778: INTO VV_SEQUENCE_NUM, VV_DISPLAY_ORDER
3779: FROM BNE_INTERFACE_COLS_B
3780: WHERE APPLICATION_ID = P_APPLICATION_ID
3781: AND INTERFACE_CODE = VV_INTERFACE_CODE;
3782:
3783:

Line 3977: FROM BNE_INTERFACE_COLS_B

3973:
3974: BEGIN
3975: SELECT SEQUENCE_NUM
3976: INTO VV_SEQUENCE_NUM
3977: FROM BNE_INTERFACE_COLS_B
3978: WHERE APPLICATION_ID = P_APPLICATION_ID
3979: AND INTERFACE_CODE = VV_INTERFACE_CODE
3980: AND INTERFACE_COL_NAME = VV_INTERFACE_COL_NAME;
3981: EXCEPTION

Line 3988: FROM BNE_INTERFACE_COLS_B

3984: END;
3985:
3986: SELECT COUNT(*)
3987: INTO VV_DUMMY
3988: FROM BNE_INTERFACE_COLS_B
3989: WHERE APPLICATION_ID = P_APPLICATION_ID
3990: AND INTERFACE_CODE = VV_INTERFACE_CODE
3991: AND GROUP_NAME = VV_GROUP_NAME;
3992:

Line 4002: UPDATE BNE_INTERFACE_COLS_B

3998: VV_PARAM_LIST_CODE := VV_INTERFACE_CODE||'_L';
3999: VV_COMPONENT_CODE := VV_INTERFACE_CODE||'_COMP';
4000:
4001:
4002: UPDATE BNE_INTERFACE_COLS_B
4003: SET GROUP_NAME = VV_GROUP_NAME,
4004: INTERFACE_COL_TYPE = 1,
4005: ENABLED_FLAG = 'Y',
4006: READ_ONLY_FLAG = 'N',

Line 4042: FROM BNE_INTERFACE_COLS_B

4038:
4039:
4040: SELECT MAX(SEQUENCE_NUM)+1, MAX(DISPLAY_ORDER) + 10
4041: INTO VV_SEQUENCE_NUM, VV_DISPLAY_ORDER
4042: FROM BNE_INTERFACE_COLS_B
4043: WHERE APPLICATION_ID = P_APPLICATION_ID
4044: AND INTERFACE_CODE = VV_INTERFACE_CODE;
4045:
4046: -- create the segment interface columns.

Line 4396: FROM BNE_INTERFACE_COLS_B

4392: VV_EXP_QUERY_CODE VARCHAR2(30);
4393: BEGIN
4394: SELECT COUNT(*)
4395: INTO VV_COUNT
4396: FROM BNE_INTERFACE_COLS_B
4397: WHERE APPLICATION_ID = P_APPLICATION_ID
4398: AND INTERFACE_CODE = P_INTERFACE_CODE
4399: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
4400:

Line 4413: FROM BNE_INTERFACE_COLS_B C

4409: EXPANDED_SQL_QUERY_APP_ID, EXPANDED_SQL_QUERY_CODE
4410: INTO VV_COMPONENT_APP_ID, VV_COMPONENT_CODE,
4411: VV_QUERY_APP_ID, VV_QUERY_CODE,
4412: VV_EXP_QUERY_APP_ID, VV_EXP_QUERY_CODE
4413: FROM BNE_INTERFACE_COLS_B C
4414: WHERE APPLICATION_ID = P_APPLICATION_ID
4415: AND INTERFACE_CODE = P_INTERFACE_CODE
4416: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
4417:

Line 4418: DELETE FROM BNE_INTERFACE_COLS_B

4414: WHERE APPLICATION_ID = P_APPLICATION_ID
4415: AND INTERFACE_CODE = P_INTERFACE_CODE
4416: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
4417:
4418: DELETE FROM BNE_INTERFACE_COLS_B
4419: WHERE APPLICATION_ID = P_APPLICATION_ID
4420: AND INTERFACE_CODE = P_INTERFACE_CODE
4421: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
4422:

Line 4526: FROM BNE_INTERFACE_COLS_B

4522: AND INTERFACE_CODE = P_INTERFACE_CODE;
4523:
4524: -- Interface Cols ...
4525: FOR I IN (SELECT SEQUENCE_NUM
4526: FROM BNE_INTERFACE_COLS_B
4527: WHERE APPLICATION_ID = P_APPLICATION_ID
4528: AND INTERFACE_CODE = P_INTERFACE_CODE)
4529: LOOP
4530: VV_DUMMY := DELETE_INTERFACE_COL(P_APPLICATION_ID, P_INTERFACE_CODE, I.SEQUENCE_NUM);

Line 5324: FROM BNE_INTERFACE_COLS_B

5320: VV_COUNT := 0;
5321:
5322: SELECT COUNT(*)
5323: INTO VV_DUMMY
5324: FROM BNE_INTERFACE_COLS_B
5325: WHERE VAL_COMPONENT_APP_ID = P_APPLICATION_ID
5326: AND VAL_COMPONENT_CODE = P_COMPONENT_CODE;
5327:
5328: IF VV_DUMMY = 0

Line 5362: FROM BNE_INTERFACE_COLS_B

5358: VV_COUNT := 0;
5359:
5360: SELECT COUNT(*)
5361: INTO VV_DUMMY
5362: FROM BNE_INTERFACE_COLS_B
5363: WHERE VAL_QUERY_APP_ID = P_APPLICATION_ID
5364: AND VAL_QUERY_CODE = P_QUERY_CODE;
5365:
5366: IF VV_DUMMY > 0

Line 5373: FROM BNE_INTERFACE_COLS_B

5369: END IF;
5370:
5371: SELECT COUNT(*)
5372: INTO VV_DUMMY
5373: FROM BNE_INTERFACE_COLS_B
5374: WHERE EXPANDED_SQL_QUERY_APP_ID = P_APPLICATION_ID
5375: AND EXPANDED_SQL_QUERY_CODE = P_QUERY_CODE;
5376:
5377: IF VV_DUMMY > 0