APPS.GCS_WEBADI_PKG dependencies on GCS_DIMENSION_MEMBERS_T

Line 1228: FROM gcs_dimension_members_t

1224: status )
1225: SELECT display_code,
1226: value_set_display_code,
1227: ''LOAD''
1228: FROM gcs_dimension_members_t
1229: WHERE sequence_num = :1 '
1230: USING p_sequence_num;
1231: ELSE
1232: EXECUTE IMMEDIATE

Line 1243: FROM gcs_dimension_members_t

1239: SELECT display_code,
1240: value_set_display_code,
1241: ''LOAD'',
1242: dimension_group_display_code
1243: FROM gcs_dimension_members_t
1244: WHERE sequence_num = :1 '
1245: USING p_sequence_num;
1246: END IF;
1247:

Line 1263: FROM gcs_dimension_members_t

1259: USERENV(''LANG''),
1260: name,
1261: description,
1262: ''LOAD''
1263: FROM gcs_dimension_members_t
1264: WHERE sequence_num = :1 '
1265: USING p_sequence_num;
1266:
1267: SELECT fdab.attribute_id, fxd.member_display_code_col, fxd.member_b_table_name,

Line 1306: FROM gcs_dimension_members_t gdmt,

1302: gdmt.ext_account_type_code, :3),
1303: NULL,
1304: fdavb.version_display_code,
1305: ''LOAD''
1306: FROM gcs_dimension_members_t gdmt,
1307: fem_dim_attr_versions_b fdavb
1308: WHERE fdavb.default_version_flag = ''Y''
1309: AND fdavb.attribute_id = :4
1310: AND gdmt.sequence_num = :5 '

Line 1334: FROM gcs_dimension_members_t ,

1330: cost_center_display_code,
1331: cost_center_vs_display_code,
1332: fdavb.version_display_code,
1333: 'LOAD'
1334: FROM gcs_dimension_members_t ,
1335: fem_dim_attr_versions_b fdavb,
1336: fem_dim_attributes_b fdab
1337: WHERE fdavb.default_version_flag = 'Y'
1338: AND fdavb.attribute_id = fdab.attribute_id

Line 1359: FROM gcs_dimension_members_t ,

1355: company_display_code,
1356: company_vs_display_code,
1357: fdavb.version_display_code,
1358: 'LOAD'
1359: FROM gcs_dimension_members_t ,
1360: fem_dim_attr_versions_b fdavb,
1361: fem_dim_attributes_b fdab
1362: WHERE fdavb.default_version_flag = 'Y'
1363: AND fdavb.attribute_id = fdab.attribute_id

Line 1446: DELETE FROM gcs_dimension_members_t

1442: x_errbuf := SQLERRM;
1443: x_retcode := '2';
1444:
1445: -- delete submitted data for this run
1446: DELETE FROM gcs_dimension_members_t
1447: WHERE sequence_num = p_sequence_num;
1448:
1449:
1450: -- Write the appropriate information to the execution report

Line 1467: DELETE FROM gcs_dimension_members_t

1463: x_errbuf := SQLERRM;
1464: x_retcode := '2';
1465:
1466: -- delete submitted data for this run
1467: DELETE FROM gcs_dimension_members_t
1468: WHERE sequence_num = p_sequence_num;
1469:
1470: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1471: FND_FILE.NEW_LINE(FND_FILE.LOG);