DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_PUB dependencies on FND_DFLEX

Line 546: flexfield FND_DFLEX.dflex_r;

542: )
543: IS
544: l_api_name CONSTANT VARCHAR2(30) := 'Create_Debrief_With_Dff_Vals';
545: l_api_version_number CONSTANT NUMBER := 1.0;
546: flexfield FND_DFLEX.dflex_r;
547: flexinfo FND_DFLEX.dflex_dr;
548: contexts FND_DFLEX.contexts_dr;
549: i binary_integer;
550: j binary_integer;

Line 547: flexinfo FND_DFLEX.dflex_dr;

543: IS
544: l_api_name CONSTANT VARCHAR2(30) := 'Create_Debrief_With_Dff_Vals';
545: l_api_version_number CONSTANT NUMBER := 1.0;
546: flexfield FND_DFLEX.dflex_r;
547: flexinfo FND_DFLEX.dflex_dr;
548: contexts FND_DFLEX.contexts_dr;
549: i binary_integer;
550: j binary_integer;
551: segments FND_DFLEX.segments_dr;

Line 548: contexts FND_DFLEX.contexts_dr;

544: l_api_name CONSTANT VARCHAR2(30) := 'Create_Debrief_With_Dff_Vals';
545: l_api_version_number CONSTANT NUMBER := 1.0;
546: flexfield FND_DFLEX.dflex_r;
547: flexinfo FND_DFLEX.dflex_dr;
548: contexts FND_DFLEX.contexts_dr;
549: i binary_integer;
550: j binary_integer;
551: segments FND_DFLEX.segments_dr;
552: l_debrief_rec Debrief_REC_TYPE;

Line 551: segments FND_DFLEX.segments_dr;

547: flexinfo FND_DFLEX.dflex_dr;
548: contexts FND_DFLEX.contexts_dr;
549: i binary_integer;
550: j binary_integer;
551: segments FND_DFLEX.segments_dr;
552: l_debrief_rec Debrief_REC_TYPE;
553: BEGIN
554: SAVEPOINT CREATE_DEBRIEF_PUB;
555:

Line 587: fnd_dflex.get_flexfield('CSF', 'CSF_DEBRIEF_HEADERS', flexfield, flexinfo);

583: l_debrief_rec.TRAVEL_DISTANCE_IN_KM := p_debrief_rec.TRAVEL_DISTANCE_IN_KM;
584:
585: -- Update the l_debrief_rec with default dff values for enabled dff.
586: BEGIN
587: fnd_dflex.get_flexfield('CSF', 'CSF_DEBRIEF_HEADERS', flexfield, flexinfo);
588:
589: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
590: fnd_log.string(fnd_log.level_statement,
591: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',

Line 619: FND_DFLEX.get_contexts(flexfield, contexts);

615: dbms_output.put_line('=== ENABLED CONTEXT INFO ===');
616: */
617: l_debrief_rec.ATTRIBUTE_CATEGORY := flexinfo.default_context_value;
618:
619: FND_DFLEX.get_contexts(flexfield, contexts);
620: FOR i IN 1 .. contexts.ncontexts
621: LOOP
622: IF(contexts.is_enabled(i)) THEN
623: --dbms_output.put_line(contexts.context_code(i) || ' - ' || contexts.context_description(i));

Line 629: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield, contexts.context_code(i)), segments, true);

625: fnd_log.string(fnd_log.level_statement,
626: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
627: contexts.context_code(i) || ' - ' || contexts.context_description(i));
628: end if;
629: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield, contexts.context_code(i)), segments, true);
630: FOR j IN 1 .. segments.nsegments
631: LOOP
632: --dbms_output.put_line(segments.segment_name(j) || ' - ' || segments.application_column_name(j) || ' - ' || segments.description(j)
633: --|| ' - ' || segments.sequence(j) || ' - ' || segments.default_type(j) || ' - ' || segments.default_value(j));