[Home] [Help]
367: sp_out_10 OUT nocopy varchar2)
368: RETURN VARCHAR2 IS
369:
370: l_entity_id ff_database_items.user_entity_id%type;
371: l_archived_value ff_archive_items.value%type;
372: l_message varchar2(1000);
373: l_main_return varchar2(100);
374:
375: TYPE dbi_columns IS RECORD(
373: l_main_return varchar2(100);
374:
375: TYPE dbi_columns IS RECORD(
376: p_user_name ff_database_items.user_name%type,
377: p_archived_value ff_archive_items.value%type);
378:
379: dbi_rec dbi_columns;
380:
381: TYPE dbi_infm IS TABLE OF dbi_rec%TYPE
399: IS
400: SELECT target.value
401: FROM ff_archive_item_contexts con2,
402: ff_contexts fc2,
403: ff_archive_items target
404: WHERE target.user_entity_id = c_user_entity_id
405: AND target.context1 = to_char(c_assignment_action_id)
406: /* context assignment action id */
407: AND fc2.context_name = 'TAX_UNIT_ID'
416: )
417: IS
418: SELECT target.value
419: FROM
420: ff_archive_items target
421: WHERE target.user_entity_id = c_user_entity_id
422: AND target.context1 = to_char(c_assignment_action_id);
423: /* context assignment action id */
424:
550: ff_archive_item_contexts con3,
551: ff_archive_item_contexts con2,
552: ff_contexts fc3,
553: ff_contexts fc2,
554: ff_archive_items target,
555: ff_database_items fdi
556: where fdi.user_name = 'A_CITY_WITHHELD_PER_JD_GRE_YTD'
557: and target.user_entity_id = fdi.user_entity_id
558: and target.context1 = to_char(c_assignment_action_id)
1289: sp_out_10 IN OUT nocopy varchar2)
1290: RETURN VARCHAR2 IS
1291:
1292: l_entity_id ff_database_items.user_entity_id%type;
1293: l_archived_value ff_archive_items.value%type;
1294: l_message varchar2(1000);
1295: l_main_return varchar2(100);
1296: l_payee_count number;
1297: lv_payee_count varchar2(30);