55: NULL,
56: to_char(to_date(p_as_of_date,'DD-MM-RRRR'),'YYYY/MM/DD HH24:MI:SS'),
57: p_accept_limit_error,
58: p_run_id,
59: fnd_global.local_chr(0));
60: END Generate_Button;
61:
62: /* ---------------------------------------------------------------------
63: | PUBLIC PROCEDURE |
560: /*11*/ l_offset_deal_no,
561: /*12*/ l_offset_trx_number,
562: /*13*/ l_success_flag,
563: /*14*/ X_cashpool_id,
564: /*15*/ nvl(fnd_global.user_id,-1),
565: /*16*/ sysdate,
566: /*17*/ nvl(fnd_global.user_id,-1),
567: /*18*/ sysdate,
568: /*19*/ nvl(fnd_global.user_id,-1)
562: /*13*/ l_success_flag,
563: /*14*/ X_cashpool_id,
564: /*15*/ nvl(fnd_global.user_id,-1),
565: /*16*/ sysdate,
566: /*17*/ nvl(fnd_global.user_id,-1),
567: /*18*/ sysdate,
568: /*19*/ nvl(fnd_global.user_id,-1)
569: );
570: FND_MSG_PUB.delete_msg(1);
564: /*15*/ nvl(fnd_global.user_id,-1),
565: /*16*/ sysdate,
566: /*17*/ nvl(fnd_global.user_id,-1),
567: /*18*/ sysdate,
568: /*19*/ nvl(fnd_global.user_id,-1)
569: );
570: FND_MSG_PUB.delete_msg(1);
571: COMMIT;
572: END LOOP;
630: /*04*/sub.account_id,
631: /*05*/sub.party_code,
632: /*06*/sub.legal_entity_id,
633: /*07*/sub.cashpool_id,
634: /*08*/nvl(fnd_global.user_id,-1),
635: /*09*/sysdate,
636: /*10*/nvl(fnd_global.user_id,-1),
637: /*11*/sysdate,
638: /*12*/nvl(fnd_global.user_id,-1)
632: /*06*/sub.legal_entity_id,
633: /*07*/sub.cashpool_id,
634: /*08*/nvl(fnd_global.user_id,-1),
635: /*09*/sysdate,
636: /*10*/nvl(fnd_global.user_id,-1),
637: /*11*/sysdate,
638: /*12*/nvl(fnd_global.user_id,-1)
639: FROM ce_cashpool_sub_accts sub
640: WHERE sub.cashpool_id = p_cashpool_id
634: /*08*/nvl(fnd_global.user_id,-1),
635: /*09*/sysdate,
636: /*10*/nvl(fnd_global.user_id,-1),
637: /*11*/sysdate,
638: /*12*/nvl(fnd_global.user_id,-1)
639: FROM ce_cashpool_sub_accts sub
640: WHERE sub.cashpool_id = p_cashpool_id
641: AND sub.type <> 'POOL';
642:
715: /*04*/sub.account_id,
716: /*05*/sub.party_code,
717: /*06*/sub.legal_entity_id,
718: /*07*/sub.cashpool_id,
719: /*08*/nvl(fnd_global.user_id,-1),
720: /*09*/sysdate,
721: /*10*/nvl(fnd_global.user_id,-1),
722: /*11*/sysdate,
723: /*12*/nvl(fnd_global.user_id,-1)
717: /*06*/sub.legal_entity_id,
718: /*07*/sub.cashpool_id,
719: /*08*/nvl(fnd_global.user_id,-1),
720: /*09*/sysdate,
721: /*10*/nvl(fnd_global.user_id,-1),
722: /*11*/sysdate,
723: /*12*/nvl(fnd_global.user_id,-1)
724: FROM ce_cashpool_sub_accts sub
725: WHERE sub.cashpool_id = p_cashpool_id
719: /*08*/nvl(fnd_global.user_id,-1),
720: /*09*/sysdate,
721: /*10*/nvl(fnd_global.user_id,-1),
722: /*11*/sysdate,
723: /*12*/nvl(fnd_global.user_id,-1)
724: FROM ce_cashpool_sub_accts sub
725: WHERE sub.cashpool_id = p_cashpool_id
726: AND sub.type <> 'POOL';
727: