DBA Data[Home] [Help]

APPS.WSH_FLEXFIELD_UTILS dependencies on FND_DFLEX

Line 57: flexfield OUT NOCOPY fnd_dflex.dflex_r,

53: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FLEXFIELD_UTILS';
54: --
55: PROCEDURE get_flexfield(appl_short_name IN fnd_application.application_short_name%TYPE,
56: flexfield_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
57: flexfield OUT NOCOPY fnd_dflex.dflex_r,
58: flexinfo OUT NOCOPY wsh_flexfield_utils.dflex_dr)
59: IS
60: ffld fnd_dflex.dflex_r;
61: dflex wsh_flexfield_utils.dflex_dr;

Line 60: ffld fnd_dflex.dflex_r;

56: flexfield_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
57: flexfield OUT NOCOPY fnd_dflex.dflex_r,
58: flexinfo OUT NOCOPY wsh_flexfield_utils.dflex_dr)
59: IS
60: ffld fnd_dflex.dflex_r;
61: dflex wsh_flexfield_utils.dflex_dr;
62:
63: CURSOR c_get_flexname IS
64: SELECT /* $Header: WSHFFUTB.pls 120.1.12000000.3 2007/03/30 09:36:11 nchellam ship $ */

Line 143: l_flexfield fnd_dflex.dflex_r;

139: FUNCTION Cache_DFF_Segments(p_table_name IN VARCHAR2,
140: x_return_status OUT NOCOPY VARCHAR2)
141: RETURN BINARY_INTEGER IS
142: l_table_name Varchar2(30);
143: l_flexfield fnd_dflex.dflex_r;
144: l_flexinfo dflex_dr;
145: l_contexts fnd_dflex.contexts_dr;
146: l_segments fnd_dflex.segments_dr;
147: l_glbl_segments fnd_dflex.segments_dr;

Line 145: l_contexts fnd_dflex.contexts_dr;

141: RETURN BINARY_INTEGER IS
142: l_table_name Varchar2(30);
143: l_flexfield fnd_dflex.dflex_r;
144: l_flexinfo dflex_dr;
145: l_contexts fnd_dflex.contexts_dr;
146: l_segments fnd_dflex.segments_dr;
147: l_glbl_segments fnd_dflex.segments_dr;
148: i BINARY_INTEGER;
149: j BINARY_INTEGER;

Line 146: l_segments fnd_dflex.segments_dr;

142: l_table_name Varchar2(30);
143: l_flexfield fnd_dflex.dflex_r;
144: l_flexinfo dflex_dr;
145: l_contexts fnd_dflex.contexts_dr;
146: l_segments fnd_dflex.segments_dr;
147: l_glbl_segments fnd_dflex.segments_dr;
148: i BINARY_INTEGER;
149: j BINARY_INTEGER;
150: k BINARY_INTEGER;

Line 147: l_glbl_segments fnd_dflex.segments_dr;

143: l_flexfield fnd_dflex.dflex_r;
144: l_flexinfo dflex_dr;
145: l_contexts fnd_dflex.contexts_dr;
146: l_segments fnd_dflex.segments_dr;
147: l_glbl_segments fnd_dflex.segments_dr;
148: i BINARY_INTEGER;
149: j BINARY_INTEGER;
150: k BINARY_INTEGER;
151: n NUMBER;

