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.

[Home] [Help]

APPS.JG_GLOBE_FLEX_VAL dependencies on JG_GLOBE_FLEX_VAL_SHARED

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

210: --
211: -- Modified version of check_attr_exists
212: --
213: FUNCTION check_attr_exists
214: (p_glob_attr_set IN jg_globe_flex_val_shared.GdfRec) RETURN BOOLEAN IS
215:
216: BEGIN
217: IF (p_glob_attr_set.global_attribute1 IS NOT NULL) or
218: (p_glob_attr_set.global_attribute2 IS NOT NULL) or

Line 415: p_glob_attr_set jg_globe_flex_val_shared.GdfRec,

411: END IF;
412: END check_context_code;
413:
414: FUNCTION check_each_gdf(p_flexfield_name VARCHAR2,
415: p_glob_attr_set jg_globe_flex_val_shared.GdfRec,
416: p_glob_attr_gen jg_globe_flex_val_shared.GenRec)
417: RETURN VARCHAR2 IS
418:
419: l_errcode VARCHAR2(10) DEFAULT NULL;

Line 416: p_glob_attr_gen jg_globe_flex_val_shared.GenRec)

412: END check_context_code;
413:
414: FUNCTION check_each_gdf(p_flexfield_name VARCHAR2,
415: p_glob_attr_set jg_globe_flex_val_shared.GdfRec,
416: p_glob_attr_gen jg_globe_flex_val_shared.GenRec)
417: RETURN VARCHAR2 IS
418:
419: l_errcode VARCHAR2(10) DEFAULT NULL;
420:

Line 1197: jg_globe_flex_val_shared.insert_rejections(p_parent_table,

1193: p_global_attribute18,
1194: p_global_attribute19,
1195: p_global_attribute20) <> TRUE)
1196: THEN
1197: jg_globe_flex_val_shared.insert_rejections(p_parent_table,
1198: p_parent_id,
1199: 'GLOBAL_ATTR_VALUE_FOUND',
1200: p_default_last_updated_by,
1201: p_default_last_update_login,

Line 1237: jg_globe_flex_val_shared.insert_rejections(p_parent_table,

1233: IF (check_context_code(
1234: p_calling_program_name,
1235: p_global_attribute_category) <> TRUE)
1236: THEN
1237: jg_globe_flex_val_shared.insert_rejections(p_parent_table,
1238: p_parent_id,
1239: 'INVALID_GLOBAL_CONTEXT',
1240: p_default_last_updated_by,
1241: p_default_last_update_login,

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

1662: WHERE i.request_id = p_request_id
1663: AND nvl(i.validated_flag,'N') <> 'Y';
1664:
1665:
1666: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1667: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1668: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1669: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1670:

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

1663: AND nvl(i.validated_flag,'N') <> 'Y';
1664:
1665:
1666: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1667: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1668: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1669: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1670:
1671: --

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

1664:
1665:
1666: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1667: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1668: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1669: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1670:
1671: --
1672: -- End of modification

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

1665:
1666: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1667: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1668: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1669: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1670:
1671: --
1672: -- End of modification
1673: --

Line 1921: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

1917: -- Modified version of check_attr_value_ar
1918: --
1919: PROCEDURE check_attr_value_ar
1920: (p_int_table_name IN VARCHAR2,
1921: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1922: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1923: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1924: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
1925: p_current_record_status OUT NOCOPY VARCHAR2

Line 1922: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

1918: --
1919: PROCEDURE check_attr_value_ar
1920: (p_int_table_name IN VARCHAR2,
1921: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1922: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1923: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1924: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
1925: p_current_record_status OUT NOCOPY VARCHAR2
1926: ) IS

Line 1923: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

1919: PROCEDURE check_attr_value_ar
1920: (p_int_table_name IN VARCHAR2,
1921: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1922: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1923: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1924: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
1925: p_current_record_status OUT NOCOPY VARCHAR2
1926: ) IS
1927:

Line 1924: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,

1920: (p_int_table_name IN VARCHAR2,
1921: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1922: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1923: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1924: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
1925: p_current_record_status OUT NOCOPY VARCHAR2
1926: ) IS
1927:
1928: l_current_record_status1 VARCHAR2(1);

Line 2019: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

2015: -- Modified version of ar_context_integrity
2016: --
2017: PROCEDURE check_ar_context_integrity(
2018: p_int_table_name IN VARCHAR2,
2019: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2020: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2021: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2022: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2023: p_current_record_status OUT NOCOPY VARCHAR2) IS

Line 2020: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

2016: --
2017: PROCEDURE check_ar_context_integrity(
2018: p_int_table_name IN VARCHAR2,
2019: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2020: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2021: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2022: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2023: p_current_record_status OUT NOCOPY VARCHAR2) IS
2024:

Line 2021: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

2017: PROCEDURE check_ar_context_integrity(
2018: p_int_table_name IN VARCHAR2,
2019: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2020: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2021: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2022: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2023: p_current_record_status OUT NOCOPY VARCHAR2) IS
2024:
2025: l_errcode1 varchar2(10) DEFAULT NULL;

Line 2022: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,

2018: p_int_table_name IN VARCHAR2,
2019: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2020: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2021: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2022: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2023: p_current_record_status OUT NOCOPY VARCHAR2) IS
2024:
2025: l_errcode1 varchar2(10) DEFAULT NULL;
2026: l_errcode varchar2(50) DEFAULT NULL;

Line 2093: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_RA_CUSTOMERS_INTERFACE(

2089: IF l_errcode IS NOT NULL THEN
2090: --
2091: -- Update STATUS column of the customer interface table
2092: --
2093: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_RA_CUSTOMERS_INTERFACE(
2094: l_errcode,
2095: p_glob_attr_general.core_prod_arg2,
2096: 'E');
2097: END IF;

Line 2131: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_INTERFACE_STATUS(

2127:
2128: --
2129: -- Update STATUS column of the profile interface table
2130: --
2131: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_INTERFACE_STATUS(
2132: p_glob_attr_general.core_prod_arg2,
2133: 'RA_CUSTOMER_PROFILES_INTERFACE',
2134: l_errcode,
2135: 'E');

Line 2287: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

2283: -- Modified version of check_ar_business_rules
2284: --
2285: PROCEDURE check_ar_business_rules(
2286: p_int_table_name IN VARCHAR2,
2287: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2288: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2289: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2290: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2291: p_current_record_status OUT NOCOPY VARCHAR2,

Line 2288: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

2284: --
2285: PROCEDURE check_ar_business_rules(
2286: p_int_table_name IN VARCHAR2,
2287: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2288: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2289: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2290: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2291: p_current_record_status OUT NOCOPY VARCHAR2,
2292: p_org_id IN NUMBER ) IS --2354736

Line 2289: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

2285: PROCEDURE check_ar_business_rules(
2286: p_int_table_name IN VARCHAR2,
2287: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2288: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2289: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2290: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2291: p_current_record_status OUT NOCOPY VARCHAR2,
2292: p_org_id IN NUMBER ) IS --2354736
2293:

Line 2290: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,

2286: p_int_table_name IN VARCHAR2,
2287: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2288: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2289: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2290: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2291: p_current_record_status OUT NOCOPY VARCHAR2,
2292: p_org_id IN NUMBER ) IS --2354736
2293:
2294: