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

Line 1: PACKAGE BODY fun_seq AS

1: PACKAGE BODY fun_seq AS
2: /* $Header: funsqgnb.pls 120.36 2004/11/04 01:07:53 masada noship $ */
3: --
4: --
5: --

Line 99: 'fun.plsql.fun_seq.get_sequence_number.begin',

95: --
96: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
97: FND_LOG.STRING(
98: FND_LOG.LEVEL_PROCEDURE,
99: 'fun.plsql.fun_seq.get_sequence_number.begin',
100: 'p_context_type: ' || p_context_type ||', '||
101: 'p_context_value: ' || p_context_value ||', '||
102: 'p_application_id: ' || p_application_id ||', '||
103: 'p_table_name: ' || p_table_name ||', '||

Line 160: 'fun.plsql.fun_seq.get_sequence_number.end',

156: --
157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FND_LOG.STRING(
159: FND_LOG.LEVEL_PROCEDURE,
160: 'fun.plsql.fun_seq.get_sequence_number.end',
161: 'p_context_type: ' || p_context_type ||', '||
162: 'p_context_value: ' || p_context_value ||', '||
163: 'p_application_id: ' || p_application_id ||', '||
164: 'p_table_name: ' || p_table_name ||', '||

Line 177: 'fun.plsql.fun_seq.get_sequence_Number.exception',

173: --
174: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
175: fnd_log.string(
176: fnd_log.level_exception,
177: 'fun.plsql.fun_seq.get_sequence_Number.exception',
178: 'p_context_type: ' || p_context_type ||', '||
179: 'p_context_value: ' || p_context_value ||', '||
180: 'p_application_id: ' || p_application_id ||', '||
181: 'p_table_name: ' || p_table_name ||', '||

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 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 247: l_seq_header_id fun_seq_versions.seq_version_id%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;
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;

Line 248: l_seq_version_id fun_seq_versions.seq_version_id%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;
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;

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 261: 'fun.plsql.fun_seq.get_assigned_sequence_info.begin',

257: --
258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
259: FND_LOG.STRING(
260: FND_LOG.LEVEL_PROCEDURE,
261: 'fun.plsql.fun_seq.get_assigned_sequence_info.begin',
262: 'p_context_type: ' || p_context_type ||', '||
263: 'p_context_value: ' || p_context_value ||', '||
264: 'p_application_id: ' || p_application_id ||', '||
265: 'p_table_name: ' || p_table_name ||', '||

Line 309: --fun_seq_utils.log_procedure(

305: p_control_date_tbl);
306: --
307: -- Get an Assigned Sequence Header
308: --
309: --fun_seq_utils.log_procedure(
310: -- p_module => l_module || ' in progress',
311: -- p_message_text => 'Beginning of get_assigned_sequence_header');
312: --
313: IF p_application_id = 435 AND p_table_name = 'FUN_TRX_BATCHES' THEN

Line 382: 'fun.plsql.fun_seq.get_assigned_sequence_info.end',

378: --
379: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
380: FND_LOG.STRING(
381: FND_LOG.LEVEL_PROCEDURE,
382: 'fun.plsql.fun_seq.get_assigned_sequence_info.end',
383: 'x_sequence_type: ' || x_sequence_type || ', ' ||
384: 'x_assignment_id: ' || x_assignment_id || ', ' ||
385: 'x_control_date_value: '|| x_control_date_value ||', '||
386: 'x_req_assign_flag: ' || x_req_assign_flag);

Line 396: 'fun.plsql.fun_seq.get_assigned_sequence_info.no_assign',

392: --
393: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: FND_LOG.STRING(
395: FND_LOG.LEVEL_EXCEPTION,
396: 'fun.plsql.fun_seq.get_assigned_sequence_info.no_assign',
397: 'No Assignment Found (Require Assignment = Y)' ||', '||
398: 'l_seq_context_id :' || l_seq_context_id);
399: END IF;
400:

Line 402: fnd_message.set_name ('FUN','FUN_SEQ_NO_ACTIVE_ASSGN_FOUND');

398: 'l_seq_context_id :' || l_seq_context_id);
399: END IF;
400:
401: x_error_code := 'ENFORCED_NO_ASSIGNMENT';
402: fnd_message.set_name ('FUN','FUN_SEQ_NO_ACTIVE_ASSGN_FOUND');
403: fnd_message.set_token ('SEQ_CONTEXT_NAME',
404: get_seq_context_name(l_seq_context_id));
405: IF p_suppress_error = 'N' THEN
406: app_exception.raise_exception;

Line 412: 'fun.plsql.fun_seq.get_assigned_sequence_info.exception',

408: WHEN OTHERS THEN
409: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
410: fnd_log.string(
411: fnd_log.level_exception,
412: 'fun.plsql.fun_seq.get_assigned_sequence_info.exception',
413: 'l_seq_context_id :' || l_seq_context_id ||', ' ||
414: 'SQLERRM: ' || SQLERRM);
415: END IF;
416: app_exception.raise_exception;

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 439: l_seq_version_id fun_seq_versions.seq_version_id%TYPE;

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';
443: BEGIN

Line 459: UPDATE fun_seq_versions

455: -- If the Sequence Version is NOT used, the current_value is null.
456: -- Use initial_value in this case.
457: -- Sequence version is locked.
458: --
459: UPDATE fun_seq_versions
460: SET current_value = NVL(current_value + 1,initial_value)
461: WHERE seq_version_id= l_seq_version_Id
462: RETURNING current_value, sysdate
463: INTO x_sequence_number, x_sequenced_date;

Line 474: || 'FUN_SEQ_S' || l_seq_version_id || '.nextval '

470:
471: END IF;
472: ELSIF (p_sequence_type = 'D') THEN
473: l_sql_stmt := 'SELECT '
474: || 'FUN_SEQ_S' || l_seq_version_id || '.nextval '
475: || 'FROM dual';
476: EXECUTE IMMEDIATE l_sql_stmt INTO x_sequence_number;
477: --
478: -- Update Status from "New" to "Used".

Line 496: module => 'fun.plsql.fun_seq.generate_sequence_number',

492: WHEN invalid_seq_type THEN
493: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
494: fnd_log.string(
495: log_level => fnd_log.level_exception,
496: module => 'fun.plsql.fun_seq.generate_sequence_number',
497: message => 'Invalid Sequence Type: ' || ', ' ||
498: 'SQLERRM: ' || SQLERRM);
499: END IF;
500: app_exception.raise_exception;

Line 505: module => 'fun.plsql.fun_seq.generate_sequence_number',

501: WHEN OTHERS THEN
502: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
503: fnd_log.string(
504: log_level => fnd_log.level_exception,
505: module => 'fun.plsql.fun_seq.generate_sequence_number',
506: message =>
507: 'SQLERRM: ' || SQLERRM);
508: END IF;
509: app_exception.raise_exception;

Line 526: UPDATE fun_seq_versions sv

522: BEGIN
523: --
524: -- Rest Sequence Version
525: --
526: UPDATE fun_seq_versions sv
527: SET sv.current_value = p_sequence_number
528: WHERE sv.seq_version_id = p_seq_version_id;
529: EXCEPTION
530: WHEN OTHERS THEN

Line 534: module => 'fun.plsql.fun_seq.reset',

530: WHEN OTHERS THEN
531: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
532: fnd_log.string(
533: log_level => fnd_log.level_exception,
534: module => 'fun.plsql.fun_seq.reset',
535: message =>
536: 'SQLERRM: ' || SQLERRM);
537: END IF;
538: app_exception.raise_exception;

Line 570: 'fun.plsql.fun_seq.get_assign_context_info.begin',

566: --
567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
568: FND_LOG.STRING(
569: FND_LOG.LEVEL_PROCEDURE,
570: 'fun.plsql.fun_seq.get_assign_context_info.begin',
571: 'Beginning of get_assign_context_info');
572: END IF;
573: --
574: -- Retrieve Sequenceing Context

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 628: 'fun.plsql.fun_seq.get_assign_context_info.end',

624: --
625: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
626: FND_LOG.STRING(
627: FND_LOG.LEVEL_PROCEDURE,
628: 'fun.plsql.fun_seq.get_assign_context_info.end',
629: 'Get_assign_context_info completes successfully.' ||', ' ||
630: 'x_seq_context_id: ' || x_seq_context_id || ', ' ||
631: 'x_control_date_type: ' || x_control_date_type || ', ' ||
632: 'x_req_assign_flag: ' || x_req_assign_flag || ', ' ||

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 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 682: l_seq_version_id fun_seq_versions.seq_version_id%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;
686: l_error_code_assign VARCHAR2(30);

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 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 688: l_sequence_number fun_seq_versions.initial_value%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;
690: l_dummy VARCHAR2(30); -- For Sort Option
691:
692: l_debug_loc VARCHAR2(100);

Line 805: module => 'fun.plsql.fun_seq.get_sequence_number_no_commit',

801: --
802: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
803: fnd_log.string(
804: log_level => fnd_log.level_exception,
805: module => 'fun.plsql.fun_seq.get_sequence_number_no_commit',
806: message =>
807: 'l_debug_loc: ' || l_debug_loc ||', '||
808: 'p_context_type: ' || p_context_type ||', '||
809: 'p_context_value: ' || p_context_value ||', '||

Line 842: module => 'fun.plsql.fun_seq.get_sequence_number_no_commit',

838: --
839: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
840: fnd_log.string(
841: log_level => fnd_log.level_exception,
842: module => 'fun.plsql.fun_seq.get_sequence_number_no_commit',
843: message =>
844: 'l_debug_loc: ' || l_debug_loc ||', '||
845: 'p_context_type: ' || p_context_type ||', '||
846: 'p_context_value: ' || p_context_value ||', '||

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 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 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 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 1012: -- fun_seq_utils.log_procedure(

1008: --
1009: -- If sequence assignment id is found,
1010: -- check if exceptions exist for the assignment.
1011: --
1012: -- fun_seq_utils.log_procedure(
1013: -- p_module => l_module || '.' || 'in progress',
1014: -- p_message_text => 'Beginning of get_seq_header_exception');
1015: --
1016: get_seq_header_exception(

Line 1025: --fun_seq_utils.log_procedure(

1021: x_exp_assignment_id => l_exp_assignment_id,
1022: x_exp_sequence_type => l_exp_sequence_type,
1023: x_exp_seq_header_id => l_exp_seq_header_id);
1024: --
1025: --fun_seq_utils.log_procedure(
1026: -- p_module => l_module || '.' || 'in progress',
1027: -- p_message_text => 'End of get_seq_header_exception');
1028: --
1029: END IF;

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 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 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 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 1460: FROM fun_seq_versions sv

1456: IF g_use_cache_flag = FALSE THEN
1457: -- For Online Transactions, issue Pessimistic Lock
1458: SELECT sv.seq_version_id
1459: INTO x_seq_version_id
1460: FROM fun_seq_versions sv
1461: WHERE sv.seq_header_id = p_seq_header_id
1462: AND sv.start_date <= p_control_date_value
1463: AND p_control_date_value <= NVL(sv.end_date, p_control_date_value + 1)
1464: AND sv.use_status_code IN ('NEW','USED')

Line 1469: FROM fun_seq_versions sv

1465: FOR UPDATE;
1466: ELSE -- No Lock is necessary, assuming Setup Pages become read-only.
1467: SELECT sv.seq_version_id
1468: INTO x_seq_version_id
1469: FROM fun_seq_versions sv
1470: WHERE sv.seq_header_id = p_seq_header_id
1471: AND sv.start_date <= p_control_date_value
1472: AND p_control_date_value <= NVL(sv.end_date, p_control_date_value + 1)
1473: AND sv.use_status_code IN ('NEW','USED');

Line 1477: fnd_message.set_name ('FUN','FUN_SEQ_NO_ACTIVE_SEQ_FOUND');

1473: AND sv.use_status_code IN ('NEW','USED');
1474: END IF;
1475: EXCEPTION
1476: WHEN NO_DATA_FOUND THEN
1477: fnd_message.set_name ('FUN','FUN_SEQ_NO_ACTIVE_SEQ_FOUND');
1478: fnd_message.set_token ('SEQ_NAME',get_seq_header_name(p_seq_header_id));
1479: --
1480: -- Cannot suppress this exception
1481: --

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 1596: l_seq_version_id fun_seq_versions.seq_version_id%TYPE;

1592: --
1593: PROCEDURE update_seq_ver_status (
1594: p_seq_version_id IN NUMBER) IS
1595:
1596: l_seq_version_id fun_seq_versions.seq_version_id%TYPE;
1597: BEGIN
1598: --
1599: -- Check if we need to update the status of the Version
1600: --

Line 1603: FROM fun_seq_versions

1599: -- Check if we need to update the status of the Version
1600: --
1601: SELECT seq_version_id
1602: INTO l_seq_version_id
1603: FROM fun_seq_versions
1604: WHERE seq_version_id = p_seq_version_id
1605: AND use_status_code = 'NEW';
1606: --
1607: -- Update status of the Version

Line 1609: UPDATE fun_seq_versions

1605: AND use_status_code = 'NEW';
1606: --
1607: -- Update status of the Version
1608: --
1609: UPDATE fun_seq_versions
1610: SET use_status_code = 'USED'
1611: WHERE seq_version_id = l_seq_version_id;
1612: EXCEPTION
1613: WHEN NO_DATA_FOUND THEN

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

Line 1737: module => 'fun.plsql.fun_seq.find_seq_head_assign_in_cache',

1733: WHEN OTHERS THEN
1734: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1735: fnd_log.string(
1736: log_level => fnd_log.level_exception,
1737: module => 'fun.plsql.fun_seq.find_seq_head_assign_in_cache',
1738: message => 'SQLERRM: ' || SQLERRM);
1739: END IF;
1740: END find_seq_head_assign_in_cache;
1741:

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

Line 1931: END fun_seq;

1927: --
1928: RETURN (TRUE);
1929: END IF;
1930: END use_cache;
1931: END fun_seq;