APPS.ECX_ATTACHMENT dependencies on ECX_ATTACHMENT_MAPS

Line 1090: INSERT INTO ecx_attachment_maps

1086:
1087: l_progress := '0001';
1088: FOR i IN l_records.FIRST .. l_records.LAST LOOP
1089:
1090: INSERT INTO ecx_attachment_maps
1091: (msgid,
1092: cid,
1093: fid,
1094: dataType,

Line 1180: INSERT INTO ecx_attachment_maps

1176:
1177: l_progress := '0001';
1178: FOR i IN l_records.FIRST .. l_records.LAST LOOP
1179:
1180: INSERT INTO ecx_attachment_maps
1181: (msgid,
1182: cid,
1183: fid,
1184: dataType,

Line 1236: l_map_row ECX_ATTACHMENT_MAPS%ROWTYPE;

1232: )AS
1233: i_method_name varchar2(2000) := 'ecx_attachment.remap_attachments';
1234: l_progress VARCHAR2(4) := NULL;
1235: l_in_aqMsgid RAW(16) := NULL;
1236: l_map_row ECX_ATTACHMENT_MAPS%ROWTYPE;
1237: CURSOR l_map_cursor (msgid RAW) IS
1238: SELECT *
1239: FROM ecx_attachment_maps
1240: WHERE MSGID = msgid;

Line 1239: FROM ecx_attachment_maps

1235: l_in_aqMsgid RAW(16) := NULL;
1236: l_map_row ECX_ATTACHMENT_MAPS%ROWTYPE;
1237: CURSOR l_map_cursor (msgid RAW) IS
1238: SELECT *
1239: FROM ecx_attachment_maps
1240: WHERE MSGID = msgid;
1241:
1242: BEGIN
1243:

Line 1268: INSERT INTO ecx_attachment_maps (msgId,

1264:
1265: IF (l_map_row.msgid = l_in_aqMsgid)
1266: THEN
1267:
1268: INSERT INTO ecx_attachment_maps (msgId,
1269: cId,
1270: fId,
1271: dataType,
1272: orderIndex,

Line 1359: FROM ecx_attachment_maps

1355:
1356: l_progress := '0000';
1357: SELECT fid, datatype
1358: INTO l_file_id, l_datatype
1359: FROM ecx_attachment_maps
1360: WHERE msgid = i_msgid AND cid = i_cid;
1361:
1362: IF ((l_file_id is NOT NULL) AND (l_datatype is NOT NULL)) THEN
1363:

Line 1498: FROM ecx_attachment_maps

1494:
1495: l_progress := '0000';
1496: SELECT fid, datatype
1497: INTO l_file_id, l_datatype
1498: FROM ecx_attachment_maps
1499: WHERE msgid = i_msgid AND cid = i_cid;
1500:
1501: IF ((l_file_id is NOT NULL) AND (l_datatype is NOT NULL)) THEN
1502:

Line 1790: FROM ecx_attachment_maps

1786:
1787: l_progress := '0000';
1788: SELECT fid, datatype
1789: INTO l_file_id, l_datatype
1790: FROM ecx_attachment_maps
1791: WHERE msgid = i_msgid AND cid = i_cid;
1792:
1793: IF ((l_file_id is NOT NULL) AND (l_datatype is NOT NULL)) THEN
1794: