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.GMD_CONC_REPLACE_PKG dependencies on FND_DSQL

Line 107: fnd_dsql.set_cursor(l_cursor_id);

103: DELETE FROM gmd_msnr_results
104: WHERE concurrent_id IS NULL;
105:
106: l_cursor_id := dbms_sql.open_cursor;
107: fnd_dsql.set_cursor(l_cursor_id);
108: l_dsql_text := fnd_dsql.get_text(FALSE);
109:
110: l_debug_text := fnd_dsql.get_text(TRUE);
111: --insert into shy_text values (l_debug_text); commit;

Line 108: l_dsql_text := fnd_dsql.get_text(FALSE);

104: WHERE concurrent_id IS NULL;
105:
106: l_cursor_id := dbms_sql.open_cursor;
107: fnd_dsql.set_cursor(l_cursor_id);
108: l_dsql_text := fnd_dsql.get_text(FALSE);
109:
110: l_debug_text := fnd_dsql.get_text(TRUE);
111: --insert into shy_text values (l_debug_text); commit;
112:

Line 110: l_debug_text := fnd_dsql.get_text(TRUE);

106: l_cursor_id := dbms_sql.open_cursor;
107: fnd_dsql.set_cursor(l_cursor_id);
108: l_dsql_text := fnd_dsql.get_text(FALSE);
109:
110: l_debug_text := fnd_dsql.get_text(TRUE);
111: --insert into shy_text values (l_debug_text); commit;
112:
113: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);
114: fnd_dsql.do_binds;

Line 114: fnd_dsql.do_binds;

110: l_debug_text := fnd_dsql.get_text(TRUE);
111: --insert into shy_text values (l_debug_text); commit;
112:
113: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);
114: fnd_dsql.do_binds;
115:
116: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );
117: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );
118: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );

Line 2026: fnd_dsql.init;

2022: END IF;
2023:
2024: END IF;
2025:
2026: fnd_dsql.init;
2027: fnd_dsql.add_text( ' Update Gmd_MSNR_Results '||
2028: ' Set Object_select_ind = 0 '||
2029: ' Where concurrent_id IS NULL '||
2030: ' And Object_select_ind = 1 '||

Line 2027: fnd_dsql.add_text( ' Update Gmd_MSNR_Results '||

2023:
2024: END IF;
2025:
2026: fnd_dsql.init;
2027: fnd_dsql.add_text( ' Update Gmd_MSNR_Results '||
2028: ' Set Object_select_ind = 0 '||
2029: ' Where concurrent_id IS NULL '||
2030: ' And Object_select_ind = 1 '||
2031: ' And object_id NOT IN ( Select object_id '||

Line 2046: fnd_dsql.add_text( ' And '||l_replace_type||' IS NULL )');

2042: ,'OPRN_CLASS'
2043: ,'ROUTING_CLASS'
2044: ,'ROUTING_ID'
2045: ,'FORMULA_CLASS') THEN
2046: fnd_dsql.add_text( ' And '||l_replace_type||' IS NULL )');
2047: ELSE
2048: -- pOld_Name cannot be null
2049: FND_MESSAGE.SET_NAME('GMD','GMD_NO_ASSIGN_VALUE_EXCEPTION');
2050: FND_MSG_PUB.ADD;

Line 2054: fnd_dsql.add_text( ' And '||l_replace_type||' IN (');

2050: FND_MSG_PUB.ADD;
2051: RAISE VALIDATION_FAILED_EXCEPTION;
2052: END IF;
2053: ELSE
2054: fnd_dsql.add_text( ' And '||l_replace_type||' IN (');
2055:
2056: IF (pReplace_type = 'INGREDIENT') THEN
2057: fnd_dsql.add_text(' SELECT FORMULA_ID FROM FM_MATL_DTL
2058: WHERE LINE_TYPE = -1

Line 2057: fnd_dsql.add_text(' SELECT FORMULA_ID FROM FM_MATL_DTL

2053: ELSE
2054: fnd_dsql.add_text( ' And '||l_replace_type||' IN (');
2055:
2056: IF (pReplace_type = 'INGREDIENT') THEN
2057: fnd_dsql.add_text(' SELECT FORMULA_ID FROM FM_MATL_DTL
2058: WHERE LINE_TYPE = -1
2059: AND INVENTORY_ITEM_ID = ');
2060: fnd_dsql.add_bind(pOld_name);
2061: fnd_dsql.add_text(' ))');

Line 2060: fnd_dsql.add_bind(pOld_name);

2056: IF (pReplace_type = 'INGREDIENT') THEN
2057: fnd_dsql.add_text(' SELECT FORMULA_ID FROM FM_MATL_DTL
2058: WHERE LINE_TYPE = -1
2059: AND INVENTORY_ITEM_ID = ');
2060: fnd_dsql.add_bind(pOld_name);
2061: fnd_dsql.add_text(' ))');
2062: ELSIF (pReplace_type = 'ACTIVITY') THEN
2063: fnd_dsql.add_text(' SELECT OPRN_ID FROM GMD_OPERATION_ACTIVITIES
2064: WHERE ACTIVITY = ');

Line 2061: fnd_dsql.add_text(' ))');

2057: fnd_dsql.add_text(' SELECT FORMULA_ID FROM FM_MATL_DTL
2058: WHERE LINE_TYPE = -1
2059: AND INVENTORY_ITEM_ID = ');
2060: fnd_dsql.add_bind(pOld_name);
2061: fnd_dsql.add_text(' ))');
2062: ELSIF (pReplace_type = 'ACTIVITY') THEN
2063: fnd_dsql.add_text(' SELECT OPRN_ID FROM GMD_OPERATION_ACTIVITIES
2064: WHERE ACTIVITY = ');
2065: fnd_dsql.add_bind(pOld_name);

Line 2063: fnd_dsql.add_text(' SELECT OPRN_ID FROM GMD_OPERATION_ACTIVITIES

2059: AND INVENTORY_ITEM_ID = ');
2060: fnd_dsql.add_bind(pOld_name);
2061: fnd_dsql.add_text(' ))');
2062: ELSIF (pReplace_type = 'ACTIVITY') THEN
2063: fnd_dsql.add_text(' SELECT OPRN_ID FROM GMD_OPERATION_ACTIVITIES
2064: WHERE ACTIVITY = ');
2065: fnd_dsql.add_bind(pOld_name);
2066: fnd_dsql.add_text(' ))');
2067: ELSIF (pReplace_type = 'RESOURCES') THEN

Line 2065: fnd_dsql.add_bind(pOld_name);

2061: fnd_dsql.add_text(' ))');
2062: ELSIF (pReplace_type = 'ACTIVITY') THEN
2063: fnd_dsql.add_text(' SELECT OPRN_ID FROM GMD_OPERATION_ACTIVITIES
2064: WHERE ACTIVITY = ');
2065: fnd_dsql.add_bind(pOld_name);
2066: fnd_dsql.add_text(' ))');
2067: ELSIF (pReplace_type = 'RESOURCES') THEN
2068: fnd_dsql.add_text(' SELECT OPRN_ID
2069: FROM GMD_OPERATION_ACTIVITIES a, GMD_OPERATION_RESOURCES r

Line 2066: fnd_dsql.add_text(' ))');

2062: ELSIF (pReplace_type = 'ACTIVITY') THEN
2063: fnd_dsql.add_text(' SELECT OPRN_ID FROM GMD_OPERATION_ACTIVITIES
2064: WHERE ACTIVITY = ');
2065: fnd_dsql.add_bind(pOld_name);
2066: fnd_dsql.add_text(' ))');
2067: ELSIF (pReplace_type = 'RESOURCES') THEN
2068: fnd_dsql.add_text(' SELECT OPRN_ID
2069: FROM GMD_OPERATION_ACTIVITIES a, GMD_OPERATION_RESOURCES r
2070: WHERE a.OPRN_LINE_ID = r.OPRN_LINE_ID

Line 2068: fnd_dsql.add_text(' SELECT OPRN_ID

2064: WHERE ACTIVITY = ');
2065: fnd_dsql.add_bind(pOld_name);
2066: fnd_dsql.add_text(' ))');
2067: ELSIF (pReplace_type = 'RESOURCES') THEN
2068: fnd_dsql.add_text(' SELECT OPRN_ID
2069: FROM GMD_OPERATION_ACTIVITIES a, GMD_OPERATION_RESOURCES r
2070: WHERE a.OPRN_LINE_ID = r.OPRN_LINE_ID
2071: AND r.RESOURCES = ');
2072: fnd_dsql.add_bind(pOld_name);

Line 2072: fnd_dsql.add_bind(pOld_name);

2068: fnd_dsql.add_text(' SELECT OPRN_ID
2069: FROM GMD_OPERATION_ACTIVITIES a, GMD_OPERATION_RESOURCES r
2070: WHERE a.OPRN_LINE_ID = r.OPRN_LINE_ID
2071: AND r.RESOURCES = ');
2072: fnd_dsql.add_bind(pOld_name);
2073: fnd_dsql.add_text(' ))');
2074: ELSIF ((pObject_type = 'ROUTING') AND (pReplace_type = 'OPRN_ID'))THEN
2075: fnd_dsql.add_text(' SELECT ROUTING_ID
2076: FROM FM_ROUT_DTL

Line 2073: fnd_dsql.add_text(' ))');

2069: FROM GMD_OPERATION_ACTIVITIES a, GMD_OPERATION_RESOURCES r
2070: WHERE a.OPRN_LINE_ID = r.OPRN_LINE_ID
2071: AND r.RESOURCES = ');
2072: fnd_dsql.add_bind(pOld_name);
2073: fnd_dsql.add_text(' ))');
2074: ELSIF ((pObject_type = 'ROUTING') AND (pReplace_type = 'OPRN_ID'))THEN
2075: fnd_dsql.add_text(' SELECT ROUTING_ID
2076: FROM FM_ROUT_DTL
2077: WHERE OPRN_ID = ');

Line 2075: fnd_dsql.add_text(' SELECT ROUTING_ID

2071: AND r.RESOURCES = ');
2072: fnd_dsql.add_bind(pOld_name);
2073: fnd_dsql.add_text(' ))');
2074: ELSIF ((pObject_type = 'ROUTING') AND (pReplace_type = 'OPRN_ID'))THEN
2075: fnd_dsql.add_text(' SELECT ROUTING_ID
2076: FROM FM_ROUT_DTL
2077: WHERE OPRN_ID = ');
2078: fnd_dsql.add_bind(pOld_name);
2079: fnd_dsql.add_text(' ))');

Line 2078: fnd_dsql.add_bind(pOld_name);

2074: ELSIF ((pObject_type = 'ROUTING') AND (pReplace_type = 'OPRN_ID'))THEN
2075: fnd_dsql.add_text(' SELECT ROUTING_ID
2076: FROM FM_ROUT_DTL
2077: WHERE OPRN_ID = ');
2078: fnd_dsql.add_bind(pOld_name);
2079: fnd_dsql.add_text(' ))');
2080: ELSIF ((pObject_type = 'RECIPE') AND (pReplace_type = 'OWNER_ORGANIZATION_ID'))THEN
2081: fnd_dsql.add_text(' SELECT RECIPE_ID
2082: FROM GMD_RECIPES_B

Line 2079: fnd_dsql.add_text(' ))');

2075: fnd_dsql.add_text(' SELECT ROUTING_ID
2076: FROM FM_ROUT_DTL
2077: WHERE OPRN_ID = ');
2078: fnd_dsql.add_bind(pOld_name);
2079: fnd_dsql.add_text(' ))');
2080: ELSIF ((pObject_type = 'RECIPE') AND (pReplace_type = 'OWNER_ORGANIZATION_ID'))THEN
2081: fnd_dsql.add_text(' SELECT RECIPE_ID
2082: FROM GMD_RECIPES_B
2083: WHERE OWNER_ORGANIZATION_ID = ');

Line 2081: fnd_dsql.add_text(' SELECT RECIPE_ID

2077: WHERE OPRN_ID = ');
2078: fnd_dsql.add_bind(pOld_name);
2079: fnd_dsql.add_text(' ))');
2080: ELSIF ((pObject_type = 'RECIPE') AND (pReplace_type = 'OWNER_ORGANIZATION_ID'))THEN
2081: fnd_dsql.add_text(' SELECT RECIPE_ID
2082: FROM GMD_RECIPES_B
2083: WHERE OWNER_ORGANIZATION_ID = ');
2084: fnd_dsql.add_bind(pOld_name);
2085: fnd_dsql.add_text(' ))');

Line 2084: fnd_dsql.add_bind(pOld_name);

2080: ELSIF ((pObject_type = 'RECIPE') AND (pReplace_type = 'OWNER_ORGANIZATION_ID'))THEN
2081: fnd_dsql.add_text(' SELECT RECIPE_ID
2082: FROM GMD_RECIPES_B
2083: WHERE OWNER_ORGANIZATION_ID = ');
2084: fnd_dsql.add_bind(pOld_name);
2085: fnd_dsql.add_text(' ))');
2086: ELSIF ((pObject_type = 'VALIDITY') AND (pReplace_type = 'ORGANIZATION_ID'))THEN
2087: fnd_dsql.add_text(' SELECT recipe_validity_rule_id
2088: FROM GMD_RECIPE_VALIDITY_RULES

Line 2085: fnd_dsql.add_text(' ))');

2081: fnd_dsql.add_text(' SELECT RECIPE_ID
2082: FROM GMD_RECIPES_B
2083: WHERE OWNER_ORGANIZATION_ID = ');
2084: fnd_dsql.add_bind(pOld_name);
2085: fnd_dsql.add_text(' ))');
2086: ELSIF ((pObject_type = 'VALIDITY') AND (pReplace_type = 'ORGANIZATION_ID'))THEN
2087: fnd_dsql.add_text(' SELECT recipe_validity_rule_id
2088: FROM GMD_RECIPE_VALIDITY_RULES
2089: WHERE ORGANIZATION_ID = ');

Line 2087: fnd_dsql.add_text(' SELECT recipe_validity_rule_id

2083: WHERE OWNER_ORGANIZATION_ID = ');
2084: fnd_dsql.add_bind(pOld_name);
2085: fnd_dsql.add_text(' ))');
2086: ELSIF ((pObject_type = 'VALIDITY') AND (pReplace_type = 'ORGANIZATION_ID'))THEN
2087: fnd_dsql.add_text(' SELECT recipe_validity_rule_id
2088: FROM GMD_RECIPE_VALIDITY_RULES
2089: WHERE ORGANIZATION_ID = ');
2090: fnd_dsql.add_bind(pOld_name);
2091: fnd_dsql.add_text(' ))');

Line 2090: fnd_dsql.add_bind(pOld_name);

2086: ELSIF ((pObject_type = 'VALIDITY') AND (pReplace_type = 'ORGANIZATION_ID'))THEN
2087: fnd_dsql.add_text(' SELECT recipe_validity_rule_id
2088: FROM GMD_RECIPE_VALIDITY_RULES
2089: WHERE ORGANIZATION_ID = ');
2090: fnd_dsql.add_bind(pOld_name);
2091: fnd_dsql.add_text(' ))');
2092: ELSIF (pReplace_type IN ('START_DATE','END_DATE')) THEN
2093: fnd_dsql.add_bind(fnd_date.displaydt_to_date(pOld_name));
2094: fnd_dsql.add_text(' ))');

Line 2091: fnd_dsql.add_text(' ))');

2087: fnd_dsql.add_text(' SELECT recipe_validity_rule_id
2088: FROM GMD_RECIPE_VALIDITY_RULES
2089: WHERE ORGANIZATION_ID = ');
2090: fnd_dsql.add_bind(pOld_name);
2091: fnd_dsql.add_text(' ))');
2092: ELSIF (pReplace_type IN ('START_DATE','END_DATE')) THEN
2093: fnd_dsql.add_bind(fnd_date.displaydt_to_date(pOld_name));
2094: fnd_dsql.add_text(' ))');
2095: ELSE

Line 2093: fnd_dsql.add_bind(fnd_date.displaydt_to_date(pOld_name));

2089: WHERE ORGANIZATION_ID = ');
2090: fnd_dsql.add_bind(pOld_name);
2091: fnd_dsql.add_text(' ))');
2092: ELSIF (pReplace_type IN ('START_DATE','END_DATE')) THEN
2093: fnd_dsql.add_bind(fnd_date.displaydt_to_date(pOld_name));
2094: fnd_dsql.add_text(' ))');
2095: ELSE
2096: fnd_dsql.add_bind(pOld_name);
2097: fnd_dsql.add_text(' ))');

Line 2094: fnd_dsql.add_text(' ))');

2090: fnd_dsql.add_bind(pOld_name);
2091: fnd_dsql.add_text(' ))');
2092: ELSIF (pReplace_type IN ('START_DATE','END_DATE')) THEN
2093: fnd_dsql.add_bind(fnd_date.displaydt_to_date(pOld_name));
2094: fnd_dsql.add_text(' ))');
2095: ELSE
2096: fnd_dsql.add_bind(pOld_name);
2097: fnd_dsql.add_text(' ))');
2098: END IF;

Line 2096: fnd_dsql.add_bind(pOld_name);

2092: ELSIF (pReplace_type IN ('START_DATE','END_DATE')) THEN
2093: fnd_dsql.add_bind(fnd_date.displaydt_to_date(pOld_name));
2094: fnd_dsql.add_text(' ))');
2095: ELSE
2096: fnd_dsql.add_bind(pOld_name);
2097: fnd_dsql.add_text(' ))');
2098: END IF;
2099:
2100: END IF;

Line 2097: fnd_dsql.add_text(' ))');

2093: fnd_dsql.add_bind(fnd_date.displaydt_to_date(pOld_name));
2094: fnd_dsql.add_text(' ))');
2095: ELSE
2096: fnd_dsql.add_bind(pOld_name);
2097: fnd_dsql.add_text(' ))');
2098: END IF;
2099:
2100: END IF;
2101:

Line 2103: fnd_dsql.set_cursor(l_cursor_id);

2099:
2100: END IF;
2101:
2102: l_cursor_id := dbms_sql.open_cursor;
2103: fnd_dsql.set_cursor(l_cursor_id);
2104: l_dynamic_select := fnd_dsql.get_text(FALSE);
2105:
2106: l_dsql_debug := fnd_dsql.get_text(TRUE);
2107: IF (l_debug = 'Y') THEN

Line 2104: l_dynamic_select := fnd_dsql.get_text(FALSE);

2100: END IF;
2101:
2102: l_cursor_id := dbms_sql.open_cursor;
2103: fnd_dsql.set_cursor(l_cursor_id);
2104: l_dynamic_select := fnd_dsql.get_text(FALSE);
2105:
2106: l_dsql_debug := fnd_dsql.get_text(TRUE);
2107: IF (l_debug = 'Y') THEN
2108: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : l_dsql_debug = '||l_dsql_debug);

Line 2106: l_dsql_debug := fnd_dsql.get_text(TRUE);

2102: l_cursor_id := dbms_sql.open_cursor;
2103: fnd_dsql.set_cursor(l_cursor_id);
2104: l_dynamic_select := fnd_dsql.get_text(FALSE);
2105:
2106: l_dsql_debug := fnd_dsql.get_text(TRUE);
2107: IF (l_debug = 'Y') THEN
2108: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : l_dsql_debug = '||l_dsql_debug);
2109: END IF;
2110:

Line 2112: fnd_dsql.do_binds;

2108: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : l_dsql_debug = '||l_dsql_debug);
2109: END IF;
2110:
2111: dbms_sql.parse(l_cursor_id, l_dynamic_select, dbms_sql.native);
2112: fnd_dsql.do_binds;
2113:
2114: pRows_Processed := dbms_sql.execute(l_cursor_id);
2115:
2116: IF (l_debug = 'Y') THEN