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.FUN_SEQ dependencies on FUN_SEQ_ASSIGNMENTS

Line 249: l_assignment_id fun_seq_assignments.assignment_id%TYPE;

245:
246: l_control_date_value DATE;
247: l_seq_header_id fun_seq_versions.seq_version_id%TYPE;
248: l_seq_version_id fun_seq_versions.seq_version_id%TYPE;
249: l_assignment_id fun_seq_assignments.assignment_id%TYPE;
250:
251: no_assignment_found EXCEPTION;
252: no_seq_version_found EXCEPTION;
253:

Line 438: l_assignment_id fun_seq_assignments.assignment_id%TYPE;

434: x_sequence_number OUT NOCOPY NUMBER,
435: x_sequenced_date OUT NOCOPY DATE,
436: x_error_code OUT NOCOPY VARCHAR2)
437: IS
438: l_assignment_id fun_seq_assignments.assignment_id%TYPE;
439: l_seq_version_id fun_seq_versions.seq_version_id%TYPE;
440: invalid_seq_type EXCEPTION;
441: l_sql_stmt VARCHAR2(2000);
442: l_debug_loc CONSTANT VARCHAR2(100) DEFAULT 'generate_sequence_number';

Line 683: l_assignment_id fun_seq_assignments.assignment_id%TYPE;

679: l_batch_flag VARCHAR2(1);
680: l_suppress_error VARCHAR2(1);
681: l_sequence_type fun_seq_headers.gapless_flag%TYPE;
682: l_seq_version_id fun_seq_versions.seq_version_id%TYPE;
683: l_assignment_id fun_seq_assignments.assignment_id%TYPE;
684: l_control_date_value DATE;
685: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
686: l_error_code_assign VARCHAR2(30);
687: l_error_code_seq VARCHAR2(30);

Line 981: l_assignment_id fun_seq_assignments.assignment_id%TYPE;

977: x_sequence_type OUT NOCOPY VARCHAR2,
978: x_seq_header_id OUT NOCOPY NUMBER)
979: IS
980:
981: l_assignment_id fun_seq_assignments.assignment_id%TYPE;
982: l_sequence_type fun_seq_headers.gapless_flag%TYPE;
983: l_seq_header_id fun_seq_headers.seq_header_id%TYPE;
984:
985: l_exp_assignment_id fun_seq_assignments.assignment_id%TYPE;

Line 985: l_exp_assignment_id fun_seq_assignments.assignment_id%TYPE;

981: l_assignment_id fun_seq_assignments.assignment_id%TYPE;
982: l_sequence_type fun_seq_headers.gapless_flag%TYPE;
983: l_seq_header_id fun_seq_headers.seq_header_id%TYPE;
984:
985: l_exp_assignment_id fun_seq_assignments.assignment_id%TYPE;
986: l_exp_sequence_type fun_seq_headers.gapless_flag%TYPE;
987: l_exp_seq_header_id fun_seq_headers.seq_header_id%TYPE;
988:
989: BEGIN

Line 1067: FROM fun_seq_assignments sa, fun_seq_headers sh

1063: sh.gapless_flag
1064: INTO x_assignment_id,
1065: x_seq_header_id,
1066: x_sequence_type
1067: FROM fun_seq_assignments sa, fun_seq_headers sh
1068: WHERE sa.seq_context_id = p_seq_context_id
1069: AND sa.seq_header_id = sh.seq_header_id
1070: AND sh.obsolete_flag = 'N'
1071: AND sa.link_to_assignment_id IS NULL

Line 1096: l_assignment_id fun_seq_assignments.assignment_id%TYPE;

1092: x_assignment_id OUT NOCOPY NUMBER,
1093: x_sequence_type OUT NOCOPY VARCHAR2,
1094: x_seq_header_id OUT NOCOPY NUMBER)
1095: IS
1096: l_assignment_id fun_seq_assignments.assignment_id%TYPE;
1097: l_seq_header_id fun_seq_headers.seq_header_id%TYPE;
1098: l_sequence_type fun_seq_headers.gapless_flag%TYPE;
1099:
1100: l_assign_info_rec assign_info_rec_type;

Line 1111: FROM fun_seq_assignments sa, fun_seq_headers sh

1107: sh.gapless_flag
1108: INTO x_assignment_id,
1109: x_seq_header_id,
1110: x_sequence_type
1111: FROM fun_seq_assignments sa, fun_seq_headers sh
1112: WHERE sa.seq_context_id = p_seq_context_id
1113: AND sa.seq_header_id = sh.seq_header_id (+) -- (+) Do Not Sequence
1114: AND sh.obsolete_flag (+) = 'N'
1115: AND sa.link_to_assignment_id IS NULL

Line 1266: FROM fun_seq_assignments xsa, fun_seq_headers xsh

1262: OPEN l_CursorVar FOR
1263: SELECT xsa.assignment_id,
1264: xsh.gapless_flag,
1265: xsa.seq_header_id
1266: FROM fun_seq_assignments xsa, fun_seq_headers xsh
1267: WHERE xsa.link_to_assignment_id = p_assignment_id
1268: AND xsa.start_date <= p_control_date_value
1269: AND p_control_date_value <= NVL(xsa.end_date, p_control_date_value + 1)
1270: AND xsa.use_status_code IN ('NEW','USED')

Line 1561: TYPE assign_id_tbl_type IS TABLE OF fun_seq_assignments.assignment_id%TYPE

1557: --
1558: PROCEDURE update_assign_status (
1559: p_assignment_id IN NUMBER) IS
1560:
1561: TYPE assign_id_tbl_type IS TABLE OF fun_seq_assignments.assignment_id%TYPE
1562: INDEX BY BINARY_INTEGER;
1563:
1564: l_assign_id_tbl assign_id_tbl_type;
1565: BEGIN

Line 1569: FROM fun_seq_assignments

1565: BEGIN
1566: SELECT assignment_id
1567: BULK COLLECT
1568: INTO l_assign_id_tbl
1569: FROM fun_seq_assignments
1570: WHERE use_status_code = 'NEW'
1571: AND ((assignment_id = p_assignment_id) OR
1572: (assignment_id = (SELECT ex.link_to_assignment_id
1573: FROM fun_seq_assignments ex

Line 1573: FROM fun_seq_assignments ex

1569: FROM fun_seq_assignments
1570: WHERE use_status_code = 'NEW'
1571: AND ((assignment_id = p_assignment_id) OR
1572: (assignment_id = (SELECT ex.link_to_assignment_id
1573: FROM fun_seq_assignments ex
1574: WHERE ex.assignment_id = p_assignment_id)));
1575: --
1576: -- When no data is found, then l_assign_id_tbl.count = 0
1577: --

Line 1580: UPDATE fun_seq_assignments

1576: -- When no data is found, then l_assign_id_tbl.count = 0
1577: --
1578: IF l_assign_id_tbl.COUNT > 0 THEN
1579: FORALL i in l_assign_id_tbl.FIRST .. l_assign_id_tbl.LAST
1580: UPDATE fun_seq_assignments
1581: SET use_status_code = 'USED'
1582: WHERE assignment_id = l_assign_id_tbl(i);
1583: END IF;
1584: EXCEPTION

Line 1759: FROM fun_seq_assignments sa, fun_seq_headers sh

1755: sh.gapless_flag
1756: INTO l_assign_seq_head_rec.assignment_id,
1757: l_assign_seq_head_rec.seq_header_id,
1758: l_assign_seq_head_rec.seq_type
1759: FROM fun_seq_assignments sa, fun_seq_headers sh
1760: WHERE sa.seq_context_id = l_rec.seq_context_id
1761: AND sa.seq_header_id = sh.seq_header_id (+) -- Do Not Sequence
1762: AND sh.obsolete_flag (+) = 'N'
1763: AND sa.link_to_assignment_id IS NULL

Line 1859: FROM fun_seq_assignments xsa, fun_seq_headers xsh

1855: OPEN l_CursorVar FOR
1856: SELECT xsa.assignment_id,
1857: xsh.gapless_flag,
1858: xsa.seq_header_id
1859: FROM fun_seq_assignments xsa, fun_seq_headers xsh
1860: WHERE xsa.link_to_assignment_id = l_rec_in.assignment_id
1861: AND xsa.start_date <= l_rec_in.control_date
1862: AND l_rec_in.control_date <= NVL(xsa.end_date, l_rec_in.control_date + 1)
1863: AND xsa.use_status_code IN ('NEW','USED')