[Home] [Help]
86: 30-JUN-2006 nbristow 115.122 Context length limited to 30
87: chars
88: 19-JUN-2006 SuSivasu 115.121 Enabled the Balance Date and Time
89: Definition ID contexts to be stored
90: in pay_action_contexts.
91: 14-MAR-2006 alogue 115.120 5094068 Fix lb_context_match_check
92: to correctly spot if context
93: wasn't in the udca.
94: 07-MAR-2006 alogue 115.119 5082050 Further fix to POG retro
373: inserted into pay_message_lines
374: are at max 240 in length.
375: 16-NOV-1999 nbristow 115.12 Now reversals and balance
376: adjustments populate
377: pay_action_contexts.
378: 26-JUL-1999 ALOGUE 115.11 Enhancement in Reversal to
379: get reversals results in same
380: order as run being reversed.
381: Optimises behaviour of the
5534: close run_results;
5535: --
5536: -- Now setup the action contexts, if there are any
5537: -- if not multi then
5538: insert into pay_action_contexts
5539: (ASSIGNMENT_ACTION_ID,
5540: ASSIGNMENT_ID,
5541: CONTEXT_ID,
5542: CONTEXT_VALUE)
5543: select distinct rev_assact,
5544: pac.assignment_id,
5545: pac.context_id,
5546: pac.context_value
5547: from pay_action_contexts pac
5548: where pac.assignment_action_id = assactid;
5549: -- end if;
5550: --
5551: -- Added for fix 366215.
6340: --
6341: -- The row could already be in the table due
6342: -- to batch balance adjustments
6343: --
6344: insert into pay_action_contexts
6345: (assignment_action_id,
6346: assignment_id,
6347: context_id,
6348: context_value)
6351: udca.cxt_id(cnt),
6352: udca.cxt_value(cnt)
6353: from sys.dual
6354: where not exists (select ''
6355: from pay_action_contexts
6356: where assignment_action_id = udca.assact_id(cnt)
6357: and assignment_id = udca.asg_id(cnt)
6358: and context_id = udca.cxt_id(cnt)
6359: and context_value = udca.cxt_value(cnt));