Line 219: fnd_dflex.get_contexts(flexfield => l_flexfield,

215: flexfield_name => l_table_name,
216: flexfield => l_flexfield,
217: flexinfo => l_flexinfo);
218:
219: fnd_dflex.get_contexts(flexfield => l_flexfield,
220: contexts => l_contexts);
221:
222: fnd_dflex.get_segments(context => fnd_dflex.make_context(flexfield => l_flexfield,
223: context_code => l_flexinfo.default_context_value),

Line 222: fnd_dflex.get_segments(context => fnd_dflex.make_context(flexfield => l_flexfield,

218:
219: fnd_dflex.get_contexts(flexfield => l_flexfield,
220: contexts => l_contexts);
221:
222: fnd_dflex.get_segments(context => fnd_dflex.make_context(flexfield => l_flexfield,
223: context_code => l_flexinfo.default_context_value),
224: segments => l_segments,
225: enabled_only => TRUE);
226:

Line 227: fnd_dflex.get_segments(context => fnd_dflex.make_context(flexfield => l_flexfield,

223: context_code => l_flexinfo.default_context_value),
224: segments => l_segments,
225: enabled_only => TRUE);
226:
227: fnd_dflex.get_segments(context => fnd_dflex.make_context(flexfield => l_flexfield,
228: context_code => l_contexts.context_code(l_contexts.global_context)),
229: segments => l_glbl_segments,
230: enabled_only => TRUE);
231:

Line 837: l_flexfield fnd_dflex.dflex_r;

833: FUNCTION Check_DFF_Req (p_table_name IN VARCHAR2,
834: x_return_status OUT NOCOPY VARCHAR2)
835: RETURN BINARY_INTEGER IS
836: l_table_name Varchar2(30);
837: l_flexfield fnd_dflex.dflex_r;
838: l_flexinfo dflex_dr;
839: l_contexts fnd_dflex.contexts_dr;
840: l_segments fnd_dflex.segments_dr;
841: l_glbl_segments fnd_dflex.segments_dr;

Line 839: l_contexts fnd_dflex.contexts_dr;

835: RETURN BINARY_INTEGER IS
836: l_table_name Varchar2(30);
837: l_flexfield fnd_dflex.dflex_r;
838: l_flexinfo dflex_dr;
839: l_contexts fnd_dflex.contexts_dr;
840: l_segments fnd_dflex.segments_dr;
841: l_glbl_segments fnd_dflex.segments_dr;
842: i BINARY_INTEGER;
843: j BINARY_INTEGER;

Line 840: l_segments fnd_dflex.segments_dr;

836: l_table_name Varchar2(30);
837: l_flexfield fnd_dflex.dflex_r;
838: l_flexinfo dflex_dr;
839: l_contexts fnd_dflex.contexts_dr;
840: l_segments fnd_dflex.segments_dr;
841: l_glbl_segments fnd_dflex.segments_dr;
842: i BINARY_INTEGER;
843: j BINARY_INTEGER;
844: l_found BOOLEAN := FALSE;

Line 841: l_glbl_segments fnd_dflex.segments_dr;

837: l_flexfield fnd_dflex.dflex_r;
838: l_flexinfo dflex_dr;
839: l_contexts fnd_dflex.contexts_dr;
840: l_segments fnd_dflex.segments_dr;
841: l_glbl_segments fnd_dflex.segments_dr;
842: i BINARY_INTEGER;
843: j BINARY_INTEGER;
844: l_found BOOLEAN := FALSE;
845:

Line 918: fnd_dflex.get_contexts(flexfield => l_flexfield,

914: flexfield_name => l_table_name,
915: flexfield => l_flexfield,
916: flexinfo => l_flexinfo);
917:
918: fnd_dflex.get_contexts(flexfield => l_flexfield,
919: contexts => l_contexts);
920:
921: IF l_flexinfo.context_required = 'Y' THEN
922: g_check_req(j).context_req_flag := 'Y';

Line 928: fnd_dflex.get_segments(context => fnd_dflex.make_context(flexfield => l_flexfield,

924: <>
925: FOR i IN 1..l_contexts.ncontexts LOOP
926: IF l_contexts.is_enabled(i) THEN
927:
928: fnd_dflex.get_segments(context => fnd_dflex.make_context(flexfield => l_flexfield,
929: context_code => l_contexts.context_code(i)),
930: segments => l_segments,
931: enabled_only => TRUE);
932:

Line 1005: l_flexfield fnd_dflex.dflex_r;

1001: p_context IN VARCHAR2,
1002: x_return_status OUT NOCOPY VARCHAR2)
1003: RETURN BINARY_INTEGER IS
1004: l_table_name Varchar2(30);
1005: l_flexfield fnd_dflex.dflex_r;
1006: l_flexinfo dflex_dr;
1007: l_contexts fnd_dflex.contexts_dr;
1008: l_segments fnd_dflex.segments_dr;
1009: l_glbl_segments fnd_dflex.segments_dr;

Line 1007: l_contexts fnd_dflex.contexts_dr;

1003: RETURN BINARY_INTEGER IS
1004: l_table_name Varchar2(30);
1005: l_flexfield fnd_dflex.dflex_r;
1006: l_flexinfo dflex_dr;
1007: l_contexts fnd_dflex.contexts_dr;
1008: l_segments fnd_dflex.segments_dr;
1009: l_glbl_segments fnd_dflex.segments_dr;
1010: i BINARY_INTEGER;
1011: j BINARY_INTEGER;

Line 1008: l_segments fnd_dflex.segments_dr;

1004: l_table_name Varchar2(30);
1005: l_flexfield fnd_dflex.dflex_r;
1006: l_flexinfo dflex_dr;
1007: l_contexts fnd_dflex.contexts_dr;
1008: l_segments fnd_dflex.segments_dr;
1009: l_glbl_segments fnd_dflex.segments_dr;
1010: i BINARY_INTEGER;
1011: j BINARY_INTEGER;
1012: k BINARY_INTEGER;

Line 1009: l_glbl_segments fnd_dflex.segments_dr;

1005: l_flexfield fnd_dflex.dflex_r;
1006: l_flexinfo dflex_dr;
1007: l_contexts fnd_dflex.contexts_dr;
1008: l_segments fnd_dflex.segments_dr;
1009: l_glbl_segments fnd_dflex.segments_dr;
1010: i BINARY_INTEGER;
1011: j BINARY_INTEGER;
1012: k BINARY_INTEGER;
1013: l_found BOOLEAN := FALSE;

Line 1080: fnd_dflex.get_contexts(flexfield => l_flexfield,

1076: flexfield_name => l_table_name,
1077: flexfield => l_flexfield,
1078: flexinfo => l_flexinfo);
1079:
1080: fnd_dflex.get_contexts(flexfield => l_flexfield,
1081: contexts => l_contexts);
1082:
1083:
1084: fnd_dflex.get_segments(context => fnd_dflex.make_context(flexfield => l_flexfield,

Line 1084: fnd_dflex.get_segments(context => fnd_dflex.make_context(flexfield => l_flexfield,

1080: fnd_dflex.get_contexts(flexfield => l_flexfield,
1081: contexts => l_contexts);
1082:
1083:
1084: fnd_dflex.get_segments(context => fnd_dflex.make_context(flexfield => l_flexfield,
1085: context_code => p_context),
1086: segments => l_segments,
1087: enabled_only => TRUE);
1088:

Line 1089: fnd_dflex.get_segments(context => fnd_dflex.make_context(flexfield => l_flexfield,

1085: context_code => p_context),
1086: segments => l_segments,
1087: enabled_only => TRUE);
1088:
1089: fnd_dflex.get_segments(context => fnd_dflex.make_context(flexfield => l_flexfield,
1090: context_code => l_contexts.context_code(l_contexts.global_context)),
1091: segments => l_glbl_segments,
1092: enabled_only => TRUE);
1093: