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 875: -- Generate the interface columns in the BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL tables

871: P_SOURCE_LANG,
872: P_USER_ID)
873: LOOP
874:
875: -- Generate the interface columns in the BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL tables
876:
877: INSERT INTO BNE_INTERFACE_COLS_B
878: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE,
879: INTERFACE_COL_NAME, ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG,

Line 877: INSERT INTO BNE_INTERFACE_COLS_B

873: LOOP
874:
875: -- Generate the interface columns in the BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL tables
876:
877: INSERT INTO BNE_INTERFACE_COLS_B
878: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE,
879: INTERFACE_COL_NAME, ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG,
880: SUMMARY_FLAG, MAPPING_ENABLED_FLAG, DATA_TYPE, FIELD_SIZE, DISPLAY_ORDER,
881: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

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

930: P_USER_ID,
931: P_INTERFACE_TABLE_OWNER)
932: LOOP
933:
934: -- Generate the interface columns in the BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL tables
935:
936: INSERT INTO BNE_INTERFACE_COLS_B
937: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE,
938: INTERFACE_COL_NAME, ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG,

Line 936: INSERT INTO BNE_INTERFACE_COLS_B

932: LOOP
933:
934: -- Generate the interface columns in the BNE_INTERFACE_COLS_B and BNE_INTERFACE_COLS_TL tables
935:
936: INSERT INTO BNE_INTERFACE_COLS_B
937: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE,
938: INTERFACE_COL_NAME, ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG,
939: SUMMARY_FLAG, MAPPING_ENABLED_FLAG, DATA_TYPE, FIELD_SIZE, DISPLAY_ORDER,
940: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)

Line 988: FROM BNE_INTERFACE_COLS_B BIC

984:
985: BEGIN
986: SELECT COUNT(*)
987: INTO VN_STANDARD_WHO_COUNT
988: FROM BNE_INTERFACE_COLS_B BIC
989: WHERE APPLICATION_ID = P_APPLICATION_ID
990: AND INTERFACE_CODE = P_INTERFACE_CODE
991: AND INTERFACE_COL_NAME IN
992: ('CREATED_BY','LAST_UPDATED_BY','LAST_UPDATE_LOGIN','CREATION_DATE','LAST_UPDATE_DATE');

Line 998: UPDATE BNE_INTERFACE_COLS_B

994: WHEN NO_DATA_FOUND THEN NULL;
995: END;
996:
997: IF VN_STANDARD_WHO_COUNT = 5 THEN
998: UPDATE BNE_INTERFACE_COLS_B
999: SET DISPLAY_FLAG = 'N'
1000: ,REQUIRED_FLAG = 'Y'
1001: ,DEFAULT_TYPE = 'ENVIRONMENT'
1002: ,DEFAULT_VALUE = 'OAUSER.ID'

Line 1008: UPDATE BNE_INTERFACE_COLS_B

1004: AND INTERFACE_CODE = P_INTERFACE_CODE
1005: AND INTERFACE_COL_NAME IN
1006: ('CREATED_BY','LAST_UPDATED_BY','LAST_UPDATE_LOGIN');
1007:
1008: UPDATE BNE_INTERFACE_COLS_B
1009: SET DISPLAY_FLAG = 'N'
1010: ,REQUIRED_FLAG = 'Y'
1011: ,DEFAULT_TYPE = 'ENVIRONMENT'
1012: ,DEFAULT_VALUE = 'SYSDATE'

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

