[Home] [Help]
371: sp_out_10 OUT nocopy varchar2)
372: RETURN VARCHAR2 IS
373:
374: l_entity_id ff_database_items.user_entity_id%type;
375: l_archived_value ff_archive_items.value%type;
376: l_message varchar2(1000);
377: l_main_return varchar2(100);
378:
379: TYPE dbi_columns IS RECORD(
377: l_main_return varchar2(100);
378:
379: TYPE dbi_columns IS RECORD(
380: p_user_name ff_database_items.user_name%type,
381: p_archived_value ff_archive_items.value%type);
382:
383: dbi_rec dbi_columns;
384:
385: TYPE dbi_infm IS TABLE OF dbi_rec%TYPE
403: IS
404: SELECT target.value
405: FROM ff_archive_item_contexts con2,
406: ff_contexts fc2,
407: ff_archive_items target
408: WHERE target.user_entity_id = c_user_entity_id
409: AND target.context1 = to_char(c_assignment_action_id)
410: /* context assignment action id */
411: AND fc2.context_name = 'TAX_UNIT_ID'
420: )
421: IS
422: SELECT target.value
423: FROM
424: ff_archive_items target
425: WHERE target.user_entity_id = c_user_entity_id
426: AND target.context1 = to_char(c_assignment_action_id);
427: /* context assignment action id */
428:
554: ff_archive_item_contexts con3,
555: ff_archive_item_contexts con2,
556: ff_contexts fc3,
557: ff_contexts fc2,
558: ff_archive_items target,
559: ff_database_items fdi
560: where fdi.user_name = 'A_CITY_WITHHELD_PER_JD_GRE_YTD'
561: and target.user_entity_id = fdi.user_entity_id
562: and target.context1 = to_char(c_assignment_action_id)
1313: sp_out_10 IN OUT nocopy varchar2)
1314: RETURN VARCHAR2 IS
1315:
1316: l_entity_id ff_database_items.user_entity_id%type;
1317: l_archived_value ff_archive_items.value%type;
1318: l_message varchar2(1000);
1319: l_main_return varchar2(100);
1320: l_payee_count number;
1321: lv_payee_count varchar2(30);