APPS.INV_GMI_MIGRATION dependencies on SY_REAS_CDS

Line 1844: FROM sy_reas_cds_b

1840: l_field_value := 'Reason Code = ' || cuadit.reason_code;
1841:
1842: IF cuadit.reason_code IS NOT NULL THEN
1843: SELECT reason_id INTO l_reason_id
1844: FROM sy_reas_cds_b
1845: WHERE
1846: reason_code = cuadit.reason_code;
1847: END IF;
1848:

Line 2185: FROM sy_reas_cds

2181: --END BUG #14147616
2182:
2183: SELECT count(*)
2184: INTO l_count
2185: FROM sy_reas_cds
2186: WHERE
2187: reason_code = 'CNVM';
2188:
2189: IF l_count = 0 THEN

Line 2193: sy_reas_cds_pkg.insert_row (

2189: IF l_count = 0 THEN
2190: --BEGIN BUG #14147616 Shaliu Chen
2191: --Add exception handling program to ignore Duplicate Key on Index error.
2192: BEGIN
2193: sy_reas_cds_pkg.insert_row (
2194: x_rowid => l_rowid,
2195: x_reason_code => 'CNVM',
2196: x_reason_desc2 => NULL,
2197: x_reason_type => 0,

Line 2215: UPDATE sy_reas_cds_b

2211: NULL;
2212: END;
2213: --END BUG #14147616
2214:
2215: UPDATE sy_reas_cds_b
2216: SET reason_id = -99
2217: WHERE reason_code = 'CNVM';
2218: END IF;
2219: COMMIT;