[Home] [Help]
118: 30-JUN-2006 nbristow 115.122 Context length limited to 30
119: chars
120: 19-JUN-2006 SuSivasu 115.121 Enabled the Balance Date and Time
121: Definition ID contexts to be stored
122: in pay_action_contexts.
123: 14-MAR-2006 alogue 115.120 5094068 Fix lb_context_match_check
124: to correctly spot if context
125: wasn't in the udca.
126: 07-MAR-2006 alogue 115.119 5082050 Further fix to POG retro
405: inserted into pay_message_lines
406: are at max 240 in length.
407: 16-NOV-1999 nbristow 115.12 Now reversals and balance
408: adjustments populate
409: pay_action_contexts.
410: 26-JUL-1999 ALOGUE 115.11 Enhancement in Reversal to
411: get reversals results in same
412: order as run being reversed.
413: Optimises behaviour of the
5770: close run_results;
5771: --
5772: -- Now setup the action contexts, if there are any
5773: -- if not multi then
5774: insert into pay_action_contexts
5775: (ASSIGNMENT_ACTION_ID,
5776: ASSIGNMENT_ID,
5777: CONTEXT_ID,
5778: CONTEXT_VALUE)
5779: select distinct rev_assact,
5780: pac.assignment_id,
5781: pac.context_id,
5782: pac.context_value
5783: from pay_action_contexts pac
5784: where pac.assignment_action_id = assactid;
5785: -- end if;
5786: --
5787: -- Added for fix 366215.
6604: --
6605: -- The row could already be in the table due
6606: -- to batch balance adjustments
6607: --
6608: insert into pay_action_contexts
6609: (assignment_action_id,
6610: assignment_id,
6611: context_id,
6612: context_value)
6615: udca.cxt_id(cnt),
6616: udca.cxt_value(cnt)
6617: from sys.dual
6618: where not exists (select ''
6619: from pay_action_contexts
6620: where assignment_action_id = udca.assact_id(cnt)
6621: and assignment_id = udca.asg_id(cnt)
6622: and context_id = udca.cxt_id(cnt)
6623: and context_value = udca.cxt_value(cnt));