1249: P_LANGUAGE,
1250: P_SOURCE_LANG,
1251: P_USER_ID) LOOP
1252:
1253: -- Generate the Interface Columns in table BNE_INTERFACE_COLS_B
1254:
1255: INSERT INTO BNE_INTERFACE_COLS_B
1256: (APPLICATION_ID,
1257: INTERFACE_CODE,

Line 1255: INSERT INTO BNE_INTERFACE_COLS_B

1251: P_USER_ID) LOOP
1252:
1253: -- Generate the Interface Columns in table BNE_INTERFACE_COLS_B
1254:
1255: INSERT INTO BNE_INTERFACE_COLS_B
1256: (APPLICATION_ID,
1257: INTERFACE_CODE,
1258: OBJECT_VERSION_NUMBER,
1259: SEQUENCE_NUM,

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

1470: VALUES
1471: (P_APPLICATION_ID, P_INTERFACE_CODE, P_LANGUAGE, P_SOURCE_LANG, VV_DESCRIPTION,
1472: P_USER_ID, SYSDATE, P_USER_ID, SYSDATE);
1473:
1474: -- Generate the Interface Columns in the BNE_INTERFACE_COLS_B table.
1475:
1476: INSERT INTO BNE_INTERFACE_COLS_B
1477: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE, INTERFACE_COL_NAME,
1478: ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG, SUMMARY_FLAG, DATA_TYPE, MAPPING_ENABLED_FLAG, DISPLAY_ORDER,

Line 1476: INSERT INTO BNE_INTERFACE_COLS_B

1472: P_USER_ID, SYSDATE, P_USER_ID, SYSDATE);
1473:
1474: -- Generate the Interface Columns in the BNE_INTERFACE_COLS_B table.
1475:
1476: INSERT INTO BNE_INTERFACE_COLS_B
1477: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE, INTERFACE_COL_NAME,
1478: ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG, SUMMARY_FLAG, DATA_TYPE, MAPPING_ENABLED_FLAG, DISPLAY_ORDER,
1479: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
1480: SELECT P_APPLICATION_ID APPLICATION_ID,

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

1547: -- Date Username Description --
1548: -- 22-APR-2002 JRICHARD CREATED --
1549: -- 22-OCT-2002 KPEET Updated to use new primary keys in 8.3 schema. --
1550: -- 24-OCT-2002 KPEET Removed VAL_MSG_COL as this columns has been --
1551: -- removed from the BNE_INTERFACE_COLS_B table. --
1552: -- 16-FEB-2005 DGROVES Bug 4187173 Added new columns. --
1553: --------------------------------------------------------------------------------
1554: PROCEDURE UPSERT_INTERFACE_COLUMN
1555: (P_APPLICATION_ID IN NUMBER, P_INTERFACE_CODE IN VARCHAR2,

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

1576: P_USER_ID IN NUMBER)
1577: IS
1578: VN_NO_INTERFACE_COL_FLAG NUMBER;
1579: BEGIN
1580: -- Check the BNE_INTERFACE_COLS_B table to ensure that the record
1581: -- does not already exist
1582:
1583: VN_NO_INTERFACE_COL_FLAG := 0;
1584:

Line 1588: FROM BNE_INTERFACE_COLS_B

1584:
1585: BEGIN
1586: SELECT 1
1587: INTO VN_NO_INTERFACE_COL_FLAG
1588: FROM BNE_INTERFACE_COLS_B
1589: WHERE APPLICATION_ID = P_APPLICATION_ID
1590: AND INTERFACE_CODE = P_INTERFACE_CODE
1591: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
1592: EXCEPTION

Line 1600: -- Insert the required row in BNE_INTERFACE_COLS_B

1596: -- If the Interface Column was not found then create
1597:
1598: IF (VN_NO_INTERFACE_COL_FLAG = 0) THEN
1599:
1600: -- Insert the required row in BNE_INTERFACE_COLS_B
1601:
1602: INSERT INTO BNE_INTERFACE_COLS_B
1603: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE, INTERFACE_COL_NAME,
1604: ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG, SUMMARY_FLAG, MAPPING_ENABLED_FLAG,

Line 1602: INSERT INTO BNE_INTERFACE_COLS_B

