APPS.GMA_GLOBAL_GRP dependencies on SY_REAS_CDS

Line 119: --| This procedure is used to retrieve all details from sy_reas_cds |

115: --| USAGE |
116: --| Used to retrieve reason code details |
117: --| |
118: --| DESCRIPTION |
119: --| This procedure is used to retrieve all details from sy_reas_cds |
120: --| |
121: --| PARAMETERS |
122: --| p_reason_code IN VARCHAR2(4) - Reason code to be retrieved |
123: --| x_sy_reas_cds OUT RECORD - Record containing sy_reas_cds |

Line 123: --| x_sy_reas_cds OUT RECORD - Record containing sy_reas_cds |

119: --| This procedure is used to retrieve all details from sy_reas_cds |
120: --| |
121: --| PARAMETERS |
122: --| p_reason_code IN VARCHAR2(4) - Reason code to be retrieved |
123: --| x_sy_reas_cds OUT RECORD - Record containing sy_reas_cds |
124: --| |
125: --| HISTORY |
126: --| 01-OCT-1998 M.Godfrey Created |
127: --| 01-NOV-2002 RTARDIO Added NOCOPY for bug 2650392 |

Line 130: ( p_reason_code IN sy_reas_cds.reason_code%TYPE

126: --| 01-OCT-1998 M.Godfrey Created |
127: --| 01-NOV-2002 RTARDIO Added NOCOPY for bug 2650392 |
128: --+=========================================================================+
129: PROCEDURE Get_Reason_Code
130: ( p_reason_code IN sy_reas_cds.reason_code%TYPE
131: , x_sy_reas_cds OUT NOCOPY sy_reas_cds%ROWTYPE
132: )
133: IS
134: CURSOR sy_reas_cds_c1 IS

Line 131: , x_sy_reas_cds OUT NOCOPY sy_reas_cds%ROWTYPE

127: --| 01-NOV-2002 RTARDIO Added NOCOPY for bug 2650392 |
128: --+=========================================================================+
129: PROCEDURE Get_Reason_Code
130: ( p_reason_code IN sy_reas_cds.reason_code%TYPE
131: , x_sy_reas_cds OUT NOCOPY sy_reas_cds%ROWTYPE
132: )
133: IS
134: CURSOR sy_reas_cds_c1 IS
135: SELECT

Line 134: CURSOR sy_reas_cds_c1 IS

130: ( p_reason_code IN sy_reas_cds.reason_code%TYPE
131: , x_sy_reas_cds OUT NOCOPY sy_reas_cds%ROWTYPE
132: )
133: IS
134: CURSOR sy_reas_cds_c1 IS
135: SELECT
136: *
137: FROM
138: sy_reas_cds

Line 138: sy_reas_cds

134: CURSOR sy_reas_cds_c1 IS
135: SELECT
136: *
137: FROM
138: sy_reas_cds
139: WHERE
140: reason_code = p_reason_code AND
141: delete_mark = 0;
142:

Line 145: OPEN sy_reas_cds_c1;

141: delete_mark = 0;
142:
143: BEGIN
144:
145: OPEN sy_reas_cds_c1;
146:
147: FETCH sy_reas_cds_c1 INTO x_sy_reas_cds;
148:
149: IF (sy_reas_cds_c1%NOTFOUND)

Line 147: FETCH sy_reas_cds_c1 INTO x_sy_reas_cds;

143: BEGIN
144:
145: OPEN sy_reas_cds_c1;
146:
147: FETCH sy_reas_cds_c1 INTO x_sy_reas_cds;
148:
149: IF (sy_reas_cds_c1%NOTFOUND)
150: THEN
151: x_sy_reas_cds.reason_code := NULL;

Line 149: IF (sy_reas_cds_c1%NOTFOUND)

145: OPEN sy_reas_cds_c1;
146:
147: FETCH sy_reas_cds_c1 INTO x_sy_reas_cds;
148:
149: IF (sy_reas_cds_c1%NOTFOUND)
150: THEN
151: x_sy_reas_cds.reason_code := NULL;
152: END IF;
153:

Line 151: x_sy_reas_cds.reason_code := NULL;

147: FETCH sy_reas_cds_c1 INTO x_sy_reas_cds;
148:
149: IF (sy_reas_cds_c1%NOTFOUND)
150: THEN
151: x_sy_reas_cds.reason_code := NULL;
152: END IF;
153:
154: CLOSE sy_reas_cds_c1;
155:

Line 154: CLOSE sy_reas_cds_c1;

150: THEN
151: x_sy_reas_cds.reason_code := NULL;
152: END IF;
153:
154: CLOSE sy_reas_cds_c1;
155:
156: EXCEPTION
157: WHEN OTHERS THEN
158: RAISE;