392: sysdate,
393: X_currency_code,
394: X_currency_code,
395: sysdate,
396: FND_GLOBAL.user_id,
397: FND_GLOBAL.login_id,
398: sysdate,
399: FND_GLOBAL.user_id,
400: p_org_id
393: X_currency_code,
394: X_currency_code,
395: sysdate,
396: FND_GLOBAL.user_id,
397: FND_GLOBAL.login_id,
398: sysdate,
399: FND_GLOBAL.user_id,
400: p_org_id
401: );
395: sysdate,
396: FND_GLOBAL.user_id,
397: FND_GLOBAL.login_id,
398: sysdate,
399: FND_GLOBAL.user_id,
400: p_org_id
401: );
402:
403: X_batch_id := X_tmp_batch_id;
442: SET actual_invoice_count = X_invoice_count,
443: actual_invoice_total = X_invoice_total,
444: control_invoice_count = X_invoice_count,
445: control_invoice_total = X_invoice_total,
446: last_updated_by = FND_GLOBAL.user_id,
447: last_update_date = sysdate,
448: last_update_login = FND_GLOBAL.login_id
449: WHERE batch_id = X_batch_id;
450:
444: control_invoice_count = X_invoice_count,
445: control_invoice_total = X_invoice_total,
446: last_updated_by = FND_GLOBAL.user_id,
447: last_update_date = sysdate,
448: last_update_login = FND_GLOBAL.login_id
449: WHERE batch_id = X_batch_id;
450:
451: EXCEPTION
452: WHEN others THEN
792: 'N', -- summary flag
793: TO_CHAR(1000), -- commit batch size
794: TO_CHAR(p_user_id), -- user_id
795: TO_CHAR(p_login_id), -- login_id
796: fnd_global.local_chr(0),NULL,
797: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
798: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
799: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
800: NULL, NULL, NULL, NULL, NULL, NULL, NULL,