1598: IF (VN_NO_INTERFACE_COL_FLAG = 0) THEN
1599:
1600: -- Insert the required row in BNE_INTERFACE_COLS_B
1601:
1602: INSERT INTO BNE_INTERFACE_COLS_B
1603: (APPLICATION_ID, INTERFACE_CODE, OBJECT_VERSION_NUMBER, SEQUENCE_NUM, INTERFACE_COL_TYPE, INTERFACE_COL_NAME,
1604: ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG, SUMMARY_FLAG, MAPPING_ENABLED_FLAG,
1605: DATA_TYPE, FIELD_SIZE, DEFAULT_TYPE, DEFAULT_VALUE, SEGMENT_NUMBER, GROUP_NAME, OA_FLEX_CODE, OA_CONCAT_FLEX,
1606: VAL_TYPE, VAL_ID_COL, VAL_MEAN_COL, VAL_DESC_COL, VAL_OBJ_NAME, VAL_ADDL_W_C, VAL_COMPONENT_APP_ID,

Line 1629: -- Update the required row in BNE_INTERFACE_COLS_B

1625: (P_APPLICATION_ID, P_INTERFACE_CODE, P_SEQUENCE_NUM, P_LANGUAGE, P_SOURCE_LANG, P_USER_HINT, P_PROMPT_LEFT,
1626: P_USER_HELP_TEXT, P_PROMPT_ABOVE, P_USER_ID, SYSDATE, P_USER_ID, SYSDATE);
1627: END IF;
1628: ELSE
1629: -- Update the required row in BNE_INTERFACE_COLS_B
1630:
1631: UPDATE BNE_INTERFACE_COLS_B
1632: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1633: INTERFACE_COL_TYPE = P_INTERFACE_COL_TYPE,

Line 1631: UPDATE BNE_INTERFACE_COLS_B

1627: END IF;
1628: ELSE
1629: -- Update the required row in BNE_INTERFACE_COLS_B
1630:
1631: UPDATE BNE_INTERFACE_COLS_B
1632: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1633: INTERFACE_COL_TYPE = P_INTERFACE_COL_TYPE,
1634: INTERFACE_COL_NAME = P_INTERFACE_COL_NAME,
1635: ENABLED_FLAG = P_ENABLED_FLAG,

Line 1755: FROM BNE_INTERFACE_COLS_B IC

1751: WHERE ATC.OWNER = CP_ORACLE_USER
1752: AND ATC.TABLE_NAME = CP_VIEW_NAME
1753: AND NOT EXISTS
1754: (SELECT 1
1755: FROM BNE_INTERFACE_COLS_B IC
1756: WHERE SUBSTR(IC.INTERFACE_COL_NAME,3) = ATC.COLUMN_NAME
1757: AND IC.INTERFACE_CODE = CP_INTERFACE_CODE);
1758: --
1759: VV_ORACLE_USER VARCHAR2(20);

Line 1781: FROM BNE_INTERFACE_COLS_B

1777: VN_SEQUENCE_NUM := 0;
1778: BEGIN
1779: SELECT MAX(SEQUENCE_NUM)
1780: INTO VN_SEQUENCE_NUM
1781: FROM BNE_INTERFACE_COLS_B
1782: WHERE INTERFACE_CODE = P_INTERFACE_CODE
1783: AND APPLICATION_ID = P_APPLICATION_ID;
1784: EXCEPTION
1785: WHEN OTHERS THEN

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

1797: P_VIEW_NAME) LOOP
1798: -- Keep note of number of cols we've inserted
1799: VN_SEQUENCE_NUM := VN_SEQUENCE_NUM + 1;
1800:
1801: -- Generate the view Columns in table BNE_INTERFACE_COLS_B
1802: -- for those view columns not matching an api param
1803: INSERT INTO BNE_INTERFACE_COLS_B
1804: (APPLICATION_ID,
1805: INTERFACE_CODE,

Line 1803: INSERT INTO BNE_INTERFACE_COLS_B

1799: VN_SEQUENCE_NUM := VN_SEQUENCE_NUM + 1;
1800:
1801: -- Generate the view Columns in table BNE_INTERFACE_COLS_B
1802: -- for those view columns not matching an api param
1803: INSERT INTO BNE_INTERFACE_COLS_B
1804: (APPLICATION_ID,
1805: INTERFACE_CODE,
1806: OBJECT_VERSION_NUMBER,
1807: SEQUENCE_NUM,

Line 2905: VV_INTERFACE_COL BNE_INTERFACE_COLS_B%ROWTYPE;

2901: VV_TABLE_HEADERS VARCHAR2(2000);
2902: VV_TABLE_COLUMNS VARCHAR2(2000);
2903: VV_TABLE_SELECT_COLUMNS VARCHAR2(2000);
2904: VV_TABLE_COLUMN_ALIAS VARCHAR2(2000);
2905: VV_INTERFACE_COL BNE_INTERFACE_COLS_B%ROWTYPE;
2906: VV_DATA_TYPE VARCHAR2(20);
2907: VV_LOV_TYPE VARCHAR2(30);
2908: BEGIN
2909:

Line 2947: FROM BNE_INTERFACE_COLS_B

2943: WHERE USER_ID = P_USER_ID;
2944:
2945: SELECT *
2946: INTO VV_INTERFACE_COL
2947: FROM BNE_INTERFACE_COLS_B
2948: WHERE APPLICATION_ID = P_APPLICATION_ID
2949: AND INTERFACE_CODE = VV_INTERFACE_CODE
2950: AND INTERFACE_COL_NAME = VV_INTERFACE_COL_NAME;
2951:

Line 2956: UPDATE BNE_INTERFACE_COLS_B

2952: VV_INTERFACE_CODE := VV_INTERFACE_COL.INTERFACE_CODE||'_C'||TO_CHAR(VV_INTERFACE_COL.SEQUENCE_NUM);
2953: VV_PARAM_LIST_CODE := VV_INTERFACE_CODE||'_L';
2954: VV_COMPONENT_CODE := VV_INTERFACE_CODE||'_COMP';
2955:
2956: UPDATE BNE_INTERFACE_COLS_B
2957: SET VAL_TYPE = 'TABLE',
2958: VAL_ID_COL = VV_ID_COL,
2959: VAL_MEAN_COL = VV_MEAN_COL,
2960: VAL_DESC_COL = VV_DESC_COL,

Line 3135: VV_INTERFACE_COL BNE_INTERFACE_COLS_B%ROWTYPE;

3131: VV_PARAM_LIST_CODE VARCHAR2(30);
3132: VV_PARAM_DEFN_CODE VARCHAR2(30);
3133: VV_COMPONENT_CODE VARCHAR2(30);
3134: VV_USER_NAME VARCHAR2(30);
3135: VV_INTERFACE_COL BNE_INTERFACE_COLS_B%ROWTYPE;
3136: VV_DATA_TYPE VARCHAR2(20);
3137: BEGIN
3138: VV_INTERFACE_CODE := TRIM(P_INTERFACE_CODE);
3139: VV_INTERFACE_COL_NAME := TRIM(P_INTERFACE_COL_NAME);

Line 3164: FROM BNE_INTERFACE_COLS_B

3160:
3161:
3162: SELECT *
3163: INTO VV_INTERFACE_COL
3164: FROM BNE_INTERFACE_COLS_B
3165: WHERE APPLICATION_ID = P_APPLICATION_ID
3166: AND INTERFACE_CODE = VV_INTERFACE_CODE
3167: AND INTERFACE_COL_NAME = VV_INTERFACE_COL_NAME;
3168:

Line 3173: UPDATE BNE_INTERFACE_COLS_B

3169: VV_INTERFACE_CODE := VV_INTERFACE_COL.INTERFACE_CODE||'_C'||TO_CHAR(VV_INTERFACE_COL.SEQUENCE_NUM);
3170: VV_PARAM_LIST_CODE := VV_INTERFACE_CODE||'_L';
3171: VV_COMPONENT_CODE := VV_INTERFACE_CODE||'_COMP';
3172:
3173: UPDATE BNE_INTERFACE_COLS_B
3174: SET VAL_TYPE = 'JAVA',
3175: VAL_ID_COL = NULL,
3176: VAL_MEAN_COL = NULL,
3177: VAL_DESC_COL = NULL,

Line 3284: VV_INTERFACE_COL BNE_INTERFACE_COLS_B%ROWTYPE;

3280: VV_PARAM_LIST_CODE VARCHAR2(30);
3281: VV_PARAM_DEFN_CODE VARCHAR2(30);
3282: VV_COMPONENT_CODE VARCHAR2(30);
3283: VV_USER_NAME VARCHAR2(30);
3284: VV_INTERFACE_COL BNE_INTERFACE_COLS_B%ROWTYPE;
3285: VV_DATA_TYPE VARCHAR2(20);
3286: BEGIN
3287: VV_INTERFACE_CODE := TRIM(P_INTERFACE_CODE);
3288: VV_INTERFACE_COL_NAME := TRIM(P_INTERFACE_COL_NAME);

Line 3312: FROM BNE_INTERFACE_COLS_B

3308: WHERE USER_ID = P_USER_ID;
3309:
3310: SELECT *
3311: INTO VV_INTERFACE_COL
3312: FROM BNE_INTERFACE_COLS_B
3313: WHERE APPLICATION_ID = P_APPLICATION_ID
3314: AND INTERFACE_CODE = VV_INTERFACE_CODE
3315: AND INTERFACE_COL_NAME = VV_INTERFACE_COL_NAME;
3316:

Line 3321: UPDATE BNE_INTERFACE_COLS_B

3317: VV_INTERFACE_CODE := VV_INTERFACE_COL.INTERFACE_CODE||'_C'||TO_CHAR(VV_INTERFACE_COL.SEQUENCE_NUM);
3318: VV_PARAM_LIST_CODE := VV_INTERFACE_CODE||'_L';
3319: VV_COMPONENT_CODE := VV_INTERFACE_CODE||'_COMP';
3320:
3321: UPDATE BNE_INTERFACE_COLS_B
3322: SET VAL_TYPE = 'JAVA',
3323: VAL_ID_COL = NULL,
3324: VAL_MEAN_COL = NULL,
3325: VAL_DESC_COL = NULL,

Line 3496: FROM BNE_INTERFACE_COLS_B

3492: WHERE USER_ID = P_USER_ID;
3493:
3494: SELECT COUNT(*)
3495: into VV_dummy
3496: FROM BNE_INTERFACE_COLS_B
3497: WHERE APPLICATION_ID = P_APPLICATION_ID
3498: AND INTERFACE_CODE = VV_INTERFACE_CODE
3499: AND INTERFACE_COL_NAME like VV_FLEX_SEG_COL_NAME_PREFIX||'%';
3500:

Line 3508: FROM BNE_INTERFACE_COLS_B

3504: end if;
3505:
3506: SELECT COUNT(*)
3507: INTO VV_DUMMY
3508: FROM BNE_INTERFACE_COLS_B
3509: WHERE APPLICATION_ID = P_APPLICATION_ID
3510: AND INTERFACE_CODE = VV_INTERFACE_CODE
3511: AND INTERFACE_COL_NAME = VV_GROUP_NAME;
3512:

Line 3520: FROM BNE_INTERFACE_COLS_B

3516: end if;
3517:
3518: SELECT COUNT(*)
3519: INTO VV_DUMMY
3520: FROM BNE_INTERFACE_COLS_B
3521: WHERE APPLICATION_ID = P_APPLICATION_ID
3522: AND INTERFACE_CODE = VV_INTERFACE_CODE
3523: AND GROUP_NAME = VV_GROUP_NAME;
3524:

Line 3534: UPDATE BNE_INTERFACE_COLS_B

3530: VV_PARAM_LIST_CODE := VV_INTERFACE_CODE||'_L';
3531: VV_COMPONENT_CODE := VV_INTERFACE_CODE||'_COMP';
3532:
3533:
3534: UPDATE BNE_INTERFACE_COLS_B
3535: SET GROUP_NAME = VV_GROUP_NAME,
3536: INTERFACE_COL_TYPE = 1,
3537: ENABLED_FLAG = 'Y',
3538: REQUIRED_FLAG = 'N',

Line 3561: FROM BNE_INTERFACE_COLS_B

3557: AND INTERFACE_COL_NAME like VV_FLEX_SEG_COL_NAME_PREFIX||'%';
3558:
3559: SELECT MAX(SEQUENCE_NUM)+1, MAX(DISPLAY_ORDER) + 10
3560: INTO VV_SEQUENCE_NUM, VV_DISPLAY_ORDER
3561: FROM BNE_INTERFACE_COLS_B
3562: WHERE APPLICATION_ID = P_APPLICATION_ID
3563: AND INTERFACE_CODE = VV_INTERFACE_CODE;
3564:
3565:

Line 3758: FROM BNE_INTERFACE_COLS_B

3754: WHERE USER_ID = P_USER_ID;
3755:
3756: SELECT COUNT(*)
3757: into VV_dummy
3758: FROM BNE_INTERFACE_COLS_B
3759: WHERE APPLICATION_ID = P_APPLICATION_ID
3760: AND INTERFACE_CODE = VV_INTERFACE_CODE
3761: AND INTERFACE_COL_NAME like VV_FLEX_SEG_COL_NAME_PREFIX||'%';
3762:

Line 3770: FROM BNE_INTERFACE_COLS_B

3766: end if;
3767:
3768: SELECT COUNT(*)
3769: INTO VV_DUMMY
3770: FROM BNE_INTERFACE_COLS_B
3771: WHERE APPLICATION_ID = P_APPLICATION_ID
3772: AND INTERFACE_CODE = VV_INTERFACE_CODE
3773: AND INTERFACE_COL_NAME = VV_GROUP_NAME;
3774:

Line 3782: FROM BNE_INTERFACE_COLS_B

3778: end if;
3779:
3780: SELECT COUNT(*)
3781: INTO VV_DUMMY
3782: FROM BNE_INTERFACE_COLS_B
3783: WHERE APPLICATION_ID = P_APPLICATION_ID
3784: AND INTERFACE_CODE = VV_INTERFACE_CODE
3785: AND GROUP_NAME = VV_GROUP_NAME;
3786:

Line 3800: FROM BNE_INTERFACE_COLS_B

3796: IF VV_CONTEXT_COL_NAME IS NOT NULL
3797: THEN
3798: SELECT COUNT(*)
3799: INTO VV_DUMMY
3800: FROM BNE_INTERFACE_COLS_B
3801: WHERE APPLICATION_ID = P_APPLICATION_ID
3802: AND INTERFACE_CODE = VV_INTERFACE_CODE
3803: AND INTERFACE_COL_NAME = VV_CONTEXT_COL_NAME;
3804:

Line 3813: UPDATE BNE_INTERFACE_COLS_B

3809:
3810: -- update column after segments.
3811: END IF;
3812:
3813: UPDATE BNE_INTERFACE_COLS_B
3814: SET GROUP_NAME = VV_GROUP_NAME,
3815: INTERFACE_COL_TYPE = 1,
3816: ENABLED_FLAG = 'Y',
3817: REQUIRED_FLAG = 'N',

Line 3841: UPDATE BNE_INTERFACE_COLS_B

3837:
3838: -- Update External context field AFTER segments, as they may share the same interface_col_name prefix.
3839: IF VV_CONTEXT_COL_NAME IS NOT NULL
3840: THEN
3841: UPDATE BNE_INTERFACE_COLS_B
3842: SET GROUP_NAME = VV_GROUP_NAME,
3843: INTERFACE_COL_TYPE = 1,
3844: ENABLED_FLAG = 'Y',
3845: REQUIRED_FLAG = 'N',

Line 3870: FROM BNE_INTERFACE_COLS_B

3866: END IF;
3867:
3868: SELECT MAX(SEQUENCE_NUM)+1, MAX(DISPLAY_ORDER) + 10
3869: INTO VV_SEQUENCE_NUM, VV_DISPLAY_ORDER
3870: FROM BNE_INTERFACE_COLS_B
3871: WHERE APPLICATION_ID = P_APPLICATION_ID
3872: AND INTERFACE_CODE = VV_INTERFACE_CODE;
3873:
3874:

Line 4068: FROM BNE_INTERFACE_COLS_B

4064:
4065: BEGIN
4066: SELECT SEQUENCE_NUM
4067: INTO VV_SEQUENCE_NUM
4068: FROM BNE_INTERFACE_COLS_B
4069: WHERE APPLICATION_ID = P_APPLICATION_ID
4070: AND INTERFACE_CODE = VV_INTERFACE_CODE
4071: AND INTERFACE_COL_NAME = VV_INTERFACE_COL_NAME;
4072: EXCEPTION

Line 4079: FROM BNE_INTERFACE_COLS_B

4075: END;
4076:
4077: SELECT COUNT(*)
4078: INTO VV_DUMMY
4079: FROM BNE_INTERFACE_COLS_B
4080: WHERE APPLICATION_ID = P_APPLICATION_ID
4081: AND INTERFACE_CODE = VV_INTERFACE_CODE
4082: AND GROUP_NAME = VV_GROUP_NAME;
4083:

Line 4093: UPDATE BNE_INTERFACE_COLS_B

4089: VV_PARAM_LIST_CODE := VV_INTERFACE_CODE||'_L';
4090: VV_COMPONENT_CODE := VV_INTERFACE_CODE||'_COMP';
4091:
4092:
4093: UPDATE BNE_INTERFACE_COLS_B
4094: SET GROUP_NAME = VV_GROUP_NAME,
4095: INTERFACE_COL_TYPE = 1,
4096: ENABLED_FLAG = 'Y',
4097: READ_ONLY_FLAG = 'N',

Line 4133: FROM BNE_INTERFACE_COLS_B

4129:
4130:
4131: SELECT MAX(SEQUENCE_NUM)+1, MAX(DISPLAY_ORDER) + 10
4132: INTO VV_SEQUENCE_NUM, VV_DISPLAY_ORDER
4133: FROM BNE_INTERFACE_COLS_B
4134: WHERE APPLICATION_ID = P_APPLICATION_ID
4135: AND INTERFACE_CODE = VV_INTERFACE_CODE;
4136:
4137: -- create the segment interface columns.

Line 4487: FROM BNE_INTERFACE_COLS_B

4483: VV_EXP_QUERY_CODE VARCHAR2(30);
4484: BEGIN
4485: SELECT COUNT(*)
4486: INTO VV_COUNT
4487: FROM BNE_INTERFACE_COLS_B
4488: WHERE APPLICATION_ID = P_APPLICATION_ID
4489: AND INTERFACE_CODE = P_INTERFACE_CODE
4490: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
4491:

Line 4504: FROM BNE_INTERFACE_COLS_B C

4500: EXPANDED_SQL_QUERY_APP_ID, EXPANDED_SQL_QUERY_CODE
4501: INTO VV_COMPONENT_APP_ID, VV_COMPONENT_CODE,
4502: VV_QUERY_APP_ID, VV_QUERY_CODE,
4503: VV_EXP_QUERY_APP_ID, VV_EXP_QUERY_CODE
4504: FROM BNE_INTERFACE_COLS_B C
4505: WHERE APPLICATION_ID = P_APPLICATION_ID
4506: AND INTERFACE_CODE = P_INTERFACE_CODE
4507: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
4508:

Line 4509: DELETE FROM BNE_INTERFACE_COLS_B

4505: WHERE APPLICATION_ID = P_APPLICATION_ID
4506: AND INTERFACE_CODE = P_INTERFACE_CODE
4507: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
4508:
4509: DELETE FROM BNE_INTERFACE_COLS_B
4510: WHERE APPLICATION_ID = P_APPLICATION_ID
4511: AND INTERFACE_CODE = P_INTERFACE_CODE
4512: AND SEQUENCE_NUM = P_SEQUENCE_NUM;
4513:

Line 4617: FROM BNE_INTERFACE_COLS_B

4613: AND INTERFACE_CODE = P_INTERFACE_CODE;
4614:
4615: -- Interface Cols ...
4616: FOR I IN (SELECT SEQUENCE_NUM
4617: FROM BNE_INTERFACE_COLS_B
4618: WHERE APPLICATION_ID = P_APPLICATION_ID
4619: AND INTERFACE_CODE = P_INTERFACE_CODE)
4620: LOOP
4621: VV_DUMMY := DELETE_INTERFACE_COL(P_APPLICATION_ID, P_INTERFACE_CODE, I.SEQUENCE_NUM);

Line 5415: FROM BNE_INTERFACE_COLS_B

5411: VV_COUNT := 0;
5412:
5413: SELECT COUNT(*)
5414: INTO VV_DUMMY
5415: FROM BNE_INTERFACE_COLS_B
5416: WHERE VAL_COMPONENT_APP_ID = P_APPLICATION_ID
5417: AND VAL_COMPONENT_CODE = P_COMPONENT_CODE;
5418:
5419: IF VV_DUMMY = 0

Line 5453: FROM BNE_INTERFACE_COLS_B

5449: VV_COUNT := 0;
5450:
5451: SELECT COUNT(*)
5452: INTO VV_DUMMY
5453: FROM BNE_INTERFACE_COLS_B
5454: WHERE VAL_QUERY_APP_ID = P_APPLICATION_ID
5455: AND VAL_QUERY_CODE = P_QUERY_CODE;
5456:
5457: IF VV_DUMMY > 0

Line 5464: FROM BNE_INTERFACE_COLS_B

5460: END IF;
5461:
5462: SELECT COUNT(*)
5463: INTO VV_DUMMY
5464: FROM BNE_INTERFACE_COLS_B
5465: WHERE EXPANDED_SQL_QUERY_APP_ID = P_APPLICATION_ID
5466: AND EXPANDED_SQL_QUERY_CODE = P_QUERY_CODE;
5467:
5468: IF VV_DUMMY > 0