APPS.AHL_FMP_MR_RELATION_PVT dependencies on AHL_MR_HEADERS_B

Line 157: l_rel_mr_header_id AHL_MR_HEADERS_B.MR_HEADER_ID%TYPE;

153: AND NVL(TYPE_CODE,'X')=DECODE(NVL(C_TYPE_CODE,'X'),'ACTIVITY','PROGRAM','PROGRAM','ACTIVITY','X');
154:
155:
156: check_flag VARCHAR2(1):='N';
157: l_rel_mr_header_id AHL_MR_HEADERS_B.MR_HEADER_ID%TYPE;
158: l_api_name VARCHAR2(30):='TRANS_VALUE_ID';
159: l_type_code AHL_MR_HEADERS_B.TYPE_CODE%TYPE;
160: l_title AHL_MR_HEADERS_B.TITLE%TYPE;
161: BEGIN

Line 159: l_type_code AHL_MR_HEADERS_B.TYPE_CODE%TYPE;

155:
156: check_flag VARCHAR2(1):='N';
157: l_rel_mr_header_id AHL_MR_HEADERS_B.MR_HEADER_ID%TYPE;
158: l_api_name VARCHAR2(30):='TRANS_VALUE_ID';
159: l_type_code AHL_MR_HEADERS_B.TYPE_CODE%TYPE;
160: l_title AHL_MR_HEADERS_B.TITLE%TYPE;
161: BEGIN
162: x_return_status:=FND_API.G_RET_STS_SUCCESS;
163:

Line 160: l_title AHL_MR_HEADERS_B.TITLE%TYPE;

156: check_flag VARCHAR2(1):='N';
157: l_rel_mr_header_id AHL_MR_HEADERS_B.MR_HEADER_ID%TYPE;
158: l_api_name VARCHAR2(30):='TRANS_VALUE_ID';
159: l_type_code AHL_MR_HEADERS_B.TYPE_CODE%TYPE;
160: l_title AHL_MR_HEADERS_B.TITLE%TYPE;
161: BEGIN
162: x_return_status:=FND_API.G_RET_STS_SUCCESS;
163:
164: IF G_DEBUG='Y' THEN

Line 172: FROM AHL_MR_HEADERS_B

168:
169: IF p_x_mr_relation_rec.MR_HEADER_ID IS NOT NULL OR p_x_mr_relation_rec.MR_HEADER_ID<>FND_API.G_MISS_NUM
170: THEN
171: SELECT TYPE_CODE INTO L_TYPE_CODE
172: FROM AHL_MR_HEADERS_B
173: WHERE MR_HEADER_ID=p_x_mr_relation_rec.MR_HEADER_ID;
174: END IF;
175:
176: IF p_x_mr_relation_rec.RELATED_MR_TITLE IS NULL OR p_x_mr_relation_rec.RELATED_MR_TITLE=FND_API.G_MISS_CHAR

Line 204: FROM AHL_MR_HEADERS_B

200:
201: IF title_to_relmr_header_id%NOTFOUND
202: THEN
203: SELECT TITLE INTO l_title
204: FROM AHL_MR_HEADERS_B
205: WHERE MR_HEADER_ID=p_x_mr_relation_rec.MR_HEADER_ID;
206:
207: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_RELATED_TITLE_INVAL');
208: FND_MESSAGE.SET_TOKEN('FIELD',l_title,false);

Line 283: FROM AHL_MR_HEADERS_B

279: as
280: CURSOR Check_mr_header_stat(C_MR_HEADER_ID IN NUMBER)
281: IS
282: SELECT MR_STATUS_CODE,TITLE,TYPE_CODE
283: FROM AHL_MR_HEADERS_B
284: WHERE MR_HEADER_ID=C_MR_HEADER_ID;
285:
286: l_head_rec Check_mr_header_stat%rowtype;
287: l_rel_head_rec Check_mr_header_stat%rowtype;

Line 306: FROM ahl_mr_headers_b

302: c_mr_header_id number
303: )
304: IS
305: SELECT 'x'
306: FROM ahl_mr_headers_b
307: WHERE mr_header_id = c_mr_header_id AND
308: program_type_code = 'MO_PROC';
309:
310: l_dummy_char VARCHAR2(1);