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_HEADERS

Line 243: l_sequence_type fun_seq_headers.gapless_flag%TYPE;

239: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;
240: l_control_date_type fun_seq_contexts.date_type%TYPE;
241: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;
242: l_sort_option_code fun_seq_contexts.sort_option%TYPE;
243: l_sequence_type fun_seq_headers.gapless_flag%TYPE;
244: l_error_code VARCHAR2(30);
245:
246: l_control_date_value DATE;
247: l_seq_header_id fun_seq_versions.seq_version_id%TYPE;

Line 681: l_sequence_type fun_seq_headers.gapless_flag%TYPE;

677: l_control_attribute_rec control_attribute_rec_type;
678: l_control_date_tbl control_date_tbl_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;

Line 982: l_sequence_type fun_seq_headers.gapless_flag%TYPE;

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;
986: l_exp_sequence_type fun_seq_headers.gapless_flag%TYPE;

Line 983: l_seq_header_id fun_seq_headers.seq_header_id%TYPE;

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;
986: l_exp_sequence_type fun_seq_headers.gapless_flag%TYPE;
987: l_exp_seq_header_id fun_seq_headers.seq_header_id%TYPE;

Line 986: l_exp_sequence_type fun_seq_headers.gapless_flag%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
990: --

Line 987: l_exp_seq_header_id fun_seq_headers.seq_header_id%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
990: --
991: -- Get Sequence Info of Assignment

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 1097: l_seq_header_id fun_seq_headers.seq_header_id%TYPE;

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;
1101: l_assign_seq_head_rec assign_seq_head_rec_type;

Line 1098: l_sequence_type fun_seq_headers.gapless_flag%TYPE;

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;
1101: l_assign_seq_head_rec assign_seq_head_rec_type;
1102: BEGIN

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 1358: l_seq_header_name fun_seq_headers.header_name%TYPE;

1354: -- Get_Seq_Header_Name
1355: -- (for debug)
1356: FUNCTION get_seq_header_name (
1357: p_seq_header_id IN NUMBER) RETURN VARCHAR2 IS
1358: l_seq_header_name fun_seq_headers.header_name%TYPE;
1359: BEGIN
1360: SELECT header_name
1361: INTO l_seq_header_name
1362: FROM fun_seq_headers

Line 1362: FROM fun_seq_headers

1358: l_seq_header_name fun_seq_headers.header_name%TYPE;
1359: BEGIN
1360: SELECT header_name
1361: INTO l_seq_header_name
1362: FROM fun_seq_headers
1363: WHERE seq_header_id = p_seq_header_id;
1364:
1365: RETURN l_seq_header_name;
1366: END get_seq_header_name;

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')