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_CONTEXTS

Line 239: l_seq_context_id fun_seq_contexts.seq_context_id%TYPE;

235: x_sort_option_code OUT NOCOPY VARCHAR2,
236: x_error_code OUT NOCOPY VARCHAR2)
237: IS
238:
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;

Line 240: l_control_date_type fun_seq_contexts.date_type%TYPE;

236: x_error_code OUT NOCOPY VARCHAR2)
237: IS
238:
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);

Line 241: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;

237: IS
238:
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:

Line 242: l_sort_option_code fun_seq_contexts.sort_option%TYPE;

238:
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;

Line 596: FROM fun_seq_contexts sac

592: INTO x_seq_context_id,
593: x_control_date_type,
594: x_req_assign_flag,
595: x_sort_option_code
596: FROM fun_seq_contexts sac
597: WHERE sac.application_id = p_application_id
598: AND sac.table_name = p_table_name
599: AND sac.context_type = p_context_type
600: AND sac.context_value = p_context_value

Line 672: l_context_type fun_seq_contexts.context_type%TYPE;

668: x_sequence_number OUT NOCOPY NUMBER,
669: x_assignment_id OUT NOCOPY NUMBER,
670: x_error_code OUT NOCOPY VARCHAR2) IS
671:
672: l_context_type fun_seq_contexts.context_type%TYPE;
673: l_context_value fun_seq_contexts.context_value%TYPE;
674: l_application_id fun_seq_contexts.application_id%TYPE;
675: l_table_name fun_seq_contexts.table_name%TYPE;
676: l_event_code fun_seq_contexts.event_code%TYPE;

Line 673: l_context_value fun_seq_contexts.context_value%TYPE;

669: x_assignment_id OUT NOCOPY NUMBER,
670: x_error_code OUT NOCOPY VARCHAR2) IS
671:
672: l_context_type fun_seq_contexts.context_type%TYPE;
673: l_context_value fun_seq_contexts.context_value%TYPE;
674: l_application_id fun_seq_contexts.application_id%TYPE;
675: l_table_name fun_seq_contexts.table_name%TYPE;
676: l_event_code fun_seq_contexts.event_code%TYPE;
677: l_control_attribute_rec control_attribute_rec_type;

Line 674: l_application_id fun_seq_contexts.application_id%TYPE;

670: x_error_code OUT NOCOPY VARCHAR2) IS
671:
672: l_context_type fun_seq_contexts.context_type%TYPE;
673: l_context_value fun_seq_contexts.context_value%TYPE;
674: l_application_id fun_seq_contexts.application_id%TYPE;
675: l_table_name fun_seq_contexts.table_name%TYPE;
676: l_event_code fun_seq_contexts.event_code%TYPE;
677: l_control_attribute_rec control_attribute_rec_type;
678: l_control_date_tbl control_date_tbl_type;

Line 675: l_table_name fun_seq_contexts.table_name%TYPE;

671:
672: l_context_type fun_seq_contexts.context_type%TYPE;
673: l_context_value fun_seq_contexts.context_value%TYPE;
674: l_application_id fun_seq_contexts.application_id%TYPE;
675: l_table_name fun_seq_contexts.table_name%TYPE;
676: l_event_code fun_seq_contexts.event_code%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);

Line 676: l_event_code fun_seq_contexts.event_code%TYPE;

672: l_context_type fun_seq_contexts.context_type%TYPE;
673: l_context_value fun_seq_contexts.context_value%TYPE;
674: l_application_id fun_seq_contexts.application_id%TYPE;
675: l_table_name fun_seq_contexts.table_name%TYPE;
676: l_event_code fun_seq_contexts.event_code%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);

Line 685: l_req_assign_flag fun_seq_contexts.require_assign_flag%TYPE;

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);
688: l_sequence_number fun_seq_versions.initial_value%TYPE;
689: l_sequenced_date DATE;

Line 1343: l_seq_context_name fun_seq_contexts.name%TYPE;

1339: -- Get_Seq_Context_Name
1340: -- (for debug)
1341: FUNCTION get_seq_context_name (
1342: p_seq_context_id IN NUMBER) RETURN VARCHAR2 IS
1343: l_seq_context_name fun_seq_contexts.name%TYPE;
1344: BEGIN
1345: SELECT name
1346: INTO l_seq_context_name
1347: FROM fun_seq_contexts

Line 1347: FROM fun_seq_contexts

1343: l_seq_context_name fun_seq_contexts.name%TYPE;
1344: BEGIN
1345: SELECT name
1346: INTO l_seq_context_name
1347: FROM fun_seq_contexts
1348: WHERE seq_context_id = p_seq_context_id;
1349:
1350: RETURN l_seq_context_name;
1351: END get_seq_context_name;

Line 1670: FROM fun_seq_contexts sac

1666: INTO l_context_ctrl_rec.seq_context_id,
1667: l_context_ctrl_rec.date_type,
1668: l_context_ctrl_rec.req_assign_flag,
1669: l_context_ctrl_rec.sort_option_code
1670: FROM fun_seq_contexts sac
1671: WHERE sac.application_id = p_context_info_rec.application_id
1672: AND sac.table_name = p_context_info_rec.table_name
1673: AND sac.context_type = p_context_info_rec.context_type
1674: AND sac.context_value = p_context_info_rec.context_value