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.JG_GLOBE_FLEX_VAL dependencies on JG_GLOBE_FLEX_VAL_SHARED

Line 227: (p_glob_attr_set IN jg_globe_flex_val_shared.GdfRec) RETURN BOOLEAN IS

223: --
224: -- Modified version of check_attr_exists
225: --
226: FUNCTION check_attr_exists
227: (p_glob_attr_set IN jg_globe_flex_val_shared.GdfRec) RETURN BOOLEAN IS
228:
229: BEGIN
230: IF (p_glob_attr_set.global_attribute1 IS NOT NULL) or
231: (p_glob_attr_set.global_attribute2 IS NOT NULL) or

Line 462: p_glob_attr_set jg_globe_flex_val_shared.GdfRec,

458: END IF;
459: END check_context_code;
460:
461: FUNCTION check_each_gdf(p_flexfield_name VARCHAR2,
462: p_glob_attr_set jg_globe_flex_val_shared.GdfRec,
463: p_glob_attr_gen jg_globe_flex_val_shared.GenRec)
464: RETURN VARCHAR2 IS
465:
466: l_errcode VARCHAR2(10) DEFAULT NULL;

Line 463: p_glob_attr_gen jg_globe_flex_val_shared.GenRec)

459: END check_context_code;
460:
461: FUNCTION check_each_gdf(p_flexfield_name VARCHAR2,
462: p_glob_attr_set jg_globe_flex_val_shared.GdfRec,
463: p_glob_attr_gen jg_globe_flex_val_shared.GenRec)
464: RETURN VARCHAR2 IS
465:
466: l_errcode VARCHAR2(10) DEFAULT NULL;
467:

Line 1304: jg_globe_flex_val_shared.insert_rejections(p_parent_table,

1300: p_global_attribute18,
1301: p_global_attribute19,
1302: p_global_attribute20) <> TRUE)
1303: THEN
1304: jg_globe_flex_val_shared.insert_rejections(p_parent_table,
1305: p_parent_id,
1306: 'GLOBAL_ATTR_VALUE_FOUND',
1307: p_default_last_updated_by,
1308: p_default_last_update_login,

Line 1344: jg_globe_flex_val_shared.insert_rejections(p_parent_table,

1340: IF (check_context_code(
1341: p_calling_program_name,
1342: p_global_attribute_category) <> TRUE)
1343: THEN
1344: jg_globe_flex_val_shared.insert_rejections(p_parent_table,
1345: p_parent_id,
1346: 'INVALID_GLOBAL_CONTEXT',
1347: p_default_last_updated_by,
1348: p_default_last_update_login,

Line 1773: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */

1769: WHERE i.request_id = p_request_id
1770: AND nvl(i.validated_flag,'N') <> 'Y';
1771:
1772:
1773: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1774: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1775: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1776: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1777:

Line 1774: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */

1770: AND nvl(i.validated_flag,'N') <> 'Y';
1771:
1772:
1773: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1774: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1775: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1776: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1777:
1778: --

Line 1775: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */

1771:
1772:
1773: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1774: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1775: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1776: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1777:
1778: --
1779: -- End of modification

Line 1776: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */

1772:
1773: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1774: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1775: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1776: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1777:
1778: --
1779: -- End of modification
1780: --

Line 2028: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

2024: -- Modified version of check_attr_value_ar
2025: --
2026: PROCEDURE check_attr_value_ar
2027: (p_int_table_name IN VARCHAR2,
2028: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2029: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2030: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2031: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2032: p_current_record_status OUT NOCOPY VARCHAR2

Line 2029: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

2025: --
2026: PROCEDURE check_attr_value_ar
2027: (p_int_table_name IN VARCHAR2,
2028: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2029: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2030: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2031: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2032: p_current_record_status OUT NOCOPY VARCHAR2
2033: ) IS

Line 2030: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

2026: PROCEDURE check_attr_value_ar
2027: (p_int_table_name IN VARCHAR2,
2028: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2029: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2030: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2031: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2032: p_current_record_status OUT NOCOPY VARCHAR2
2033: ) IS
2034:

Line 2031: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,

2027: (p_int_table_name IN VARCHAR2,
2028: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2029: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2030: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2031: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2032: p_current_record_status OUT NOCOPY VARCHAR2
2033: ) IS
2034:
2035: l_current_record_status1 VARCHAR2(1);

Line 2126: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

2122: -- Modified version of ar_context_integrity
2123: --
2124: PROCEDURE check_ar_context_integrity(
2125: p_int_table_name IN VARCHAR2,
2126: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2127: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2128: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2129: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2130: p_current_record_status OUT NOCOPY VARCHAR2) IS

Line 2127: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

2123: --
2124: PROCEDURE check_ar_context_integrity(
2125: p_int_table_name IN VARCHAR2,
2126: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2127: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2128: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2129: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2130: p_current_record_status OUT NOCOPY VARCHAR2) IS
2131:

Line 2128: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

2124: PROCEDURE check_ar_context_integrity(
2125: p_int_table_name IN VARCHAR2,
2126: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2127: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2128: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2129: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2130: p_current_record_status OUT NOCOPY VARCHAR2) IS
2131:
2132: l_errcode1 varchar2(10) DEFAULT NULL;

Line 2129: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,

2125: p_int_table_name IN VARCHAR2,
2126: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2127: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2128: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2129: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2130: p_current_record_status OUT NOCOPY VARCHAR2) IS
2131:
2132: l_errcode1 varchar2(10) DEFAULT NULL;
2133: l_errcode varchar2(50) DEFAULT NULL;

Line 2200: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_RA_CUSTOMERS_INTERFACE(

2196: IF l_errcode IS NOT NULL THEN
2197: --
2198: -- Update STATUS column of the customer interface table
2199: --
2200: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_RA_CUSTOMERS_INTERFACE(
2201: l_errcode,
2202: p_glob_attr_general.core_prod_arg2,
2203: 'E');
2204: END IF;

Line 2238: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_INTERFACE_STATUS(

2234:
2235: --
2236: -- Update STATUS column of the profile interface table
2237: --
2238: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_INTERFACE_STATUS(
2239: p_glob_attr_general.core_prod_arg2,
2240: 'RA_CUSTOMER_PROFILES_INTERFACE',
2241: l_errcode,
2242: 'E');

Line 2394: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

2390: -- Modified version of check_ar_business_rules
2391: --
2392: PROCEDURE check_ar_business_rules(
2393: p_int_table_name IN VARCHAR2,
2394: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2395: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2396: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2397: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2398: p_current_record_status OUT NOCOPY VARCHAR2,

Line 2395: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

2391: --
2392: PROCEDURE check_ar_business_rules(
2393: p_int_table_name IN VARCHAR2,
2394: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2395: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2396: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2397: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2398: p_current_record_status OUT NOCOPY VARCHAR2,
2399: p_org_id IN NUMBER ) IS --2354736

Line 2396: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

2392: PROCEDURE check_ar_business_rules(
2393: p_int_table_name IN VARCHAR2,
2394: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2395: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2396: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2397: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2398: p_current_record_status OUT NOCOPY VARCHAR2,
2399: p_org_id IN NUMBER ) IS --2354736
2400:

Line 2397: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,

2393: p_int_table_name IN VARCHAR2,
2394: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2395: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2396: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2397: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2398: p_current_record_status OUT NOCOPY VARCHAR2,
2399: p_org_id IN NUMBER ) IS --2354736
2400:
2401: